Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007
    Posts
    17
    Plugin Contributions
    0

    Default Help, mysql error when optimizing tables

    Hi,

    I'm not sure what's gone on here but when I go into store manager and try to optimize my database I get 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 '-_database2' at line 1
    in:
    [SHOW TABLE STATUS FROM *****-_database2]
    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.

    Can anyone help me please? I'm not sure whats going on here....

    Thanks

    Tim

  2. #2
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,021
    Plugin Contributions
    3

    Default Re: Help, Zencart mysql error


  3. #3
    Join Date
    Jun 2007
    Posts
    17
    Plugin Contributions
    0

    Default Re: Help, Zencart mysql error

    Thank you that has now fixed it! Great stuff thanks

    Tim

 

 

Similar Threads

  1. Dreaded mYSQL 1064 error when importing MySQL 4 database into MySQL5
    By dml311071 in forum Installing on a Linux/Unix Server
    Replies: 4
    Last Post: 10 Jun 2008, 05:38 AM
  2. Optimizing mySQL for Zen Cart in searches
    By enigmabomb in forum General Questions
    Replies: 1
    Last Post: 31 May 2008, 04:56 AM
  3. Mysql error when transporting database
    By pilot in forum General Questions
    Replies: 5
    Last Post: 3 Jan 2007, 02:49 AM
  4. MySQL error when updating order status
    By spretswell in forum General Questions
    Replies: 7
    Last Post: 10 Sep 2006, 10:59 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg