Cannot publish when statistics module is turned on

[GiorgosI]

CentOS5 x64
Sitebuilder 4.5.0 Hotfix-20110711 (2011071115)

If I go to:
-> Sitebuilder
-> Sites
-> Click on site alias I'd like
-> Statistics Settings
-> Check the checkbox 'Statistics is turned on'

and then try to publish the site, I get the error:
1 PHP SQLite extension does not support UTF-8 encoding on the publishing server. Text information on the site may be displayed incorrectly.
2 Cannot execute a query to SQLite database.
3 The data of 'Statistics' module (id is 'zrftbzem48x') has not been published.
4 The modules data have been updated with errors.

If I disable statistics (uncheck the checkbox 'Statistics is turned on'), the site is published successfully and there are no any errors in sitebuilder logs.

 

[Dmitry Frantsev]

Hello,

Statistic module is one of the dynamic module and additional requirements take affect here.

There is a special requirements list for publishing server exists - http://www.parallels.com/en/products/sitebuilder/reqs
This list includes sqlite (2.x, support UTF-8 encoding) support for PHP. If publishing side does not have appropriate UTF-8 encoding support for SQLite 2.x extension installed for PHP publication will be completed but you will get warning message during publication.
Resolution
There are two ways for resolving this situation:

1. Install appropriate SQLite 2.x extension with UTF-8 encoding support. Complete instructions can be found here:
http://kb.parallels.com/en/5462

Or try to:

2. Disable warning message by adding following line into <SB_ROOT>/config file:

[general]
...........
disable_sqlite_encoding_warning = true

Let me know how it goes.

 

[GiorgosI]

Thank you Dmitry for your fast reply.

The server to which I publish the site (hosts the site) is Windows server and indeed it does not have UTF-8 encoding support for SQLite 2.x extension (Sitebuilder is installed in linux server).
I cannot access the article you refer to (http://kb.parallels.com/en/5462). It outputs:
'You can't see internal articles'

In the past, when I was trying to publish to that windows server I had the warning:
PHP SQLite extension does not support UTF-8 encoding on the publishing server. Text information on the site may be displayed incorrectly.

but not all other errors.
I wouldn't like to disable the warning message because we use this sitebuilder installation to publish sites to many servers, so I would like to know which one supports UTF-8.

So, could you please send the right link for the article?