Comment to 'Points Module'
Comment to Points Module

  • M

    Database error in Man of Teal | An OpenRCT2 Community


    Query:
    SELECT `h`.*, IF (`a`.`module_name` IS NULL, '----', IF ( `a`.`group` != '', `a`.`group`, `a`.`module_name`)) as `module_name` FROM `aqb_points_history` as `h` LEFT JOIN `aqb_points_actions` as `a` ON `h`.`action_id` = `a`.`id` WHERE `profile_id`= ORDER BY `added` DESC LIMIT 0, 11

    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 'ORDER BY `added` DESC LIMIT 0, 11' at line 1

    Location:
    The error was found in getAll function in the file /home/manofteal/public_html/inc/classes/BxDolGrid.php at line 417.

    collation_connection:
    utf8mb4_unicode_ci