Announcement

Collapse
No announcement yet.

Forums Database Error after uploading all files of 4.2.1

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Forums Database Error after uploading all files of 4.2.1

    I never had any problems while upgrading my forums so I didn't take a backup before attempting the upgrade, I know, very stupid of me

    I had 4.2.0 Installed so I downloaded 4.2.1, removed the install.php and config.php.new files and uploaded the files to my forums folder on my server overwriting all files that are there.

    Half way down through the process, when I opened my website I got this error:

    Warning: mysqli_query() [[URL="http://forums.tweakarena.com/function.mysqli-query"]function.mysqli-query[/URL="http://forums.tweakarena.com/function.mysqli-query"]]: (42000/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 '= 0 ORDER BY navtype, displayorder' at line 3 in [path]/includes/class_core.php on line 1391
    Database error
    The Tweak Arena Forums database has encountered a problem.

    Please try the following:
    • Load the page again by clicking the [URL="http://forums.tweakarena.com/upgrade.php#"]Refresh[/URL="http://forums.tweakarena.com/upgrade.php#"] button in your web browser.
    • Open the [URL="http://forums.tweakarena.com/"]forums.tweakarena.com[/URL="http://forums.tweakarena.com/"] home page, then try to open another page.
    • Click the Back button to try another link.

    The forums.tweakarena.com forum technical staff have been notified of the error, though you may [EMAIL="[email protected]"]contact them[/EMAIL="[email protected]"] if the problem persists.

    We apologise for any inconvenience.

    Database error in vBulletin 4.2.0:

    Invalid SQL:

    SELECT *
    FROM navigation
    WHERE state & = 0
    ORDER BY navtype, displayorder;

    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 '= 0
    ORDER BY navtype, displayorder' at line 3
    Error Number : 1064
    Request Date : Thursday, April 18th 2013 @ 11:17:57 AM
    Error Date : Thursday, April 18th 2013 @ 11:17:57 AM
    Script : [URL="http://forums.tweakarena.com/upgrade.php"]http://forums.tweakarena.com/upgrade.php[/URL="http://forums.tweakarena.com/upgrade.php"]
    Referrer :
    IP Address : 92.98.10.97
    Username : Matrix Leader
    Classname : vB_Database_MySQLi
    MySQL Version : 5.5.23-55
    Now if I try to go to [URL="http://forums.tweakarena.com/upgrade.php"]http://forums.tweakarena.com/upgrade.php[/URL="http://forums.tweakarena.com/upgrade.php"] I get the same page as above

    Please help, what shall I do? I cannot even run the upgrade script upgrade.php since I only get the above error when I type in that URL!?

  • #3
    Originally posted by Trevor Hannant View Post

    Ohh!! thanks a lot!

    That worked! you are a savior man! thanks for your quick support

    Comment


    • #4
      Forum upgraded successfully

      Tweak Arena
      This is a discussion forum powered by vBulletin. To find out about vBulletin, go to http://www.vbulletin.com/ .

      Comment


      • #5
        When i go to link posted and enter my customer number it tells me its incorrect but have triple checked it and its right.

        Update

        Figured out the problem with vbull, i didn't run the upgrade script, all working now.
        Last edited by Xplosive60; Sun 21 Apr '13, 7:20am.

        Comment

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