Our site www.viart.com site is operated by latest Viart Shop 5 with default Clear design
Topic Information
Vera
Vera
Description
If you delete a user, their entries in the va_users_properties table are not deleted.
 
Solution
http://www.viart.com/downloads/admin_user-4.2.zip
 
Download the file above and extract 'admin_user.php' in /admin folder of your shop replacing existing file. Please do not forget to make a backup copy of the current file in case something goes wrong.
 
To delete properties of already deleted users you can run the following query in Tools > DB Management > Run SQL Query:
delete from va_users_properties where user_id not in (select user_id from va_users)