By jesseliberty on

Hi,

When going into my site, I have the following php error:

user warning: 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 '.uid FROM comments c INNER JOIN node n ON n.nid = c.nid WHERE c.nid IN (11) AND ' at line 1 query: SELECT c.nid, c.subject, c.cid, c.timestamp c.uid FROM comments c INNER JOIN node n ON n.nid = c.nid WHERE c.nid IN (11) AND n.status = 1 AND c.status = 0 ORDER BY c.timestamp DESC LIMIT 0, 10 in /home/my_host/public_html/my_website/includes/database.mysql.inc on line 172.

What do I do?

Jesse Liberty

⋅ Categories: Drupal 5.x

Comments

nevets’s picture

nevets commented

This part SELECT c.nid, c.subject, c.cid, c.timestamp c.uid FROM missing a comma between c.timestamp and c.uid.

jesseliberty’s picture

jesseliberty commented

How do I know which file this error is in>?\
\
JesseLiberty

jesseliberty’s picture

jesseliberty commented

OK, duh. I fugured it out.
Thanks for the help...
hopefully I will still meet my deadline.