Database error 1064 when creating set
I tried creating a set with Low 2.1.1 and am using EE version 2.3.1 and get this error:
A Database Error Occurred
Error Number: 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 '' at line 10
SELECT DISTINCT(t.entry_id), 't'.'channel_id', 't'.'title', 't'.'status', 't'.'url_title' FROM ('exp_channel_titles' t) JOIN 'exp_category_posts' cp ON 't'.'entry_id' = 'cp'.'entry_id' WHERE 't'.'site_id' IN (1) AND 't'.'channel_id' IN ('4') AND 't'.'status' IN ('open') AND 'cp'.'cat_id' IN ('30') AND (t.expiration_date = 0 OR t.expiration_date >= 1362779855) AND 't'.'entry_date' t reorder entries or use save/reorder. (Just save works fine) I have the ability to restore the db to before I installed the latest version of low_reorder, but would prefer not to have to.
Replies
Low 8 Mar 2013 22:11
As per the docs, Low Reorder 2+ is compatible with EE 2.4+. Try upgrading EE to see if the problem persists.
Magner Sanborn 8 Mar 2013 22:50
I am not able to do so at this time, as the previous developer included a bunch of custom php in the EE config files that I don't want to mess with until the client has budget for that.
I purchased the add-on from the Devot:ee site, is there a refund system? I can't very well use this if it isn't compatible, and there was no message in the description that it was only compatible with 2.4+ version of EE.
Low 8 Mar 2013 22:54
Devot:ee does have a 30-day refund policy, but before you do, I'd like to make sure this issue is related to EE. I know there was a bug with EE with certain queries (looks like that's the case here), but it looks like your query is truncated. Can you make a screenshot of the error you see?
Magner Sanborn 8 Mar 2013 23:02
Magner Sanborn 8 Mar 2013 23:02
I read in a couple places that people upgraded to EE 2.4 and that fixed the error, but I needed to know if there was another way to fix it, since I couldn't do that.
Low 8 Mar 2013 23:05
Yeah, that's a bug in that version EE itself, and that's why Low Reorder 2 is compatible with EE 2.4+. I understand the confusion that it's not mentioned on Devot:ee and will add it to the description over there.
Magner Sanborn 8 Mar 2013 23:18
Thank you.