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] Shane Bester
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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.