Hello,
I purchased EasySocial component with LT Social Company template from L.Theme.
I contacted them with the issue that I got and they said that I need to contact your company directly and go to support forum. I created the account but it still won't give me a permission to post a support ticket, so this is the only way to communicate with you at this point.
Here is my problem:
I had to move the site to a different server and I did Joomla upgrade to version 3.4.3
Not sure if that is what caused the problem, but this is what I get:
in Admin when I click on EasySocial in Components tab:
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 `hpj92_users` AS `a` LEFT JOIN `hpj92_social_avatars` AS `b` ON `b`.`uid` = `a`.`id` AND `b`.`type` = 'user' LEFT JOIN `hpj92_social_profiles_maps` AS `d` ON `d`.`user_id` = `a`.`id` LEFT JOIN `hpj92_social_users` AS `e` ON `e`.`user_id` = `a`.`id` LEFT JOIN `hpj92_social_covers` AS `f` ON `f`.`uid` = `a`.`id` AND `f`.`type` = 'user' LEFT JOIN `hpj92_social_points_history` AS `g` ON `g`.`user_id` = `a`.`id` WHERE `a`.`id` = '280' GROUP BY `a`.`id`
And this is what I get in the FrontEnd (
suleyera.com/index.php/club-suley/suley-elite.html
):
1146
Table 'qline2_sera_db.hpj92_social_stream_sticky' doesn't exist SQL=SELECT a.* , l.id as loc_id, l.uid as loc_uid, l.type as loc_type, l.user_id as loc_user_id, l.created as loc_created, l.short_address as loc_short_address ,l.address as loc_address, l.longitude as loc_longitude, l.latitude as loc_latitude, l.params as loc_params ,md.id as md_id, md.namespace as md_namespace,md.namespace_uid as md_namespace_uid, md.icon as md_icon, md.verb as md_verb, md.subject as md_subject, md.custom as md_custom ,md.text as md_text, md.user_id as md_user_id, md.created as md_created, ssk.id as sticky ,0 as bookmarked ,FLOOR( ( UNIX_TIMESTAMP( now() ) - UNIX_TIMESTAMP( a.`modified`) ) / 60 ) AS `min` ,FLOOR( ( UNIX_TIMESTAMP( now() ) - UNIX_TIMESTAMP( a.`modified`) ) / 60 / 60 ) AS `hour` ,FLOOR( ( UNIX_TIMESTAMP( now() ) - UNIX_TIMESTAMP( a.`modified`) ) / 60 / 60 / 24 ) AS `day` FROM `hpj92_social_stream` AS a LEFT JOIN `hpj92_social_locations` AS l ON a.`location_id` = l.`id` LEFT JOIN `hpj92_social_moods` AS md ON a.`mood_id` = md.`id` LEFT JOIN `hpj92_social_stream_sticky` AS ssk ON a.`id` = ssk.`stream_id` WHERE a.`state` = 1 AND ( (a.`cluster_id`= 0) OR (a.`cluster_id` > 0 and a.`cluster_access` = 1) ) AND a.`context_type` NOT IN ('users') AND a.`access` = '0' ORDER BY a.`modified` DESC LIMIT 0,11
I believe that I need to reinstall the component and upgrade it to be compatible with Joomla 3.4.3, but L.Theme did not supply the component separate from the quickstart package.
I need to fix it ASAP because I cannot continue to develop the site any further.
My site URL:
suleyera.com
EasySocial link:
suleyera.com/index.php/club-suley/suley-elite.html
Thank you in advance for your help.
