UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support Active topics error

Getting this when try to use Active Topics (any of those options) on my 7.3b5 test forum
Anyone help?



We encountered a problem. The reason reported was
Script: /home/sites/www.domain name here.com/web/forums/scripts/activetopics.inc.php
Line#: 139
SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and t1.FORUM_ID = t2.FORUM_ID and t2.FORUM_ACTIVE_POSTS = 1 and t1' at line 5
SQL Error #: 1064
Query: select count(t1.TOPIC_ID) from ubbt_TOPICS as t1, ubbt_FORUMS as t2 where t1.TOPIC_LAST_REPLY_TIME > 1210159296 and t1.FORUM_ID in () and t1.FORUM_ID = t2.FORUM_ID and t2.FORUM_ACTIVE_POSTS = 1 and t1.TOPIC_IS_APPROVED = 1 and t1.TOPIC_STATUS <> 'M'

Have you made any changes to your scripts - perhaps line 139 of scripts/activetopics.inc.php?

And I would suggest testing with the final rather than b5 as several fixes were made between b5 and the final.

no I didn't change anything.

I will try with the 7.3 tomorrow morning, got to rest now!

thanks

Do you have any actual forums setup where you can see them on your test board? The error is that there are no forums in the query for some reason. The script should catch this and present a more user friendly error, so I'll need to look at that.

"Do you have any actual forums setup where you can see them on your test board?"

Yes I do.

OK I deleted the test forums completely, dropped the database and then reinstalled.

As soon as the clean install (7.3) was on, I went to any of the 3 dropdowns and got the below:


We encountered a problem. The reason reported was
Script: /home/sites/www.yuzawa-now.com/web/forums/scripts/activetopics.inc.php
Line#: 139
SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and t1.FORUM_ID = t2.FORUM_ID and t2.FORUM_ACTIVE_POSTS = 1 and t1' at line 5
SQL Error #: 1064
Query: select count(t1.TOPIC_ID) from ubbt_TOPICS as t1, ubbt_FORUMS as t2 where t1.TOPIC_LAST_REPLY_TIME > 1210236712 and t1.FORUM_ID in () and t1.FORUM_ID = t2.FORUM_ID and t2.FORUM_ACTIVE_POSTS = 1 and t1.TOPIC_IS_APPROVED = 1 and t1.TOPIC_STATUS <> 'M'

Please click back to return to the previous page.

I seem to have fixed this. Not exactly sure how unfortunately but once I had all the permissions on it seems to be working now.

I hope it works on the real thing.