User Management tab not loading

The User Management tab in the backend has just started hanging rather than loading. The backend menu URL is www.test2.sag.org.au/administrator/index.php?option=com_comprofiler&task=showusers&view=showusers .

The CB version is 1.9.1 with Joomla version 2.5.14. Could something in the recent CB update have triggered this change in behaviour? Any other suggestions as to a fix? Other backend CB and CBS tabs appear to open fine.

I have been editing permissions for some user groups but the problem I am facing now occurs even with super admin users.

The User Management tab in the backend has just started hanging rather than loading.

Let it sit for a few minutes and see if it ever loads. If still not loading disable CB plugins 1 by 1 within CB > Plugin Management until issue goes away. If it doesn't enable debug mode and maximum error reporting in Joomla global configuration then retry and see if any fatal errors are shown. If none check server error log for any errors.

Could something in the recent CB update have triggered this change in behaviour?

No, the only thing changed in 1.9.1 is password encryption usage so CB uses Joomla API.

Thanks Kyle.

Tested further. On four trials the tab loaded once after 3-4 minutes, the other three times it eventually resulted in an Internal Server Error 500.

The one time it did load, it was then quick to go into an edit screen for a user but then went into another time-out funk when I cancelled out of the edit screen.

I then backed up the site and upgraded to J2.5.16 with no apparent effect on the CB User Mgt load issue.

I then started progressively unpublishing the CB Plugins. The only minor improvement came when I disabled the Verify Email plugin. After doing that I now seem to be able to load the page three out of four or even higher - but still after waiting for several minutes which is of course still a problem.

I note also that the same lengthy delay occurs with a front end login and also, perhaps to a lesser extent, a logout.

Keep disabling CB Plugins until the issue goes away entirely. It sounds like you've something going into an infinite loop. Disabling a few plugins will reduce memory usage so it should gradually improve, but you'll know the culprit when the issue is gone entirely.

Completed disabling the plugins without finding the culprit.

Exceptions were the language plugins and CB Core plugins that could not be disabled.

Set Debug on with Max Error Reporting in J config, and after many unsuccessful attempts got the CB User Mgt tab to load (after a 10min delay) and have uploaded the debug info in Notepad++ txt format. If I read it correctly the delay point is after the afterRoute action and before the afterDespatch action is complete - not really sure what this means.



Checked the host error log shown via Control Panel and found the following type entries repeated:

[Sun Nov 17 16:52:45 2013] [error] [client 220.239.105.169] File does not exist: <span>/</span>home<span>/</span>sagorg/public_html/images/hdr.png, referer: www.test2.sag.org.au/administrator/index.php?option=com_comprofiler&task=showusers&view=showusers
[Sun Nov 17 16:52:45 2013] [error] [client 220.239.105.169] File does not exist: <span>/</span>home<span>/</span>sagorg/public_html/error.css, referer: www.test2.sag.org.au/administrator/index.php?option=com_comprofiler&task=showusers&view=showusers

It appears to be looking for these files on the live site root rather than the test2 site root, but they don't exist on the test2 site root either.

Looked at the error_log file maintained in the test2 root folder, and there are no recent errors reported there.

Also noticed that with max error reporting on, when I try to edit a plan from the Paid Subs | Plans list the resulting page is prefixed with the following reported errors:

Warning: CBSubs VirtueMart plugin load list groups error: DB function failed with error number 1146
Table 'sagorg_test2.sag13_vm_auth_group' doesn't exist SQL=SELECT `group_name` AS name, `group_id` AS id FROM `sag13_vm_auth_group` ORDER BY `group_name` in /home/sagorg/public_html/test2/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubsvirtuemart/cbsubs.virtuemart.php on line 630

Warning: CBSubs VirtueMart plugin load list groups error: DB function failed with error number 1146
Table 'sagorg_test2.sag13_vm_auth_group' doesn't exist SQL=SELECT `group_name` AS name, `group_id` AS id FROM `sag13_vm_auth_group` ORDER BY `group_name` in /home/sagorg/public_html/test2/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubsvirtuemart/cbsubs.virtuemart.php on line 630

Warning: CBSubs VirtueMart plugin load list shoppers error: DB function failed with error number 1146
Table 'sagorg_test2.sag13_vm_vendor' doesn't exist SQL=SELECT `vendor_name` AS name, `vendor_id` AS id FROM `sag13_vm_vendor` ORDER BY `vendor_name` in /home/sagorg/public_html/test2/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubsvirtuemart/cbsubs.virtuemart.php on line 687

Warning: CBSubs VirtueMart plugin load list shoppers error: DB function failed with error number 1146
Table 'sagorg_test2.sag13_vm_vendor' doesn't exist SQL=SELECT `vendor_name` AS name, `vendor_id` AS id FROM `sag13_vm_vendor` ORDER BY `vendor_name` in /home/sagorg/public_html/test2/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubsvirtuemart/cbsubs.virtuemart.php on line 687

The CBS Virtuemart plugin is published.

So am not sure what to do next. Are you able to provide further guidance based on what I have provided above?

Happy to give you access on the test site (and hosting server) if you are prepared to have a look.

I don't see anything that'd cause this. The two missing file errors are just HTTP request notices. They won't actually cause any problems.

As for your CBSubs Virtuemart issue. You need to delete the below file if you're using Virtuemart 2.x. VM decided to re-add this file, which only exists in VM 1.x, to prevent old VM modules from throwing a missing file error (the file does nothing for VM 2.x) after I already released the integration.

/components/com_virtuemart/virtuemart_parser.php