Closed (fixed)
Project:
Amazon Product Advertisement API
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
18 May 2009 at 12:15 UTC
Updated:
31 Oct 2009 at 22:30 UTC
I've just installed, run update.php and am running the test - but I'm getting an error
Field 'brand' doesn't have a default value query: INSERT INTO amazon_item (asin, title, detailpageurl, salesrank, publisher, manufacturer, studio, label, binding, productgroup, producttypename, timestamp) VALUES ('0316726648', 'Persian Fire', 'http://www.amazon.com/Persian-Fire-Tom-Holland/dp/0316726648%3FSubscriptionId%3D0CD9RCQYM0TBVH55NB82%26tag%3Dviaposit-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D0316726648', 1632508, 'Time Warner Books UK', 'Time Warner Books UK', 'Time Warner Books UK', 'Time Warner Books UK', 'Hardcover', 'Book', 'ABIS_BOOK', 1242646939)
Comments
Comment #1
pkiraly commentedI receive same warning messages with the 'binding' field.
user warning: Field 'binding' doesn't have a default value query: INSERT INTO amazon_item (asin, title, detailpageurl, salesrank, brand, publisher, manufacturer, mpn, studio, label, listpriceamount, listpricecurrencycode, listpriceformattedprice, productgroup, producttypename, timestamp) VALUES ('B000HG84CS', 'Timolino 16 oz. Aromatic Australian Press, black', 'http://www.amazon.com/Timolino-Aromatic-Australian-Press-black/dp/B000HG...', 515525, 'Timolino', 'Timolino', 'Timolino', 'APA-05GBL', 'Timolino', 'Timolino', 1700, 'USD', '$17.00', 'Kitchen', 'KITCHEN', 1249555901)
I tried 6.x-1.x-dev, and amazon-6.x-1.0-beta7 and both gave the same warning.
Comment #2
shaundychkoHello, I get the same type of error with the 'releasedate' when referring to a tea kettle: (installed amazon-6.x-1.0-beta7 with Drupal 6.13 and the latest everything else)
user warning: Field 'releasedate' doesn't have a default value query: INSERT INTO amazon_item (asin, title, detailpageurl, salesrank, brand, publisher, manufacturer, mpn, studio, label, binding, productgroup, producttypename, timestamp) VALUES ('B000CQFEKS', 'KitchenAid 2-qt.Teakettle Multiple Colors Available', 'http://www.amazon.com/KitchenAid-2-qt-Teakettle-Multiple-Colors-Availabl...', 0, 'KitchenAid', 'Meyer Corp.', 'Meyer Corp.', '177446', 'Meyer Corp.', 'Meyer Corp.', 'Kitchen', 'Kitchen', 'HOME', 1251131890) in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\chap04\includes\common.inc on line 3436.
And I get the exact same type of error when referring to a book:
user warning: Field 'brand' doesn't have a default value query: INSERT INTO amazon_item (asin, title, detailpageurl, salesrank, publisher, manufacturer, studio, label, binding, listpriceamount, listpricecurrencycode, listpriceformattedprice, productgroup, producttypename, timestamp) VALUES ('0143113100', 'The Brain That Changes Itself: Stories of Personal Triumph from the Frontiers of Brain Science (James H. Silberman Books)', 'http://www.amazon.com/Brain-That-Changes-Itself-Frontiers/dp/0143113100%...', 494, 'Penguin (Non-Classics)', 'Penguin (Non-Classics)', 'Penguin (Non-Classics)', 'Penguin (Non-Classics)', 'Paperback', 1600, 'USD', '$16.00', 'Book', 'ABIS_BOOK', 1251133674) in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\chap04\includes\common.inc on line 3436.
Comment #3
ahansen1 commentedThis is similar to #353285: Remove 'not null' on items for which Amazon might not return attributes
Comment #4
rfayIs this a current issue with the current release? (6.x-1.0-beta7)?
Comment #5
rfayI believe this is fixed in the current dev release and in upcoming 6.x-1.0-beta9. Please reopen if it's still a problem.