Home Forums Plugins Offline Credit Card Processing [Resolved] stopped functioning after wp and ecommerce upgrade

Welcome to our community support forums! We're here to help - but if you have an urgent request for a Pro Plugin, you will get a prioritised response through our Premium Support page.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • #28575

    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.

    Michael Visser

    Hi jillc, based on the information you’ve provided it sounds like you’re using the legacy WP e-Commerce 3.7 series, our OCCP Plugin is compatible with the latest release of the legacy 3.7 series. Regarding not being able to see the “View remaining card details” this is likely linked to your now corrupted database as we do version checks throughout our OCCP to tie together with WP e-Commerce, please contact us via the Contact page with WP Admin and working FTP details so I can view the Sale detail screen. It would help alot if you can confirm the version of WP e-Commerce you were using prior to upgrading.

    For updating to the new WP e-Commerce 3.8 series I recommend contacting the GetShopped.org migration team via Premium Upgrades.


Viewing 2 posts - 1 through 2 (of 2 total)
  • The topic ‘[Resolved] stopped functioning after wp and ecommerce upgrade’ is closed to new replies.