Any time I try to reindex my records from Tools > Reindex I get the same 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 '1,2,3,5)' at line 1 SQL=SELECT id, title, type_id, section_id, user_id, fields FROM xxx_js_res_record WHERE type_id IN (,1,2,3,5)
Assuming that it's related to the leading comma in (,1,2,3,5), but can't see any way of fixing that
Any help would be appreciated
Thanks
KC
Question
Announcement
Conversation
Idea
Praise
Problem
Reviewed
Open
Any time I try to reindex my records from Tools > Reindex I get the same 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 '1,2,3,5)' at line 1 SQL=SELECT id, title, type_id, section_id, user_id, fields FROM
xxx_js_res_recordWHERE type_id IN (,1,2,3,5)Assuming that it's related to the leading comma in (,1,2,3,5), but can't see any way of fixing that
Any help would be appreciated
Thanks KC