> Adding the following little ditty after the code that checks the day in
> UPDATE_COUPON in ft 1.3 fixes coupons with dates. Seems as though the
same
> problem exists in 1.4. Can't figure out why not putting a number in
display
> precedence on the edit_coupon screen breaks the update query. The only
> thing I can figure is that php is giving "" the wrong data type and mysql
is
> expecting an integer. Would be interested to understand that one.....
It's because DisplayPrecedence is being joined with as a string. PHP
doesn't know it should be an integer. So, you end up with bad SQL. The fix
is to wrap it in an intval().
Leon
_______________________________________________
FreeTrade-dev mailing list
[EMAIL PROTECTED]
http://share.whichever.com/mailman/listinfo/freetrade-dev
