Topic: [Resolved] stopped functioning after wp and ecommerce upgrade |

The shop has been running for a couple of years. The other day it was decided to upgrade the wp-ecommerce plugin as it was presumed we would need that for the revised Australia Post charges. Upgraded WP at the same time. First thing we noticed was that the postage calculations went beserk. Sometimes when the page was first loaded you could calculate the postage, but if you changed the quantity or added a new item the calculation would not appear and it was not possible to complete the checkout. So it was temporarily disabled.

Next, it was discovered when someone put an order through that we could not access the credit card numbers and it would not show on the sales page although the email  from the Offline Credit Card processing came through successfully.

So, let’s restore the site – big mistake. It eventually required a manual instal to get the site back online. In the process I found a huge error_log file with more than 1.2 million lines of errors listed since about Feb last year. I removed that file and then got the site up and running again and found it had created another nice big error_log – this time about 400,000 lines of errors (2 days worth). Mostly the errors are for missing tables wp_wpsc_categorisation_groups and wp_wpsc_product_categories and wp_wpsc_product_list

The error goes like this:

[19-Apr-2013 07:34:03] 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(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, storefront_options

Can you assist with any or all of these problems? I presume the shipping and payment problems would rectify themselves if the database errors could be solved … but I’m only guessing.