MySQL Error after Update to 2.0.2 (from 1.2.1) when trying to reorder entries in a set
Hey. Just updated today from version 1.2.1. When trying to reorder entries (Clicking on Reorder Entries), I get the following 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' = 1 AND 't'.'channel_id' IN ('6') AND 't'.'status' IN ('open') AND 'cp'.'cat_id' IN ('3') AND (t.expiration_date = 0 OR t.expiration_date >= 1339015186) AND 't'.'entry_date' <= 1339015186 ORDER BY FIELD(t.entry_id, '690', '299', '300', '698', '695', '301', '303', '694', '699', '696', '697', '693', '692', '691', '689', '302)'
Filename: third_party/low_reorder/base.low_reorder.php
Line Number: 410
EE Version 2.3.1
Low Reorder 2.0.2
PHP: 5.2.17
MySQL: 5.1.63
Replies
Low 6 Jun 2012 21:06
Hi,
It's actually a known bug in that version of EE. If you can upgrade, then please do.