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.

Advertisements