LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > LinuxQuestions.org > LQ Suggestions & Feedback
User Name
Password
LQ Suggestions & Feedback Do you have a suggestion for this site or an idea that will make the site better? This forum is for you.
PLEASE READ THIS FORUM - Information and status updates will also be posted here.

Notices


Reply
  Search this Thread
Old 07-15-2004, 09:30 PM   #1
itsjustme
Senior Member
 
Registered: Mar 2003
Location: Earth
Distribution: Slackware, Ubuntu, Smoothwall
Posts: 1,571

Rep: Reputation: 47
SQL errors on Keywords at Reviews


I went here:
http://www.linuxquestions.org/review...hp?product=238

And clicked on 'patrick' in the Keywords and got a page full of this:
-----
MySQL error reported!

Script: showcat

Query: SELECT f.userid,p.id,p.user,p.userid,p.cat,p.date,p.title,p.description,p.keywords, p.bigimage,p.views,p.approved,p.rating,p.manu FROM rp_favorites f, rp_products p WHERE ( AND ((title LIKE "% patrick%" OR description LIKE "% patrick%" OR keywords LIKE "% patrick%" OR bigimage LIKE "% patrick%" OR extra1 LIKE "% patrick%" OR extra2 LIKE "% patrick%" OR extra3 LIKE "% patrick%" OR extra4 LIKE "% patrick%" OR extra5 LIKE "% patrick%" OR extra6 LIKE "% patrick%") OR (title LIKE "patrick%" OR description LIKE "patrick%" OR keywords LIKE "patrick%" OR bigimage LIKE "patrick%" OR extra1 LIKE "%patrick%" OR extra2 LIKE "%patrick%" OR extra3 LIKE "%patrick%" OR extra4 LIKE "%patrick%" OR extra5 LIKE "%patrick%" OR extra6 LIKE "%patrick%"))) AND f.userid=28064 AND f.product=p.id ORDER BY disporder,date DESC

Result: 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 ((title LIKE "% patrick%" OR description LIKE "% patrick%"

Database handle: Resource id #10
-----
It happened on all of the keywords.

Regards...
 
Old 07-16-2004, 05:31 AM   #2
Goala
Member
 
Registered: May 2004
Location: Merida (Spain)
Distribution: Debian
Posts: 89

Rep: Reputation: 15
the error is after the WHERE clause. Something is absent between "(" and "AND".
 
Old 07-16-2004, 08:33 AM   #3
jeremy
root
 
Registered: Jun 2000
Distribution: Debian, Red Hat, Slackware, Fedora, Ubuntu
Posts: 13,602

Rep: Reputation: 4084Reputation: 4084Reputation: 4084Reputation: 4084Reputation: 4084Reputation: 4084Reputation: 4084Reputation: 4084Reputation: 4084Reputation: 4084Reputation: 4084
I'll get this cleaned up ASAP. Thanks.

--jeremy
 
Old 07-16-2004, 01:33 PM   #4
jeremy
root
 
Registered: Jun 2000
Distribution: Debian, Red Hat, Slackware, Fedora, Ubuntu
Posts: 13,602

Rep: Reputation: 4084Reputation: 4084Reputation: 4084Reputation: 4084Reputation: 4084Reputation: 4084Reputation: 4084Reputation: 4084Reputation: 4084Reputation: 4084Reputation: 4084
This has been corrected. Thanks again for the heads up.

--jeremy
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[BUG] lq bookmarks- searchable keywords titanium_geek LQ Suggestions & Feedback 3 10-11-2005 08:17 AM
GCC 4.0 specific keywords abk4523 Programming 1 09-22-2005 12:03 PM
How to: test packages with missing keywords. exodist Linux - Distributions 1 05-08-2005 10:25 PM
As will get rid of a spam on keywords ukrainet Linux - Newbie 2 12-13-2004 03:00 AM
Linux Keywords Westdog976 Linux - Newbie 4 06-13-2003 03:00 AM

LinuxQuestions.org > Forums > LinuxQuestions.org > LQ Suggestions & Feedback

All times are GMT -5. The time now is 03:52 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration