+ Reply to Thread
Results 1 to 7 of 7

Thread: MYSQL ERROR When adding category

  1. #1

    MYSQL ERROR When adding category

    Hello flynax team,
    When i trying to add category i got white screen with text "MYSQL ERROR"

  2. #2
    Did it happen after upgrade or after some other actions?
    Could you please create a new ticket with the problem. We will solve it.
    Also, you can show the log file located: ftp://tmp>>errorLog>>errors.log, maybe it will help you to solve the problem.
    Viktor,
    Flynax technical department,
    Best wishes.

  3. #3
    Master
    Join Date
    Oct 2019
    Location
    Hungary
    Posts
    403
    I just faced this problem now. Cannot edit category either.

    20 Feb 10:49:36 | 1 repeats | Mysql Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY `Position`' at line 1 on line# 1861 (file: /includes/classes/rlListingTypes.class.php)

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

    There are two possible bugs on add/edit category page:

    1. go to ftp > includes > classes > rlCategories.class.php > public function ajaxLoadType

    find a string:
    PHP Code:
    Only registered members can view the code
    and replace it with:
    PHP Code:
    Only registered members can view the code
    2. then go to includes > utils > Category.php > public static function getCategories

    find after the comment // get from db:
    PHP Code:
    Only registered members can view the code
    change it to:
    PHP Code:
    Only registered members can view the code
    Last edited by Rudi; February 20, 2020 at 10:51 AM.

  5. #5
    Master
    Join Date
    Oct 2019
    Location
    Hungary
    Posts
    403
    Thamk you. It works perfectly now.

  6. #6
    Hello,

    A similar problem, when I try to register a new profile by the method of adding an ad directly without registration, whether it is for girls, boys or masseuses, this error occurs.

    05 Aug 09:10:40 | 31 repeats | Mysql Error: Unknown column 'phone_number' in 'where clause' on line# 137 (file: /includes/classes/rlHook.class.php)

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

    You need to create a ticket for the problem as it's not related to this thread

+ Reply to Thread