I have an issue.. I upgraded from 1.13a to 1.20a
Admin->Custom->Reward Points list the users. I am able to sort the list and edit any listed user without trouble.
If I enter a 'Search' string the results are returned. Selecting any of the results listed from the search results in a screen refresh with a default user listing and the following error listed at the bottom of the page.
I am able to select any of the listed users from this screen and edit them and I can also select a new sort order without additional errors. So, this error only seems to happen when a sort is used.1064 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 'AND status=0 ORDER BY date DESC LIMIT 12' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM reward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Bookmarks