Announcement

Collapse
No announcement yet.

Reupload, avatar issues.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Reupload, avatar issues.

    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?

  • #2
    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?
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      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.

      Comment


      • #4
        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.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          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?

          Comment


          • #6
            So I almost figured out how to fix this.

            If I enter phpmyadmin and run
            Code:
            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.
            Code:
            UPDATE vb_user SET avatarrevision = avatarrevision -1
            UPDATE vb_user SET avatarrevision = 0 WHERE avatarrevision=4294967295
            Last edited by ComputerVitals; Mon 19 Jan '09, 8:23pm.

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...
            X