Problem with Store Manager.

[philip56]

When I try to run the "Optimize Database to remove wasted space from deleted records" option in Store Manager, I recieve the following 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 '-_zcart' at line 1
in:
[SHOW TABLE STATUS FROM pjleisurewear_co_uk_-_zcart]
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.

Any advice would be gratfully received.

Regards

Philip

[DrByte]

What version of MySQL are you using?

[philip56]

What version of MySQL are you using?

Good morning DrByte, thanks for replying. I'm using 5.0.45

Philip

[Myth]

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 . "`";

[philip56]

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 . "`";

Hi Myth/DrByte

Finally got round to trying this - I'm afraid it hasn't helped.

I appreciate it's not critical, but if you have any further thoughts, I'd love to hear them.

Philip

[DrByte]

Did you use back-quotes?

[philip56]

Did you use back-quotes?

Hmm, those blessed backquotes - they get me every time!

Problem solved.

Many thanks

Philip