View Full Version : Notify and Favorites not in sync after upgrade
September 23rd, 2008, 09:49 AM
Ok, I ran the userfix to sync the photos and comments.
Is there a fix for the Notify and Favorites file that I can run as well?
September 23rd, 2008, 06:08 PM
Albums and buddies are out of sync as well.
September 23rd, 2008, 06:15 PM
There are no fixes that I am aware of since the application is not designed to be really switched as far as integrations.
I would not even know how to fix albums at this point because the categories table has an old userid and at this point I would not know who would be the old userid.
what we did on photos and comments was grab a new userid based on a username. The favorites and albums are done via a userid not username.
If you have a backup of old photos and comments tables I may be able to try and write a different script but that might take a little while as I would need to somehow work on creating a new field on the photos table say olduserid and pull names from that.
September 23rd, 2008, 06:21 PM
That's pretty much what I was thinking after reviewing the files, etc. I'm just going to clear the fav, notify, buddies files and remove the albums and let them start from scratch. Thanks anyway.
September 23rd, 2008, 06:26 PM
Not a problem.
September 23rd, 2008, 06:37 PM
Is this all I need to run to bulk delete all the albums or are there other files/fields that need to be cleaned up?
delete FROM `categories` WHERE `catorder` = 9999
September 23rd, 2008, 06:49 PM
No you need to delete albums from the manage albums function in admin.
September 23rd, 2008, 06:50 PM
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.