Forums / Install & configuration / Affected by the charset problem during install....

Affected by the charset problem during install....

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

Benj Duval

Monday 20 March 2006 7:08:36 am

Hi,
i'm unfortunately affected by the charset problem during install. This is the first time ever that i encounter this problem when installing a script.

Linux
Ez: 3.7.4
Php: 4.4.2
Mysql: 4.1.18

My server is a dedicated server, hosted in USA. I chose as a language, English/USA and got the folowing message:

"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."

My question is: how can I know which encoding is my database using ? What should I do to convert it ?

(although I don't see why I encouter a problem when using English/USA as the language).

Thanks,
Benj

Benj Duval

Monday 20 March 2006 8:22:30 am

I logged in mysql, used the ez database and typed:

mysql> ALTER DATABASE CHARACTER SET latin1;
Query OK, 1 row affected (0.00 sec)

mysql> ALTER DATABASE COLLATE latin1_swedish_ci;
Query OK, 1 row affected (0.00 sec)

Even after this, I still got the error message.

Well, this is all I can do thus far. If I can't get past this, I will not be able to use the software.

Cordially,
Benj

Benj Duval

Monday 20 March 2006 10:36:10 am

I tried to install EZ in an existing database. For some reason, I didn't had the problem with this already existing database.

Maybe the problem was caused because my database name contained a "-" ?

Anyway, the system is up and running. If someone encounter this problem, try removing "-" from your database name if any.

Benj

eZ debug

Timing: Jan 18 2025 19:07:00
Script start
Timing: Jan 18 2025 19:07:00
Module start 'content'
Timing: Jan 18 2025 19:07:01
Module end 'content'
Timing: Jan 18 2025 19:07:01
Script end

Main resources:

Total runtime0.7194 sec
Peak memory usage4,096.0000 KB
Database Queries192

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0070 587.9609180.8047
Module start 'content' 0.00700.5545 768.7656445.7813
Module end 'content' 0.56150.1578 1,214.5469333.4453
Script end 0.7193  1,547.9922 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00490.6880210.0002
Check MTime0.00150.2139210.0001
Mysql Total
Database connection0.00090.119010.0009
Mysqli_queries0.642189.26161920.0033
Looping result0.00210.29261900.0000
Template Total0.685895.320.3429
Template load0.00220.299720.0011
Template processing0.683695.032720.3418
Template load and register function0.00020.028410.0002
states
state_id_array0.00090.126210.0009
state_identifier_array0.00130.184620.0007
Override
Cache load0.00160.2224310.0001
Sytem overhead
Fetch class attribute can translate value0.00190.259420.0009
Fetch class attribute name0.00150.204330.0005
XML
Image XML parsing0.00040.059620.0002
class_abstraction
Instantiating content class attribute0.00000.001130.0000
General
dbfile0.00530.7301210.0003
String conversion0.00000.001130.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
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
6content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
8content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 19
 Number of unique templates used: 5

Time used to render debug report: 0.0004 secs