Forums Database Error after uploading all files of 4.2.1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Matrix Leader
    Senior Member
    • Nov 2011
    • 117
    • 3.8.x

    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!?
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24326
    • 5.7.X

    #2
    Try going to http://forums.tweakarena.com/install/upgrade.php
    Vote for:

    - Admin Settable Paid Subscription Reminder Timeframe (vB6)
    - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

    Comment

    • Matrix Leader
      Senior Member
      • Nov 2011
      • 117
      • 3.8.x

      #3
      Originally posted by Trevor Hannant

      Ohh!! thanks a lot!

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

      Comment

      • Matrix Leader
        Senior Member
        • Nov 2011
        • 117
        • 3.8.x

        #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

        • Xplosive60
          New Member
          • Feb 2010
          • 25
          • 4.0.0

          #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, 6:20am.

          Comment

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