MYSQL Error after the upgrade from 2.8.2 to 2.9.0
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)
