Issue with spamalyser

[Monkeys]

Hi,

I tried posting under the plugins board but it would give me an error about lacking sufficient permissions, so I'll post here instead. Sorry if that's bad.

A user tried posting a message on our boards and received the following error:

Code:

1 2 3 4 5 6

MyBB has experienced an internal SQL error and cannot continue. SQL Error: 1364 - Field 'pid' doesn't have a default value Query: INSERT INTO mybb_spamalyser_log (`event`,`score`,`details`,`dateline`,`message`,`uid`,`username`,`fid`,`ipaddress`,`httpreq`,`timeonline`,`postcount`,`actions`,`subject`) VALUES ('0','0.010653409090909','a:6:{s:10:\"onlinetime\";d:0.010653409090909092;s:6:\"ipdiff\";d:0;s:3:\"msg\";i:0;s:3:\"sfs\";d:0;s:13:\"google_search\";d:0;s:13:\"markedreports\";d:0;}','1345738692','Your name: Blazzed \r\nYour STEAM ID: STEAM_0:1:42867562 \r\n[b]Guard ban or Server ban?[/b]: Server ban \r\n[b]Ban reason[/b]:i typed pp_pixelrender in the console\r\n[b]Banning admin[/b]: Really don\'t know \r\n[b]Apology, explanation or additional notes[/b]: I\'m so very sorry my friend said if i did it i would get ban and i said bull shit and i typed it and BAM i was auto ban please unban me i love to play your jailbreak please.:iiam:','2231','Blazzed','9','24.188.77.107','POST /forums/newthread.php?fid=

---

I'd appreciate some help to solve the issue, thanks.

[ZiNgA BuRgA]

I'm very surprised you're not getting SQL errors elsewhere as MyBB wasn't designed to run with SQL strict mode enabled.
You can try altering the mybb_spamalyser_log table and setting the default value for pid to be 0.

[Monkeys]

Yeah that seems to have fixed it, thanks.

Could you elaborate on "SQL strict mode", what it is, how can I find out if it's enabled, how can I disable it, etc?

Thanks.

[ZiNgA BuRgA]

http://dev.mysql.com/doc/refman/5.0/en/s...http://dev.mysql.com/doc/refman/5.0/en/server-sql