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

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.

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.