Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

The website started to behave erratically - so in the process of trying to restore a backup, I discovered that it had a error_log file with 1.2 million lines of errors. Most of these errors - most errors reading like ....

[27-Feb-2012 10:57:04] WordPress database error Table 'kidspart_kpbshop.wp_wpsc_product_categories' doesn't exist for query SELECT * FROM wp_wpsc_product_categories WHERE active = 1 ORDER BY name made by require, require_once, require_once, require_once, do_action, call_user_func_array, storefront_options

I remove this file, restored the site from an old backup a got a new error_log file which has already 496,000+ lines of error codes, mostly the same "doesn't exist" type errors. How can I sort out the problem? Is it a wp-ecommerce fault? Or what?

share|improve this question
    
Is your database named kidspart_kpbshop? Is there a table named wp_wpsc_product_categories or similar? Possible one with a different prefix-- the wp_? –  s_ha_dum Apr 19 '13 at 4:07
    
What an idiot I am. Didn't even think to look at the database. There are lots of tables starting with wp_wpsc but none with that specific name. There are several other missing tables. What do I do? –  JillC Apr 19 '13 at 6:09
    
I created a new site on my localhost and installed the wp-ecommerce plugin - there was no wp_wpsc_product_categories table. So I created 2 categories and 2 products - no new tables were added. This must be some other plugin do you think? –  JillC Apr 19 '13 at 6:59
    
Typically, the tables are created on plugin activation, so I would deactivate the wp-ecommerce plugin and reactivate it. See if the tables are created, and watch the logs to see if the activation process triggers errors. You may have had a PHP or MySQL timeout the first time around. Also, if this is a development server, I wouldn't log the errors. If you print them to the screen it makes a big mess that is hard to miss and you catch things quickly. :) –  s_ha_dum Apr 19 '13 at 12:57
    
I deleted the error_log a couple of days ago - so this is a new list of errors. Today's list so far goes from line 12184 to line 13476 so that is 1292 lines of errors just for today! This site has been functioning for more than 2 years so, no, I am not outputting the errors to screen. I deactivated and reactivated but it is impossible to know whether it changed the errors or not. The "missing" tables were not created. –  JillC Apr 22 '13 at 6:37
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.