1
Bug Fixes & Patches / Re: PHP 8 - Fix for Image Gallery 1.8 - Ready to use / Fertig zum Anwenden
« on: September 11, 2023, 08:55:32 PM »
It was several pages, but I seem to have fixed it by declaring the varibales blank if not used, for example:
$user_info['user_level'] = isset($user_info['user_level']) ? $user_info['user_level'] : '';
$user_info['user_name'] = isset($user_info['user_name']) ? $user_info['user_name'] : '';
etc.
Everything seems to work fine except I'm not able to login. If I try to login from the admin panel I get this:
Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' '', '')' at line 4 in C:\xampp\htdocs\4images\includes\db_mysqli.php:76 Stack trace: #0 C:\xampp\htdocs\4images\includes\db_mysqli.php(76): mysqli_query(Object(mysqli), 'REPLACE INTO 4i...') #1 C:\xampp\htdocs\4images\includes\sessions.php(138): Db->query('REPLACE INTO 4i...') #2 C:\xampp\htdocs\4images\includes\sessions.php(179): Session->start_session('1', 1) #3 C:\xampp\htdocs\4images\admin\admin_global.php(105): Session->login('Frankie', '4rtttyggh5757DD', 0, 0) #4 C:\xampp\htdocs\4images\admin\index.php(6): require('C:\\xampp\\htdocs...') #5 {main} thrown in C:\xampp\htdocs\4images\includes\db_mysqli.php on line 76
$user_info['user_level'] = isset($user_info['user_level']) ? $user_info['user_level'] : '';
$user_info['user_name'] = isset($user_info['user_name']) ? $user_info['user_name'] : '';
etc.
Everything seems to work fine except I'm not able to login. If I try to login from the admin panel I get this:
Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' '', '')' at line 4 in C:\xampp\htdocs\4images\includes\db_mysqli.php:76 Stack trace: #0 C:\xampp\htdocs\4images\includes\db_mysqli.php(76): mysqli_query(Object(mysqli), 'REPLACE INTO 4i...') #1 C:\xampp\htdocs\4images\includes\sessions.php(138): Db->query('REPLACE INTO 4i...') #2 C:\xampp\htdocs\4images\includes\sessions.php(179): Session->start_session('1', 1) #3 C:\xampp\htdocs\4images\admin\admin_global.php(105): Session->login('Frankie', '4rtttyggh5757DD', 0, 0) #4 C:\xampp\htdocs\4images\admin\index.php(6): require('C:\\xampp\\htdocs...') #5 {main} thrown in C:\xampp\htdocs\4images\includes\db_mysqli.php on line 76