Hello Team,

CB Subs is behaving weird. No idea what it could be only that its now showing this messages:

administrator/index.php?option=com_comprofiler&task=showusers

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/vision11/public_html/libraries/joomla/database/database/mysql.php on line 500
Out of memory (Needed 8388580 bytes) SQL=SELECT COUNT(DISTINCT u.id) FROM iav_users AS u LEFT JOIN iav_comprofiler AS ue ON u.id = ue.id INNER JOIN iav_user_usergroup_map AS aro ON aro.user_id = u.id INNER JOIN iav_usergroups AS g ON g.id = aro.group_id
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/vision11/public_html/libraries/joomla/database/database/mysql.php on line 500
DB function failed with error number 5
Out of memory (Needed 8388482 bytes) SQL=SELECT u.*, GROUP_CONCAT( DISTINCT g.title ORDER BY g.title SEPARATOR ', ') AS groupname, ue.approved, ue.confirmed, ue.cbactivation FROM iav_users AS u LEFT JOIN iav_comprofiler AS ue ON u.id = ue.id INNER JOIN iav_user_usergroup_map AS aro ON aro.user_id = u.id INNER JOIN iav_usergroups AS g ON g.id = aro.group_id GROUP BY u.id LIMIT 0, 20

administrator/index.php?option=com_comprofiler&task=editPlugin&cid=516&action=showtable&table=plans

Notice: SQLXML::queryObjectList: error: Out of memory (Needed 8388580 bytes) SQL=SELECT a.`id`, a.`name`, a.`alias`, a.`exclusive`, a.`rate`, a.`validity`, IF( ( a.`recurring_max_times` = 0 ), 'unlimited', a.`recurring_max_times` ) AS `recurring_max`, a.`first_rate`, a.`first_validity`, a.`ordering`, a.`published`, a.`allow_newsubscriptions`, a.`allow_registration`, a.`allow_upgrade_to_this`, a.`access`, a.`default`, a.`usergroup`, IF( ( a.`owner` = 0 ), 'System', c.`username` ) AS `owner_name`, ( SELECT COUNT( DISTINCT d.`id` ) AS `change_logs` FROM `iav_cbsubs_history` AS d WHERE ( d.`table_name` = '#__cbsubs_plans' ) AND ( d.`table_key_id` = a.`id` ) ) AS `change_logs`, ( SELECT COUNT( DISTINCT e.`id` ) AS `subscribers` FROM `iav_cbsubs_subscriptions` AS e WHERE ( e.`plan_id` = a.`id` ) ) AS `subscribers`, a.`currency`, a.`cssclass`, a.`description`, b.`id` AS `parent` FROM `iav_cbsubs_plans` AS a LEFT JOIN `iav_cbsubs_plans` AS b ON b.`id` = a.`parent` LEFT JOIN `iav_users` AS c ON c.`id` = a.`owner` ORDE in /home/vision11/public_html/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.sql.php on line 350

administrator/index.php?option=com_users&view=users

Out of memory (Needed 8388580 bytes) SQL=SELECT a.id AS value, a.title AS text, COUNT(DISTINCT b.id) AS level FROM iav_usergroups AS a LEFT JOIN `iav_usergroups` AS b ON a.lft > b.lft AND a.rgt < b.rgt GROUP BY a.id ORDER BY a.lft ASC

Sorry;

joomla 1.7
cb 1.7
cbsubs 1.2.2