SQL error deleting posts as moderator

New Member Joined: Oct 03, 2004 Posts: 3

When a moderator tries to delete a post this is the error that appears

Quote:

Could not get poster id information

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ') GROUP BY poster_id' at line 3

SELECT poster_id, COUNT(post_id) AS posts FROM nuke_bbposts WHERE topic_id IN () GROUP BY poster_id

Line : 299
File : /var/www/html/modules/Forums/modcp.php

Also even though no errors appear locking or moving posts fail as well.

Have copied original php scripts back onto the server into the modules/Forums directories.

Still no luck so I dropped all the nuke_bb databases and reloaded them in case an id was out of synch.

Same result.

So bar scrapping the site and starting from scratch where do I go now?

This seems to be the relevant code

Code:

$sql = "SELECT poster_id, COUNT(post_id) AS posts


                                FROM " . POSTS_TABLE . "


                                WHERE topic_id IN ($topic_id_sql)


                                GROUP BY poster_id";

and this seems to be the bit falling in a heap

Code:

$topic_id_sql = '';


         while ($row = $db->sql_fetchrow($result))


         {


            $topic_id_sql .= (($topic_id_sql != '') ? ', ' : '') . intval($row['topic_id']);


         }

Thanks

Babbage

Posted: Mon Oct 04, 2004 9:29 pm

What forum version are you using. The current version is 2.0.10

Posted: Tue Oct 05, 2004 5:13 am

"Powered by phpBB 2.0.8"

Which was from the 7.3 upgrade, is 2.0.10 available for 7.3?

Thanks

Babbage

Posted: Tue Oct 05, 2004 5:29 am

Yes!
[ Only registered users can see links on this board! Get registered or login! ]

Posted: Tue Oct 05, 2004 8:34 am

Quote:

Fixed use of non-existing result variable in modcp (poster_id instead of user_id)

Looks like it was addressed in .09 version Smile

I'll download the patch in a few hours time and try it out and let you know the result.

Thanks for the replies

babbage

www.babbage.biz