Article ID: 6177, created on Mar 20, 2009, last review on Sep 8, 2016

  • Applies to:
  • Plesk Sitebuilder 4.5 for Linux/Unix


  1. When open page with module the following error is shown in Sitebuilder log at Sitebuilder > System > Logs:

    Modules 3/20/2009 11:42:10 AM     admin     Cannot execute query to Sqlite database - SQL logic error or missing database, sql - SELECT...
  2. If click on Modules to see details, the following message can be observed:

    Details #18673097 --------------------------------------------
    Message     Cannot execute query to Sqlite database - SQL logic error or missing database, sql - SELECT
    FROM modules\_fvmss5nwun8\_user
    name ASC
    LIMIT 0, 100


Incorrect permissions on SQLite database file sb_modules.php where modules data is store or corruption in the database.


To fix the first problem verify the file has correct permissions, it should be 777 and owned by Apache user. The SQLite database fileis located on the publishing server in directory Working_directory/data/storage.

  1. Login to FTP location where the site is published to, verify and correct permissions. They should be:

    ftp> ls data/storage
    200 PORT command successful
    150 Opening ASCII mode data connection for file list
    drwxrwsrwx   3 user  group       45 Mar 16 18:04 .
    drwxrwsr-x   5 user  group       45 Nov 29 09:51 ..
    drwxrwsrwx   2 user  group        6 Nov 29 09:51 attachments
    -rwxrwxrwx   1 user  group     8192 Feb 10 18:19 sb_modules.php
    226 Transfer complete

    Where user:group is user and group of Apache web server in this directory (Apache works in the directory with privileges of user:group). Working_directory is site's publishing directory.

  2. If permissions are incorrect. Login to the publish server via SSH and set proper permissions.

Another case if the database is corrupted and several required tables are missing. If earlier the site contain module and was published, the database was removed from Sitebuilder server. So it cannot be restored.

To resolve the problem just publish the site anew. During publishing Parallels Plesk Sitebuilder checks content of module database and creates missing tables.

Search Words

Cannot execute query to Sqlite database - SQL logic error or missing database

f7f840260c1591440648a375a64b5b75 fad6dc0c8e983c17ae70a51ac7952cd0 d055be4fdc562a8ecb8e6d0bf419f946 ea6a61e571a858aa6019ceb068ea403a 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF