A Database Error Occurred Error Number: 1064
getting an error when trying to select a category to reorder"
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 ('44') AND (t.expiration_date = 0 OR t.expiration_date >= '') AND 't'.'entry_date' <= 1393261114 ORDER BY FIELD(t.entry_id, '5404', '5402', '5403', '5400', '5399', '5401', '5397', '5398', '5395', '5396', '5393', '5394', '5392', '5390', '5391', '5388', '5389', '5387', '5386', '5385', '5383', '5384', '5381', '5382', '5380', '5378', '5377', '5376)'
Filename: third_party/low_reorder/base.low_reorder.php
Line Number: 424
Replies
peter e 24 Feb 2014 17:01
looks like I simply need to upgrade EE
Low 24 Feb 2014 17:05
Yes, that's an EE bug that has been solved in the meantime.