[Shaman]

Mine was failing with:

---

Query failed:
INSERT LOW_PRIORITY INTO post (title,allowsmilie,threadid,dateline,nntpdateline, pagetext,visible,msgid,ord,username,userid,nntpfro m,ipaddress,isusenetpost) VALUES ('wanted',1,,995388228,945544816,'Need somebody to clean apartment.\n\ncgardner@home.com\n','1','<Q7R64.138 66$TT4.520532@news1.rdc2.on.home.com>','0','C. Gardner',0,'&quot;C. Gardner&quot; &lt;cgardner@nospam.home.com&gt;',0,1)

DBD::mysql::db do failed: You have an error in your SQL syntax near '995388228,945544816,'Need somebody to clean apartment.\n\ncgardner@home.com\n','' at line 1 [for statement ``SELECT a.nntpposter, a.forum, a.msgid, a.dtm, a.subject, a.poster, a.email, a.body, a.ord, a.threadid, a.postid FROM usenet_article AS a LEFT OUTER JOIN post AS b on (a.msgid=b.msgid) WHERE a.forum = 26 AND b.msgid is null AND (refs = '' OR refs is NULL OR refs = '(none)') AND LEFT(subject,3) <> 'Re:' ORDER BY dtm'']) at ./newnews.pl line 594, <SOCK1> line 11165.

---

This was with DBI v1.16 and MySQL module v1.21xx

Note that threadid was nonexistant (which is the error in the query).

Now it is working perfectly with:

MySQL v 3.23.36
Perl 5.6.1
DBI v1.18
MySQL module from Msql-Mysqjl-Modules v1.2216