Parallels

Symptoms

I get the following error when open module page (eShop, Image Gallery, etc) in Sitebuilder Wizard {Sitebuilder -> Sites -> <site alias> -> Open Site In Wizard -> Edit -> eShop}:

 Cannot connect to the database host.

or

Error! Cannot get module data.

What these error mean?

Cause

For published site when you open module pages in for site Wizard Sitebuilder works with publishing server where the site is published.
Via HTTP requests it queries and updates SQLite database that contains modules data

These errors are caused by inability to work with the database. The problem may be caused by 1) incorrect permissions for the database file or 2) Apache module that limit communication.

1) To fix the first problem verify the file has correct permissions, it should be 777 and owned by Apache user.
The SQLite database file is located on the publishing server in directory <Working directory>/data/storage. Login to FTP location where the site is published to, verify and correct permissions. They should be:


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.

Also you may login, check and correct via SSH.

2) Apache modules mod_security or mod_security2 may cause the problem.
Currently it is recommended to disable the modules. For details refer to this article: http://kb.parallels.com/en/5429.

Additional information

Also the errors may be caused by corruption of SQLite database file. See this article for details.