Add-On Can't Release New Version of Plugin: SafeMySQL: Incorrect integer value: '' for column `phoebus_live`

[own3mall]

Hi, I just tried updating my addon, but it gave me this error message:

Fatal error: Uncaught Exception: SafeMySQL: Incorrect integer value: '' for column `phoebus_live`.`client`.`toolkit` at row 1. Full query: [UPDATE `client` SET `toolkit`='',`palemoon`='1',`basilisk`='1',`ambassador`='',`borealis`='',`epyrus`='',`thunderbird`='' WHERE `addonID` = 'myemailremoved'] in /srv/www/addons.palemoon.org/public_html/libraries/safemysql/safemysql.class.php:623 Stack trace: #0 /srv/www/addons.palemoon.org/public_html/libraries/safemysql/safemysql.class.php(483): SafeMySQL->error('SafeMySQL: Inco...') #1 /srv/www/addons.palemoon.org/public_html/libraries/safemysql/safemysql.class.php(140): SafeMySQL->rawQuery('UPDATE `client`...') #2 /srv/www/addons.palemoon.org/public_html/modules/classDatabase.php(75): SafeMySQL->query('UPDATE `client`...', Array, 'myemailremoved') #3 /srv/www/addons.palemoon.org/public_html/modules/classWriteManifest.php(236): classDatabase->query('normal', 'UPDATE `client`...', Array, 'myemailremoved...') #4 /srv/www/addons.palemoon.org/public_html/components/panel/devel in /srv/www/addons.palemoon.org/public_html/libraries/safemysql/safemysql.class.php on line 623

Any ideas?

Thanks

[moonbat]

Assuming this is for Youtube Non-stop. Guess Moonchild will have to take a look at the code or database.

[Moonchild]

Seems like Tobin relied on sloppy code being accepted by the database. Integer fields can't hold strings, and MariaDB is strict about it by default.
I guess I can work around it by disabling strict mode but it needs php code updates to use '0' or NULL (can't use NULL because not allowed in the schema) correctly instead of the empty string to properly solve this in phoebus.

EDIT: I've worked around it for now, seems it was configured prior but an update sidelined the relevant conf file. It does need fixing in phoebus, though. Means I'll have to switch gears to php when I'm not busy otherwise (not sure when) to make a proper fix for this.
Please let me know if it works for you.

EDIT2: filed Issue #7 (phoebus)

[own3mall]

Thank you, it seems to have worked.