I'm having a big problem with Drupal clean install. (I've done other sites before and now they also have this problem) I uploaded the Drupal 5.5 tarball. In phpMyAdmin I created the MySQL database drupal-domainname and associated with it a pre-existing SQL user with global privileges. I then did the install script and create the admin account as per the instructions. Here's the problem: I initially added two modules: the Available Updates module and also System info module. No other modules (yet). But I did run cron. So in the System Info, I get: user warning: 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 '' at line 1 query: SHOW GRANTS in /home/domainname/public_html/includes/database.mysql.inc on line 172. user warning: 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 '' at line 1 query: SHOW GRANTS in /home/domainname/public_html/includes/database.mysql.inc on line 172. The identical line is repeated twice on the System info page as I quoted above. So this is odd enough. I generally use phpMyAdmin to create the databases, but when I try it from the terminal using the install instructions, I get a similar message: mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE -> TEMPORARY TABLES, LOCK TABLES -> ON drupal-domainname.* -> TO 'root'@'localhost' IDENTIFIED BY 'password'; ERROR 1064: 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 '-domainname.* Given that the install is as clean as possible (and I've had no similar problems with other Drupal installs on the same server until now) and that it's happening when I use both phpMyAdmin or mysqladmin, I'm thinking this might be a MySQL problem and not a Drupal problem. Any advice and help are really appreciated. Thanks.
Hi, Watch out for hyphens (-) in table and database names. The names using - must be quoted in single backquotes (`). That's why you are getting those errors. Happy New Year! -- # Vasileios Lourdas, # Informatics Engineer, Thessaloniki (Greece) # http://www.lourdas.name
participants (2)
-
Tenant -
Vasileios Lourdas