Announcement

Collapse
No announcement yet.

Need help with a completely broken site - mysql issues

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

  • Need help with a completely broken site - mysql issues

    My site sat untouched for two years while I dealt with some bad depression and other nasty things, and now I'm trying to get it ready for a vbulletin 5 connect upgrade. It's currently on 3.8.7, and PHP is no longer compatible with it, at 7.2.

    I don't want to try and run an upgrade script with database errors though, so I'm hoping someone can help me with this.

    I previously had a content manager installed from vbadvanced, and that has since been completely uninstalled.

    This is the error that I'm getting:

    Database error in vBulletin 3.8.7:

    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 : Tuesday, February 11th 2020 @ 01:18:29 AM
    Error Date : Tuesday, February 11th 2020 @ 01:18:29 AM
    Script : http://www.pavilionboards.com/
    Referrer :
    IP Address : 185.25.35.10
    Username :
    Classname : vB_Database_MySQLi
    MySQL Version :
    Server : 69.65.31.16
    User Agent :


    Stack Trace:

    #0 vB_Database->halt() called in [path]/includes/class_core.php on line 1395
    #1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 475
    #2 vB_Database->query_read_slave() called in [path]/includes/functions_navigation.php on line 27
    #3 build_navigation_datastore() called in [path]/includes/functions_navigation.php on line 70
    #4 build_navigation_array() called in [path]/includes/functions_navigation.php on line 392
    #5 build_navigation_menudata() called in [path]/includes/functions_navigation.php on line 819
    #6 render_navigation() called in [path]/includes/functions_navigation.php on line 864
    #7 render_navbar_template() called in [path]/includes/functions.php on line 3707
    #8 standard_error() called in [path]/includes/functions.php on line 2161
    #9 vbsetcookie() called in [path]/includes/class_core.php on line 3942
    #10 vB_Session->fetch_session() called in [path]/includes/class_core.php on line 3734
    #11 vB_Session->__construct() called in [path]/includes/init.php on line 659
    #12 require_once([path]/includes/init.php) called in [path]/includes/class_bootstrap.php on line 101
    #13 vB_Bootstrap->init() called in [path]/includes/class_bootstrap.php on line 72
    #14 vB_Bootstrap->bootstrap() called in [path]/global.php on line 26
    #15 require_once([path]/global.php) called in /home/valkysas/public_html/index.php on line 44.

    Also getting the below errors at http://pavilionboards.com/forum/index.php:


    PHP Warning: Use of undefined constant MYSQL_NUM - assumed 'MYSQL_NUM' (this will throw an Error in a future version of PHP) in ..../includes/init.php on line 165

    PHP Warning: Use of undefined constant MYSQL_ASSOC - assumed 'MYSQL_ASSOC' (this will throw an Error in a future version of PHP) in ..../includes/init.php on line 165

    PHP Warning: Use of undefined constant MYSQL_BOTH - assumed 'MYSQL_BOTH' (this will throw an Error in a future version of PHP) in ..../includes/init.php on line 165

    PHP Warning: 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 ..../includes/class_core.php on line 1386

  • #2
    vBulletin 3 simply will not run on php 7.2. You will need to get the site upgraded. Take a full database and file backup first.
    MARK.B | vBULLETIN SUPPORT

    TalkNewsUK - My vBulletin 5.6.4 Demo
    AdminAmmo - My Cloud Demo

    Comment

    Related Topics

    Collapse

    Working...
    X