Please Log in to join the conversation.
Only way that could happen is if the user object was modified and lost its user id or the previous auto action caused a redirect.This makes me think that a user on logging in, who doesn't have a membership, one of the processes exits the chain of actions and so the Auto Action is prevented from getting triggered.
The below should work perfectly fine.To be clear, this is what I'm trying to achieve:
An existing user without a membership
A CB Query Field returning 1 or 0
On login, an Auto Action signs the user up to a membership plan if Query returns 1.
Please Log in to join the conversation.
Warning: Declaration of getuddeimTab::sendUserPMS($toid, $fromid, $subject, $message, $systemGenerated = false, $escaped = false) should be compatible with cbPMSHandler::sendUserPMS($toUserId, $fromUserId, $subject, $message, $systemGenerated = false, $fromName = NULL, $fromEmail = NULL) in /var/www/html2/components/com_comprofiler/plugin/user/plug_privatemessagingsystem(uddeimpms)/pms.uddeim.php on line 0
Site Debug mode: CB redirection with message "You have successfully logged in" without empty output
During its normal operations Community Builder often redirects you between pages and this causes potentially interesting debug information to be missed. When your site is in debug mode (global Joomla config is site debug ON), some of these automatic redirects are disabled. This is a normal feature of the debug mode and does not directly mean that you have any problems.
Click this link to proceed with the next page (in non-debug mode this is automatic): http://my.domain.com//
92 queries executed
1
SELECT `data`
FROM `esf_session`
WHERE `session_id` = 'dtjpe82t7n96qj1hgq4s9m7u4r'
2
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `esf_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
3
SELECT id, rules
FROM `esf_viewlevels`
4
SELECT b.id
FROM esf_usergroups AS a
LEFT JOIN esf_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 9
5
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM esf_extensions
WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5)
ORDER BY ordering
6
SELECT *
FROM `esf_comprofiler_plugin_autoactions`
WHERE `trigger` != ''
AND `published` = 1
ORDER BY `ordering` ASC
7
SELECT m.id, m.menutype, m.title, m.alias, m.note, 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 esf_menu AS m
LEFT JOIN esf_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
8
SELECT id, link FROM esf_menu WHERE link LIKE 'index.php?option=com_kide%' AND published='1'
9
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `esf_extensions`
WHERE `type` = 'library' AND `element` = 'joomla'
10
UPDATE `esf_extensions`
SET `params` = '{\"mediaversion\":\"74041577fb44cbc82454a192797612ec\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
11
SELECT id, home, template, s.params
FROM esf_template_styles as s
LEFT JOIN esf_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
12
SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM esf_template_styles AS s
WHERE s.client_id = 0 AND s.template = 'rt_xenon'
ORDER BY s.id
13
SELECT *
FROM esf_languages
WHERE published=1
ORDER BY ordering ASC
14
SELECT `params`
FROM `esf_comprofiler_plugin`
WHERE `id` = 1
15
SHOW FULL COLUMNS FROM `esf_users`
16
SELECT `params`
FROM `esf_modules`
WHERE `module` = 'mod_cblogin'
AND `published` = 1
AND `access` IN (1, 5)
AND `language` IN ( 'en-GB', '*', '' )
ORDER BY `position`, `ordering` LIMIT 0, 1
17
SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
FROM `esf_comprofiler_plugin`
WHERE `published` = 1
AND `viewaccesslevel` IN (1,5)
AND `type` = 'user'
ORDER BY `ordering`
18
SELECT *
FROM `esf_comprofiler_plugin_autoactions`
WHERE `trigger` != ''
AND `published` = 1
ORDER BY `ordering` ASC
19
SELECT *
FROM `esf_cbsubs_config`
WHERE `id` = 1
20
SELECT c.*, u.*
FROM esf_users AS u
LEFT JOIN esf_comprofiler AS c ON c.id = u.id
WHERE u.`username` = 'tomas'
21
SELECT a.id
FROM esf_user_usergroup_map AS map
LEFT JOIN esf_usergroups AS a ON a.id = map.group_id
WHERE map.user_id = 450
22
SELECT *
FROM `esf_users`
WHERE `id` = 450
23
SELECT `g`.`id`,`g`.`title`
FROM `esf_usergroups` AS g
INNER JOIN `esf_user_usergroup_map` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 450
24
SELECT c.*, u.*
FROM esf_users AS u
LEFT JOIN esf_comprofiler AS c ON c.id = u.id
WHERE u.`id` = 450
25
SELECT s.* FROM esf_cbsubs_subscriptions s
WHERE s.user_id = 450
AND s.status = 'A'
ORDER BY s.plan_id ASC, s.`id` ASC
26
SELECT a.* FROM `esf_cbsubs_plans` AS a
WHERE a.`id` = 6
27
SELECT b.*
FROM esf_cbsubs_payment_baskets b
WHERE b.user_id = 450
AND b.payment_status = 'NotInitiated'
AND b.payment_method IS NULL
ORDER BY b.time_initiated DESC LIMIT 0, 1
28
SELECT s.* FROM esf_cbsubs_subscriptions s
WHERE s.user_id = 450
ORDER BY s.`id` ASC
29
SELECT id, password
FROM esf_users
WHERE username='tomas'
30
SELECT `id`
FROM `esf_users`
WHERE `username` = 'tomas' LIMIT 1
31
SELECT ip
FROM esf_saxum_iplogger_excp
32
insert into esf_saxum_iplogger (user_id, ip, visitDate, client_id) values (450,'70.130.78.172','2019-07-17 00:11:44',0)
33
SELECT `id`
FROM `esf_users`
WHERE `username` = 'tomas' LIMIT 1
34
SELECT *
FROM `esf_users`
WHERE `id` = 450
35
SELECT `g`.`id`,`g`.`title`
FROM `esf_usergroups` AS g
INNER JOIN `esf_user_usergroup_map` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 450
36
SELECT b.id
FROM esf_user_usergroup_map AS map
LEFT JOIN esf_usergroups AS a ON a.id = map.group_id
LEFT JOIN esf_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE map.user_id = 450
37
SELECT `id`,`name`,`rules`,`parent_id`
FROM `esf_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gantry5','com_installer','com_jce','com_jcomments','com_jdownloads','com_jevents','com_joomlaupdate','com_kide','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_saxumiplogger','com_search','com_tags','com_templates','com_uddeim','com_users','com_wrapper')
38
DELETE
FROM `esf_session`
WHERE `session_id` = 'dtjpe82t7n96qj1hgq4s9m7u4r'
39
SELECT `data`
FROM `esf_session`
WHERE `session_id` = 'aevv7n01gpb9d57ame4iu39ctv'
40
UPDATE `esf_session`
SET `data` = 'joomla|s:3304:\"TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjI6e3M6OToiX19kZWZhdWx0IjtPOjg6InN0ZENsYXNzIjo0OntzOjc6InNlc3Npb24iO086ODoic3RkQ2xhc3MiOjM6e3M6NzoiY291bnRlciI7aTo0NjtzOjU6InRpbWVyIjtPOjg6InN0ZENsYXNzIjozOntzOjU6InN0YXJ0IjtpOjE1NjMzMjA0NzA7czo0OiJsYXN0IjtpOjE1NjMzMjIxODI7czozOiJub3ciO2k6MTU2MzMyMjE5Nzt9czo1OiJ0b2tlbiI7czozMjoiTmwxUzRhaEg2WVZYaUhNVE5talVMNk02QlZXd0Rvc04iO31zOjg6InJlZ2lzdHJ5IjtPOjI0OiJKb29tbGFcUmVnaXN0cnlcUmVnaXN0cnkiOjM6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MTp7czoxMToiY29tX2NvbnRlbnQiO086ODoic3RkQ2xhc3MiOjE6e3M6ODoiY2F0ZWdvcnkiO086ODoic3RkQ2xhc3MiOjE6e3M6NjoiZmlsdGVyIjtPOjg6InN0ZENsYXNzIjoxOntzOjY6IjEyOjI2MSI7Tzo4OiJzdGRDbGFzcyI6MTp7czozOiJ0YWciO2E6MTp7aTowO2k6MDt9fX19fX1zOjE0OiIAKgBpbml0aWFsaXplZCI7YjowO3M6OToic2VwYXJhdG9yIjtzOjE6Ii4iO31zOjQ6InVzZXIiO086MjA6Ikpvb21sYVxDTVNcVXNlclxVc2VyIjoxOntzOjI6ImlkIjtpOjA7fXM6MTE6ImFwcGxpY2F0aW9uIjtPOjg6InN0ZENsYXNzIjoxOntzOjU6InF1ZXVlIjthOjA6e319fXM6MTc6Il9fSlBsdWdpbkdKRmllbGRzIjtPOjg6InN0ZENsYXNzIjoxOntzOjEzOiJEZWZhdWx0UGFyYW1zIjthOjQyOntzOjU6ImRlYnVnIjtzOjE6IjAiO3M6MTg6IkVuYWJsZWRfRnJvbnRfUGFnZSI7czoxOiIxIjtzOjIwOiJmcF9jYXRlZ29yaWVzX3N3aXRjaCI7czoxOiIwIjtzOjEzOiJmcF9jYXRlZ29yaWVzIjtzOjA6IiI7czoxODoiZnBfYXJ0aWNsZXNfc3dpdGNoIjtzOjE6IjAiO3M6MTU6Impvb21sYV9hcnRpY2xlcyI7czoxOiIxIjtzOjMwOiJqb29tbGFfYXJ0aWNsZXNfcGFyc2VfY2F0ZWdvcnkiO3M6MToiMCI7czoxNzoiY2F0ZWdvcmllc19zd2l0Y2giO3M6MToiMCI7czoxMDoiY2F0ZWdvcmllcyI7czowOiIiO3M6MTU6ImFydGljbGVzX3N3aXRjaCI7czoxOiIwIjtzOjE0OiJjb250ZXh0X3N3aXRjaCI7czo3OiJleGNsdWRlIjtzOjI1OiJjb250ZXh0X2NhdGVnb3JpZXNfc3dpdGNoIjtzOjE6IjAiO3M6Mjg6ImNvbnRleHRfY29udGVudF9pdGVtc19zd2l0Y2giO3M6MToiMCI7czoyMDoiZXhjbHVkZV9tb2RfY29udGV4dHMiO3M6MToiMSI7czoxNzoiY29udGV4dHNUb0V4Y2x1ZGUiO3M6MTk6Im1vZF9jdXN0b20uY29udGVudCwiO3M6OToibGltaXR0eXBlIjtzOjE6IjAiO3M6MTU6Im5vU3BhY2VMYW5ndWFnZSI7czoxOiIwIjtzOjEwOiJsZWFkaW5nTWF4IjtzOjM6Ijc1MCI7czo4OiJpbnRyb01heCI7czozOiI1MDAiO3M6MjU6Iklnbm9yZV9FeGlzdGluZ19SZWFkX01vcmUiO3M6MToiMCI7czoxMDoiUGx1Z2luQ29kZSI7czo2OiJpZ25vcmUiO3M6MTY6IlN0cmlwX0Zvcm1hdHRpbmciO3M6MToiMCI7czoxMjoicHJlc2VydmVUYWdzIjtzOjA6IiI7czo3OiJhZGROQlNQIjtzOjE6IjAiO3M6MTE6IndyYXBfb3V0cHV0IjtzOjE6IjAiO3M6MjA6IndyYXBfb3V0cHV0X3RlbXBsYXRlIjtzOjQwOiI8ZGl2IGNsYXNzPSJhdXRvcmVhZG1vcmUiPiVPVVRQVVQlPC9kaXY+IjtzOjE3OiJhZGRfdHJpbW1pbmdfZG90cyI7czoxOiIwIjtzOjEzOiJ0cmltbWluZ19kb3RzIjtzOjM6Ii4uLiI7czoxMzoicmVhZG1vcmVfdGV4dCI7czowOiIiO3M6MTA6IlRodW1ibmFpbHMiO3M6MToiMCI7czoxNzoiRm9yY2VfSW1hZ2VfQ291bnQiO3M6MToiMCI7czoxMzoiZGVmYXVsdF9pbWFnZSI7czoxMTM6Imh0dHBzOi8vdXBsb2FkLndpa2ltZWRpYS5vcmcvd2lraXBlZGlhL2NvbW1vbnMvdGh1bWIvYS9hYy9Ob19pbWFnZV9hdmFpbGFibGUuc3ZnLzIwMHB4LU5vX2ltYWdlX2F2YWlsYWJsZS5zdmcucG5nIjtzOjExOiJJbWFnZUFzSFRNTCI7czoxOiIxIjtzOjE2OiJUaHVtYm5haWxzX0NsYXNzIjtzOjA6IiI7czoyMToiaW1hZ2VfbGlua190b19hcnRpY2xlIjtzOjE6IjAiO3M6MjI6IlN0cmlwX0ltYWdlX0Zvcm1hdHRpbmciO3M6MToiMCI7czo3OiJjc3Njb2RlIjtzOjI1OiIubWFyZ2luLWgtOCB7bWFyZ2luOjhweDt9IjtzOjE4OiJGb3JjZV9JbWFnZV9IYW5kbGUiO3M6MToiMCI7czoxNzoid3JhcF9pbWFnZV9vdXRwdXQiO3M6MToiMCI7czoyNjoid3JhcF9pbWFnZV9vdXRwdXRfdGVtcGxhdGUiO3M6MzM6IjxkaXYgY2xhc3M9ImltYWdlIj4lT1VUUFVUJTwvZGl2PiI7czoyMDoiaW1hZ2Vfc2VhcmNoX3BhdHRlcm4iO3M6ODoiaW1nX29ubHkiO3M6Mjc6ImltYWdlX3NlYXJjaF9wYXR0ZXJuX2N1c3RvbSI7czo0NDoifjxhW14+XSs+PGltZyBbXj5dKz48L2E+fnVpDQp+PGltZyBbXj5dKj5+aXUiO319fXM6MTQ6IgAqAGluaXRpYWxpemVkIjtiOjA7czo5OiJzZXBhcmF0b3IiO3M6MToiLiI7fQ==\";cbsubs|a:1:{s:11:\"expireduser\";s:3:\"450\";}'
, `time` = 1563322304
WHERE `session_id` = 'aevv7n01gpb9d57ame4iu39ctv'
41
SELECT `data`
FROM `esf_session`
WHERE `session_id` = 'aevv7n01gpb9d57ame4iu39ctv'
42
SELECT `session_id`
FROM `esf_session`
WHERE `session_id` = 'aevv7n01gpb9d57ame4iu39ctv' LIMIT 1
43
INSERT INTO `esf_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('aevv7n01gpb9d57ame4iu39ctv', 0, 1563320470, 450, 'Tomas', 0)
44
DELETE
FROM esf_session
WHERE `session_id` = 'dtjpe82t7n96qj1hgq4s9m7u4r'
45
SELECT *
FROM `esf_users`
WHERE `id` = 450
46
SELECT `g`.`id`,`g`.`title`
FROM `esf_usergroups` AS g
INNER JOIN `esf_user_usergroup_map` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 450
47
UPDATE `esf_users`
SET `lastvisitDate`='2019-07-17 00:11:44'
WHERE `id`=450
48
SELECT f.* FROM esf_comprofiler_fields f
INNER JOIN esf_comprofiler_tabs AS t ON (f.tabid = t.tabid)
WHERE f.published = 1
ORDER BY t.position, t.ordering, f.ordering
49
SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
FROM `esf_comprofiler_plugin`
WHERE `published` = 1
AND `viewaccesslevel` IN (1,2)
AND `type` = 'user'
ORDER BY `ordering`
50
SELECT s.* FROM esf_cbsubs_subscriptions s
LEFT JOIN esf_cbsubs_plans AS a ON a.`id` = s.`plan_id`
LEFT JOIN esf_cbsubs_plans AS b ON b.`id` = a.`parent`
WHERE s.user_id = 450
GROUP BY s.`id`
ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC, s.`id` ASC
51
UPDATE `esf_cbsubs_subscriptions` SET `replaces_plan` = NULL, `replaces_subscription` = '0', `subscription_date` = '2018-06-18 01:48:02', `last_renewed_date` = '2018-06-18 01:48:02', `expiry_date` = '2019-07-06 03:44:18', `autorenew_type` = '0', `autorecurring_type` = 0, `regular_recurrings_total` = '0', `regular_recurrings_used` = '2', `previous_expiry_date` = '2019-07-06 03:44:18', `previous_autorecurring_type` = '0', `previous_recurrings_used` = '1', `ip_addresses` = '76.182.2.5', `status` = 'C', `previous_status` = 'A', `user_id` = '450', `plan_id` = '6', `parent_plan` = '0', `parent_subscription` = '0', `integrations` = '[]' WHERE `id` = '34'
52
INSERT INTO `esf_cbsubs_history`
(`event_type`,`message`,`table_name`,`table_key_id`,`field_changed`,`change_type`,`old_value`,`new_value`,`event_time`,`user_id`,`ip_addresses`,`log_priority`,`log_version`) VALUES
('2','User subscription deactivated with status Cancelled','#__cbsubs_subscriptions','34','','update','<fields>\n <field name=\"status\" value=\"A\" />\n</fields>\n','<fields>\n <field name=\"status\" value=\"C\" />\n</fields>\n','2019-07-17 00:11:44','450','70.130.78.172','6','1')
53
SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
FROM `esf_comprofiler_plugin`
WHERE `published` = 1
AND `viewaccesslevel` IN (1,2)
AND `type` = 'user/plug_cbpaidsubscriptions/plugin'
ORDER BY `ordering`
54
SELECT m.*
FROM `esf_cbsubs_promotions` AS m
WHERE m.`published` = 1
ORDER BY m.`priority`, m.`ordering`
55
SELECT `name`, `table`, `type`
FROM `esf_comprofiler_fields`
WHERE `published` = 1
AND `fieldid` = 0
56
SELECT `name`, `table`, `type`
FROM `esf_comprofiler_fields`
WHERE `published` = 1
AND `fieldid` = 0
57
SELECT `name`, `table`, `type`
FROM `esf_comprofiler_fields`
WHERE `published` = 1
AND `fieldid` = 0
58
SELECT `name`, `table`, `type`
FROM `esf_comprofiler_fields`
WHERE `published` = 1
AND `fieldid` = 0
59
SELECT `name`, `table`, `type`
FROM `esf_comprofiler_fields`
WHERE `published` = 1
AND `fieldid` = 0
60
SELECT `name`, `table`, `type`
FROM `esf_comprofiler_fields`
WHERE `published` = 1
AND `fieldid` = 0
61
SELECT `name`, `table`, `type`
FROM `esf_comprofiler_fields`
WHERE `published` = 1
AND `fieldid` = 0
62
SELECT `name`, `table`, `type`
FROM `esf_comprofiler_fields`
WHERE `published` = 1
AND `fieldid` = 0
63
SELECT `name`, `table`, `type`
FROM `esf_comprofiler_fields`
WHERE `published` = 1
AND `fieldid` = 0
64
SELECT `name`, `table`, `type`
FROM `esf_comprofiler_fields`
WHERE `published` = 1
AND `fieldid` = 0
65
SELECT s.* FROM esf_cbsubs_subscriptions s
WHERE s.user_id = 450
AND s.status = 'A'
ORDER BY s.plan_id ASC, s.`id` ASC
66
SELECT `username`, `block` FROM `esf_users` WHERE `id` = 450
67
SELECT *
FROM `esf_users`
WHERE `id` = 450
68
SELECT `g`.`id`,`g`.`title`
FROM `esf_usergroups` AS g
INNER JOIN `esf_user_usergroup_map` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 450
69
SELECT `id`,`title`
FROM `esf_usergroups`
WHERE `id` = 2
70
SELECT `id`
FROM `esf_users`
WHERE `username` = 'Tomas' AND `id` != 450
71
SELECT `id`
FROM `esf_users`
WHERE `email` = 'my@email.com' AND `id` != 450
72
SELECT `id`
FROM `esf_users`
WHERE `username` = ''
73
SELECT *
FROM `esf_users`
WHERE `id` = 450
74
SELECT `g`.`id`,`g`.`title`
FROM `esf_usergroups` AS g
INNER JOIN `esf_user_usergroup_map` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 450
75
SELECT count(id)
FROM esf_usergroups
76
SELECT *
FROM esf_usergroups
ORDER BY lft ASC
77
UPDATE `esf_users` SET `name`='Tomas',`username`='Tomas',`email`='my@email.com',`block`='1',`sendEmail`='0',`registerDate`='2018-06-18 01:48:02',`lastvisitDate`='2019-07-16 23:41:10',`activation`='',`params`='{\"language\":null,\"editor\":null,\"timezone\":null,\"admin_style\":null,\"admin_language\":null,\"helpsite\":null}',`lastResetTime`='0000-00-00 00:00:00',`resetCount`='0',`otpKey`='',`otep`='',`requireReset`='0' WHERE `id` = '450'
78
SELECT `group_id`
FROM `esf_user_usergroup_map`
WHERE `user_id` = 450
79
DELETE
FROM `esf_user_keys`
WHERE `user_id` = 'Tomas'
80
UPDATE `esf_jcomments`
SET `name` = 'Tomas'
, `username` = 'Tomas'
, `email` = 'my@email.com'
WHERE `userid` = 450
81
UPDATE `esf_jcomments_subscriptions`
SET `email` = 'my@email.com'
WHERE `userid` = 450
82
UPDATE `esf_comprofiler` SET `user_id` = 450, `firstname` = '', `middlename` = '', `lastname` = 'Tomas', `hits` = '12', `message_last_sent` = '0000-00-00 00:00:00', `message_number_sent` = '0', `avatar` = '450_5cf4971fe9a92.jpg', `avatarapproved` = '1', `canvas` = 'gallery/Banners-1500-Woodpecker.jpg', `canvasapproved` = '1', `approved` = '1', `confirmed` = '1', `lastupdatedate` = '2019-06-10 05:18:10', `registeripaddr` = '76.182.2.5', `cbactivation` = '', `banned` = '0', `acceptedterms` = '1', `alias` = '', `canvasposition` = '50', `acceptedtermsconsent` = '0000-00-00 00:00:00', `cb_folderaccess` = '{SHA}vCwNN5eRZ8qGMDRLqU4Xy1jwPVg=', `cb_gender` = '1', `cb_age` = '50-59', `cb_forum_order` = '0', `cb_forum_viewtype` = 'flat', `cb_status` = 'This is My Canvas', `cb_furum_signature` = 'This is my Signature\r\n[b]Tomás [/b]', `cb_city` = 'My City', `cb_state` = 'ST', `cb_country` = 'US', `cb_website` = '', `cb_forum_email_hide` = '', `cb_forum_online_status` = '1', `cb_forum_thread_subscr` = '-1', `cb_pb_enable` = '', `cb_pb_autopublish` = '', `cb_pb_notifyme` = '', `cb_pb_enable_wall` = '', `cb_pb_autopublish_wall` = '', `cb_pb_notifyme_wall` = '', `cb_location` = '', `cb_greetings` = '<p>Hello! This is your profile\'s greeting page. Yay! <img style=\"float: right;\" src=\"images/users-personal/450/Dove-heart_0346.jpg\" alt=\"Dove heart 0346\" width=\"500\" height=\"332\" /></p>' WHERE `id` = 450
83
SELECT m.id AS aro_id, a.group_id FROM esf_user_usergroup_map AS a
INNER JOIN esf_usergroups AS m ON m.id= a.group_id
WHERE a.user_id = 450
84
SELECT *
FROM `esf_users`
WHERE `id` = 450
85
SELECT `g`.`id`,`g`.`title`
FROM `esf_usergroups` AS g
INNER JOIN `esf_user_usergroup_map` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 450
86
UPDATE `esf_users`
SET `lastvisitDate`='2019-07-17 00:11:44'
WHERE `id`=450
87
DELETE
FROM `esf_session`
WHERE `session_id` = 'aevv7n01gpb9d57ame4iu39ctv'
88
DELETE
FROM `esf_session`
WHERE `userid` = 450 AND `client_id` = 0
89
SELECT `data`
FROM `esf_session`
WHERE `session_id` = 'dtjpe82t7n96qj1hgq4s9m7u4r'
90
SELECT `session_id`
FROM `esf_session`
WHERE `session_id` = 'dtjpe82t7n96qj1hgq4s9m7u4r' LIMIT 1
91
INSERT INTO `esf_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('dtjpe82t7n96qj1hgq4s9m7u4r', 1, 1563322304, 0, '', 0)
92
DELETE FROM esf_session WHERE userid = 450
POST: array (
'option' => 'com_comprofiler',
'view' => 'login',
'op2' => 'login',
'return' => 'B:aHR0cDovL2Rldi5lc2ZvdW5kYXRpb25zLmNvbS8v',
'message' => '1',
'loginfrom' => 'loginform',
'cbsecuritym3' => 'cbm_6d5e5504_7e550bc2_530ec1e580213377bfde70d4493e538a',
'username' => 'tomas',
'passwd' => '******',
'Submit' => '',
'task' => 'login',
)
Warning: Declaration of getuddeimTab::sendUserPMS($toid, $fromid, $subject, $message, $systemGenerated = false, $escaped = false) should be compatible with cbPMSHandler::sendUserPMS($toUserId, $fromUserId, $subject, $message, $systemGenerated = false, $fromName = NULL, $fromEmail = NULL) in /var/www/html2/components/com_comprofiler/plugin/user/plug_privatemessagingsystem(uddeimpms)/pms.uddeim.php on line 0
Site Debug mode: CB redirection with notice "
A membership is needed for access.
" without empty output
During its normal operations Community Builder often redirects you between pages and this causes potentially interesting debug information to be missed. When your site is in debug mode (global Joomla config is site debug ON), some of these automatic redirects are disabled. This is a normal feature of the debug mode and does not directly mean that you have any problems.
Click this link to proceed with the next page (in non-debug mode this is automatic): http://my.domain.com/index.php/cb-profile/pluginclass/cbpaidsubscriptions?do=accountexpired
36 queries executed
1
SELECT `data`
FROM `esf_session`
WHERE `session_id` = 'b8ef4p3hmq7bf6qqp4mt4n5og5'
2
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `esf_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
3
SELECT id, rules
FROM `esf_viewlevels`
4
SELECT b.id
FROM esf_usergroups AS a
LEFT JOIN esf_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 9
5
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM esf_extensions
WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5)
ORDER BY ordering
6
SELECT *
FROM `esf_comprofiler_plugin_autoactions`
WHERE `trigger` != ''
AND `published` = 1
ORDER BY `ordering` ASC
7
SELECT m.id, m.menutype, m.title, m.alias, m.note, 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 esf_menu AS m
LEFT JOIN esf_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
8
SELECT id, link FROM esf_menu WHERE link LIKE 'index.php?option=com_kide%' AND published='1'
9
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `esf_extensions`
WHERE `type` = 'library' AND `element` = 'joomla'
10
UPDATE `esf_extensions`
SET `params` = '{\"mediaversion\":\"8d3d27ecf1c42d38aa275a249304f3ae\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
11
SELECT id, home, template, s.params
FROM esf_template_styles as s
LEFT JOIN esf_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
12
SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM esf_template_styles AS s
WHERE s.client_id = 0 AND s.template = 'rt_xenon'
ORDER BY s.id
13
SELECT *
FROM esf_languages
WHERE published=1
ORDER BY ordering ASC
14
SELECT `params`
FROM `esf_comprofiler_plugin`
WHERE `id` = 1
15
SHOW FULL COLUMNS FROM `esf_users`
16
SELECT `params`
FROM `esf_modules`
WHERE `module` = 'mod_cblogin'
AND `published` = 1
AND `access` IN (1, 5)
AND `language` IN ( 'en-GB', '*', '' )
ORDER BY `position`, `ordering` LIMIT 0, 1
17
SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
FROM `esf_comprofiler_plugin`
WHERE `published` = 1
AND `viewaccesslevel` IN (1,5)
AND `type` = 'user'
ORDER BY `ordering`
18
SELECT *
FROM `esf_comprofiler_plugin_autoactions`
WHERE `trigger` != ''
AND `published` = 1
ORDER BY `ordering` ASC
19
SELECT *
FROM `esf_cbsubs_config`
WHERE `id` = 1
20
SELECT c.*, u.*
FROM esf_users AS u
LEFT JOIN esf_comprofiler AS c ON c.id = u.id
WHERE u.`username` = 'tomas'
21
SELECT a.id
FROM esf_user_usergroup_map AS map
LEFT JOIN esf_usergroups AS a ON a.id = map.group_id
WHERE map.user_id = 450
22
SELECT *
FROM `esf_users`
WHERE `id` = 450
23
SELECT `g`.`id`,`g`.`title`
FROM `esf_usergroups` AS g
INNER JOIN `esf_user_usergroup_map` AS m ON m.group_id = g.id
WHERE `m`.`user_id` = 450
24
SELECT c.*, u.*
FROM esf_users AS u
LEFT JOIN esf_comprofiler AS c ON c.id = u.id
WHERE u.`id` = 450
25
SELECT s.* FROM esf_cbsubs_subscriptions s
WHERE s.user_id = 450
AND s.status = 'A'
ORDER BY s.plan_id ASC, s.`id` ASC
26
SELECT *
FROM `esf_usergroups`
ORDER BY `lft`
27
SELECT `id`,`name`,`rules`,`parent_id`
FROM `esf_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gantry5','com_installer','com_jce','com_jcomments','com_jdownloads','com_jevents','com_joomlaupdate','com_kide','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_saxumiplogger','com_search','com_tags','com_templates','com_uddeim','com_users','com_wrapper')
28
SELECT count(id)
FROM esf_usergroups
29
SELECT *
FROM esf_usergroups
ORDER BY lft ASC
30
SELECT b.id
FROM esf_user_usergroup_map AS map
LEFT JOIN esf_usergroups AS a ON a.id = map.group_id
LEFT JOIN esf_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE map.user_id = 450
31
SELECT a.`id` AS value, a.`title` AS text, COUNT( DISTINCT b.`id` ) AS level, a.`lft`, a.`rgt`
FROM `esf_usergroups` AS a
LEFT JOIN `esf_usergroups` AS b ON a.`lft` > b.`lft` AND a.`rgt` < b.`rgt`
GROUP BY a.`id`
ORDER BY a.`lft` ASC
32
SELECT a.* FROM `esf_cbsubs_plans` AS a
LEFT JOIN `esf_cbsubs_plans` AS b ON b.`id` = a.`parent`
WHERE a.published = 1 AND a.access IN (-2,-1,1,2) AND a.viewaccesslevel IN (1, 2)
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
33
SELECT s.* FROM esf_cbsubs_subscriptions s
WHERE s.user_id = 450
AND s.status = 'X'
ORDER BY s.plan_id ASC, s.`id` ASC
34
SELECT `id`
FROM `esf_menu`
WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=pluginclass&plugin=cbpaidsubscriptions&do=accountexpired%' OR `link` LIKE 'index.php?option=com_comprofiler&task=pluginclass&plugin=cbpaidsubscriptions&do=accountexpired%' )
AND `published` = 1
AND `access` IN ( 1,5 )
AND `language` IN ( 'en-GB', '*', '' )
AND `client_id` = 0
35
SELECT `id`
FROM `esf_menu`
WHERE ( `link` = 'index.php?option=com_comprofiler&view=userprofile' OR `link` = 'index.php?option=com_comprofiler&task=userprofile' OR `link` = 'index.php?option=com_comprofiler' )
AND `published` = 1
AND `access` IN ( 1,5 )
AND `language` IN ( 'en-GB', '*', '' )
AND `client_id` = 0
36
SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
FROM `esf_comprofiler_plugin`
WHERE `published` = 1
AND `viewaccesslevel` IN (1,5)
ORDER BY `ordering`
POST: array (
'option' => 'com_comprofiler',
'view' => 'login',
'op2' => 'login',
'return' => 'B:aHR0cDovL2Rldi5lc2ZvdW5kYXRpb25zLmNvbS9jb21tdW5pdHkvZ2F0aGVyaW5n',
'message' => '1',
'loginfrom' => 'loginmodule',
'cbsecuritym3' => 'cbm_6397ce2d_63362f16_8ac784b0c939d26611fdcc7358431b38',
'username' => 'tomas',
'passwd' => '****',
'Submit' => '',
'task' => 'login',
)
Please Log in to join the conversation.
Please Log in to join the conversation.