Article ID: 6450, created on Jan 12, 2010, last review on Apr 25, 2014

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

Symptômes

L'erreur suivante s'affiche dans l'Assistant de Sitebuilder lors de la publication du site :

--->8---
1 Can not execute a request to the SQLite database.
2 Data Module 'Image Gallery' (con id 'eh8rhfbk75r') have not been published.
3 Data Module 'Blog' (con id 'z51zex9k9on') have not been published.
4 Data Module 'eShop' (con id 'ww8wgim1pis') have not been published.
5 The modules data have been updated with errors.
---8<---


Si vous voulez voir un contenu plus détaillé de l'erreur, allez dans le GUI de Parallels Plesk Sitebuilder sur la page Logs (Sitebuilder -> Serveur -> Logs):

--->8---
System 6/18/2009 1:21:51 AM    admin   91.204.24.201   The site 'site.alias.name' has been published, but with errors....
System 6/18/2009 1:21:46 AM    admin   91.204.24.201   Modules data has been updated, but with errors....
Modules 6/18/2009 1:21:46 AM    admin   91.204.24.201   The data of 'Eshop' module (id is 'ww8wgim1pis') was not published (site alias is 'site.alias.name', owner is 'site.alias.nam...
Modules 6/18/2009 1:21:46 AM    admin   91.204.24.201   Cannot execute query to Sqlite database - attempt to write a readonly database, sql - DELETE FROM modules_ww8wgim1pis_categor...
Modules 6/18/2009 1:21:46 AM    admin   91.204.24.201   Cannot execute query to Sqlite database - attempt to write a readonly database, sql - UPDATE modules_ww8wgim1pis_category SET...
Modules 6/18/2009 1:21:46 AM    admin   91.204.24.201   The data of 'Blogger' module (id is 'z51zex9k9on') was not published (site alias is 'site.alias.name', owner is 'kayaktener...
Modules 6/18/2009 1:21:46 AM    admin   91.204.24.201   Cannot execute query to Sqlite database - attempt to write a readonly database, sql - DELETE FROM modules_z51zex9k9on_post WH...
Modules 6/18/2009 1:21:46 AM    admin   91.204.24.201   Cannot execute query to Sqlite database - attempt to write a readonly database, sql - UPDATE modules_z51zex9k9on_post SET sto...
Modules 6/18/2009 1:21:46 AM    admin   91.204.24.201   The data of 'ImageGallery' module (id is 'eh8rhfbk75r') was not published (site alias is 'site.alias.name', owner is 'kayak...
Modules 6/18/2009 1:21:46 AM    admin   91.204.24.201   Cannot execute query to Sqlite database - attempt to write a readonly database, sql - DELETE FROM modules_eh8rhfbk75r_categor...
Modules 6/18/2009 1:21:46 AM    admin   91.204.24.201   Cannot execute query to Sqlite database - attempt to write a readonly database, sql - UPDATE modules_eh8rhfbk75r_category SET...
---8<---

Cause

La base de données SQLite est corrompue et Parallels Plesk Sitebuilder est incapable de la mettre à jour.

Pour vérifier la base de données, téléchargez-la à partir de l'hôte publié. Ce fichier est  situé dans  /data/storage/sb_modules.php sous l'emplacement FTP.
Essayez d'ouvrir la base de données avec l'utilitaire SQLite version 2.

~# sqlite sb_modules.php
SQLite version 2.8.17
Enter ".help" for instructions
sqlite>

Les sorties suivantes signifient que la base de données est corrompue :

~# sqlite sb_modules.php
Unable to open database "sb_modules.php": database disk image is malformed
~#

~# sqlite sb_modules.php
Unable to open database sb_modules.php
~#


IMPORTANT : Parallels Plesk Sitebuilder ne prend actuellement en charge que SQLite version 2.

Résolution

Pour résoudre le problème et faire fonctionner le site normalement, nous vous conseillons de supprimer tous les modules sur le site via l'Assistant, enregistrez les changements, placez et configurez de nouveau les modules. Les anciennes données seront malheureusement perdues.

f7f840260c1591440648a375a64b5b75 fad6dc0c8e983c17ae70a51ac7952cd0 d055be4fdc562a8ecb8e6d0bf419f946 ea6a61e571a858aa6019ceb068ea403a 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF