I've got a reproducible bug that if I have the $active flag set to false and attempt an upgrade of the addon I'm working on, the sql string throws an error:

Code: Select all

SQL:
UPDATE `roster20_addon` SET `basename`='raidtracker', `version`='1.9.9.1004', `active`=, `fullname`='raidtracker_info', `description`='raidtracker_desc', `credits`='a:2:{i:0;a:2:{s:4:"name";s:21:"gaxme@vestramater.com";s:4:"info";s:25:"Contributing Author (2.0)";}i:1;a:2:{s:4:"name";s:8:"PoloDude";s:4:"info";s:21:"Original 1.7.3 author";}}', `icon`='ability_dualwield', `wrnet_id`='0' WHERE `addon_id`=29;

Note the active variable is null. Setting this flag to 0 rather than "false" solves the problem.

G.

PS: Hope this wasn't posted already, my searches didn't find anything.

Fixed svn[1572]

Wicked fast fixes as always. Cheers.

G.