Title: In-Series plugin database error
Last modified: August 18, 2016

---

# In-Series plugin database error

 *  [antoniamar](https://wordpress.org/support/users/antoniamar/)
 * (@antoniamar)
 * [20 years, 5 months ago](https://wordpress.org/support/topic/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.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [antoniamar](https://wordpress.org/support/users/antoniamar/)
 * Last activity: [20 years, 5 months ago](https://wordpress.org/support/topic/in-series-plugin-database-error/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics
