Closed (fixed)
Project:
Listhandler
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Reporter:
Created:
27 Jan 2005 at 08:47 UTC
Updated:
10 Feb 2005 at 21:15 UTC
Hi, I was getting the following error:
user error: You have an error in your SQL syntax near 'ON l.nid = n.nid WHERE n.title LIKE '%Test] kdkdiekdkd' AND mid = 1 ORDER by n.n' at line 1 query: SELECT * FROM listhandler l JOIN node n ON l.nid = n.nid WHERE n.title LIKE '%Test] kdkdiekdkd' AND mid = 1 ORDER by n.nid DESC in /home/uws/public_html/includes/database.mysql.inc on line 125.
Making the sql query that generated the error an "INNER JOIN" rather than plain "JOIN" fixed the error.
Comments
Comment #1
killes@www.drop.org commentedFixed, thanks.
Comment #2
(not verified) commented