PHP SQLite extension does not support UTF-8 encoding on the publishing server.

[yee78]

i found this error in my sitebuilder and all my client cant publish..

error msg: PHP SQLite extension does not support UTF-8 encoding on the publishing server. Text information on the site may be displayed incorrectly.

[root@server SQLite-1.0.3]# php -i|grep -i sqlite

PHP Warning: PHP Startup: Unable to load dynamic library './sqlite.so' - ./sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0
PDO drivers => mysql, sqlite, sqlite2
pdo_sqlite
PDO Driver for SQLite 3.x => enabled
PECL Module version => (bundled) 1.0.1 $Id: pdo_sqlite.c 293036 2010-01-03 09:23:27Z sebastian $
SQLite Library => 3.3.7
Registered save handlers => files user sqlite
SQLite
SQLite support => enabled
PECL Module version => 2.0-dev $Id: sqlite.c 298697 2010-04-28 12:10:10Z iliaa $
SQLite Library => 2.8.17
SQLite Encoding => iso8859
sqlite.assoc_case => 0 => 0
PWD => /root/SQLite-1.0.3
_SERVER["PWD"] => /root/SQLite-1.0.3
_ENV["PWD"] => /root/SQLite-1.0.3

how to solve it? please help..

 

[yee78]

i already follow instruction of http://kb.odin.com/en/5460...but it cant change SQLite Encoding => iso8859
to UTF-8..how?? can you help me check? i can give you my root password...

 

[yee78]

[root@server SQLite-1.0.3]# sb_config
PHP Warning: Module 'sqlite' already loaded in Unknown on line 0
PHP Warning: Module 'sqlite' already loaded in Unknown on line 0
Usage:
--phpcli_path PHP CLI executable [/opt/php52/bin/php5]
--phpcgi_path PHP CGI executable [/opt/php52/cgi-bin/php5]
--update_locales Update locales [no]
--update_templates Update templates [no]
--update_modules Update modules [no]
--update_skins Update skins [no]
--migrate_all Migrate all sites [no]
--help Show this help [no]
--verbose Be verbose [no]
--[no]use_rewrite Enable/disable mod_rewrite usage [yes]
--sb_admin_passwd Password for admin user [not changed by default]
--db_host MySQL database remote host [localhost]
--db_port MySQL database remote port [3306]
--db_admin_name MySQL administrator username [root]
--db_admin_passwd MySQL administrator password
--sb_db_user_name Sitebuilder MySQL username [sitebuilder_db]
--sb_db_user_passwd Sitebuilder MySQL password
--sb_db_name Sitebuilder database name [sitebuilder3]
--httpd_port Webserver port [80]
--sb_host_ip Create virtual host on the specified IP [202.75.54.245]
--sb_hostname Sitebuilder virtual host name [sitebuilder2u.net]
--httpd_owner Webserver user and group [apache:apache]
--[no]enable_ssl Enable/disable SSL [no]

 

[yee78]

anyone can help me...??????????????

 

[yee78]

urgent here...................................

 

[Dmitry Frantsev]

Did you follow the KB article on each step? Actually, cannot say for sure where is the issue here. Looks like module was compiled with errors. Did all the steps were passed successfully? Please let me know the details.

 

[Leyla]

We would like to offer you to contact our Technical Support team & create a support request at

https://www.parallels.com/support/sitebuilder/form/

Please include the detailed description of the problem.

Thank you

 

[yee78]

ioncube=ok os= phpVersion=5.2.14 mbstring=ok zlib=ok session=ok dom=ok domxml_xslt=fail xslt=fail sqlite=2.8.17 sqliteEncoding=iso8859 gd_png=ok gd_gif=ok gd_jpg=ok gd_wbmp=ok gd=2.0.34 mail=ok curl=ok serverApi=Apache Handler

how to install dom-xslt??

 

[yee78]

who can help me...please..........

 

[Dmitry Frantsev]

In this case PHP on the server should be recompiled with appropriate options. With PHP 5.x installed on the target server, it is necessary to compile PHP with the following options: -with-dom-xslt=/usr; -with-dom-exslt=/usr; -with-dom=shared and -with-xsl.

 

[yee78]

after that. sitebuilder can run?? how to change encoding to UTF-8