Hi there - it's me again! I'm trying to fix the corrupted data in my database from the wonderful (read SARCASM) folks at Arvixe, and I just want to make sure I'm looking at the right tables to remove corrupted data for newly registered users.

In investigating, I've found that a new registration hits the yaf_prov_membership table, the yaf_checkemail table and the yaf_users table. Does it hit any others? I know I'm going to have to manually delete the rows of data from the yaf_prov_membership table that does NOT exist in the yaf_users table and/or in the yaf_checkemail table. Are there any other tables that I need to remove corrupted data from for a new registration?

Thanks!

After deleting the data in the yaf_prov_membership table that was not in the yaf_users table and/or in the yaf_checkemail table, I had a user re-register, and it worked! So, hopefully there won't be any other errors with users after deleting extraneous data from the yaf_prov_members table.

If anyone else has this problem, just be sure that there are NO related rows in any of the 3 tables, and if there are, delete them all and have your user re-regsietr. It seems to work, so I am presuming that those 3 table are the only tables affected...