View Single Post
  #5 (permalink)  
Old 07-09-2007, 12:21 AM
betagirl betagirl is offline
Pligg Donor
 
Join Date: Mar 2007
Posts: 85
Thanks: 16
Thanked 16 Times in 10 Posts
Quote:
Originally Posted by betagirl View Post
I'm getting this same error. I removed all comments, votes, links and then the users from the table (all were faux data). Then I get this error for 3 users (God, and two others) when trying to access the profiles for each:

invalid username or userid in get_avatar

I also then went into the friends table, to update (remove) any ids associated with deleted users. I still get the error.

I also emptied the cache.

I'd rather not repopulate the database with bad data. Is there another fix for this? Can anyone tell me where the code that generates the error is so I can check the SQL statment?

Thanks!
OK, not sure what I did that, but instead of restoring the database, I went through every table and deleted any reference to a user_id that I had deleted. That seemed to fix it. (so in addition to the above tables, I removed any records referring to deleted users in trackbacks, friends and pageviews).

Profile pages work fine now.
Reply With Quote
The Following User Says Thank You to betagirl For This Useful Post: