MyBB Community Forums

Full Version: MyBB SQL Error - 1366
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Detailed description of your problem, including steps to reproduce if necessary I'm insure what triggers it, but it seems to be something with the "away" system. The user set himself as away and it worked fine, but now it seems to give an error message when we click on his profile. Maybe, maybe the "away" time ran out and there was an error in setting him as back or something? I have no idea.

URL to your forum/URL to specific problematic page Forum URL: http://www.lifepunch.net - Specific URL to his profile: http://www.lifepunch.net/forums/member.p...le&uid=966

New installation or upgrade (from which version of MyBB)? Upgrade from 1.6.4 I think? I don't remember honestly, sorry.

Screenshot or error text, verbatim
[Image: NFcw7.jpg]

Also pasting the error in case someone Googles it and an answer is found on this thread. Smile

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1366 - Incorrect integer value: '' for column 'awaydate' at row 1
Query:
UPDATE mybb_users SET away='0', awaydate='', returndate='', awayreason='' WHERE uid='966'
Please contact the MyBB Group for support.
Sorry to bump, this has sunk to the 4th page with no reply.

I guess I'm on my own?

Fixed it by replacing 'awaydate' => '' with 'awaydate' => '0'