Sitebuilder Gallery error: "Cannot execute a query to SQLite database. Cannot get categories."

Created:

2016-11-16 12:53:11 UTC

Modified:

2017-08-16 18:35:20 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Sitebuilder Gallery error: "Cannot execute a query to SQLite database. Cannot get categories."

Applicable to:

  • Web Presence Builder for Linux
  • Plesk Sitebuilder for Linux

Symptoms

sqlite2

client is outdated and dropped by most vendors.>
  • Attempt to open Image Gallery page in SiteBuilder fails with the error:

    Cannot execute a query to SQLite database. Cannot get categories.

  • sqlite integrity check command pragma integrity_check fails with Segmentation Fault error message

    # sqlite-2.8.17.bin /var/www/vhosts/domain.tld/data/sb_modules.php "pragma integrity_check"
    Segmentation Fault
  • Website docroot /var/www/vhosts/domain.tld/data/tmp/sqlite.sql contains the following error

    Error message: database disk image is malformed

Cause

SQLIte db corrupted

Resolution

  1. Locate a sqlite database file in hosting Create a database dump and restored it into a new database.

    ~# cd /var/www/vhosts/domain.tld/data/
    ~# sqlite-2.8.17.bin sb_modules.php ".dump" >new.db.sql
    ~# sqlite-2.8.17.bin new.db ".read new.db.sql"
    ~# cp new.db sb_modules.php
  2. Add a new empty Image Gallery page to the site.

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