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
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, The Long Tail Pipe, davidherron.com, 7gen.com, What is Reiki
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:
Mr. Mik
This information may be used entirely at your own risk.
There is always a way if there is no other way!
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/
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!