+ Reply to Thread
Results 1 to 6 of 6

Thread: MYSQL Error: Unknown column 'Array' in 'where clause'

  1. #1
    Senior Member
    Join Date
    Aug 2014
    Posts
    105

    MYSQL Error: Unknown column 'Array' in 'where clause'

    Hi,

    I've installed the latest Flynax Real Estate script using the new Realty_Rainbow theme.

    I've made several changes to the settings and now I'm getting an error message when posting new ads :

    PHP Code:
    Only registered members can view the code
    Can anyone suggest a solution to the error?

    Many thanks

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

    Go to includes > classes > admin > rlControls.class.php > public function ajaxRebuildCatLevels

    replace:
    PHP Code:
    Only registered members can view the code
    with:
    PHP Code:
    Only registered members can view the code
    then:
    PHP Code:
    Only registered members can view the code
    with:
    PHP Code:
    Only registered members can view the code
    then go to Common > Refresh and rebuild category levels
    Last edited by Rudi; August 8, 2023 at 11:54 AM.

  3. #3
    Senior Member
    Join Date
    Aug 2014
    Posts
    105
    Thanks for your help Rudi,

    That resolved the problem :-)

  4. #4
    Senior Member
    Join Date
    Mar 2016
    Posts
    181
    This is works! but after replacing the code the filter in the category is not working properly. like in category of House and lot, before when i search for this category the result display the correct listings but after replacing the code the result display Zero ad. please see the images below.

    before



    After

    Attached Images Attached Images

  5. #5
    Flynax developer Rudi's Avatar
    Join Date
    Dec 2014
    Location
    Planet Earth
    Posts
    3,138
    Have you refreshed category levels via Common > Refresh and rebuild category levels?

    Also, you need to refresh the system cache

    or create a ticket if the problem still exists

  6. #6
    Senior Member
    Join Date
    Mar 2016
    Posts
    181
    Hi Rudi. Yup ive refresh all except for MultiField: Refresh Paths and for water marks.
    got the same problem and also i disable the cache.

    Thank you so much and regards,
    Last edited by PQB; August 17, 2022 at 07:47 PM.

+ Reply to Thread