Avatar problem

[Ryan McBain]

Ok Im trying to sort out my avatars on my page, when I go into my admincp it only shows that I have 23 avatars, but when you I look at the list of avatars on my board (http://www.ryanmcbain.com/forums) it shows much much more. Bottom line is I cant edit all my avatars cause they are not being shown when I go to my admincp. How come?

[Ryan McBain]

can anyone help?

[Mike Sullivan]

I'm guessing that a lot of your avatars aren't in a category (although they should be). What does this query return?

SELECT DISTINCT(imagecategoryid) FROM avatar;

Also, if you go to .../admincp/image.php?do=viewimages&table=avatar , does that show all your avatars?

[Ryan McBain]

If I go to http://www.ryanmcbain.com/forums/mis...do=showavatars then that shows all my avatars but when i go to my admincp all of them are not shown

[Mike Sullivan]

Yeah, I saw that before. But what about the query and by going to that URL manually (it's actually the "show all avatars" link)?

[Ryan McBain]

you kind of lost me, what do I need to do?

[Ryan McBain]

Ok ok when I go to admincp/image.php?do=viewimages&table=avatar all the avatars are shown, but when I go to the avatar manager all of them are not shown. There isnt a link to go to all of the avatars. How do I fix this?

[Mike Sullivan]

Right, as I suspected, most avatars aren't in a category. You can manually edit each of the offending avatars to put them in a category (a pain), or run a query to do so.

To run the query, you first need to find the appropriate imagecategoryid. This can be done by going into your CP and mousing over the link to the avatar category you want to move the avatars into.
The URL it points to should look something like this:

http://localhost/vb3/admincp/image.php?do=viewimages&table=avatar&imagecategoryid=3

The part that I bolded is the important part and it might be a different number for you.

The actual query you want to run is:

UPDATE avatar SET imagecategoryid = 3 WHERE imagecategoryid = 0;

Change the 3 appropriately if necessary.

Now, to run a query, you can go down to the
"execute SQL query" section (it's in "import & maintenence"). If you get an error when you go to that section, you need to add your userid to this line in config.php:

$canrunqueries = '';

Alternatively, you might have phpMyAdmin somewhere in your site's control panel (cPanel has it).