Forum Index
RegisterSearchFAQMemberlistUsergroupsLog in
MySQL error in search

 
Reply to topic    Forum Index » Bugs and errors View previous topic
View next topic
MySQL error in search
Author Message
hetes



Joined: 17 Apr 2007
Posts: 36
Location: Hungary

Post MySQL error in search Reply with quote
I get this error message, when i search e.g. John Williams:

Quote:
Notice:
mysql_query(): MySQL 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 '%john 'williams%' or full like %john 'williams%'' at line 4 in /host/path/wwwroot/mypage.php: include on line 144

in /host/prepend/prepend.php(187) : system created function on line 36

Notice:
mysql_query(): MySQL 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 '%john 'williams%'' at line 4 in /host/path/wwwroot/mypage.php: include on line 144

in /host/prepend/prepend.php(187) : system created function on line 36


On mypage on line 144

Quote:
<?php
include("dirname/head.php");
?>

....

<?php
if ($do == 'search'){ include $cutepath.'/search.php'; }
?>


If i search just John or Williams, i get the results correctly.

Is it a bug or my server's bad settings?
Any idea? Idea
Mon Sep 17, 2007 4:22 pm View user's profile Send private message
Guest








Please login to hide the ads.

scottdallas



Joined: 04 May 2006
Posts: 1943
Location: US

Post Reply with quote
The script (for reasons I don't understand) doesn't seem to like to search multiple words. I've never seen it flip out that bad though. There's a multiple word search add-on in 'Additional Downloads' but it doesn't allow you to set a $template.. the search template seems hard-coded inside of the search plugin. I haven't taken much time to see how to adjust it's template.. it works similarly to CuteNews search out of box. I'm sure it won't be too hard to manipulate, then you should be able to search John Williams Razz

_________________
www.scottdizzle.com uses cnr Smile
last update: 07-22-08: 8:30 pm
Mon Sep 17, 2007 6:35 pm View user's profile Send private message Visit poster's website AIM Address
Display posts from previous:    
Reply to topic    Forum Index » Bugs and errors All times are GMT + 1 Hour
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum



Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Music Lyrics.