More of the same UPDATE errors. I had a couple of users trying to change their password and getting:
Failed to execute query: 'UPDATE gforum_User SET user_location_other IS ? , user_quick1 IS ? , user_quick2 IS ? , user_quick3 IS ? , user_mil_status = ? , user_occupation_other IS ? , user_email = ? , user_password = ? , user_message_notify = ? , user_real_name = ? , user_signature IS ? , user_default_reply_notify = ? , user_grade = ? , user_location = ? , user_accept_privmsg = ? , user_invisible = ? , user_state = ? , user_occupation = ? WHERE user_id = ?' Reason: 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 'IS NULL , user_quick1 IS NULL , user_quick2 IS NULL , user_quic
Help!
Dave
Failed to execute query: 'UPDATE gforum_User SET user_location_other IS ? , user_quick1 IS ? , user_quick2 IS ? , user_quick3 IS ? , user_mil_status = ? , user_occupation_other IS ? , user_email = ? , user_password = ? , user_message_notify = ? , user_real_name = ? , user_signature IS ? , user_default_reply_notify = ? , user_grade = ? , user_location = ? , user_accept_privmsg = ? , user_invisible = ? , user_state = ? , user_occupation = ? WHERE user_id = ?' Reason: 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 'IS NULL , user_quick1 IS NULL , user_quick2 IS NULL , user_quic
Help!
Dave