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.