Notification database errors

With version 4.x there is now a database error any time a notification attempts to get written. It appears that the default value for “dismissed” is not getting provided, but instead a blank empty string is. Likely this has to do with the casting around of bools versus strings versus ints. But that the point of insertion the dismissed value is coming in as a blank string, and not NULL nor 0.

This is the error notice under 4.0.11:

WordPress database error Incorrect integer value: '' for column <code>site-2019</code>.<code>fb_aioseo_notifications</code>.<code>dismissed</code> at row 1 for query INSERT INTO fb_aioseo_notifications
SET <code>slug</code> = '5ff3826ec3b3c', <code>title</code> = 'Physical Robots.txt File Detected', <code>content</code> = 'AIOSEO has detected a physical robots.txt file in the root folder of your WordPress installation. We recommend removing this file as it could cause conflicts with WordPress\' dynamically generated one. AIOSEO can import this file and delete it, or you can simply delete it.', <code>type</code> = 'error', <code>level</code> = '[\"all\"]', <code>notification_id</code> = NULL, <code>notification_name</code> = 'robots-physical-file', <code>start</code> = '2021-01-04 21:02:38', <code>end</code> = NULL, <code>button1_label</code> = 'Import and Delete', <code>button1_action</code> = 'https://action#tools/import-robots-txt?redirect=aioseo-tools', <code>button2_label</code> = 'Delete', <code>button2_action</code> = 'https://action#tools/delete-robots-txt?redirect=aioseo-tools', <code>dismissed</code> = '', <code>created</code> = '2021-01-04 21:02:38', <code>updated</code> = '2021-01-04 21:02:38'

• This topic was modified 4 years, 2 months ago by grahambudd.