Hello Goodwin,

First of all, you need to transfer the data for your Joomla table jos_users and also all the tables with the prefix jos_social_ to your new site. You can export the tables using phpMyAdmin and import the data into your new site.

Once you have the data moved to your new site. Install EasySocial at your new site.

Next, you will need to copy all the photos from your old site to your new site. By default the folder for your EasySocial photos are at

JOOMLA/media/com_easysocial/avatars
JOOMLA/media/com_easysocial/badges
JOOMLA/media/com_easysocial/photos
JOOMLA/media/com_easysocial/defaults

You need to copy the contents ( including subfolders ) to your new site.

Hope this help.

OK sam thanks. let me do that. if i encounter any problem i will let you know

Hi Goodwin,

Sure, do let us know how it goes
Have a nice day!

hi sam
i have done all the instruction you gave me to do ans the home page is opening up well but when i try to login am geting this error i hav posted below:

---------------------------------------------------------------------------------------------------------------------------------------------
1054 Unknown column 'e.completed_fields' in 'field list' SQL=SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`completed_fields`,`e`.`permalink`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` FROM `uxc0b_users` AS `a` LEFT JOIN `uxc0b_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `uxc0b_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `uxc0b_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `uxc0b_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `uxc0b_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` IN ('441', '374', '458', '411', '409', '447', '432') GROUP BY `a`.`id`
---------------------------------------------------------------------------------------------------------------------------------------------

can you please help. my new subdomain is test.mzansisocial.co.za

on the phpmyadmin i was coping tables from mzansi_mzansi adding them to mzansi_joom

Hi Goodwin,

I am sorry for the delay of this reply.

I cant login to your Joomla backend with the access you provided. Anyway, regarding your issue, it seems like your EasySocial tables is missing some columns. Can you try this.

Go to your EasySocial backend under Maintenance -> database and click on the 'start' button to run the db update scripts. Please see
http://screen.stackideas.com/2014-11-11_1951.png

Let me know if the above fix your issue or not.
Hope this help and have a nice day

hi sam
am having an issue. i have managed to move everyhting like you instructed but now when a user wants to login they cant. this is what is coming

Warning
You cannot access the private section of this site.

Hi Goodwin,

Em, regarding your issue, try move this Joomla table from your old site into your new site and see if that helps or not.

jos_assets

I advise you to backup your database from your new site first before you bring the data from jos_assets into your new site.

Once you've backup your db in your new site, clear the data in db table jos_assets and import the data from your old site the same db table.

Let me know if the above work fix your issue or not.

ok let me try that

Sure, let me know how it goes, Goodwin.

hey sam i tried to replace the jos_assets and it now fully started even rejecting the admin login so i have put back the one which was there

Hi Goodwin,

Okay, I've checked your new site the table #__user_usergroup_map and there are only two records. You will need to copy the records from your old site to your new site as well.

You might want to clear the records of this table in your new site first before you import the data from your old site. Always make backup before you run any data import operation incase something bad happen and you can still able to revert the data back to it original state.

Hope this help and have a nice day!