Forums / Install & configuration / 3.8.0rc1 database connection error on setup/ please help

3.8.0rc1 database connection error on setup/ please help

Author Message

Thomas Johannessen

Tuesday 23 May 2006 3:39:43 am

Issue:
I have altered my DB to utf8, but I still get this message:

The database [xxx_-_38] cannot be used, the setup wizard wants to create the site in [utf-8] but the database has been created using character set []. You will have to choose a database having support for [utf-8] or modify [xxx_-_38] .

<b>
So I ask you smart guys: What do I have to do then, when I change my DB to UTF-8, and I try with all of the utf-8 variants I can, no luck.</b>

Soon I give up EZ.


www.taon.no

Vjeran Vlahovic

Wednesday 24 May 2006 6:57:03 am

I had some strange similar issue like You... Try to remove - from the database name (rename xxx_-_38 to xxx38) and try again.

http://www.netgen.hr/eng

Thomas Johannessen

Wednesday 24 May 2006 9:46:01 am

Vjeran, I understand, but my created databases have the name:
xxx_-_38 where the domain is: xxx = taon_-_38

my creation is just 38, the system makes the rest... I can try but I do not think I can change the name..


www.taon.no

Rod Pal

Thursday 25 May 2006 2:20:09 pm

I have this very same issue. I'm not able to go beyond the "Site details" installation step, it says:

 

 The database [uv0027_noticias] cannot be used, the setup wizard wants to create the site in [utf-8] but the database has been created using character set [iso-8859-1]. You will have to choose a database having support for [utf-8] or modify [uv0027_noticias] 
 

How could it be fixed?

Ole M. Holden

Monday 29 May 2006 11:14:09 pm

I've got the same message also. I have tried to change my DB to utf-8, but it just won't work.

Thomas Johannessen

Sunday 04 June 2006 10:29:18 am

i got this problem first time a month before x-mas 2005, aprox.
Now I have tried so many things, and the issues seems to be the php version, regarding the mySQL problem.

I have also asked the EZ team about any solution, and the best they came up with, even when I asked how much they would charge to fix my setup, was that I should alter my db to utf-8, so it seams like a server related isse, that I cant solve.

Now I am giving up this CMS, They have made it TOO specific for server-ware, so It cant be used on LAMP in general, but an ez special configured solution. They are in general a bit expencive for the low cost projects, but in range for the medium and up.

But MY problem is that I do not want to pay a minimum 4000 NOK a year to be able to set up, test and maintain, develope on an EZ -- I had a EZ running on my own until the php was updated.

So long ez. It was fun.


www.taon.no

Kristof Coomans

Monday 05 June 2006 12:13:46 am

Hi Thomas

What version of PHP/MySQL/eZ publish are you using?

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Matt Brady

Sunday 30 July 2006 12:12:50 am

Hi Kristof... if you're asking, I've got the same problem as Thomas.
Using the install wizard it comes up the the error...
--------------------
Warning
The database [crewmark_com_au_-_xportal] cannot be used, the setup wizard wants to create the site in [utf-8] but the database has been created using character set []. You will have to choose a database having support for [utf-8] or modify [crewmark_com_au_-_xportal] .
--------------------
My set up is:
MySQL 4.1.20
PHP4.4.2
ezPublish 3.8.3 (tried with 3.8.1 also)
Database MySQL charset: UTF-8 Unicode (utf8)

I was running 3.8 on another server
MySQL 4.1.19
PHP4.4.2
ezPublish 3.8

No problem on the previous.

Any ideas?

It's not easy being easy.

Guglielmo Celata

Wednesday 29 November 2006 7:07:55 am

Hi everyone,
I had similar problems, with different php and mysql versions.
It seems that somehow this is a mysql issue.
Once I removed all non-literal characters from the database name, the setup wizard accepted it and everything went smoothly.

This was on a 3.8.6 version.

cheers,
Guglielmo

stephen conklin, jr.

Saturday 10 July 2010 9:43:57 am

This thread looks a bit outdated, but I found a simple fix to the problem. Log into your webserver's cPanel, go to PHP MyAdmin, select your database, then select "Operations" and then at the bottom, you'll see "Coalition" and a drop down menu where you can select utf-8 and "go". As soon as I did that, everything worked.

eZ debug

Timing: Jan 18 2025 01:04:46
Script start
Timing: Jan 18 2025 01:04:46
Module start 'content'
Timing: Jan 18 2025 01:04:47
Module end 'content'
Timing: Jan 18 2025 01:04:47
Script end

Main resources:

Total runtime1.1278 sec
Peak memory usage4,096.0000 KB
Database Queries227

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0060 589.4063180.8047
Module start 'content' 0.00600.9730 770.2109832.2109
Module end 'content' 0.97900.1487 1,602.4219349.2969
Script end 1.1277  1,951.7188 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00390.3489210.0002
Check MTime0.00150.1344210.0001
Mysql Total
Database connection0.00050.047510.0005
Mysqli_queries1.021690.58442270.0045
Looping result0.00280.24602250.0000
Template Total1.091196.720.5455
Template load0.00200.179720.0010
Template processing1.089096.564120.5445
Template load and register function0.00030.023310.0003
states
state_id_array0.00180.159510.0018
state_identifier_array0.00150.135620.0008
Override
Cache load0.00180.1594620.0000
Sytem overhead
Fetch class attribute can translate value0.00160.141990.0002
Fetch class attribute name0.00170.1548120.0001
XML
Image XML parsing0.00620.545890.0007
class_abstraction
Instantiating content class attribute0.00000.0021120.0000
General
dbfile0.01611.4295340.0005
String conversion0.00000.000630.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
10content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
8content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
14content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 38
 Number of unique templates used: 7

Time used to render debug report: 0.0002 secs