UPDATES EasyBlog 6.0.14 Released! Joomla 5.x and PHP 8.x compatible now!

Helpdesk

Your Time
Our Time
Response Time
24 — 48 hours
We strive to provide the fastest ever response possible. However, we are not super beings.

Allow at least 24 — 48 hours
  Support is offline
It is currently off working hours and most of us aren't around

Rest assured that we will get back to you as soon as the day starts tomorrow!
  Support is offline

Site down since migration

Jaymz Yates · ·
9:54 AM Sunday, 03 August 2014
None
Hello,

I moved my site from one host to another using akeba backup. Everything works except when a user logs in, They receive the following error, please advise.

1305 - FUNCTION c1txoedb.es_hasmutualfriend does not 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 ,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 `lhpn1_social_stream` AS a LEFT JOIN `lhpn1_social_locations` AS l ON a.`location_id` = l.`id` LEFT JOIN `lhpn1_social_moods` AS md ON a.`mood_id` = md.`id` INNER JOIN `lhpn1_users` AS uu ON a.`actor_id` = uu.`id` AND uu.`block` = 0 WHERE ( (a.`cluster_id`= 0) OR (a.`cluster_id` > 0 and a.`cluster_access` = 1) OR (a.`cluster_id` > 0 and a.`cluster_access` > 1 and 722 IN (select scn.`uid` from `lhpn1_social_clusters_nodes` as scn where scn.`cluster_id` = a.`cluster_id` and scn.`type` = 'user' and scn.`state` = 1) ) ) AND a.`context_type` NOT IN ('comments','users') AND ( (a.`access` = '0') OR ( (a.`access` = '10') AND (722 > 0 ) ) OR ( (a.`access` = '20') AND ( es_hasmutualfriend( a.`actor_id`, 722) > 0 OR es_isfriend( a.`actor_id`, 722) > 0 ) ) OR ( (a.`access` = '20') AND ( es_isfriend( a.`actor_id`, 722) > 0 ) ) OR ( (a.`access` = '30') AND ( es_isfriend( a.`actor_id`, 722) > 0 ) ) OR ( (a.`access` = '40') AND ( a.`actor_id` = 722 ) ) OR ( (a.`access` = '100') AND ( a.`custom_access` LIKE '%,722,%' ) ) OR (a.`actor_id` = 722) ) AND NOT EXISTS ( SELECT h.`uid` FROM `lhpn1_social_stream_hide` AS h WHERE a.`id`= h.`uid` AND h.`user_id`='722' AND h.`type`='stream' ) AND NOT EXISTS ( SELECT h1.`context` FROM `lhpn1_social_stream_hide` AS h1 WHERE a.`context_type` = h1.`context` AND h1.`user_id`='722' AND h1.`uid` = '0' AND h1.`actor_id` = '0' ) AND NOT EXISTS ( SELECT h2.`actor_id` FROM `lhpn1_social_stream_hide` AS h2 WHERE a.`actor_id`= h2.`actor_id` AND h2.`user_id`='722' AND h2.`uid` = '0' AND h2.`context` is null ) ORDER BY a.`modified` DESC LIMIT 0,5
The replies under this section are restricted to logged in users or users with an active subscription with us