+ Reply to Thread
Results 1 to 3 of 3

Thread: MYSQL Error after the upgrade from 2.8.2 to 2.9.0

  1. #1
    Senior Member
    Join Date
    Mar 2016
    Posts
    181

    Exclamation 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)
    Last edited by PQB; March 15, 2022 at 06:13 AM.

  2. #2
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Location
    Planet Earth
    Posts
    3,160
    Hello,

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

  3. #3
    Senior Member
    Join Date
    Mar 2016
    Posts
    181
    Hi Rudi. Noted. thank you so much

+ Reply to Thread