I installed WordPress e-commerce plugin and was configuring it on my Windows. In my settings checkout screen, I was not seeing any of the shipping or billing form fields. Wow, something must have gone wrong. I turned on WordPress debugging. In my php error log, I saw this error message
WordPress database error BLOB/TEXT column ‘options’ can’t have a default value for query CREATE TABLE `wp_wpsc_checkout_forms`
A bit of poking around I came to this MySQL bug. Fired up my gui MySQL admin and set sql_mode to ””.
Deactivated e-commerce plugin and installed it again. All the fields in checkout tab setting were there as expected.
By deactivating the e-commerce plugin on a site that is already up and running, I’ll lose all the customizations I made in the admin portion, right?
I am not very sure, but deactivating the plugin should not take away the plugin configurations you have made. It should be there the next time you activate it again. But, most probably what ever widgets you have added as part of your plugin will be gone. You will have to reconfigure them again. Again, I am not very sure about this.