php forum
php mysql forum
php mysql smarty
 
Topic Options
#276297 - 07/10/04 06:59 AM Search error on Entrance page
Pasqualist Offline
Member

Registered: 01/30/03
Posts: 285
Loc: Amsterdam, The Netherlands
I just did a search from the Entrance page and it returned the following error:<br /><br />
Code:
<br />Script: /home/threadsdev/domains/threadsdev.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 
<br /><br />I was looking for: +photopost +footer

Top
#276298 - 07/10/04 10:31 AM Re: Search error on Entrance page [Re: 10k]
msula Offline
Addict

Registered: 02/18/02
Posts: 1969
Loc: Lansing, Michigan
It was reported last night, should be fixed soon, thanks!

Top
#276299 - 07/10/04 12:33 PM Re: Search error on Entrance page [Re: 10k]
scroungr Offline
Old Hand

Registered: 10/17/03
Posts: 2409
Loc: Richmond, VA
add these to the site's searchpal.php<br /><br />FIND<br /><br /><input type=\"hidden\" name=\"Limit\" value=\"$QSearchLimit\" /><br /><br />ADD BELOW IT<br /><br /><input type=\"hidden\" name=\"fromsearch\" value=\"1\" /><br /><input type=\"hidden\" name=\"checkwords\" value=\"1\" /><br /><br />they changed the search so you need those lines. I am gonna upload 6.5 IIP Beta tonite with all the changes.
_________________________
Couchtomatoe - www.couch-tomatoe.cc
My abilities are for hire for installs, upgrades, custom themes and custom modifications.

Top
#276300 - 07/11/04 10:11 PM Re: Search error on Entrance page [Re: 234234]
AllenAyres Offline

I type Like navaho

Registered: 03/10/00
Posts: 25580
Loc: Texas
grazi, will be fixed tomorrow, unless someone beats me to it <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />
_________________________
- Allen wavey
- What Drives You?

Top



Moderator:  Deb 
Latest Posts
[7.2.1] - Naked shoutbox
by bellaonline
05/05/12 05:00 PM
[7.x] Stop Forum Spam Integration v0.4
by bellaonline
05/05/12 03:53 PM
Shout Box

(Views)Popular Topics
Known public proxy servers 1689885
Integrated Index Page (IIP) 5.3.1 555705
Finished-[6.5.2] Games Arcade Deluxe v1.9 501236
Integrated Index Page (IIP) 5.1.1 415112
TLD Bv2.1 Released - Threads Links Directory 396822
[6.0x] Who's Online 4.0.0 [Finished] 389412
Finished-[6.5.1] Integrated Index Page (IIP) 6.5 330423
Q & A 298663
Slash UBB 266936
[6.3.x] [beta] Hit Hack 2.0 227970
Forum Stats
13621 Members
59 Forums
37191 Topics
295716 Posts

Max Online: 686 @ 06/28/07 07:04 AM

 

 

 
fusionbb message board php hacks