The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SQL database errors

Discussion in 'Database Discussions' started by kicon, Feb 1, 2015.

  1. kicon

    kicon Member

    Joined:
    May 12, 2011
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    hi
    i have SQL error report from my site database below. it seems happen to all the tables in my site database. could anyone help me to fix this? thank you
    SQL Error: 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 ''tblwhoislog'' at line 1 - Full Query: OPTIMIZE TABLE 'tblwhoislog'
     
  2. whmpress

    whmpress Registered

    Joined:
    Feb 2, 2015
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Have you tried repairing the tables with repair table option in cpanel > mysql > repair database option.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Is this database associated with a specific application? Have you contacted the developer of the application to determine how to best address the issue?

    Thank you.
     
Loading...

Share This Page