Modules SSLcertificate loadData DBD mysql db do failed

**fulltilt** · May 7th 2019

- IMSCP: 1.5.3

- Distribution: Debian 9

- Proftpd

- PHP FPM

- MariaDB 10.1

- Dovecot

- Roundcube

- Web2FTP

- Plugins:

PMA Captcha, RoundCubePlugins, SpamAssassin , LetsEncrypt, PHPswitcher, ClamAV

since this morning I can no longer add new hostings to IMSCP (latest)

Code

[Tue May 7 09:12:25 2019] [fatal] iMSCP::DbTasksProcessor::_processModuleDbTasks: Modules::SSLcertificate::_loadData: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version
...propagated at /var/www/imscp/engine/PerlLib/iMSCP/DbTasksProcessor.pm line 496, <$fh> line 184.

libdbd-mysql-perl is already installed

**fulltilt** · May 7th 2019

it seems 2 ssl certs where not proper deleted when deleting a domain in table ssl-certs, now it works.

**Nuxwin** · May 8th 2019

fulltilt

You're using i-MSCP 1.5.3 (first build) while there have been two other builds since... That would be great if you maintain your i-MSCP installations up-to-date before reporting bugs which were already fixed... Your current version is affected by a bug (wrong SQL query) which has been fixed in version i-MSCP version 1.5.3 (build 2018120700). Furthermore, there has been another version released since which is 1.5.3 (Build 2018120800)...

The bug in your version is clearly highlighten here: https://github.com/i-MSCP/imsc…es/SSLcertificate.pm#L256
The fix is clearly highlighten in the 2018120700 build: https://github.com/i-MSCP/imsc…es/SSLcertificate.pm#L256

Basically put, the FROM clause appear twice in your version, hence the error raised.

Modules SSLcertificate loadData DBD mysql db do failed

Nuxwin May 8th 2019

Nuxwin May 8th 2019

Share

Daily visitors