Forums / Install & configuration / Wrong character set detected while installing DB

Wrong character set detected while installing DB

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

mix mac

Saturday 24 April 2010 3:53:07 am

Hi!

This is my first ezP installation. I've borrowed the 4.3.0 package.

Everything runs smoothly through the install wizard until the Step 9 (DB details).

As said in the doc: “It is required that the database uses UTF-8 as character set.”

[URL=http://img153.imageshack.us/i/capturedcran20100424170.png/][IMG]http://img153.imageshack.us/img153/5455/capturedcran20100424170.png[/IMG][/URL]

Which is the case, as shown in the screenshot.

But the Wizard still argues that the DB has been created using a [iso-8859-1] character set.

Any idea to help me solve this pb?

Thanks!

m

mix mac

Saturday 24 April 2010 4:27:01 am

I've found the problem. The DB was created with a utf8 caracter set. But the collation was set to latin1_swedish_ci. I've updated this to utf8-unicode_ci through phpMyAdmin.

Sorry for the noise!

m

Nicolas Pastorino

Saturday 24 April 2010 9:17:11 am

Hi !

Good to read you found your problem. You may now want to mark the forum thread as solved (small ticker at the leff of the topic's title above).

Ow, and welcome aboard the eZ Community !

Cheers,

--
Nicolas Pastorino
Director Community - eZ
Member of the Community Project Board

eZ Publish Community on twitter: http://twitter.com/ezcommunity

t : http://twitter.com/jeanvoye
G+ : http://plus.tl/jeanvoye

eZ debug

Timing: Jan 29 2025 13:36:43
Script start
Timing: Jan 29 2025 13:36:43
Module start 'content'
Timing: Jan 29 2025 13:36:43
Module end 'content'
Timing: Jan 29 2025 13:36:43
Script end

Main resources:

Total runtime0.2258 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0069 588.1797180.8047
Module start 'content' 0.00690.0071 768.984493.8828
Module end 'content' 0.01400.2117 862.8672522.6250
Script end 0.2256  1,385.4922 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00361.5907200.0002
Check MTime0.00140.6142200.0001
Mysql Total
Database connection0.00090.389310.0009
Mysqli_queries0.134359.48871410.0010
Looping result0.00140.62051390.0000
Template Total0.211393.610.2113
Template load0.00090.404310.0009
Template processing0.210393.147610.2103
Override
Cache load0.00060.277710.0006
Sytem overhead
Fetch class attribute can translate value0.00100.458710.0010
XML
Image XML parsing0.00020.108510.0002
General
dbfile0.042318.7360200.0021
String conversion0.00000.002630.0000
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
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs