warning error with database character set

«

Previous topic

|

Install & configuration

|

Next topic

»

Author	Message
donald Bart	Monday 03 March 2008 2:29:50 am Good day, I am trying to install the eZ publish 4.0.0, but i am stuck in the site details page, i keep getting this warning message: "The database [db237249126] 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 [db237249126]" . I have check out my database character set it is not [iso-8859-1], but rather it is [utf-8], this is my MySQL charset: UTF-8 Unicode (utf8), cos i am using MySQL 5.0 I dont know what to do i have read other issues like this on the forum, and done all that is been stated but still i am stuck.. is there something i am doing wrong.
Kristof Coomans	Monday 03 March 2008 2:51:38 am Hi Bart, You can run the following SQL query to find out what's the default charset of your schema called db237249126: select DEFAULT_CHARACTER_SET_NAME from information_schema.schemata where schema_name='db237249126'; Good luck! independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org
donald Bart	Monday 03 March 2008 4:03:22 am Hi krisof Thanks for your reply.. I have just ran the query and the default charset is utf8 but i am still having the same problems, with the wizard. Dont know what to do next... Donald.
Albert De Queljoe	Tuesday 04 March 2008 10:42:34 am Hello Donald, I've got the same problem.. my MySQL charset is utf8... but still the warning message as you have mentioned in your post... I've installed on two different servers with same result.... Is this a script issue or ? .... regards Ps. i'm using: MySQL 4.1.14 PHP Version: 5.2.0 EDIT: problem solved ! Click the database name and set "Collation" to utf8_unicode_ci ....
donald Bart	Tuesday 04 March 2008 11:55:02 pm Hi Albert, I am still stuck here with this warning about the charset ... But i saw this write up, and dont know i guess i will have to try it out to see if it works out http://ez.no/ezpublish/documentation/configuration/configuration/language_and_charset/unicode_with_ez_publish Guess to try out the configuration in this ini. * site.ini * i18n.ini * template.ini Will let you know if it works out.. But i you devise a means around it prior to me, let me know also. Regards Donald.
Albert De Queljoe	Wednesday 05 March 2008 1:01:01 am Hello Donald, Click the database name and set "Collation" to utf8_unicode_ci .. this works for me :) Hope this will do regards
donald Bart	Wednesday 05 March 2008 3:58:26 am Hi Albert, Nice to know you sorted it out.. But funny that method did not work for me, Did change the collation setting to utf8_unicode_ci But did not work for me... Just dont know what next to do. Donald
Albert De Queljoe	Wednesday 05 March 2008 7:14:26 am Hello Donald, Maybe you should delete the old database..make a new one and try different options in collation: - utf8_unicode_ci - utf8_bin -----------> was reported by a member to have also solved the problem regards
donald Bart	Wednesday 05 March 2008 8:26:31 am Hi Albert, Thanks for the info, i got that sorted out...what i needed do was to change the default character set from [latin 1] to [utf-8] but i still am stock at the ending of the installation it is giving me the message The following errors were detected: * EZSW-004Failed inserting data to mysql Table 'ezapprove_items' already exists * EZSW-040Failed to initialize site package 'ezwebin_site' If you think you have fixed the errors you can try then click the "Retry" button. still looking for a way around this thanks. Donald

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing:	Jan 31 2025 05:30:26
Script start
Timing:	Jan 31 2025 05:30:26
Module start 'layout'
Timing:	Jan 31 2025 05:30:26
Module start 'content'
Timing:	Jan 31 2025 05:30:26
Module end 'content'
Timing:	Jan 31 2025 05:30:26
Script end

Main resources:

Total runtime	0.0215 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0064	588.3672	151.2266
Module start 'layout'	0.0064	0.0030	739.5938	36.6797
Module start 'content'	0.0094	0.0096	776.2734	98.3438
Module end 'content'	0.0190	0.0025	874.6172	37.9922
Script end	0.0214		912.6094

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0035	16.2041	14	0.0002
Check MTime	0.0015	6.8039	14	0.0001
Mysql Total
Database connection	0.0008	3.4889	1	0.0008
Mysqli_queries	0.0022	10.3460	3	0.0007
Looping result	0.0000	0.0509	1	0.0000
Template Total	0.0018	8.3	1	0.0018
Template load	0.0014	6.3919	1	0.0014
Template processing	0.0004	1.8674	1	0.0004
Override
Cache load	0.0010	4.4736	1	0.0010
General
dbfile	0.0031	14.4640	8	0.0004
String conversion	0.0000	0.0377	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.0001 secs