Modules SSLcertificate loadData DBD mysql db do failed

  • - 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)

    1. [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
    2. ...propagated at /var/www/imscp/engine/PerlLib/iMSCP/ line 496, <$fh> line 184.

    libdbd-mysql-perl is already installed

  • 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)...

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


  • Nuxwin

    Added the Label unreproducible
  • Nuxwin

    Closed the thread.