1054 - Unknown column 'Array' in 'where clause' SQL=SELECT COUNT(1) FROM (SELECT `user_id` FROM `#__community_fields_values` AS a INNER JOIN `#__community_users` AS b ON a.`user_id` = b.`userid` WHERE a.`value`=Array AND a.`field_id`='1' AND ((b.`profile_id` = '0') OR (b.`userid` IN ( SELECT d.`userid` FROM `#__community_profiles_fields` as c INNER JOIN `#__community_users` AS d ON c.`parent`=d.`profile_id` AND c.`field_id`='1'))) AND( (a.`access` = '0' OR a.`access` = '10') OR (a.`access` = '20' AND '0'!='0' ) OR (a.`access` = '30' AND a.`user_id` IN ( SELECT c.`connect_to` FROM `#__community_connection` AS c WHERE c.`connect_from`='0' AND c.`status`='1')) OR (a.`access` = '40' AND a.`user_id`='0'))) AS z

The requested page can't be found.

An error has occurred while processing your request.

You may not be able to visit this page because of:

  • an out-of-date bookmark/favourite
  • a mistyped address
  • a search engine that has an out-of-date listing for this site
  • you have no access to this page

If difficulties persist, please contact the System Administrator of this site and report the error below.

#1054 Unknown column 'Array' in 'where clause' SQL=SELECT COUNT(1) FROM (SELECT `user_id` FROM `#__community_fields_values` AS a INNER JOIN `#__community_users` AS b ON a.`user_id` = b.`userid` WHERE a.`value`=Array AND a.`field_id`='1' AND ((b.`profile_id` = '0') OR (b.`userid` IN ( SELECT d.`userid` FROM `#__community_profiles_fields` as c INNER JOIN `#__community_users` AS d ON c.`parent`=d.`profile_id` AND c.`field_id`='1'))) AND( (a.`access` = '0' OR a.`access` = '10') OR (a.`access` = '20' AND '0'!='0' ) OR (a.`access` = '30' AND a.`user_id` IN ( SELECT c.`connect_to` FROM `#__community_connection` AS c WHERE c.`connect_from`='0' AND c.`status`='1')) OR (a.`access` = '40' AND a.`user_id`='0'))) AS z