Hi guys, i'm new on this forum.
I'm writing a plugin for change the order of every post inside a directory with a simple interface.
Now, i've finished the plugin, but when i go in a category, i've this error message:
WordPress database error: [Column: 'ID' in field list is ambiguous]
SELECT COUNT(DISTINCT ID) FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) WHERE 1=1 AND (category_id = 3) AND post_date_gmt <= '2006-10-05 12:09:59' AND (post_status = "publish" OR post_author = 1 AND post_status != 'draft' AND post_status != 'static') AND post_status != "attachment"
This is a query that i've not found on wordpress files, and is not a query made by me..what does is it? how could i resolve my problem?
Although this problem my plugin works very fine!