Forums / Install & configuration / Database setup problem

Database setup problem

«

Previous topic

|

Install & configuration

|

Next topic

»

Author	Message
Jackson Hartsfield	Wednesday 01 September 2010 11:24:52 am Well you guys were great in solving my last question/problem but now I have another one... I created my MySQL database on 1and1.com which consist of clicking "New Database" and giving it a name. I got to the point of "Site access configuration" then the next page is "Site Details" When I click next on this page it gives me this error: Warning The database [db339530096] 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 [db339530096] .(I also put up a screenshot at http://jacksonhartsfield.com/dbproblem.jpg ) I once again called 1and1.com and they said it was a MySQL database in the utf-8 format. Thanks in advance for any help and suggestions. Jackson
Jackson Hartsfield	Wednesday 01 September 2010 12:08:24 pm Well I may have solved this myself. I point the EZ setup to another database that I had created but never used as well as just chose the "Plain" site and this time it went through. I dont know what the difference is but it appears to be working now. Jackson
Jackson Hartsfield	Wednesday 01 September 2010 2:34:44 pm Grrr.... Ok, things werent working exactly right so I wiped the files and re-uploaded them and now I am back to my error in the original post. Any suggestions?? Thanks, Jackson
Jérôme Vieilledent	Wednesday 01 September 2010 11:27:53 pm Hi Jackson Your database really needs to be created in UTF-8 charset. You must create it before launching eZ Publish setup wizard : CREATE DATABASE `mydatabase` DEFAULT CHARACTER SET `utf8`; If you already created your database in Latin1 charset for example, you will need to change the charset : ALTER DATABASE `mydatabase` DEFAULT CHARACTER SET `utf8`
Russell Michell	Monday 13 September 2010 1:43:57 pm " Hi Jackson Your database really needs to be created in UTF-8 charset. You must create it before launching eZ Publish setup wizard : CREATE DATABASE `mydatabase` DEFAULT CHARACTER SET `utf8`; If you already created your database in Latin1 charset for example, you will need to change the charset : ALTER DATABASE `mydatabase` DEFAULT CHARACTER SET `utf8` " Jackson, Jérôme is right but I think your problem might be that you do not have shell (direct) access to alter your database configuration - is that right? This is generally the case with many webhosts and is done for security reasons. However, most webhosts with MySQL will also have a GUI management tool like phpMyAdmin for example. Uisng phpMyAdmin you are able to run the necessry SQL commands as Jérôme describes either by pasting them into a text-field or by pointing and clicking. There are many, many phpMyAdmin tutorials and how-to's out there so check first that you have it installed on your host, and then go looking for how to convert/create a DB in it with UTF-8 encoding. Good luck Russ Russell Michell, Wellington, New Zealand. We're building! http://www.theruss.com/blog/ I'm on Twitter: http://twitter.com/therussdotcom Believe nothing, consider everything.
Audun Wilhelmsen	Friday 22 October 2010 12:06:18 pm I had the same problem, and the actual problem was that the database user I created didn't have enough privileges to the database (I think I used the query specified in the documentation, so perhaps this is something that should be checked out). To anyone else Googling this question I suggest trying with a root database user and see if that works.