rackem
Well-Known Member
I have a dbjoin element in my list that is set up with a field filter. I receive the following error when I enter a search term in that filter field. For this example, I entered "brass".
Attached are my element settings. It seems to be due to the ' characters in the Concat label as the error disappears if I don't use them. Interestingly, it only happens on my live site and not my local test setup. Here is the page: http://www.mypoolstats.com/player-ratings. The filter in question is the "Where Found".
Any ideas why this occurs?
getData: 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 '\' - \', mps_locations.city, \', \',mps_locations.state) LIKE '%brass%' )' at line 5 SQL=SELECT COUNT(DISTINCT `mps_players`.`id`) AS t FROM mps_players LEFT JOIN `btxz_users` AS `btxz_users` ON `btxz_users`.`id` = `mps_players`.`edit_by` LEFT JOIN `btxz_users` AS `btxz_users_0` ON `btxz_users_0`.`id` = `mps_players`.`owner` LEFT JOIN `mps_players_32_repeat` AS `mps_players_32_repeat` ON `mps_players_32_repeat`.`parent_id` = `mps_players`.`id` LEFT JOIN `mps_locations` AS `mps_locations` ON `mps_locations`.`id` = `mps_players_32_repeat`.`place` WHERE ( CONCAT(mps_locations.name, \' - \', mps_locations.city, \', \',mps_locations.state) LIKE '%brass%' )
Attached are my element settings. It seems to be due to the ' characters in the Concat label as the error disappears if I don't use them. Interestingly, it only happens on my live site and not my local test setup. Here is the page: http://www.mypoolstats.com/player-ratings. The filter in question is the "Where Found".
Any ideas why this occurs?