[F] [pgsql] Report posts [C-StefanT]

[Michael S.]

If the board is set to notify the moderators via PM about reported posts you get two SQL errors using PostgreSQL.

SQL Error:
22P02 - ERROR: invalid input syntax for integer: ""
Query:
SELECT pmid FROM mybb_privatemessages WHERE folder='3' AND uid='' AND pmid='0'

You can find the query in inc/datahandlers/pm.php in line 511.

SQL Error:
22P02 - ERROR: invalid input syntax for integer: ""
Query:
INSERT INTO mybb_privatemessages (fromid,folder,subject,icon,message,dateline,status,includesig,smilieoff,receipt,readtime,recipients,uid,toid) VALUES ('','1','Reported post at Forums','0','tester from Forums has reported this post: Test http://michael-laptop/~michael/mybb/showthread.php?tid=4&pid=5#pid5 The reason this user gave for reporting this post: Test This message has been sent to all moderators of this forum, or all administrators and super moderators if there are no moderators. Please check this post out as soon as possible.','1241369915','0','1','0','0','0','a:1:{s:2:"to";a:1:{i:0;s:1:"2";}}','2','2')

You can find the query in inc/datahandlers/pm.php in line 584.