UBB.threads PHP Forum Software Community Forums UBB.threads 7 Bug Reports [NOTABUG] Search stopped working in 7.2

I get the error below now when I do any search. Forum is http://www.audiotalkback.com

I'm thinking about paying the $99 to re-join the members area and upgrading myself from 7.2 to the latest 7.x version. Is this wise? Is it a relatively easy upgrade? I'm thinking upgrading will probably fix the error with search. Thanks.

Justin


UBB Error
We encountered a problem. The reason reported was

Script: /home/audio/public_html/forums/scripts/dosearch.inc.php
Line#: 487
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 '99999999999999999999' at line 14
SQL Error #: 1064
Query: SELECT t1.POST_ID FROM ubbt_POSTS as t1, ubbt_TOPICS as t2 WHERE t1.POST_IS_APPROVED = '1' AND t2.TOPIC_STATUS <> 'M' AND t2.FORUM_ID IN ('1') AND t1.TOPIC_ID = t2.TOPIC_ID AND MATCH ( t1.POST_SUBJECT,t1.POST_DEFAULT_BODY) AGAINST ('test da7' IN BOOLEAN MODE) AND t1.POST_POSTED_TIME > '936739943' ORDER BY t1.POST_POSTED_TIME DESC LIMIT 99999999999999999999

I'd check the Maximum Results from Search: in the Control Panel under feature settings and make sure that's something reasonable, default is 200.

As for upgrading. It's not too bad if you're comfortable with uploading files via FTP. You can use this guide to assist.

Thanks Rick that fixed my issue. I will consider upgrading this weekend and hope every little bit helps support your fine company and product(s).

Well, got through the upgrade process without a hitch and am now happily using 7.5.3. It's great and I look forward to using some of the new functionality as is my user group. http://www.audiotalkback.com

Thanks again!

Was poking around your forum a bit. I did not register but may do so in the future as I get more going on my sound studio that I'm building.

Glad to hear it JAISP you're more than welcome!

I registered on your forum today Justin. I'm only a few short weeks away from building my setup. Hope to get some great information and help from your site.

I also noticed you upgraded to 7.5.3 as well.