What is this error message?

4 replies [Last post]
Mik
Mik's picture
Offline
Joined: 12/11/2007
Posts:
Points: 3710

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

Quote:

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

__________________

This information may be used entirely at your own risk.

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

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
reikiman's picture
Offline
Joined: 11/19/2006
Posts:
Points: 8448
Re: What is this error message?

Quote:

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?

__________________

- David Herron, Green Transportation Examiner, Green Transportation Info, The Long Tail Pipe, Torque News, electric race news, davidherron.com, 7gen.com, What is Reiki
- EVT 4000, Charger bike (rebuilt), Vego 600sx (rebuilt), Electrified Electra Townie
- Lectra motorcycle, 1971 Karmann Ghia

Mik
Mik's picture
Offline
Joined: 12/11/2007
Posts:
Points: 3710
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's picture
Offline
Joined: 11/16/2006
Posts:
Points: 872
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://www.7gen.com/

Mik
Mik's picture
Offline
Joined: 12/11/2007
Posts:
Points: 3710
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!

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Short URL

Customize This