Access across different CB sites

micheleq
OFFLINE
Posts: 144
Thanks: 22
Karma: 6

5 years 4 months ago - 5 years 4 months ago #313258 by micheleq

Replied by micheleq on topic Access across different CB sites

Hi Kyle,
I am using the CB Login module. I have 2 auto actions and I've switched them from subscribe to unsubscribe, and the unsubscribe continued to work while the subscribe continued to not work. So that ruled out anything in the setting of the Auto Action instance itself.
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.
Does this make sense?
That being the case, I'd have to figure out a different trigger event.
Thanks.

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.

I can't get that to work.

Last edit: 5 years 4 months ago by micheleq.

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48551
Thanks: 8291
Karma: 1445

5 years 4 months ago - 5 years 4 months ago #313264 by krileon

Replied by krileon on topic Access across different CB sites

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.

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.

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.

The below should work perfectly fine.

Global
Triggers: onAfterLogin
Type: CB Paid Subscriptions
User: Automatic
Access: Everybody
Conditions
QUERY_FIELD Equal To 1
Action
Mode: Subscribe
Plans: YOUR_PLANS

If it's not working enabled debug mode under Parameters then enable debug mode and maximum error reporting in Joomla global configuration. This should cause it to output a Joomla message queue message about what failed if something failed, which is usually the condition as your query field may not be outputting as expected or it may not be as accessible as needed.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Last edit: 5 years 4 months ago by krileon.

Please Log in or Create an account to join the conversation.

micheleq
OFFLINE
Posts: 144
Thanks: 22
Karma: 6

5 years 4 months ago #313275 by micheleq

Replied by micheleq on topic Access across different CB sites

Here are the results of my debug test, before these tests:
- All other custom Auto Actions were disabled
- Cleared Cache (server and browser)
- When executing the logins, the conditions were set for the active Auto Action to execute

These are the results of the login when the Unsubscribe Auto Action was enabled (only one enabled) and the user was set to be Unsubscribed from the plan

Warning: Spoiler!

Code:

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',
)

Result: The user was unsubscribed (as it should) and redirected to the home page without a message and logged out.

These are the results of the login when the Subscribe Auto Action was enabled (only one enabled) and the user was set to be Subscribed to the plan

Warning: Spoiler!

Code:

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',
)

Result: Nothing different. Notice "A membership is needed for access." Should have subscribe the user and logged in, but didn't.

I tried with subscriptions that were available in the front end.

Thanks,
Tomas

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48551
Thanks: 8291
Karma: 1445

5 years 4 months ago #313283 by krileon

Replied by krileon on topic Access across different CB sites

"A membership is needed for access" is the access denied message CBSubs displays when it blocks access to something. Are you protecting the entire CB component with CBSubs? Do not do this. It will prevent all access to CB. The access denied redirect is happening before your auto action and is why it isn't working.

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon