god/admin profile problem

[bichopro]

only to id user 1 (Admin/god)

when i try to click in my own profile the database send me this message

Warning: Invalid argument supplied for foreach() in /home/wi180055/public_html/beta/libs/utils.php on line 406
invalid username or userid in get_avatar

the four line is the 406 - begin with foreach...

PHP Code:

// using this because i'm not sure if (array)$user will work in php 4
    // i'm not sure if we even need all this but it makes my code work 
    $array = array();
    foreach ($result as $key=>$value) {
        if (is_object($value)) {
            $array[$key]=object_2_array($value);
        }
        elseif (is_array($value)) {
            $array[$key]=object_2_array($value);
        }
        else {
            $array[$key]=$value;
        }
    }
    return $array;
} 

function phpnum() { 


any solution?

I use 9.5 with the login patch (2) and this is so rare because i don't touch the database.
sorry my so bad inglish

Update: all user profile in my site is good, but when a user try to watch my profel (user id 1 god admin) see the error

[bichopro]

this user have same problem when click in second page from the popular page

I've got a strange error

[bichopro]

i try the solution of this user but nothing happens

Can help me please?

[betagirl]

Originally Posted by bichopro

i try the solution of this user but nothing happens

Can help me please?

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!

[betagirl]

Originally Posted by betagirl

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.

[ryanshyper]

betagirl - i had the same problem after using a modified killspam - this took care of it -thank you.

[tbones]

Modified killspam is here: Spamkill? More like Spambruise

[ryanshyper]

FYI - I was also receiving a 406 error when reading private messages because they were coming from user 1 (god) in the welcome_privmsg_main and I had deleted him. After switching this value to antoher user it was resolved.

[tbones]

This was your only problem with the modified killspam? Then I will try it.

[ryanshyper]

I was basically getting a 406 when I went to some of the user profiles. I had to remove any references to the deleted users in every table they were referenced in the database. The reference to the welcome_privmsg_main may is only relevant if you killspam God.