Forums / Install & configuration / Database Install problem in setup 3.8.3 & 3.8.1

Database Install problem in setup 3.8.3 & 3.8.1

Next topic

Author	Message
Matt Brady	Thursday 03 August 2006 3:54:13 pm Got this problem coming up on install... -------------------- 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 server. Any ideas? Anyone? It's not easy being easy.
Kristof Coomans	Thursday 03 August 2006 11:58:20 pm Hello Matt What result do you get when you run this SQL query on your db? SHOW CREATE DATABASE <i>somedbnamethatexists</i>; independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org
Eckhard Schnell	Friday 04 August 2006 12:57:15 am Hello Matt, try to create the database with the following command CREATE DATABASE crewmark_com_au_-_xportal DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; Hope this helps. Greetings Eckhard Schnell Eckhard Schnell Siemens Business Services http://www.sbs.de Privat: http://www.2schnell.de
Matt Brady	Friday 04 August 2006 10:43:53 pm Hi Kristof -------------quote-------------- What result do you get when you run this SQL query on your db? SHOW CREATE DATABASE somedbnamethatexists; ----------end quote----------- I get the following error when querying database 'crewmark_com_au_-_crewmark': ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-_crewmark' at line 1 Thanks. Hi Eckhard, -------------quote-------------- try to create the database with the following command CREATE DATABASE crewmark_com_au_-_xportal DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; ----------end quote----------- I get the following error: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-_xportal' at line 1 Thanks. I am assuming now that this may be a priviledge problem with mysql... I'm on a shared server and although I can create new databases through the Ensim interface, I don't seem to be able to through phpmyadmin or a command line. What sort of access priviledge is required on mysql to get ezPublish working? It's not easy being easy.
Kristof Coomans	Saturday 05 August 2006 1:42:49 am Hello Matt Put on eZ's SQL debug output to see any query errors. This is not a privilege problem, it's your database name (the - character in particular) that the create and show create commands choke on. Try this (note the backticks surrounding the database name): CREATE DATABASE `crewmark_com_au_-_xportal` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; The setup wizard uses the show create database sql command to look for your db's default charset, but it doesn't quote the db name while it should. This is a bug and I've reported it at http://ez.no/bugs/view/8768. There's an untested solution in the bug report too, give it a try and tell us if it passes the test now. independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org
Matt Brady	Saturday 05 August 2006 5:06:34 pm Hi Kristof Great... through the command line I couldn't create the database so I set it up in the standard way through the Ensim hosting software as I had previously... which is how I normally set up databases on this server. I didn't bother putting on eZ's SQL debug output to see any query errors (as I hadn't been able to install yet). -------------------Quote------------------ The setup wizard uses the show create database sql command to look for your db's default charset, but it doesn't quote the db name while it should. This is a bug and I've reported it at http://ez.no/bugs/view/8768. There's an untested solution in the bug report too, give it a try and tell us if it passes the test now. -----------------End Quote---------------- Used you debug and it worked a treat :) You can now say that this has been tested and is a success. Thanks for you help :) Matt It's not easy being easy.