Need help with a completely broken site - mysql issues

[Valkysas]

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

[Mark.B]

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.