Forums / Install & configuration / Pb installing eZ : character encoding conflict with MySQL

Pb installing eZ : character encoding conflict with MySQL

« 
Previous topic
|
Install & configuration
|
Next topic
 »
Author Message

Michel Roche

Thursday 20 April 2006 6:50:42 am

Hi,
I'm attempting to install eZ Publish in a provider's space, so I only have acces to the tool he let me to administrate PHP and MySQL, that is PHPMyAdmin for this concern.

When the eZ installer comes to the point of selecting the database, it finds the right one but complains when I click on the Next button because :

<i>The database cannot be used, it uses the character set iso-8859-1 which is different from the requested charset utf-8.</i>

I swear I defined all formats to utf-8 in the db, either for the data storage and for the collating datas.
So I don't understand what I'm missing, or if it's a bug (either from eZ, PhpMyAdmin, MySql or my provider) that I should work around.

Thanks a lot for your help.

Michel Roche
occasionally webmaster ;-)

Vercors, France.

Łukasz Serwatka

Sunday 23 April 2006 11:02:59 pm

Hello,

What is your MySQL version? Support for Unicode is available since version 4.1 or higer. Use this query to setup database in Unicode:

CREATE DATABASE `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

You can execute it from phpmyadmin.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Hakim Bouras

Thursday 15 June 2006 4:39:39 am

Hello,

It happens to me too when I tred to install ezPublish 3.8 selecting 2 languages. The only way I had to finish my installation was to select only one language.

Hakim

eZ debug

Timing: Jan 20 2025 10:52:20
Script start
Timing: Jan 20 2025 10:52:20
Module start 'content'
Timing: Jan 20 2025 10:52:21
Module end 'content'
Timing: Jan 20 2025 10:52:21
Script end

Main resources:

Total runtime1.0949 sec
Peak memory usage4,096.0000 KB
Database Queries196

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0061 590.4922180.8047
Module start 'content' 0.00610.9787 771.2969583.7266
Module end 'content' 0.98480.1101 1,355.0234333.0469
Script end 1.0948  1,688.0703 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00390.3558210.0002
Check MTime0.00140.1276210.0001
Mysql Total
Database connection0.00080.069410.0008
Mysqli_queries1.018493.01321960.0052
Looping result0.00930.84921940.0000
Template Total1.064597.220.5323
Template load0.00240.221120.0012
Template processing1.062197.001920.5310
Template load and register function0.00010.013010.0001
states
state_id_array0.00130.114310.0013
state_identifier_array0.00100.095620.0005
Override
Cache load0.00200.1827240.0001
Sytem overhead
Fetch class attribute can translate value0.00100.092240.0003
Fetch class attribute name0.00120.105550.0002
XML
Image XML parsing0.00150.140840.0004
class_abstraction
Instantiating content class attribute0.00000.001150.0000
General
dbfile0.00230.2133350.0001
String conversion0.00020.020030.0001
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
3content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
3content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
6content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 17
 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs