UBB.Dev
Posted By: Pasqualist Search error on Entrance page - 07/10/2004 1:59 PM
I just did a search from the Entrance page and it returned the following error:

Code
<br />Script: /home/threadsdev/domains/ubbdev.com/public_html/forum/dosearch.php<br />Line#: 659<br />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.B_Posterid = t2.U_Number ORDER BY t1.B_Number DESC' <br />SQL Error #: 1064<br />Query: SELECT t1.B_Number,t1.B_Main,t2.U_Username,t1.B_Subject,t1.B_Posted,t1.B_Board,t2.U_Color,t1.B_Reged,t1.B_Icon,t1.B_Posterid,t1.B_Status,t1.B_Anonname,t1.B_Body,t1.B_LastPostNum,t1.B_Last_Post FROM w3t_Posts AS t1, w3t_Users AS t2 WHERE t1.B_Number IN () AND t1.B_Posterid = t2.U_Number ORDER BY t1.B_Number DESC 


I was looking for: +photopost +footer
Posted By: msula Re: Search error on Entrance page - 07/10/2004 5:31 PM
It was reported last night, should be fixed soon, thanks!
Posted By: scroungr Re: Search error on Entrance page - 07/10/2004 7:33 PM
add these to the site's searchpal.php

FIND

<input type="hidden" name="Limit" value="$QSearchLimit" />

ADD BELOW IT

<input type="hidden" name="fromsearch" value="1" />
<input type="hidden" name="checkwords" value="1" />

they changed the search so you need those lines. I am gonna upload 6.5 IIP Beta tonite with all the changes.
Posted By: AllenAyres Re: Search error on Entrance page - 07/12/2004 5:11 AM
grazi, will be fixed tomorrow, unless someone beats me to it
© UBB.Developers