search

clearbold / audit-pro

Audit Pro is the missing activity tracker for ExpressionEngine. It uses any available Control Panel hooks to log creating, editing or deleting entries as well as other activity.
http://devot-ee.com/add-ons/audit-pro
BSD 3-Clause "New" or "Revised" License
16 stars 12 forks source link

Error Number: 1366 Incorrect integer value: ‘’ for column ‘item_id’ at row 1 #10

Open jonroome opened 10 years ago

jonroome commented 10 years ago

I am getting an error when trying to add a notification error as follows: Any pointers? thanks. Error Number: 1366 Incorrect integer value: ‘’ for column ‘item_id’ at row 1 INSERT INTO exp_audit_notifications (email_address, is_sms, member_id, group_id, item_type, channel_id, item_id) VALUES (‘myname@myaddress.com’, 0, 0, 6, ‘entry_update’, ‘0’, ‘’) Filename: third_party/audit_pro/mcp.audit_pro.php Line Number: 295

heymarkreeves commented 10 years ago

Hello!

Looks like you're inserting an empty string for item_id, which is an integer field.

I don't have this running anywhere at the moment -- Do you have a value selected for the "Does this" dropdown field?