[F] [pgsql] SQL error if threads are moderated [C-StefanT]

[Michael S.]

If new threads in a forum are moderated you get a sql error after submitting the form:

Quote:SQL Error:
0 - ERROR: invalid input syntax for integer: ""
Query:
SELECT replies,unapprovedposts,attachmentcount,attachmentcount FROM mybb_threads WHERE tid=''

Fix: Open inc/datahandlers/post.php and find:

PHP Code:

update_thread_counters($thread['tid'], array("replies" => 0, "unapprovedposts" => 1)); 


Replace with:

PHP Code:

update_thread_counters($this->tid, array("replies" => 0, "unapprovedposts" => 1)); 


[Technoman]

[08-May-2009 17:12:21] PHP Parse error: parse error, expecting `'}'' in root\editpost.php(616) : eval()'d code on line 4

is this the error your referring to, if so thank you i replaced on what you posted

[Ryan Gordon]

(05-13-2009 02:04 AM)technoman Wrote:  [08-May-2009 17:12:21] PHP Parse error: parse error, expecting `'}'' in root\editpost.php(616) : eval()'d code on line 4

is this the error your referring to, if so thank you i replaced on what you posted

That has nothing to do with this

[Technoman]

thats right, so since this is a php error im recieving where can this be forwarded to since my responce isnt related to SQL.

[Ryan Gordon]

(05-13-2009 02:24 AM)technoman Wrote:  thats right, so since this is a php error im recieving where can this be forwarded to since my responce isnt related to SQL.

Try the general support forum

[Tomm M]

Thank you for your bug report.

This bug has been fixed in our internal code repository. Please note that the problem will not be fixed here until these forums are updated.

With regards,
MyBB Group