Wrong data type for link in insert sql
Sean B Fuller - April 1, 2008 - 18:15
| Project: | Recipe |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | minor |
| Assigned: | Unassigned |
| Status: | active |
Description
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.
| Attachment | Size |
|---|---|
| recipe_ingredient_datatype.patch | 865 bytes |
