MyBB Community Forums

I get this error when attempting to post a reply:

Quote:mySQL error: 1048
Column 'fid' cannot be null
Query: INSERT INTO mybb_favorites (fid,uid,tid,type) VALUES (NULL,'1','4','s')

I had to change servers recently and we changed PHP versions in the move. Perhaps that has something to do with it but I'm not sure.

CrazyTech Wrote:I get this error when attempting to post a reply:

Quote:mySQL error: 1048
Column 'fid' cannot be null
Query: INSERT INTO mybb_favorites (fid,uid,tid,type) VALUES (NULL,'1','4','s')

I had to change servers recently and we changed PHP versions in the move. Perhaps that has something to do with it but I'm not sure.

Could you please post/send your board URL? Also, what is the version number of your php and mysql?

Furthermore, are you using MyBB 1.0? Is this only in specific forums or in all forums on your board?

I'd say you're using MyBB 1.0 PR2 along with MySQL 5. Please be aware that we have released "1.0", which has better compatibility with MySQL 5.

Board: http://www.datestandard.com/
MySQL: 4.0.25

It is version 1.0 PR2 so I'll try the update.

I did the upgrade from 1.00 RC2 to 1.00.

I'm still getting errors upon posting.

Quote:mySQL error: 1048
Column 'fid' cannot be null
Query: INSERT INTO mybb_favorites (fid,uid,tid,type) VALUES (NULL,'1','45','s')

Anyone with ideas?

Sorry - didn't notice activity in this thread.

Please try the attached version of newreply.php and let me know how you go.

Regards,
Chris

Thank Chris! That worked.