Hi

Joomla 1.7.3
CB 1.7.1
CBsubs 1.2.2

I have read a number of forum posts relating to fatal errors caused by php memory limits and understand that the solution is to increase php memory. Most of these posts point to low php memory issues however mine is already set at 64mb and I keep getting fatal errors (example below) even though I have stripped down the site as much as possible even deleting the likes of Kunena (which I would really like to use).

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 491520 bytes) in <span>/</span>home<span>/</span>##########/modules/mod_cblogin/mod_cblogin.php on line 379

The latest error came after adding an auto action to amend a field value based on a country field.

I guess my question to yourselves is...

Is this a site problem or is it indeed common place to require a php memory limit in excess of 64mb?

If it is a site issue this may be caused by my installing then deleting a number of extensions during the dev process??? If it's a php memory issue what level would you advise as my current hosting company (shared server) refuses to increase the limit...?

I am more than happy to provide you with the site details should you wish to have a poke around.

I don't think the extensions loaded are excessive and my current functionality includes;

• CB and plugins
• CBsubs and plugins
• Groupjive and plugins
• Geocode factory (google maps)
• JCE editor
• SugaryCB for linking to CRM (although not set up)
• Multi Sites for creating child sites off the same db

I am on a wee bit of a deadline with this so any 'quick' advice would be appreciated.

Many thanks in advance

Robbie
YNWA

Hi Krileon

Whow...super speedy reply, many thanks.

I have completely deleted kunena so this is not the issue.

If I disable cb auto actions I do not get the error.

If auto actions is enabled I get the following error even though Multisites is disabled.

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 491520 bytes) in <span>/</span>home<span>/</span>##########/modules/mod_cblogin/mod_cblogin.php on line 379

If I disable Groupjive but keep Auto Actions on then I still get the error message.

Looking at this it seems that Auto Actions is the culprit...although when I first started getting error messages I there were no auto actions setup...?

I am up to date with my modules but will re-install CB Login 1.7.1

Debug and max error is on but that's all a bit beyond me...

Any ideas?

Robbie
YNWA

Hi Krileon

Update...

If I delete the auto action then I still get the error.

If I un-publish auto actions the error dissapears but I am not sure that auto actions is the cause. I think something is causing the site to use too much memory

Profile information from de-bug as follows...

Profile Information
Application 0.000 seconds (+0.000); 1.63 MB (+1.631) - afterLoad
Application 0.063 seconds (+0.063); 6.77 MB (+5.141) - afterInitialise
Application 0.138 seconds (+0.075); 16.34 MB (+9.567) - afterRoute
Application 0.481 seconds (+0.343); 55.17 MB (+38.833) - afterDispatch
Application 0.594 seconds (+0.113); 59.60 MB (+4.431) - beforeRenderModule mod_roknavmenu ()
Application 0.624 seconds (+0.030); 61.24 MB (+1.636) - afterRenderModule mod_roknavmenu ()
Application 0.658 seconds (+0.034); 61.23 MB (-0.014) - beforeRenderModule mod_cblogin (CB Login)
Application 0.665 seconds (+0.007); 61.25 MB (+0.024) - afterRenderModule mod_cblogin (CB Login)
Application 0.665 seconds (+0.000); 61.23 MB (-0.020) - beforeRenderModule mod_custom (fitnessconnexions.eu)
Application 0.677 seconds (+0.012); 62.12 MB (+0.894) - afterRenderModule mod_custom (fitnessconnexions.eu)
Application 0.677 seconds (+0.000); 62.12 MB (-0.003) - beforeRenderModule mod_custom (EREPS)
Application 0.678 seconds (+0.001); 62.13 MB (+0.005) - afterRenderModule mod_custom (EREPS)
Application 0.678 seconds (+0.000); 62.12 MB (-0.003) - beforeRenderModule mod_custom (EHFA-Standards)
Application 0.679 seconds (+0.001); 62.13 MB (+0.005) - afterRenderModule mod_custom (EHFA-Standards)
Application 0.679 seconds (+0.000); 62.13 MB (-0.002) - beforeRenderModule mod_languages (Select Your Language)
Application 0.693 seconds (+0.014); 62.82 MB (+0.689) - afterRenderModule mod_languages (Select Your Language)
Application 0.693 seconds (+0.000); 62.81 MB (-0.005) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.698 seconds (+0.004); 62.90 MB (+0.090) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.698 seconds (+0.000); 62.89 MB (-0.006) - beforeRenderModule mod_insertarticle (Insert Article)
Application 0.702 seconds (+0.004); 63.10 MB (+0.205) - afterRenderModule mod_insertarticle (Insert Article)
Application 0.709 seconds (+0.007); 63.18 MB (+0.085) - afterRender
Memory Usage
62.62 MB (65,660,352 Bytes)
49 Queries Logged

and this is where it works with auto actions turned off.

Will post the queries in a seperate post

Robbie
YNWA

Hi...

queries called at the point of clicking register...

SELECT `data`
FROM `master_session`
WHERE `session_id` = 'fb2c276520f265eed21c5109ea59dfe0'
SELECT folder AS type, element AS name, params
FROM master_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT *
FROM master_languages
WHERE published=1
ORDER BY ordering ASC
SELECT extension_id AS "id", element AS "option", params, enabled
FROM master_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM master_menu AS m
LEFT JOIN master_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT extension_id AS "id", element AS "option", params, enabled
FROM master_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT *
FROM `master_cbsubs_config`
WHERE `id` = '1'
SELECT a.*
FROM `master_cbsubs_plans` AS a
LEFT JOIN `master_cbsubs_plans` AS b
ON b.`id` = a.`parent`
WHERE a.published = 1
GROUP BY a.id
ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT m.`user_id`
FROM `master_cbsubs_subscriptions` AS m
WHERE m.`plan_id` = 1
AND m.`status` = 'A'
AND m.`expiry_date` < '2011-11-18 17:17:08'
AND m.`expiry_date` > '0000-00-00 00:00:00'
LIMIT 0, 10
SELECT extension_id AS "id", element AS "option", params, enabled
FROM master_extensions
WHERE `type` = 'component'
AND `element` = 'com_comprofiler'
SELECT id, home, template, s.params
FROM master_template_styles as s
LEFT JOIN master_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM master_comprofiler_plugin
WHERE published = 1
AND access <= 1
AND type = 'user'
ORDER BY ordering
SELECT *
FROM `master_comprofiler_plugin`
WHERE `element` = 'cbforums'
SELECT *
FROM `master_comprofiler_tabs`
WHERE `pluginid` = 533
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM master_comprofiler_plugin
WHERE published = 1
AND access <= 1
AND type = 'user/plug_cbgroupjive/plugins'
ORDER BY ordering
SELECT *
FROM `master_groupjive_plugin_auto`
WHERE ( `published` = 1 )
ORDER BY `ordering` ASC
SELECT *
FROM `master_comprofiler_plugin`
WHERE `element` = 'cbgroupjive'
SELECT *
FROM `master_comprofiler_tabs`
WHERE `pluginid` = 539
SELECT *
FROM `master_comprofiler_plugin`
WHERE `element` = 'cbblogs'
SELECT *
FROM `master_comprofiler_tabs`
WHERE `pluginid` = 529
SELECT c.*, u.*
FROM master_users AS u
LEFT JOIN master_comprofiler AS c
ON c.id = u.id
WHERE u.`username` = 'test'
LIMIT 0, 1
SELECT a.id
FROM master_user_usergroup_map AS map
LEFT JOIN master_usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 46
SELECT s.*
FROM master_cbsubs_subscriptions s
WHERE s.user_id = 46
AND s.status = 'R'
ORDER BY s.plan_id
SELECT a.*
FROM `master_cbsubs_plans` AS a
WHERE a.`id` = 1
SELECT b.*
FROM master_cbsubs_payment_baskets b, master_cbsubs_payment_items i, master_cbsubs_subscriptions s
WHERE b.id = i.payment_basket_id
AND i.subscription_id = s.id
AND s.user_id = 46
AND s.plan_id = 1
AND s.id = 1
AND b.user_id = s.user_id
AND b.payment_status = 'NotInitiated'
ORDER BY b.time_initiated DESC
LIMIT 0, 1
SELECT a.*
FROM `master_cbsubs_gateway_accounts` AS a
WHERE a.enabled > 0
AND a.owner = 0
ORDER BY a.`ordering` ASC
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM master_comprofiler_plugin
WHERE published = 1
AND access <= 1
AND type = 'user/plug_cbpaidsubscriptions/plugin'
ORDER BY ordering
SELECT *
FROM `master_cbsubs_payment_items` AS m
WHERE m.`payment_basket_id` = 1
ORDER BY m.`ordering`
SELECT *
FROM `master_cbsubs_payment_totalizers` AS m
WHERE m.`payment_basket_id` = 1
ORDER BY m.`ordering`
SELECT *
FROM `master_cbsubs_subscriptions`
WHERE `id` = '1'
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM master_comprofiler_plugin
WHERE published = 1
AND access <= 1
AND type = 'user/plug_cbpaidsubscriptions/plugin/cbsubstax/validations'
ORDER BY ordering
SELECT r.*, ru.short_code AS _rule_short_code
FROM `master_cbsubs_tax_rates` AS r JOIN `master_cbsubs_tax_rules` AS ru
ON ru.id = r.`tax_rule_id`
LEFT JOIN `master_cbsubs_geo_zones` AS b
ON b.id = r.`buyer_geo_zone_id`
LEFT JOIN `master_cbsubs_geo_zones` AS s
ON s.id = r.`seller_geo_zone_id`
WHERE r.`tax_rule_id` = 1
AND ( ( r.`buyer_geo_zone_id` = 0 ) OR ( SELECT COUNT(*)
FROM `master_cbsubs_geo_zones_entries` AS be
WHERE be.geo_zone_id = b.id
AND be.`country_iso_code2` = ''
AND ( be.`province_iso_code` = '' OR be.`province_iso_code` = '' )
AND ( be.`zip_code_condition` = 0 OR ( be.`zip_code_condition` = 1
AND '' REGEXP be.`zip_code_regexp` ) OR ( be.`zip_code_condition` = 2
AND be.`zip_code_min` <= 0
AND be.`zip_code_max` >= 0 ) ) ) > 0 )
AND ( ( r.`seller_geo_zone_id` = 0 ) OR ( SELECT COUNT(*)
FROM `master_cbsubs_geo_zones_entries` AS se
WHERE se.geo_zone_id = s.id
AND se.`country_iso_code2` = 'BE'
AND ( se.`province_iso_code` = '' OR se.`province_iso_code` = 'BE-BRU' )
AND ( se.`zip_code_condition` = 0 OR ( se.`zip_code_condition` = 1
AND 'B-1050' REGEXP se.`zip_code_regexp` ) OR ( se.`zip_code_condition` = 2
AND se.`zip_code_min` <= 0
AND se.`zip_code_max` >= 0 ) ) ) > 0 )
AND ( r.`tax_outside_of_country` >= 1 )
AND r.`published` = 1
AND r.`owner` = 0
GROUP by r.`id`
ORDER by r.`priority`, r.`ordering`
SELECT a.`country_iso_code2` AS `value`, a.`country_name` AS `text`
FROM `master_comprofiler_countries` AS a
ORDER BY a.`country_name` ASC
SELECT id
FROM master_menu
WHERE link = 'index.php?option=com_comprofiler'
AND published=1
AND access <= 1
SELECT *
FROM `master_cbsubs_promotions` AS m
WHERE m.`published` = 1
ORDER BY m.`priority`, m.`ordering`
SELECT DISTINCT `position`
FROM master_modules
WHERE `client_id` = 0
AND `position` <> ''
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM master_modules AS m
LEFT JOIN master_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN master_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2011-12-02 17:17:08')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-12-02 17:17:08')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 531 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.ordering
SELECT id, home, template, params
FROM master_template_styles
WHERE client_id = 0
SELECT id, home, template, params
FROM master_template_styles
WHERE client_id = 0
SELECT id, home, template, params
FROM master_template_styles
WHERE client_id = 0
SELECT id, home, template, params
FROM master_template_styles
WHERE client_id = 0
SELECT template
FROM master_template_styles
WHERE home = 1
AND client_id = 0
SELECT extension_id AS "id", element AS "option", params, enabled
FROM master_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT id
FROM master_menu
WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
AND published=1
AND access <= 1
SELECT id,language
FROM `master_menu`
WHERE home=1
SELECT m2.language, m2.id
FROM master_menu as m
LEFT JOIN master_associations as a
ON a.id=m.id
AND a.context='com_menus.item'
LEFT JOIN master_associations as a2
ON a.key=a2.key
LEFT JOIN master_menu as m2
ON a2.id=m2.id
WHERE m.id=531
select *
FROM master_content
WHERE id =78
AND state=1
SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
FROM master_categories as c
LEFT JOIN master_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM master_categories AS cat JOIN master_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=2
AND badcats.id is null
AND (c.id=s.id OR c.language in ('en-GB','*'))
GROUP BY c.id
ORDER BY c.lft
UPDATE `master_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:14;s:19:\"session.timer.start\";i:1322845113;s:18:\"session.timer.last\";i:1322846208;s:17:\"session.timer.now\";i:1322846228;s:22:\"session.client.browser\";s:67:\"Mozilla/5.0 (Windows NT 6.1; rv:8.0.1) Gecko/20100101 Firefox/8.0.1\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}', `time` = 1322846228
WHERE `session_id` = 'fb2c276520f265eed21c5109ea59dfe0'

35 Query Types Logged, Sorted by Occurrences.
SELECT Tables:

4 × SELECT id, home, template, params FROM master_template_styles
4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM master_extensions
4 × SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name FROM master_comprofiler_plugin
3 × SELECT * FROM `master_comprofiler_tabs`
3 × SELECT * FROM `master_comprofiler_plugin`
2 × SELECT id FROM master_menu
1 × SELECT * FROM `master_cbsubs_promotions` AS m
1 × SELECT a.`country_iso_code2` AS `value`, a.`country_name` AS `text` FROM `master_comprofiler_countries` AS a
1 × SELECT r.*, ru.short_code AS _rule_short_code FROM `master_cbsubs_tax_rates` AS r JOIN `master_cbsubs_tax_rules` AS ru ON ru.id = r.`tax_rule_id` LEFT JOIN `master_cbsubs_geo_zones` AS b ON b.id = r.`buyer_geo_zone_id` LEFT JOIN `master_cbsubs_geo_zones` AS s ON s.id = r.`seller_geo_zone_id`
1 × SELECT * FROM `master_cbsubs_payment_totalizers` AS m
1 × SELECT * FROM `master_cbsubs_subscriptions`
1 × SELECT DISTINCT `position` FROM master_modules
1 × SELECT m2.language, m2.id FROM master_menu as m LEFT JOIN master_associations as a ON a.id=m.id AND a.context='com_menus.item' LEFT JOIN master_associations as a2 ON a.key=a2.key LEFT JOIN master_menu as m2 ON a2.id=m2.id
1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM master_categories as c LEFT JOIN master_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM master_categories AS cat JOIN master_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT template FROM master_template_styles
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM master_modules AS m LEFT JOIN master_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN master_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT * FROM `master_cbsubs_payment_items` AS m
1 × select * FROM master_content
1 × SELECT id,language FROM `master_menu`
1 × SELECT a.* FROM `master_cbsubs_plans` AS a
1 × SELECT a.* FROM `master_cbsubs_plans` AS a LEFT JOIN `master_cbsubs_plans` AS b ON b.`id` = a.`parent`
1 × SELECT m.`user_id` FROM `master_cbsubs_subscriptions` AS m
1 × SELECT * FROM `master_cbsubs_config`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM master_menu AS m LEFT JOIN master_extensions AS e ON m.component_id = e.extension_id
1 × SELECT folder AS type, element AS name, params FROM master_extensions
1 × SELECT * FROM master_languages
1 × SELECT id, home, template, s.params FROM master_template_styles as s LEFT JOIN master_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT * FROM `master_groupjive_plugin_auto`
1 × SELECT `data` FROM `master_session`
1 × SELECT b.* FROM master_cbsubs_payment_baskets b, master_cbsubs_payment_items i, master_cbsubs_subscriptions s
1 × SELECT s.* FROM master_cbsubs_subscriptions s
1 × SELECT a.id FROM master_user_usergroup_map AS map LEFT JOIN master_usergroups AS a ON a.id = map.group_id
1 × SELECT c.*, u.* FROM master_users AS u LEFT JOIN master_comprofiler AS c ON c.id = u.id
1 × SELECT a.* FROM `master_cbsubs_gateway_accounts` AS a

OTHER Tables:

1 × UPDATE `master_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:14;s:19:\"session.timer.start\";i:1322845113;s:18:\"session.timer.last\";i:1322846208;s:17:\"session.timer.now\";i:1322846228;s:22:\"session.client.browser\";s:67:\"Mozilla/5.0 (Windows NT 6.1; rv:8.0.1) Gecko/20100101 Firefox/8.0.1\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}', `time` = 1322846228