Database character set issue

Next topic

Author	Message
Aaron Carlino	Friday 23 February 2007 9:06:59 am I'm installing ezPublish 3.6.11 (the latest version that works with PHP 4.3) and I've gotten to following screen: Site details This page lets you modify information about the site you've chosen to install. In addition, it also lets you choose a database for the site. Warning The database cannot be used, it uses the character set which is different from the requested charset iso-8859-1, iso-8859-2, iso-8859-3, iso-8859-4, iso-8859-9, iso-8859-10, iso-8859-13, iso-8859-14, iso-8859-15, windows-1252, windows-1250, cp850, dec-mcs. When I go into PHPMyAdmin, I don't have ISO as a choice. I've tried changing it to UTF, but it doesn't work. What does EZPublish want from me? -Aaron MYSQL 4.1 PHP 4.3.9
Claudia Kosny	Friday 23 February 2007 12:53:01 pm Hi Aaron As the name of the used charset is missing in the error message I think that you are experiencing this bug http://issues.ez.no/6545 (read Vittals comment for the solution). Here some info about character sets in MySQL: http://dev.mysql.com/doc/refman/4.1/en/charset-we-sets.html says that: MySQL's latin1 is the same as the Windows cp1252 character set. This means it is the same as the official ISO 8859-1 ... Not sure whether eZ 3.6 is smart enough to recognise this though - just try it out if necessary. Good luck Claudia
Aaron Carlino	Tuesday 27 February 2007 7:58:39 am Perfect!!! Thank you!
Betsy Gamrat	Tuesday 27 February 2007 7:29:44 pm I had the same question, thank you Claudia. :)

eZ debug

Timing:	Jan 19 2025 00:32:56
Script start
Timing:	Jan 19 2025 00:32:56
Module start 'layout'
Timing:	Jan 19 2025 00:32:56
Module start 'content'
Timing:	Jan 19 2025 00:32:57
Module end 'content'
Timing:	Jan 19 2025 00:32:57
Script end

Main resources:

Total runtime	0.8962 sec
Peak memory usage	4,096.0000 KB
Database Queries	62

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0077	589.1484	152.6406
Module start 'layout'	0.0077	0.0060	741.7891	39.4766
Module start 'content'	0.0137	0.8811	781.2656	546.8203
Module end 'content'	0.8948	0.0013	1,328.0859	12.4609
Script end	0.8962		1,340.5469

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0037	0.4164	16	0.0002
Check MTime	0.0016	0.1816	16	0.0001
Mysql Total
Database connection	0.0014	0.1586	1	0.0014
Mysqli_queries	0.8346	93.1320	62	0.0135
Looping result	0.0006	0.0699	60	0.0000
Template Total	0.8517	95.0	2	0.4258
Template load	0.0025	0.2747	2	0.0012
Template processing	0.8492	94.7598	2	0.4246
Template load and register function	0.0002	0.0212	1	0.0002
states
state_id_array	0.0010	0.1116	1	0.0010
state_identifier_array	0.0025	0.2807	2	0.0013
Override
Cache load	0.0021	0.2382	27	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0009	0.0989	3	0.0003
Fetch class attribute name	0.0011	0.1280	5	0.0002
XML
Image XML parsing	0.0008	0.0851	3	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0013	5	0.0000
General
dbfile	0.0040	0.4505	16	0.0003
String conversion	0.0000	0.0012	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
4	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
7	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 17 Number of unique templates used: 7

Time used to render debug report: 0.0002 secs