What is this error message?

5 posts / 0 new
Last post
Mik
Mik's picture
Offline
Last seen: 7 years 11 months ago
Joined: Tuesday, December 11, 2007 - 15:27
Points: 3739
What is this error message?

This appears in a pink box on top of my screen most of the time:

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 'DESC LIMIT 0, 5' at line 1 query: SELECT DISTINCT(node.nid), active, node.title AS node_title, node.changed AS node_changed, forward_statistics.clickthrough_count AS forward_statistics_clickthrough_count, forward_statistics.forward_count AS forward_statistics_forward_count FROM node node LEFT JOIN forward_statistics forward_statistics ON node.nid = forward_statistics.nid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'forum_access'))) ORDER BY DESC LIMIT 0, 5 in /var/www/vhosts/visforvoltage.org/httpdocs/includes/database.mysql.inc on line 172.

Anything I can do to get rid of it?

Mr. Mik

reikiman
reikiman's picture
Offline
Last seen: 10 months 4 weeks ago
Joined: Sunday, November 19, 2006 - 17:52
Points: 8447
Re: What is this error message?

Anything I can do to get rid of it?

Yeah, you tell me what you did to get that to print - so that I can replicate the problem - so that I can have a chance of fixing it.

'forward_statics' makes me think you tried forwarding a page to someone?

Mik
Mik's picture
Offline
Last seen: 7 years 11 months ago
Joined: Tuesday, December 11, 2007 - 15:27
Points: 3739
Re: What is this error message?

Hi,
it comes up all by itself as soon as I log into "V".

Happens with Firefox and IE.

Does not happen if I am not logged in.

Everything seems to work fine, but it uses up "real estate" on the screen.

It looks like this:

error_message.jpeg

Mr. Mik

This information may be used entirely at your own risk.

There is always a way if there is no other way!

Webmaster
Webmaster's picture
Offline
Last seen: 1 month 2 weeks ago
Joined: Thursday, November 16, 2006 - 17:00
Points: 667
Re: What is this error message?

I masqueraded as you and yup- there was the message. I found that turning off the 'Most Active' block in your user configuration made the message go away. It appears there is a syntax error in some SQL query.

- David Herron, http://longtailpipe.com/

Mik
Mik's picture
Offline
Last seen: 7 years 11 months ago
Joined: Tuesday, December 11, 2007 - 15:27
Points: 3739
Re: What is this error message?

Thanks, it's fixed.
Mr. Mik

This information may be used entirely at your own risk.

There is always a way if there is no other way!

Log in or register to post comments


Who's online

There are currently 0 users online.

Who's new

  • stuuno
  • marce002
  • Heiwarsot
  • headsupcorporation
  • OldTech

Support V is for Voltage