Reupload, avatar issues.

[ComputerVitals]

I had to reupload my forum.
restore the database. I now have avatar problems.

all the pics are there but the links are bad.
Example:
my avatar: avatar1_12.gif
But after the restore it's trying to use avatar1_13.gif

It seems everyone that has an avatar is off by 1 number. If they have avatar112_23 the forum is pointing to avatar112_24

How do I fix this?

[Steve Machol]

That definitely should have have happened if you restored a clean backup of the files and database. What did you do exactly? Do you still have those backups?

[ComputerVitals]

The server I was on was migrating, I missed the email that was sent out.
I switched DNS at the domain. But all my files were old.

I have a backup of the files from Jan 5th from when I upgraded to 3.8.0
And a database backup from Jan 14th.

I uploaded my files, and imported the database backup. All went smooth and the forum came back online. I thought everything was fine, but I was notified that the avatars are not showing.

This is why I seen that it seems my vB installation has all avatars off by 1 number.

Where in the database are the avatar information stored? BTW all images are file stored and not stored in the database.

[Steve Machol]

So the files are from a different date than the database? If so, that is the problem.
The backups you restore must be from the same time.

[ComputerVitals]

Thats one thing I dont have.

But I did find that in the database,
vb_user

In each user profile,

avatarrevision

My avatarrevision was set to 13
I changed that to 12 and my avatar is back.
Is there a quick and easy way to run a SQL command to drop that number by 1 digit if a person uses a custom avatar?

[ComputerVitals]

So I almost figured out how to fix this.

If I enter phpmyadmin and run

UPDATE vb_user SET avatarrevision = avatarrevision -1

but the users that are set at 0 are changed to 4294967295
I need the 0 to stay 0

any ideas?


EDIT:

I fixed my avatars by running 2 sql commands. It took me a while of trial and error on my test database, but I got them changed by running 2 commands.

UPDATE vb_user SET avatarrevision = avatarrevision -1
UPDATE vb_user SET avatarrevision = 0 WHERE avatarrevision=4294967295