and my site is really slow!
SO tell me is this normal
thanks guys
and my site is really slow!
SO tell me is this normal
thanks guys
SELECT b.`id` FROM ( SELECT action.`id`, action.`entityId`, action.`entityType`, action.`pluginKey`, action.`data`, activity.timeStamp FROM ow_newsfeed_action action INNER JOIN ow_newsfeed_activity activity ON action.id = activity.actionId INNER JOIN `ow_newsfeed_action_set` cactivity ON action.id = cactivity.actionId INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `cactivity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id` LEFT JOIN `ow_base_user_disapprove` base_user_approve_table_alias ON base_user_approve_table_alias.`userId` = `base_user_table_alias`.`id` INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId LEFT JOIN ow_newsfeed_follow follow ON action_feed.feedId = follow.feedId AND action_feed.feedType = follow.feedType WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND (`base_user_approve_table_alias`.`id` IS NULL) AND (`base_user_table_alias`.`emailVerify` = 1) AND cactivity.userId = :u AND activity.status=:s AND activity.timeStamp<:st AND ( ( follow.userId=:u AND activity.visibility & :vf ) ) UNION SELECT action.`id`, action.`entityId`, action.`entityType`, action.`pluginKey`, action.`data`, activity.timeStamp FROM ow_newsfeed_action action INNER JOIN ow_newsfeed_activity activity ON action.id = activity.actionId INNER JOIN `ow_newsfeed_action_set` cactivity ON action.id = cactivity.actionId INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `cactivity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id` LEFT JOIN `ow_base_user_disapprove` base_user_approve_table_alias ON base_user_approve_table_alias.`userId` = `base_user_table_alias`.`id` WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND (`base_user_approve_table_alias`.`id` IS NULL) AND (`base_user_table_alias`.`emailVerify` = 1) AND cactivity.userId = :u AND activity.status=:s AND activity.timeStamp<:st AND ( ( activity.userId=:u AND activity.visibility & :va ) ) UNION SELECT action.`id`, action.`entityId`, action.`entityType`, action.`pluginKey`, action.`data`, activity.timeStamp FROM ow_newsfeed_action action INNER JOIN ow_newsfeed_activity activity ON action.id = activity.actionId INNER JOIN `ow_newsfeed_action_set` cactivity ON action.id = cactivity.actionId INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `cactivity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id` LEFT JOIN `ow_base_user_disapprove` base_user_approve_table_alias ON base_user_approve_table_alias.`userId` = `base_user_table_alias`.`id` INNER JOIN ow_newsfeed_action_feed action_feed ON activity.id=action_feed.activityId WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND (`base_user_approve_table_alias`.`id` IS NULL) AND (`base_user_table_alias`.`emailVerify` = 1) AND cactivity.userId = :u AND activity.status=:s AND activity.timeStamp<:st AND ( ( action_feed.feedId=:u AND action_feed.feedType="user" AND activity.visibility & :vfeed ) ) UNION SELECT action.`id`, action.`entityId`, action.`entityType`, action.`pluginKey`, action.`data`, activity.timeStamp FROM ow_newsfeed_action action INNER JOIN ow_newsfeed_activity activity ON action.id = activity.actionId INNER JOIN `ow_newsfeed_action_set` cactivity ON action.id = cactivity.actionId INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `cactivity`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id` LEFT JOIN `ow_base_user_disapprove` base_user_approve_table_alias ON base_user_approve_table_alias.`userId` = `base_user_table_alias`.`id` INNER JOIN ow_newsfeed_activity subscribe ON activity.actionId=subscribe.actionId and subscribe.activityType=:as AND subscribe.userId=:u WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND (`base_user_approve_table_alias`.`id` IS NULL) AND (`base_user_table_alias`.`emailVerify` = 1) AND cactivity.userId = :u AND activity.status=:s AND activity.timeStamp<:st ) b GROUP BY b.`id` ORDER BY MAX(b.timeStamp) DESC LIMIT 0, 5
this issue has been already reported to our devs, but the actions necessary to fix that requires refactoring of the newsfeed code and it's querys it's a lot of work, please be patient, it will be fixed in the nearest future.
And is this related to 1.8.1 or also to 1.8 ?
You can try more powerful server for now, that's all I can recommend you.
Thanks ross.
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@theotherbook.nl and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.
Apache/2.2.31 (Unix) mod_ssl/2.2.31 OpenSSL/1.0.1e-fips mod_bwlimited/1.4 mod_fcgid/2.3.9 Server at theotherbook.com Port 443but the error you get is related to the server, you need to contact your hosting provider to resolve it.
your cron works fine, the job NEWSFEED_Cron::deleteActionSet ran today Mon, 07 Mar 2016 06:15:02 GMT