optimizing database

[visionsfromvoid]

Whenever I've tried to optimize my database through the admin/store manager I get the error message:

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 '-Cart' at line 1
in:
[SHOW TABLE STATUS FROM vfv_Zen-Cart]
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.

What is it and how do I fix it so I can optimize my database?

[DrByte]

Since you've used a hyphen in your database name, you'll need to alter the code to add backquotes around it: http://www.zen-cart.com/forum/showthread.php?t=100191

[visionsfromvoid]

Hi,

thank you for your help. I just got around to trying what you suggested and it didn't seem to help.

the file I edited:

\httpdocs\catalog\myadmin\store_manager.php

Old code looked like this:
case ('optimize_db'):
// clean out unused space in database
$sql = "SHOW TABLE STATUS FROM " . DB_DATABASE;
$tables = $db->Execute($sql);

New code looks like this:
case ('optimize_db'):
// clean out unused space in database
$sql = "SHOW TABLE STATUS FROM `" . DB_DATABASE . "`";
$tables = $db->Execute($sql);

Does everything look OK to you? Any other suggestions?

Thank you for your help in advance.

[DrByte]

That looks about right.
If it's not working for you, you have 4 options:
1. don't worry about optimizing at all ... for years it's never mattered to most shopowners ... unless you get hundreds of orders a day and remove and add thousands of new products every week, it's probably not even needed.
2. use the "optimize database" option provided in your hosting company's control panel, if they have one
3. use the Optimize option to optimize your tables using phpMyAdmin
4. keep playing with the PHP code to make it work as you desire

[visionsfromvoid]

Thank you

[cafman]

Since you've used a hyphen in your database name, you'll need to alter the code to add backquotes around it: http://www.zen-cart.com/forum/showthread.php?t=100191

The solution that link provides is this:

The reason why you are getting this error is because you have a - in your database.

To sort this problem you need to.

Edit store_manager.php

FIND:
$sql = "SHOW TABLE STATUS FROM " . DB_DATABASE ;

REPLACE:
$sql = "SHOW TABLE STATUS FROM `" . DB_DATABASE . "`";

But can some one tell me, what ARE back-quotes? Are they those double quotation marks? And what is that weird little symbol between the double quotation marks at the end of the last line?

[DrByte]

A back-quote is a reverse-direction quotation mark: `
On some keyboards it's located to the left of the "1" key, usually on the same key as the ~ symbol.
That's what that "weird little symbol", as you call it, is.

[cafman]

Thanks Dr Byte!