I'm trying to add a new product to a client's store and we're using the variable_price module. For some reason, I'm now getting this error:

PDOException: SQLSTATE[HY000]: General error: 1364 Field 'sel_options' doesn't have a default value: INSERT INTO {uc_varprice_products} (pfid, price_default, price_minimum, price_maximum, add_to_cart_title, amount_title) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => 18 [:db_insert_placeholder_1] => 15 [:db_insert_placeholder_2] => [:db_insert_placeholder_3] => [:db_insert_placeholder_4] => [:db_insert_placeholder_5] => ) in drupal_write_record() (line 7166 of /var/www/vhosts/mysite.org/web/content/includes/common.inc).

The only issues I've seen with this have been with core, but I just re-installed the acquia D7 distribution (7.23) - no idea where this is coming from.

Comments

roborracle’s picture

anyone?

roborracle’s picture

bump

garyg’s picture

Until there is a patch for this ...

Edit the database table structure
In the table "uc_varprice_products"
add the default value NULL to the field SEL_OPTIONS

all is well...