* 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 'AND n.status = 1 AND n.promote=1 ) ORDER BY vc.value DESC, n.created LIMIT 5' at line 1 query: SELECT * FROM node n LEFT JOIN votingapi_cache vc ON vc.content_id=n.nid LEFT JOIN term_node t ON n.nid = t.nid WHERE ( 1=1 ) AND ( 1=1 AND vc.content_type='node' AND vc.value_type='points' AND vc.tag='vote' AND vc.function = 'sum' AND n.type='drigg' AND n.created > UNIX_TIMESTAMP(CURRENT_TIMESTAMP()) - 60*60*72 AND t.tid= AND n.status = 1 AND n.promote=1 ) ORDER BY vc.value DESC, n.created LIMIT 5 in /home/onlinega/public_html/includes/database.mysql.inc on line 172.
    * 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 'AND n.status = 1 AND n.promote=0 ) ORDER BY vc.value DESC LIMIT 5' at line 1 query: SELECT * FROM node n LEFT JOIN votingapi_cache vc ON vc.content_id=n.nid LEFT JOIN term_node t ON n.nid = t.nid WHERE ( 1=1 ) AND ( 1=1 AND vc.content_type='node' AND vc.value_type='points' AND vc.tag='vote' AND vc.function = 'sum' AND n.type='drigg' AND n.created > UNIX_TIMESTAMP(CURRENT_TIMESTAMP()) - 60*60*48 AND t.tid= AND n.status = 1 AND n.promote=0 ) ORDER BY vc.value DESC LIMIT 5 in /home/onlinega/public_html/includes/database.mysql.inc on line 172.

How i can fix this?

Comments

mr.andrey’s picture

mr.andrey commented

I'm also experiencing this.

myactivistnetwork’s picture

myactivistnetwork commented

I don't know that it will help anyone else.
I am using Drupal. 5.7 , I was having this same problem after installing several new modules it simply popped up.
After running update.php the error went away.

Hope this helps someone.

It seems that some modules do not update the database as they should. Just a guess on my part since I am not a programmer, but after running update.php they seem to update and function properly.

jamesrutherford’s picture

jamesrutherford commented

I am also experiencing this is issue. Has any one found a cause or patch?

jamesrutherford’s picture

jamesrutherford commented

My error, and probably others like it was caused by trying to use node_load with an empty argument. Maybe this will help anyone else with this issue.

dberzon’s picture

dberzon commented

I am also experiencing this.

dpearcefl’s picture

dpearcefl commented
Status: Active » Closed (won't fix)

Considering the time elapsed between now and the last comment plus the fact that D5 is no longer supported, I am closing this ticket.