WP Ecommerce Editing Problems

So I’ve been getting a lot of requests regarding WP Ecommerce and the ability to edit products. People are saying that they make the edits but after saving, the edits dont’ show up and the product (description) goes back to normal.

I have a few fixes for this, that have helped….hopefully one of these can help you out if you’re experiencing the same issues.

The problem could be on your SQL server and this fix addresses the issue by changing a setting in your “php.ini” file on your server. If you don’t know where this is or can’t find it, you can contact your hosting company as sometimes they keep this file in a location that you do not have access to.

In the php.ini file check to see if it has “Strict Mode” set to “On”…this needs to be “Off”.

Change from this:

1

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

To this:

1

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

If that doesn’t work for you, the next reason might be that your SQL table is missing information (as in a column in a table), so here’s how to check for that.

In the root of your “wp-shopping-cart” directory, you’ll find “display_items.php”. Open that file to edit and add this line near the top…no particular area, just near the top (on it’s own line).

1

$wpdb->show_errors = true;

Now save that file and re-upload it and go edit your product again. What this will do is stop the SQL errors from being supressed, and they will show on the page. Does that fix the problem? Well, no it does not, but it will show you what errors (if any) are occurring and from there you can try to correct them, or if you need help you can get it over here.

So those are the fixes that I have for editing errors in WP Ecommerce for the moment. Again, I love this plugin…and FYI most all errors I see (besides the ones mentioned above) are from theme issues. Make sure that when you’re selecting a theme for your WordPress site that it is compatiable with WP Ecommerce (if you’re going to be using the plugin). Themes can do funny things to the plugin.

So, until next time….