Issue with spamalyser
Monkeys Offline
Junior Member
**
Posts: 2
Joined: Aug 2012
Post: #1
Issue with spamalyser
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.

08-24-2012 02:44 AM
Find all posts by this user Quote this message in a reply
ZiNgA BuRgA Offline
Fag
*******
Posts: 3,357
Joined: Jan 2008
Post: #2
RE: Issue with spamalyser
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.

My Blog
08-24-2012 07:47 AM
Find all posts by this user Quote this message in a reply
Monkeys Offline
Junior Member
**
Posts: 2
Joined: Aug 2012
Post: #3
RE: Issue with spamalyser
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.
08-24-2012 08:21 AM
Find all posts by this user Quote this message in a reply
ZiNgA BuRgA Offline
Fag
*******
Posts: 3,357
Joined: Jan 2008
Post: #4
RE: Issue with spamalyser
http://dev.mysql.com/doc/refman/5.0/en/s...http://dev.mysql.com/doc/refman/5.0/en/server-sql

My Blog
08-24-2012 11:56 AM
Find all posts by this user Quote this message in a reply

« Next Oldest | Next Newest »

 Standard Tools
Forum Jump: