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.

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 18 2025 04:07:42
Script start
Timing: Jan 18 2025 04:07:42
Module start 'layout'
Timing: Jan 18 2025 04:07:42
Module start 'content'
Timing: Jan 18 2025 04:07:43
Module end 'content'
Timing: Jan 18 2025 04:07:43
Script end

Main resources:

Total runtime0.8614 sec
Peak memory usage4,096.0000 KB
Database Queries90

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0066 588.1953152.6563
Module start 'layout' 0.00660.0029 740.851639.4922
Module start 'content' 0.00950.8506 780.3438831.1016
Module end 'content' 0.86010.0013 1,611.445320.0938
Script end 0.8614  1,631.5391 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00310.3649160.0002
Check MTime0.00130.1483160.0001
Mysql Total
Database connection0.00180.203410.0018
Mysqli_queries0.783390.9280900.0087
Looping result0.00110.1287880.0000
Template Total0.818695.020.4093
Template load0.00220.252520.0011
Template processing0.816494.773320.4082
Template load and register function0.00020.018910.0002
states
state_id_array0.00610.705610.0061
state_identifier_array0.00090.107620.0005
Override
Cache load0.00200.2273620.0000
Sytem overhead
Fetch class attribute can translate value0.00090.104080.0001
Fetch class attribute name0.00150.1700120.0001
XML
Image XML parsing0.00190.222680.0002
class_abstraction
Instantiating content class attribute0.00000.0033120.0000
General
dbfile0.00090.1089230.0000
String conversion0.00000.000940.0000
Note: percentages do not add up to 100% because some accumulators overlap

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
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 38
 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs