PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect decimal value: '' for column 'start_price' at row 1: INSERT INTO {uc_auction} (nid, expiry, start_price, bid_increment, min_increase, max_increase, max_increase_pctg) 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, :db_insert_placeholder_6); Array ( [:db_insert_placeholder_0] => 7 [:db_insert_placeholder_1] => 1324149780 [:db_insert_placeholder_2] => [:db_insert_placeholder_3] => [:db_insert_placeholder_4] => [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => ) in drupal_write_record() (line 6884 of /home/rahul/public_html/d7/includes/common.inc).
CommentFileSizeAuthor
#8 uc_auction-sql_exception_editing-1367198-8.patch891 bytesloziju
#7 sql-exception-editing-product-1367198-7.patch892 byteskalabro
#6 sql-exception-editing-product-1367198-6.patch579 byteskalabro

Comments

nohup’s picture

nohup commented
Status: Active » Fixed

Added check for is_auction ture.

Changes committed to git

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

GraemeCampbell’s picture

GraemeCampbell commented
Status: Closed (fixed) » Active

I'm getting the same same error when I edit a non-auction item.

GraemeCampbell’s picture

GraemeCampbell commented
Title: SQL exception creating product if not auction » SQL exception editing product if not auction
friendswoodtech’s picture

friendswoodtech commented

This issue still exists. Any assistance in resolving would be greatly appreciated.

kalabro’s picture

kalabro
she/her
commented
Status: Active » Needs review
StatusFileSize
new sql-exception-editing-product-1367198-6.patch579 bytes

Forgot about hook_node_update().

Patch attached. Thanks!

kalabro’s picture

kalabro
she/her
commented
StatusFileSize
new sql-exception-editing-product-1367198-7.patch892 bytes

More accurate patch. Use it instead of previous. Thanks!

loziju’s picture

loziju commented
Assigned: nohup » Unassigned
Issue summary: View changes
StatusFileSize
new uc_auction-sql_exception_editing-1367198-8.patch891 bytes

Patch in #1367198-7: SQL exception editing product if not auction failed because of wrong original code. It should be if (isset($node->is_auction)){ instead of if (!empty($node->is_auction)){. Attaching the correct patch.