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
Comment #1
roborracle CreditAttribution: roborracle commentedanyone?
Comment #2
roborracle CreditAttribution: roborracle commentedbump
Comment #3
garyg CreditAttribution: garyg commentedUntil 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...