Can I do a DB operation to bring User Avatars across from old ES site?
By Andy on Thursday, 18 September 2014
Posted in Tips & Tricks (Not Supported)
Replies 3
Likes 0
Views 670
Votes 0
Hoping for some advise on whether I can salvage user avatars from an old ES installation or whether that's too problematic to consider.

My users are all the same with the same user ID's (I just wanted to start a fresh Joomla 3.3 site with a fresh beautiful ES install because my old site had been around since Joomla 1 days and had a lot of legacy clutter with it).

I'm comfortable doing basic DB / File operations and I'm hoping it's just a move of an avatars folder and perhaps a data import into a DB table.

If it's tricky I'll just start from scratch. Thanks for considering / any advice.
Hi,

It is possible especially since you mentioned that the user ids are the same but this can get a little bit tricky.

Folders that you need to move over are /media/com_easysocial/avatars and /media_com_easysocial/photos

DB tables that are required:

#__social_avatars, for type = 'user' and uid is the user id.
#__social_photos, for type = 'user' and uid is the user id.
#__social_photos_meta
#__social_albums, for type = 'user' and uid & user_id is the user id.
Jason Rey
·
Thursday, 18 September 2014 12:16
·
0 Likes
·
0 Votes
·
0 Comments
·
Great. Thanks for the advice Jason. I'll do it when I'm feeling brave!
Andy
·
Thursday, 18 September 2014 21:12
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Andy
Mark
·
Saturday, 20 September 2014 02:20
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post