UBB.Developers Forums UBB.threads 6 Bug Reports SQL Error in Search.php

I only want to display one category. Here is my url :
http://blah.com/search.php?Cat=3

When I go to do a search with that particular url, I get an sql error. Here is both the sql statement (I added that code to print it out) and the error, to help you debug Scream :
q = SELECT Bo_Title,Bo_Keyword,Bo_Cat,Bo_Sorter FROM w3t_Boards WHERE (Bo_Read_Perm LIKE '%-3-%' OR Bo_Read_Perm LIKE '%-1-%') AND (Bo_Cat = ) ORDER BY Bo_Cat,Bo_Sorter

Seeya! You have an error in your SQL syntax near ') ORDER BY Bo_Cat,Bo_Sorter ' at line 5: 1064

I believe the error is happening at line 85 in Search.php.

Thanks!


= Jim =

Ok, try this fix:

Line 59 of search.php currently looks like this:

$catonly = ereg_replace($pattern,$replace,$Cat);

Change that, to this:

$thiscat = ereg_replace($pattern,$replace,$Cat);