Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By scarer on
I just upgraded Drupal to 5.10 and I am getting this error on user profile pages:
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 '' at line 1 query: SELECT uid,name,picture FROM users WHERE status != 0 and uid != 0 and picture <> '' ORDER BY in /Volumes/MyQCA-Data/Webfolder/includes/database.mysql.inc on line 172.
Please help.
Comments
what version is your MYSQL
what version is your MYSQL server?
also, what effects does this error have on your page, if any? is anything not displaying right?
not affecting anything
MySQL version 5.0.24a
i have cut out the error message from the viewer by setting messages to display:none in the css
still don't know what the error's about though
same problem
using advanced profile - (?) - with Drupal 5.12
fixed this by...
disabling the avatar gallery module.