Hi, please help? Getting the error on a live site.
I'm getting this error after login:
1436
Error: 1436
Thread stack overrun: 12456 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack. 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 `jos_social_stream` AS a LEFT JOIN `jos_social_locations` AS l ON a.`location_id` = l.`id` LEFT JOIN `jos_social_moods` AS md ON a.`mood_id` = md.`id` INNER JOIN `jos_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 66 IN (select scn.`uid` from `jos_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 ('adsense','article','calendar','k2','kunena','blog','users') AND ( (a.`access` = '0') OR ( (a.`access` = '10') AND (66 > 0 ) ) OR ( (a.`access` = '20') AND ( es_hasmutualfriend( a.`actor_id`, 66) > 0 OR es_isfriend( a.`actor_id`, 66) > 0 ) ) OR ( (a.`access` = '20') AND ( es_isfriend( a.`actor_id`, 66) > 0 ) ) OR ( (a.`access` = '30') AND ( es_isfriend( a.`actor_id`, 66) > 0 ) ) OR ( (a.`access` = '40') AND ( a.`actor_id` = 66 ) ) OR ( (a.`access` = '100') AND ( a.`custom_access` LIKE '%,66,%' ) ) OR (a.`actor_id` = 66) ) AND NOT EXISTS ( SELECT h.`uid` FROM `jos_social_stream_hide` AS h WHERE a.`id`= h.`uid` AND h.`user_id`='66' AND h.`type`='stream' ) AND NOT EXISTS ( SELECT h1.`context` FROM `jos_social_stream_hide` AS h1 WHERE a.`context_type` = h1.`context` AND h1.`user_id`='66' AND h1.`uid` = '0' AND h1.`actor_id` = '0' ) AND NOT EXISTS ( SELECT h2.`actor_id` FROM `jos_social_stream_hide` AS h2 WHERE a.`actor_id`= h2.`actor_id` AND h2.`user_id`='66' AND h2.`uid` = '0' AND h2.`context` is null ) ORDER BY a.`modified` DESC LIMIT 0,10
I'm getting this error after login:
1436
Error: 1436
Thread stack overrun: 12456 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack. 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 `jos_social_stream` AS a LEFT JOIN `jos_social_locations` AS l ON a.`location_id` = l.`id` LEFT JOIN `jos_social_moods` AS md ON a.`mood_id` = md.`id` INNER JOIN `jos_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 66 IN (select scn.`uid` from `jos_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 ('adsense','article','calendar','k2','kunena','blog','users') AND ( (a.`access` = '0') OR ( (a.`access` = '10') AND (66 > 0 ) ) OR ( (a.`access` = '20') AND ( es_hasmutualfriend( a.`actor_id`, 66) > 0 OR es_isfriend( a.`actor_id`, 66) > 0 ) ) OR ( (a.`access` = '20') AND ( es_isfriend( a.`actor_id`, 66) > 0 ) ) OR ( (a.`access` = '30') AND ( es_isfriend( a.`actor_id`, 66) > 0 ) ) OR ( (a.`access` = '40') AND ( a.`actor_id` = 66 ) ) OR ( (a.`access` = '100') AND ( a.`custom_access` LIKE '%,66,%' ) ) OR (a.`actor_id` = 66) ) AND NOT EXISTS ( SELECT h.`uid` FROM `jos_social_stream_hide` AS h WHERE a.`id`= h.`uid` AND h.`user_id`='66' AND h.`type`='stream' ) AND NOT EXISTS ( SELECT h1.`context` FROM `jos_social_stream_hide` AS h1 WHERE a.`context_type` = h1.`context` AND h1.`user_id`='66' AND h1.`uid` = '0' AND h1.`actor_id` = '0' ) AND NOT EXISTS ( SELECT h2.`actor_id` FROM `jos_social_stream_hide` AS h2 WHERE a.`actor_id`= h2.`actor_id` AND h2.`user_id`='66' AND h2.`uid` = '0' AND h2.`context` is null ) ORDER BY a.`modified` DESC LIMIT 0,10