fantomel Posted September 27, 2008 Share Posted September 27, 2008 hello please can someone explain to me why does it gives this warning ? Inserted rows: 1 Inserted row id: 1 Note: #1265 Data truncated for column 'date' at row 1 Note: #1265 Data truncated for column 'expire' at row 1 Link to comment https://forums.phpfreaks.com/topic/126045-solved-note-1265-data-truncated-for-column-date-at-row-1/ Share on other sites More sharing options...
PFMaBiSmAd Posted September 27, 2008 Share Posted September 27, 2008 You tried to put in data that was longer than what your column definitions allow. Link to comment https://forums.phpfreaks.com/topic/126045-solved-note-1265-data-truncated-for-column-date-at-row-1/#findComment-651834 Share on other sites More sharing options...
fenway Posted September 29, 2008 Share Posted September 29, 2008 An example of the insert statement and the table definition would help, too. Link to comment https://forums.phpfreaks.com/topic/126045-solved-note-1265-data-truncated-for-column-date-at-row-1/#findComment-653347 Share on other sites More sharing options...
FoxRocks Posted November 15, 2012 Share Posted November 15, 2012 You tried to put in data that was longer than what your column definitions allow. 4 years later and this helped me thanks! Link to comment https://forums.phpfreaks.com/topic/126045-solved-note-1265-data-truncated-for-column-date-at-row-1/#findComment-1392588 Share on other sites More sharing options...
deo Posted August 30, 2013 Share Posted August 30, 2013 while uploading an excel i got this error it was not a back end issue excel uploaded was having large space in one column before the double value like: isbn mrp 323232 121 21212 3232 Link to comment https://forums.phpfreaks.com/topic/126045-solved-note-1265-data-truncated-for-column-date-at-row-1/#findComment-1447418 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.