Article ID: 6450, created on Jun 18, 2009, last review on Apr 21, 2012

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

Síntomas

Cuando se intenta publicar un sitio en el Asistente de Parallels Plesk Sitebuilder, aparece el siguiente error:

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


El error presenta más detalles en el GUI de Parallels Plesk Sitebuilder, en la página Registros (Parallels Plesk Sitebuilder -> Servidor -> Registros):

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

Causa

La base de datos SQLite está dañada y Parallels Plesk Sitebuilder no puede actualizarla.

Para comprobar la base de datos, descárguela desde el host publicado. Encontrará el archivo en /data/storage/sb_modules.php de la ubicación FTP.

Intente abrir la base de datos con la utilidad SQLite 2.

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

Las siguientes salidas denotas que la base de datos está dañada:

~# 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
~#

IMPORTANTE: En este momento, Parallels Plesk Sitebuilder sólo soporta la versión 2 de SQLite.

Resolución

Para resolver el problema y conseguir que el sitio funcione correctamente, le recomendamos eliminar todos los módulos presentes en el sitio a través del Asistente, guardar los cambios e incorporar y configurar los módulos de nuevo. Lamentablemente, se perderán los datos presentes anteriormente.

f7f840260c1591440648a375a64b5b75 fad6dc0c8e983c17ae70a51ac7952cd0 d055be4fdc562a8ecb8e6d0bf419f946 ea6a61e571a858aa6019ceb068ea403a 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF