PhotoPost Community - View Single Post - Update the database after a user has changed user name?

marit · June 16th, 2006, 07:50 AM

I have just moved my forum from phpBB2 to vB, and I'm about to switch my gallery integration. I remembered that some of my users have changed username in the last year, and the photos they uploaded before the change was made, still has their old username (the userID is correct - no problems there, but the old photos are still displayed with the old username). Will this cause a problem when I run the userfix to assign the photos to the correct user in the vb table? I can go into phpMyAdmin and to it manually, but a couple of the users have appx 300 pics each with their first username, so it would be great if there was a query I could run to change the names to their current one in the photos and comment tables.

Thanks!

~Marit

June 16th, 2006, 07:50 AM	#1 (permalink)
marit Member Join Date: Jan 2005 Location: Norway Posts: 56	Update the database after a user has changed user name? I have just moved my forum from phpBB2 to vB, and I'm about to switch my gallery integration. I remembered that some of my users have changed username in the last year, and the photos they uploaded before the change was made, still has their old username (the userID is correct - no problems there, but the old photos are still displayed with the old username). Will this cause a problem when I run the userfix to assign the photos to the correct user in the vb table? I can go into phpMyAdmin and to it manually, but a couple of the users have appx 300 pics each with their first username, so it would be great if there was a query I could run to change the names to their current one in the photos and comment tables. Thanks! ~Marit