avatars gone again!

[betterthanyours]

Hi...wondering is anyone can help

My avatars seem to have disappeared again since moving to a VPS from shared hosting...

I checked Avatars > User Picture Storage Type and made sure the paths were correct they are all ./customavatars ./customprofilepics and ./signaturepic

How can i resolve this? All the avatars seem to be in the correct directory and the avatar link (right click on avatar place and image link) shows the server is pointing to the correct folder...

Uploading new avatars works and the new avatars upload to the correct folder.

[snakes1100]

1. View the source for one of the missing images.

2. Get the broken images name.

3. SSH into the VPS

4. Run this cmd "updatedb"

5. Run this cmd "find / -name imagenamefrompreviouscmd.gif -print

What is the result of the find cmd?

If it returns no results, then the image never got moved over & is lost unless you had a backup of it, if its a missing thumb, rebuild the thumbs via admincp maintenance options.

The folder path in the admincp dont mean sh*t unless the image actually exists on the server.

[betterthanyours]

I've found what the issue is...

The avatars for some reason are pointing at the incorrect URL
eg:
http://www.unrealkillers.com/customavatars/avatar46_21.gif

but it should be
http://www.unrealkillers.com/customavatars/avatar46_23.gif


Note: the difference is avatar46_21.gif = incorrect 46_23.gif=correct

I've found it to be consistent each avatar is -2 less what it should be. How can I change it to be +2 than it currently is?

I have rebuilt the custom avatars and thumbs

--------------- Added 1348398992 at 1348398992 ---------------

Bump....anyone?

[betterthanyours]

Any ideas anybody?

[ForceHSS]

delete them all reupload them or rename them

[betterthanyours]

Was hoping I could avoid that...lol there's hundreds of them. Is there no way of automating it ?

[Lynne]

Something like:

UPDATE tablename SET field=field+2

(I can't get to my phpMyAdmin at the time to check out the tablename or field name)

And, of course, TRY THIS ON YOUR TEST SITE FIRST and be sure to MAKE A BACKUP OF YOUR LIVE SITE before doing that query.

[betterthanyours]

I tried the command prescribed, no worky.

I also tried UPDATE CUSTOMAVATAR SET WHERE FILENAME=FILENAME+2

Still no worky.

[Lynne]

That is not going to work as it is not the customavatar table you need to change. I believe it is the user table and the field is avatarrevision. Please take a look at your actual database and that field and compare it to what you are seeing on the site and verify that equation will work for what you are seeing.