Invalid SQL after upgrade to 3.7.2

  • Time
  • Show
Clear All
new posts
  • DD214
    New Member
    • Apr 2005
    • 2

    Invalid SQL after upgrade to 3.7.2

    After upgrading to 3.7.2 PL1, I receive the following error dozens of times a day. I have not personally seen any errors when using the forum, nor have I had any complaints, but this error is filling up my inbox and I have no idea how to fix it. Here is the error:

    Invalid SQL:

    SELECT text, languageid, special
    FROM phrase AS phrase
    LEFT JOIN phrasetype USING (fieldname)
    WHERE phrase.fieldname = 'error'
    AND varname = 'install_ghostscript_to_resize_pdf' AND languageid IN (-1, 0, 0);

    MySQL Error :
    Error Number :
    Request Date : Wednesday, August 6th 2008 @ 01:14:05 AM
    Error Date : Wednesday, August 6th 2008 @ 01:14:06 AM
    Script : {domain removed} /image.php?type=regcheck&imagehash=7b809668ec7e9862741c471611637e01
  • Jose Amaral Rego
    Senior Member
    • Feb 2005
    • 11058
    • 1.1.x

    It would be nice to have the error message...
    MySQL Error :
    Error Number :


    • DD214
      New Member
      • Apr 2005
      • 2

      Originally posted by Jose Amaral Rego
      It would be nice to have the error message...
      I agree, but they are not listed in the error notification.


      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        Invalid SQL errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any third-pary 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.


        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.