In migrating to a windows environment that is more strict that our linux environments (I forget the default flag that is on in mysql), we noticed that trying to insert a new ingredient was causing an error. Basically, this is just turning the '%s' placeholder into a %d placeholder.

There's an additional issue with the table, however, because currently link is INT NOT NULL, but the module is passing it a NULL value. I'd also suggest changing that to INT DEFAULT 0, but I'm not sure if that would affect anything else.

CommentFileSizeAuthor
recipe_ingredient_datatype.patch865 bytesseanbfuller

Comments

scottprive’s picture

Title: Wrong data type for link in insert sql » MySQL flags or Windows, wrong data type for link in insert sql
scottprive’s picture

Version: 5.x-1.x-dev » master
Assigned: Unassigned » scottprive
Status: Active » Closed (duplicate)