Bug #69286 Error : Incorrect integer value: '' for column 'main' at row 1
Submitted: 20 May 2013 13:28 Modified: 20 May 2013 13:54
Reporter: tal hh Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.6.10 OS:Windows
Assigned to: CPU Architecture:Any

[20 May 2013 13:28] tal hh
Description:
Error : Incorrect integer value: '' for column 'main' at row 1
Error No: 1366
Date: Monday 20th 2013f May 2013 04:25:47 PM

---------------Query---------------

insert into rafia_news  (cat_id,
                                                         title,
                                                         date_time,
                                                         userid,
                                                         name,
                                                         news_head,
                                                         post,
                                                         allow,
                                                         lastuserid,
                                                         timestamp,
                                                         inindex,
                                                         main,
                                                         inmenu,
                                                         catmig,
                                                         ues_editor)
                                                   values
                                                         ('14',
                                                         'dd',
                                                         '1369056347',
                                                         '3',
                                                         'user',
                                                         '<p>ddd</p>',
                                                         '<p>dd</p>',
                                                         'yes',
                                                         '3',
                                                         '1369056347',
                                                         '1',
                                                         '',
                                                         '0',
                                                         '0',
                                                         '1')

How to repeat:
earch uncle solution to this error, please

Suggested fix:
earch uncle solution to this error, please
[20 May 2013 13:31] tal hh
A copy of the error

Attachment: errormusql.jpg (image/jpeg, text), 127.09 KiB.

[20 May 2013 13:33] tal hh
A copy of the error-1

Attachment: erorr2.jpg (image/jpeg, text), 54.35 KiB.

[20 May 2013 13:54] MySQL Verification Team
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php