PDA

View Full Version : MYSQL Error after the upgrade from 2.8.2 to 2.9.0



PQB
March 15, 2022, 05:56 AM
Hello guys. after the upgrade from 2.8.2 to 2.9.0 there are times when i tried to edit old post and creating a new one the error message said MYSQL error. please see below the debug result



MYSQL ERROR


Error:
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 'AND `Type` = 'picture' LIMIT 1' at line 3


Query:
SELECT COUNT(*) AS `Count` FROM `fl_listing_photos` WHERE `Listing_ID` = AND `Type` = 'picture' LIMIT 1


Function:
stepPhoto


Class:
Flynax\Classes\AddListing


File:
/home/X/public_html/includes/classes/AddListing.php (line# 676)





| 2 repeats | System error: Can not run mass action with accounts (MySQL Fail). Action: activate on line# 2486 (file: /includes/classes/rlAccount.class.php)
15 Mar 01:02:00 | 2 repeats | DEBUG: Can not run mass action with accounts (MySQL Fail). Action: activate on line# 2487 (file: /includes/classes/rlAccount.class.php)
15 Mar 01:16:58 | 1 repeats | System error: Can not run mass action with listings (MySQL Fail). Action: activate on line# 222 (file: /includes/classes/admin/rlListingsAdmin.class.php)
15 Mar 01:16:58 | 1 repeats | DEBUG: Can not run mass action with listings (MySQL Fail). Action: activate on line# 223 (file: /includes/classes/admin/rlListingsAdmin.class.php)


2 repeats | Mysql Error: Unknown column 'Array' in 'where clause' on line# 661 (file: /includes/classes/AddListing.php)
15 Mar 01:50:16 | 1 repeats | Mysql Error: 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 'AND `Type` = 'picture' LIMIT 1' at line 3 on line# 676 (file: /includes/classes/AddListing.php)
15 Mar 01:56:17 | 12 repeats | Mysql Error: Unknown column 'Array' in 'where clause' on line# 230 (file: /includes/classes/EditListing.php)

Rudi
March 15, 2022, 06:11 AM
Hello,

You need to create a ticket and we'll investigate the problem

PQB
March 15, 2022, 06:15 AM
Hi Rudi. Noted. thank you so much