Charset-Error in Setup-Procedure

«

Previous topic

|

Install & configuration

|

Next topic

»

Author	Message
Stefan Huegel	Friday 24 June 2005 7:27:30 am Hi there. I encounter a very strange phenomenon when trying to install EZP: in the last step before closing the installation process I am given the warning ... The database cannot be used, it uses the character set which is different from the requested charset iso-8859-1. The database (MySQL 4.1.8a) is UTF-8, however, and charset for the database cannot be changed (=> shared webspace). I changed the 'preferred and allowed charsets' for my German language isntallation by modifying the respective file share/locale folder - no way I can pass by that error message. Is there any way I can teach EZP to store information in UTF-8 in my database not ISO-8859-1? Any Feedback or help is highly appreciated. Thanx in advance! Stefan.
Birger Kollstrand	Sunday 26 June 2005 6:53:41 am Hi, THere is a good article about unicode (UTF-8) support in eZ. http://ez.no/ez_publish/documentation/configuration/configuration/language_and_charset/unicode_with_ez_publish That solved most of my problems. There are still issues though tha I have not been able to solve. One of them is that email adresses with other characters than the ascii is not accepted as user mail addresses. cu / birger....
Stefan Huegel	Monday 27 June 2005 2:27:12 am Hi Birger. First of all thanx for your reply. A had already been looking into the approach which you suggested. However it did not solve my problem. Still I am stuck at the point where the EZP isntallation process tries to write things into the DB. Then I am given the above mentioned error message. My DB-charset is 'latin1', collation is 'latin1_german2_ci'. As I am working with MySQL 4.1.8a there is no way I can set the charset to 'iso-8859-1'. Anyone any idea what I am doing wrong here? :o/ Stefan.
Birger Kollstrand	Monday 27 June 2005 11:07:12 am Hi, 'latin1' is the same as iso-8859-1. So if your DB is set to latin1/iso-8859-1 and you can't change it. Then all your setup of eZ should be like the default eZ setup which is iso-8859-1 if i understand the documentation correctly. http://www.cs.tut.fi/~jkorpela/latin1/ cu / birger....

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 19 2025 07:04:24
Script start
Timing:	Jan 19 2025 07:04:24
Module start 'layout'
Timing:	Jan 19 2025 07:04:24
Module start 'content'
Timing:	Jan 19 2025 07:04:25
Module end 'content'
Timing:	Jan 19 2025 07:04:25
Script end

Main resources:

Total runtime	0.0299 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.0088	589.2813	152.6406
Module start 'layout'	0.0088	0.0029	741.9219	39.4766
Module start 'content'	0.0117	0.0158	781.3984	89.3828
Module end 'content'	0.0276	0.0023	870.7813	34.3047
Script end	0.0299		905.0859

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0027	9.0927	14	0.0002
Check MTime	0.0012	4.0073	14	0.0001
Mysql Total
Database connection	0.0017	5.5857	1	0.0017
Mysqli_queries	0.0035	11.8639	3	0.0012
Looping result	0.0000	0.0471	1	0.0000
Template Total	0.0017	5.8	1	0.0017
Template load	0.0009	3.1623	1	0.0009
Template processing	0.0008	2.5766	1	0.0008
Override
Cache load	0.0007	2.1984	1	0.0007
General
dbfile	0.0060	20.1203	8	0.0008
String conversion	0.0000	0.0303	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