Database setup problem - community.ez.no

Wednesday 01 September 2010 11:24:52 am - 5 replies

5 replies

Author	Message
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.

You must be logged in to post messages in this topic!