when i delete a user, such an error appears:

"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 'WHERE uid = 6' at line 1 query: DELETE FROM profile_privacy_values ppv WHERE uid = 6 in /site/includes/database.mysql.inc on line 172."

Drupel 5.3,
MySQL database 5.0.27
PHP 5.2.5

Comments

ali_a’s picture

ali_a commented

I get the same error:
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 'WHERE uid = 25' at line 1 query: DELETE FROM profile_privacy_values ppv WHERE uid = 25 in /home/elnitco/public_html/includes/database.mysql.inc on line 172.

drupal 5.5
MySQL version: 5.0.45
PHP version: 5.2.5

mindyblock’s picture

mindyblock commented

Gosh, I've been getting that error for months. I didn't understand it until tonight. I deleted this module and it went away.

quicksketch’s picture

quicksketch
he/him
commented
Status: Active » Fixed

Thanks I finally committed http://drupal.org/node/171796 which fixes the problem so that the profile_privacy information is cleaned up when removing a user.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.