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

v7.1.1

I enabled the SQL log about a week ago and just caught my first error in it. Here it is, can anybody tell me what the issue is?

Script: /usr/home/dunsire/ubbthreads/scripts/postlist.inc.php - Line: 709
select t1.TOPIC_ID,t1.POST_ID,t2.USER_DISPLAY_NAME,t1.TOPIC_CREATED_TIME,t1.TOPIC_LAST_REPLY_TIME,t1.TOPIC_SUBJECT,
t1.TOPIC_STATUS,t1.TOPIC_IS_APPROVED,t1.TOPIC_ICON,t1.TOPIC_VIEWS,t1.TOPIC_REPLIES,t1.TOPIC_TOTAL_RATES,
t1.TOPIC_RATING,t3.USER_NAME_COLOR,t2.USER_MEMBERSHIP_LEVEL,t1.USER_ID,t1.TOPIC_IS_STICKY,t1.TOPIC_LAST_POSTER_ID,
t1.TOPIC_LAST_POSTER_NAME,t1.TOPIC_LAST_POST_ID,t1.TOPIC_IS_EVENT,t1.TOPIC_HAS_FILE,t1.TOPIC_HAS_POLL
from ubbt_TOPICS as t1
left join ubbt_USERS as t2 on t1.USER_ID = t2.USER_ID
left join ubbt_USER_PROFILE as t3 on t1.USER_ID = t3.USER_ID
where t1.FORUM_ID = '33'
and t1.TOPIC_IS_STICKY = '0'
AND t1.TOPIC_LAST_REPLY_TIME > 1190886042
AND t1.TOPIC_IS_APPROVED = '1'
ORDER BY t1.TOPIC_LAST_REPLY_TIME desc
LIMIT -35, 36
- 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 '-35, 36' at line 13


Thanks in advance!

That was a problem in earlier versions where sometimes the limit clause would end up being negative, the "LIMIT -35,36" portion. An upgrade will take care of that as well as a few other bugs.

Thanks for the info Rick,

I have v7.2.2 on our test site and will probably wait until v7.3 before moving the production site to the latest release.