MyBB Community Forums

As the title says, that's the error I'm getting on my forum. A member reported the error as:

mySQL error: 1366  Incorrect integer value: 'upload' for column 'avatartype' at row 1  Query: UPDATE mybb_users SET avatar='./uploads/avatars/avatar_6.gif', avatartype='upload' WHERE uid='6'

and I've been able to duplicate it (except with uid='1' obviously). Any help?

EDIT: I'm using myBB 1.1.5

*UPDATE*

I just found out I get the error when I try and stick a thread aswell

mySQL error: 1366
Incorrect integer value: '' for column 'fid' at row 1
Query: INSERT INTO mybb_moderatorlog (uid,dateline,fid,tid,action,ipaddress) VALUES ('1','1151509630','','','Thread stuck','192.168.1.1')

I also searched around for help, and others have said they've had problems with MySQL 5. Could MySQL 5 be causing this? If so, is there any way I could downgrade to MySQL 4 until this is fixed in MySQL 5?

Heh, I fixed it, turns out I had strict mode enabled. Sorry about that.

You should be able to run MySQL 5 in strict mode in 1.2. We've been ironing out these MySQL 5 issues since the release of 1.0