What is this error message?

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

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
reikiman's picture
Offline
Joined: 11/19/2006
Points: 8454
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, Electric Race News, davidherron.com, 7gen.com, What is Reiki
- Charger bike (rebuilt), Electrified Electra Townie, 1971 Karmann Ghia

Mik
Mik's picture
Offline
Joined: 12/11/2007
Points: 3723
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
Joined: 11/16/2006
Points: 885
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
Points: 3723
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