Page with module cannot be opened in wizard with error "Cannot execute query to Sqlite database"

Refers to:

  • Plesk Sitebuilder 4.5 for Linux

Created:

2016-11-16 13:22:09 UTC

Modified:

2016-12-21 20:33:38 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Page with module cannot be opened in wizard with error "Cannot execute query to Sqlite database"

Symptoms

  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     91.204.24.201     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
    id,
    name,
    email,
    first\\_name,
    last\\_name,
    creation\\_date,
    status

    FROM modules\\_fvmss5nwun8\\_user

    WHERE
    (modules\\_fvmss5nwun8\\_user.storage\\_state>1)

    ORDER BY
    name ASC

    LIMIT 0, 100
    --------------------------------------------------------------

Cause

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

Resolution

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
    ftp>

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.

  1. 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.

Have more questions? Submit a request
Please sign in to leave a comment.