eZ publish 4.0 MySQL utf8 install problem

Previous topic

Install & configuration

Next topic

Author	Message
Michael Hall	Monday 24 December 2007 11:15:35 pm Gday: I'm trying to install eZ publish 4.0 on the following platform: openSUSE 10.3 apache 2.2.4 (prefork) PHP 5.2.4 MySQL 5.0.45 I'm using the wizard which is complaining about the database as follows: Warning The database [dbez4] cannot be used, the setup wizard wants to create the site in [utf-8] but the database has been created using character set [iso-8859-1]. You will have to choose a database having support for [utf-8] or modify [dbez4] . I have fiddled just about everything I can think of in MySQL, and have done all the usual 'SET NAMES' and 'SET CHARACTER SET' stuff. All the character_set_* variables are now utf8, even in the /etc/my.conf file, but I still get the same error message. I actually started with a manual install and got a site up OK, but it was bare bones and I wanted a 'kick start' so have now opted for the wizard. Have I overlooked something? Could the problem lie in the site packages (plainsite / ezwebin) I'm trying to use, or maybe in PHP? Confused ... any tips?
Greg McAvoy-Jensen	Monday 24 December 2007 11:27:56 pm Michael, Welcome to eZ Publish. Which character were you hoping to use? If UTF8, when you created the database, did you use: mysql> create database <database> character set 'utf8';? Granite Horizon, Certified Developer of eZ Publish Web Solutions Provider of the SaaS Solution Granite Horizon In The Cloud \| http://granitehorizon.com/cloud http://granitehorizon.com \| +1 916 647 6350 \| California USA \| @granitegreg Blog: http://granitehorizon.com/blog
Michael Hall	Monday 24 December 2007 11:41:47 pm That works perfectly, thanks!

Author

Message

Michael Hall

Monday 24 December 2007 11:15:35 pm

Gday:

I'm trying to install eZ publish 4.0 on the following platform:

openSUSE 10.3
apache 2.2.4 (prefork)
PHP 5.2.4
MySQL 5.0.45

I'm using the wizard which is complaining about the database as follows:

Warning

The database [dbez4] cannot be used, the setup wizard wants to create the site in [utf-8] but the database has been created using character set [iso-8859-1]. You will have to choose a database having support for [utf-8] or modify [dbez4] .

I have fiddled just about everything I can think of in MySQL, and have done all the usual 'SET NAMES' and 'SET CHARACTER SET' stuff. All the character_set_* variables are now utf8, even in the /etc/my.conf file, but I still get the same error message.

I actually started with a manual install and got a site up OK, but it was bare bones and I wanted a 'kick start' so have now opted for the wizard. Have I overlooked something? Could the problem lie in the site packages (plainsite / ezwebin) I'm trying to use, or maybe in PHP?

Confused ... any tips?

Greg McAvoy-Jensen

Monday 24 December 2007 11:27:56 pm

Michael,

Welcome to eZ Publish. Which character were you hoping to use? If UTF8, when you created the database, did you use:

mysql> create database <database> character set 'utf8';?

Granite Horizon, Certified Developer of eZ Publish Web Solutions
Provider of the SaaS Solution Granite Horizon In The Cloud | http://granitehorizon.com/cloud
http://granitehorizon.com | +1 916 647 6350 | California USA | @granitegreg
Blog: http://granitehorizon.com/blog

Michael Hall

Monday 24 December 2007 11:41:47 pm

That works perfectly, thanks!

eZ debug

Timing:	Jan 31 2025 01:25:49
Script start
Timing:	Jan 31 2025 01:25:49
Module start 'layout'
Timing:	Jan 31 2025 01:25:49
Module start 'content'
Timing:	Jan 31 2025 01:25:49
Module end 'content'
Timing:	Jan 31 2025 01:25:49
Script end

Main resources:

Total runtime	0.0387 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0086	588.3750	151.2266
Module start 'layout'	0.0086	0.0052	739.6016	220.7188
Module start 'content'	0.0138	0.0228	960.3203	997.8672
Module end 'content'	0.0366	0.0020	1,958.1875	33.9922
Script end	0.0386		1,992.1797

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0029	7.5240	14	0.0002
Check MTime	0.0011	2.7211	14	0.0001
Mysql Total
Database connection	0.0019	4.8479	1	0.0019
Mysqli_queries	0.0032	8.3562	3	0.0011
Looping result	0.0001	0.1424	1	0.0001
Template Total	0.0015	3.8	1	0.0015
Template load	0.0011	2.9110	1	0.0011
Template processing	0.0003	0.8119	1	0.0003
Override
Cache load	0.0007	1.7249	1	0.0007
General
dbfile	0.0026	6.6363	8	0.0003
String conversion	0.0000	0.0345	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0002 secs