Wordpress Database Errors!! Please Help- Will pay $5

This error started popping up every time I want to post, edit a post, or even publish a comment on my blog. It started after a blotched installation of the WP Super Cache Plugin (http://ocaoimh.ie/wp-super-cache/) and has been cropping up since then.

PLEASE HELP ME FIX THIS PROBLEM. It'd be much appreciated

My blog's url is www.dailymoolah.com

Here's the exact error when I try to post :

WordPress database error: [Table 'nextaffi_wrdp1.wp_post2cat' doesn't exist]
SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM `wp_posts` p LEFT JOIN `wp_post2cat` pc ON p.ID = pc.post_id LEFT JOIN `wp_categories` c ON pc.category_id = c.cat_ID WHERE post_status = 'publish' GROUP BY cat_ID

WordPress database error: [Table 'nextaffi_wrdp1.wp_post2cat' doesn't exist]
SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM `wp_posts` p LEFT JOIN `wp_post2cat` pc ON p.ID = pc.post_id LEFT JOIN `wp_categories` c ON pc.category_id = c.cat_ID WHERE post_status = 'publish' GROUP BY cat_ID

Warning: Cannot modify header information - headers already sent by (output started at /home/nextaffi/public_html/dailymoolah/wp-includes/wp-db.php:160) in /home/nextaffi/public_html/dailymoolah/wp-includes/pluggable.php on line 391

 

You are obviously missing tables in the dtaabase that the plugin needs. What happens if you disable it and enable it agian. As it should insert those tables by it's own.
Otherwise I would suggest adding the tables by hand using phpmyadmin

 

Maybe you should check the WP version needed to run that plugin

 

Did you uninstall the WP Super Cache Plugin? If not first remove this plugin and then execute following query to create blank table which was created by wordpress at the time of installation.

CREATE TABLE post2cat (
rel_id bigint(20) NOT NULL auto_increment,
post_id bigint(20) NOT NULL default '0',
category_id bigint(20) NOT NULL default '0',
PRIMARY KEY (rel_id),
KEY post_id (post_id,category_id)
) $charset_collate;


Note: before creating new table ensure table is not exist. If table "post2cat" is exist the rename this table and create new one and then import all record from renamed table.

 

its a plugin conflict for sure .. try disable all unwanted plugins

 

I agree with you Post2Cat is a core table in wordpress 2.+ and if you don't have it as it looks like then it means you are running on WP1.5 this will mean that you either should upgrade your wordpress (it is recommanded anyway as there exploits for older wordpress versions) and then reinstall the plugins or forget this plugin and look for an other option