In-Series plugin database error

  • Hi, just installed In-Series 2 (great plugin idea). I put the <?php previous_in_series(); ?> and
    <?php next_in_series(); ?> tags into my theme’s index.php
    file (don’t have a single.php) but I got a database error for each tag when I created post #1 and post #2 to test it out. I get the error no matter where in the files I place the tag. Any suggestions on what to do? These are the error messages:

    WordPress database error: [You have an error in your SQL syntax near ‘(meta_value AS SIGNED) DESC LIMIT 1’ at line 1]
    SELECT post_id FROM wp_postmeta INNER JOIN wp_posts ON wp_postmeta.post_id=wp_posts.ID WHERE post_id IN (49,50) AND meta_key=’series_order’ AND meta_value < 2 AND wp_posts.post_author = ‘1’ AND wp_posts.post_date < ‘2006-01-14 18:50:49′ AND (wp_posts.post_status=’publish’ OR wp_posts.post_status=’static’) ORDER BY CAST(meta_value AS SIGNED) DESC LIMIT 1

    WordPress database error: [You have an error in your SQL syntax near ‘(meta_value AS SIGNED) > 2 AND wp_posts.post_author = ‘1’ AND wp_posts.post_date’ at line 1]
    SELECT post_id FROM wp_postmeta INNER JOIN wp_posts ON wp_postmeta.post_id=wp_posts.ID WHERE post_id IN (49,50) AND meta_key=’series_order’ AND CAST(meta_value AS SIGNED) > 2 AND wp_posts.post_author = ‘1’ AND wp_posts.post_date < ‘2006-01-14 18:50:49′ AND (wp_posts.post_status=’publish’ OR wp_posts.post_status=’static’) ORDER BY CAST(meta_value AS SIGNED) ASC LIMIT 1

  • The topic ‘In-Series plugin database error’ is closed to new replies.