UBB.threads PHP Forum Software Community Forums UBB.threads 7 Bug Reports Fixed Bugs [Fixed 7.3]7.2.2. Watch List Bug

after i add a forum or user to a watch list i get this error when i try to select "my watch lists" link.

We encountered a problem. The reason reported was
Script: E:\www\markdriver\forums\scripts\tab_forums.inc.php
Line#: 113
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 '' at line 8
SQL Error #: 1064
Query: select t.TOPIC_ID,t.POST_ID,t.USER_ID,t.TOPIC_SUBJECT,t.TOPIC_ICON,t.TOPIC_CREATED_TIME,u.USER_DISPLAY_NAME,t.TOPIC_LAST_REPLY_TIME,t.FORUM_ID from ubbt_TOPICS as t, ubbt_USERS as u where TOPIC_IS_APPROVED = '1' and t.USER_ID = u.USER_ID and t.FORUM_ID IN ( '1' ) order by t.TOPIC_LAST_REPLY_TIME desc limit

It looks like the limit clause is missing. That comes from your Topics per page setting in your profile. Try going into your preferences and make sure you have a valid number in the topics per page setting.

Now fixed to not allow a null in 7.3

What about Watched Topics even in 7.3b3 still not emailing notices? :/

Allen has been experiancing weird issues with it for a while now at the other site...

I'm having this same problem in 7.3.1.

Whats the fix?

i tried changing the ubbt_forums.forum_default_topic_age to NULL, 1, 365, still no joy.

Mysql ver 4.1.10

Thanks

Looks like i fixed mine. The limit statement is not complete.

Rather than figuring out why, i just removed it.

\scripts\tab_forums.inc.php

Line 112 removed $limit_clause

it's caused because the user doesn't have a topics per page value set and tab_forums.inc.php assumes so..

ideally, it should check to see if it's defined.. if not, then grab the global config value.. if even that (for some reason) ain't happening, then there should be a catchall of 25 or whatever.

this occurs elsewhere too

you can 'fix it' without modifying code, by simply going into your preferences, selecting a value and saving..