No announcement yet.

Recurring database error after moving installation

  • Time
  • Show
Clear All
new posts
  • pneisen
    New Member
    • Apr 2007
    • 1
    • 3.6.x

    Recurring database error after moving installation

    I recently moved my vbulletin installation farther down the filesystem tree on my host. Basically from public_html/gmtrucks to public_html/domains/ Since then, I have been receiving numerous emails everyday with the same database error:

    Database error in vBulletin 3.6.6:

    Invalid SQL:

    SELECT page.page_id, page.page_namespace, page.page_title, SUBSTRING(txt.old_text, 1, 4096) AS page_text
    FROM page page
    LEFT OUTER JOIN revision rev ON page.page_latest = rev.rev_id
    LEFT OUTER JOIN text txt ON rev.rev_text_id = txt.old_id
    WHERE page_namespace = AND page_touched >= '20070906000000';

    MySQL 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 'AND page_touched >= '20070906000000'' at line 5
    Error Number : 1064
    Date : Wednesday, September 5th 2007 @ 06:10:09 PM
    Script : .php?&rand=514050
    Referrer :
    IP Address :
    Username : Unregistered
    Classname : vB_Database

    I can see that the syntax error is because there is no value after the = on the SQL statement. I looked at the cron.php and didn't see any SQL formatting that might be suspect. So, I am kinda lost. Everything works fine on the board, but I get a ton of these emails every day.

    Any ideas?
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    SQL Syntax errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any hacks or plugins, then see if you still have this problem.

    If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

    Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.