Error trying to use Data base optomise

[sparktronic]

Can someone tell me why I am getting this when I am in the admin of my catalog and in store manager and then go to the bottom and click optomise:

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 '-_cat1' at line 1
in:
[SHOW TABLE STATUS FROM rochesterlaw_org_-_cat1]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I am on a unix server and running ver 1.37 I haven't changed anything nor has my host.

[DrByte]

It's probably because you're using a '-' in your database name. Anything other than numbers, letters, and underscore are fringe characters in a database name and should be avoided. Even the mysql documentation suggests similarly. The installer doesn't let you use those characters anymore, for this reason.

You might try changing your DB_DATABASE setting to use backquotes around the database name in your admin configure.php file, ie:

define('DB_DATABASE', '`rochesterlaw_org_-_cat1`');

I'd recommend changing things to not use the hyphen though, if at all possible.

[sparktronic]

Unfortunately the sserver automatically puts that in. I only wanted cat1. I tried the back quotes, I assume it is the one next the the number 1 on the keyboard. That did not work. It tells me on the page, can't connect to the database.

[DrByte]

Then you'll have to use phpMyAdmin to optimize your tables if you believe that is necessary.