Title: error
Last modified: August 21, 2016

---

# error

 *  [great-taste](https://wordpress.org/support/users/great-taste/)
 * (@great-taste)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/error-311/)
 * I know that support is discontinued but I’m starting this post just in case anyone
   knows how to help. I’d really appreciate any direction you can give.
 * I’m a beginner and I don’t even know where to start.
 * Thank you
 * [Mon Jan 20 18:43:21 2014] [error] [client 5.255.253.21] WordPress database error
   Operand should contain 1 column(s) for query SELECT wp_posts.*, wp_wpecbd.* ,
   wp_p2p.* FROM wp_posts LEFT JOIN wp_wpecbd ON wp_posts.ID = wp_wpecbd.post_id
   INNER JOIN wp_p2p WHERE 1=1 AND wp_posts.post_type = ‘my_culinary_recipe’ AND(
   wp_posts.post_status = ‘publish’) AND (wp_p2p.p2p_type = ‘my_culinary_recipe_to_wpecbd’
   AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN (SELECT wp_posts.ID, wp_wpecbd.*
   FROM wp_posts LEFT JOIN wp_wpecbd ON wp_posts.ID = wp_wpecbd.post_id WHERE 1=
   1 AND wp_posts.ID IN (197698) AND wp_posts.post_type = ‘wpecbd’ AND (wp_posts.
   post_status = ‘publish’) ORDER BY wp_posts.post_date DESC )) ORDER BY wp_posts.
   post_date DESC /* From [www.great-taste.net/listing/canyon-pizza-yorba-linda/]
   in [/nas/wp/www/cluster-1063/greattaste/wp-content/plugins/posts-to-posts/core/
   side-post.php:105] */ made by require(‘wp-blog-header.php’), require_once(‘wp-
   includes/template-loader.php’), include(‘/themes/genesis/single.php’), genesis,
   do_action(‘genesis_loop’), call_user_func_array, genesis_do_loop, genesis_standard_loop,
   do_action(‘genesis_entry_footer’), call_user_func_array, bop_genesis, genesis_widget_area,
   dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, P2P_Widget-
   >widget, P2P_List_Renderer::query_and_render, call_user_func, P2P_Directed_Connection_Type-
   >get_connected, P2P_Directed_Connection_Type->abstract_query, P2P_Side_Post->
   do_query, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
 * [http://wordpress.org/plugins/posts-to-posts/](http://wordpress.org/plugins/posts-to-posts/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [great-taste](https://wordpress.org/support/users/great-taste/)
 * (@great-taste)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/error-311/#post-4525434)
 * I see two colons in a row in this error. Could that be messing up the code? Any
   ideas where to fix that directive?
    Please, someone come up with a bright idea.
   I have many connections but get this error way too many times. thank you,
 *  [tedinoz](https://wordpress.org/support/users/tedinoz/)
 * (@tedinoz)
 * [12 years, 3 months ago](https://wordpress.org/support/topic/error-311/#post-4525517)
 * Hi
 * That’s some query for a beginner. Can you indicate the context in which the error
   occurred?
 * The error message “Operand should contain 1 column(s) for query” is the key. 
   If you had googled this you would have found a lot of hits, most of which would
   have helped you.
 * Anyway…
    1 = the query has a WHERE condition: “wp_p2p.p2p_to IN (SELECT…”. 2 
   = This Select returns two columns “wp_posts.ID” and “wp_wpecbd.*”. 3 = But the“
   IN” condition is only expecting one column. Result = error.
 * Delete one of those columns in the Select and it should be fine.
 * Ted

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘error’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/posts-to-posts_7a8e9d.svg)
 * [Posts 2 Posts](https://wordpress.org/plugins/posts-to-posts/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/posts-to-posts/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/posts-to-posts/)
 * [Active Topics](https://wordpress.org/support/plugin/posts-to-posts/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/posts-to-posts/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/posts-to-posts/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [tedinoz](https://wordpress.org/support/users/tedinoz/)
 * Last activity: [12 years, 3 months ago](https://wordpress.org/support/topic/error-311/#post-4525517)
 * Status: not resolved