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.0 Demo
    AdminAmmo - My Cloud Demo

    Comment

    Related Topics

    Collapse

    • vb_nils
      Mysql error with Sphinx enabled
      by vb_nils
      Hello,

      Since a long time I get sporadic errors emails indicating "Database Error".
      I finally have time to investigate, and it seems to happen when a user is writting an answer
      ...
      Sun 25th Oct '15, 12:06am
    • Paul.
      Database Error
      by Paul.
      Hi,

      Literally no idea why we're getting problem after problem since upgrading to vB5.
      Can anyone let me know what happens here? I am not sure if I'm pasting sensitive information. Mods,...
      Mon 28th Mar '16, 7:41am
    • catsma_97504
      SQL Error
      by catsma_97504
      Tonight I was attempting to help one of my forum members log in. At first he was unable to log in at all. Reset his password and could log in, but the forum would kick him out after attempting to navigate....
      Mon 7th Apr '14, 7:17pm
    Working...
    X