All Low add-ons are now owned by EEHarbor. Read the blog post.

Support archive

Database Error After Update to 2.0

thedesigncore 1 May 2012 22:09 problem, complete

When I click Re-order Entries fr any of my sets, 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 6

SELECT DISTINCT(t.entry_id), 't'.'channel_id', 't'.'title', 't'.'status', 't'.'url_title' FROM ('exp_channel_titles' t) WHERE 't'.'site_id' = 5 AND 't'.'channel_id' IN ('16') AND 't'.'status' IN ('open', 'closed', 'Home') ORDER BY FIELD(t.entry_id, '147', '123', '124', '122', '125)'

Filename: third_party/low_reorder/base.low_reorder.php

Line Number: 407

Thanks for any help.

Replies

  1. thedesigncore 1 May 2012 23:47

    Updated my EE install from 2.3.1 to 2.4.0 and the error is now gone.

  2. Low 2 May 2012 06:28

    Good to hear the problem was solved by upgrading EE. I will still closely monitor the error, tho.

  3. Brendan Underwood 14 May 2012 03:43

    Afraid I also have this problem under EE v2.2.2, but I'm yet to upgrade to v2.4. 

    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 ('1') AND 't'.'status' IN ('open') AND 'cp'.'cat_id' IN ('37') AND (t.expiration_date = 0 OR t.expiration_date >= 1336966856) AND 't'.'entry_date' <= 1336966856 ORDER BY FIELD(t.entry_id, '392', '393', '295', '294', '414', '413', '412', '411', '410', '409', '408)' 

     Filename: third_party/low_reorder/base.low_reorder.php 

     Line Number: 410


    I'm doing this on a single category selected set of entries within Reorder.

  4. Low 14 May 2012 07:09

    Hi Brandan,

    It's a bug in EE, so I would recommend upgrading first. Is that possible for you?

  5. Brendan Underwood 14 May 2012 07:20

    Yep, although it wasn't planned, I think I will anyway...at least to v2.4 until v2.5 has shown itself to be 95% stable.

  6. Low 14 May 2012 07:21

    Cool. Seems a bit silly to "fix" my add-on to work around an old bug in EE. :)

  7. trif3cta 16 Aug 2012 19:04

    Hi Low,

    Same problem, but I'm not in a position to upgrade (2 x 9 site MSM installs) for another month or so.

    Running EE2.3.1 and Low Reorder 2.0.2 and perfectly happy to hotfix either side to keep the client happy in the meantime.

    Any hints or a link to the bug tracker as to what the issue is?

    Thanks!