Cancelling a payment

10 years 11 months ago #137954 by cferron
Cancelling a payment was created by cferron
When a users wants to cancel his payment he gets this message:

Your request to cancel the subscription and invoice has been processed successfully.

But really, nothing happend.

Any idea?

Claude

Please Log in to join the conversation.

10 years 11 months ago #137983 by krileon
Replied by krileon on topic Re:Cancelling a payment
Please enable debug mode and maximum error reporting within Joomla global configuration then attempt to cancel again. This should assist in displaying any on-screen errors. Please also review CBSubs History for any CB related errors and/or warnings. Sounds as if a fatal PHP error is occurring.


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.

Please Log in to join the conversation.

10 years 11 months ago #138017 by cferron
Replied by cferron on topic Re:Cancelling a payment
Here is what I get:
[code:1]Informations
Application afterLoad: 0.000 seconds, 0.40 MB
Application afterInitialise: 0.086 seconds, 7.75 MB
Application afterRoute: 0.327 seconds, 14.08 MB
Application afterDispatch: 0.849 seconds, 36.31 MB
Application afterRender: 1.556 seconds, 39.04 MB
Utilisation de la mémoire
40980472
44 requêtes achevées

1.
SELECT *
FROM jos_session
WHERE session_id = 'ad8f302d8c8ad91f539a380caba31124'
2.
DELETE
FROM jos_session
WHERE ( time < '1279323586' )
3.
SELECT *
FROM jos_session
WHERE session_id = 'ad8f302d8c8ad91f539a380caba31124'
4.
UPDATE `jos_session`
SET `time`='1279325086',`userid`='364',`usertype`='Registered',`username`='lesanglier',`gid`='18',`guest`='0',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:37;s:19:\"session.timer.start\";i:1279323279;s:18:\"session.timer.last\";i:1279325074;s:17:\"session.timer.now\";i:1279325081;s:22:\"session.client.browser\";s:95:\"Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.6) Gecko/20100625 Firefox/3.6.6\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:10:\"com_search\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:5:\"limit\";i:8;}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:3:\"364\";s:4:\"name\";s:16:\"Utilisateur Test\";s:8:\"username\";s:10:\"lesanglier\";s:5:\"email\";s:21:\"subitophoto@gmail.com\";s:8:\"password\";s:65:\"cdcfac736dc6503d192e3c5f24316b04:mzHAXB5mreitkC1T0TRXF9HscNgFhXma\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"Registered\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"0\";s:3:\"gid\";s:2:\"18\";s:12:\"registerDate\";s:19:\"2010-07-15 14:08:30\";s:13:\"lastvisitDate\";s:19:\"2010-07-16 23:23:20\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:28:\"language=fr-FR\ntimezone=-5\n\n\";s:3:\"aid\";i:1;s:5:\"guest\";i:0;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:76:\"/home1/subitoph/public_html/ATRUF/v2/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":2:{s:8:\"language\";s:5:\"fr-FR\";s:8:\"timezone\";s:2:\"-5\";}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}referrerid|s:17:\"AUPRR-SUBITOPHOTO\";'
WHERE session_id='ad8f302d8c8ad91f539a380caba31124'
5.
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 1
ORDER BY ordering
6.
SELECT id, title, alias
FROM jos_jumi
WHERE published = 1
7.
SELECT newurl
FROM jos_sh404sef_aliases
WHERE alias = 'index.php?option=com_comprofiler&task=pluginclass&user=364&plugin=cbpaidsubscriptions&cbpaidsubscriptionsmethod=cancelpay&cbpaidsubscriptionspdtback=edc71e25aef1df749b81033d7f914f7b&cbpaidsubscriptionsbasket=14&result=cancel'
8.
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_comprofiler&cbpaidsubscriptionsbasket=14&cbpaidsubscriptionsmethod=cancelpay&cbpaidsubscriptionspdtback=edc71e25aef1df749b81033d7f914f7b&lang=fr&plugin=cbpaidsubscriptions&result=cancel&task=pluginclass&user=364'
9.
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
10.
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_comprofiler&cbpaidsubscriptionsbasket=14&cbpaidsubscriptionsmethod=cancelpay&cbpaidsubscriptionspdtback=edc71e25aef1df749b81033d7f914f7b&lang=fr&plugin=cbpaidsubscriptions&result=cancel&task=pluginclass&user=364'
11.
SELECT name, link,id
FROM jos_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_comprofiler%'
12.
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
13.
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1
14.
SELECT *

FROM `jos_cbsubs_config`

WHERE `id` = '1'
15.
SELECT s.*
FROM jos_cbsubs_subscriptions s

WHERE s.user_id = 364

AND s.STATUS = 'A'

ORDER BY s.plan_id
16.
SELECT a.*
FROM `jos_cbsubs_plans` AS a

WHERE a.`id` = 2
17.
SELECT a.*
FROM `jos_cbsubs_plans` AS a

LEFT JOIN `jos_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
18.
SELECT *
FROM jos_components
WHERE parent = 0
19.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 364
20.
SELECT *
FROM jos_comprofiler_plugin p

WHERE p.published = 1
AND p.element = 'cbpaidsubscriptions'
21.
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name

FROM jos_comprofiler_plugin

WHERE published = 1
AND access <= 1
AND type = 'user'

ORDER BY ordering
22.
SELECT *

FROM `jos_cbsubs_payment_baskets`

WHERE `id` = '14'
23.
SELECT i.*
FROM jos_cbsubs_payment_items i

WHERE i.payment_basket_id = 14

ORDER BY i.ordering ASC
24.
SELECT a.*
FROM `jos_cbsubs_plans` AS a

WHERE a.`id` = 1
25.
SELECT *

FROM `jos_cbsubs_subscriptions`

WHERE `id` = '295'
26.
SELECT b.*

FROM jos_cbsubs_payment_baskets b, jos_cbsubs_payment_items i, jos_cbsubs_subscriptions s

WHERE b.id = i.payment_basket_id

AND i.subscription_id = s.id

AND s.user_id = 364

AND s.plan_id = 1

AND s.id = 295

AND b.user_id = s.user_id

AND b.payment_status = 'Pending'

AND b.id <> 14

ORDER BY b.time_initiated DESC

LIMIT 0, 1
27.
SELECT b.*

FROM jos_cbsubs_payment_baskets b, jos_cbsubs_payment_items i, jos_cbsubs_subscriptions s

WHERE b.id = i.payment_basket_id

AND i.subscription_id = s.id

AND s.user_id = 364

AND s.plan_id = 1

AND s.id = 295

AND b.user_id = s.user_id

AND b.payment_status = 'Pending'

AND b.id <> 14

ORDER BY b.time_initiated DESC

LIMIT 0, 1
28.
DELETE
FROM jos_cbsubs_payment_items

WHERE payment_basket_id = 14
29.
DELETE
FROM `jos_cbsubs_payment_baskets`

WHERE `id` = '14'
30.
INSERT INTO `jos_cbsubs_history` ( `event_type`,`message`,`table_name`,`table_key_id`,`field_changed`,`change_type`,`old_value`,`event_time`,`user_id`,`ip_addresses`,`log_priority`,`log_version` )
VALUES ( '2','Payment basket deleted because the subscriptions and payment got cancelled','#__cbsubs_payment_baskets','14','','delete','<record type=\"sql:row\" table=\"#__cbsubs_payment_baskets\" class=\"cbpaidPaymentBasket\" key=\"id\" value=\"14\" valuetype=\"const:«»string\">\n <field name=\"user_id\" value=\"364\" />\n <field name=\"owner\" value=\"0\" />\n <field name=\"gateway_account\" value=\"0\" />\n <field name=\"time_initiated\" value=\"2010-07-16 18:04:41\" />\n <field name=\"shared_secret\" value=\"cbp4c40f399c4fe1212172223\" />\n <field name=\"ip_addresses\" value=\"70.35.173.91\" />\n <field name=\"test_ipn\" value=\"0\" />\n <field name=\"address_name\" value=\"Claude Ferron\" />\n <field name=\"first_name\" value=\"Claude\" />\n <field name=\"last_name\" value=\"Ferron\" />\n <field name=\"contact_phone\" value=\"1111111111\" />\n <field name=\"item_name\" value=\"Membre de L\'ATRUF (cotisation payée) pour lesanglier\" />\n <field name=\"item_number\" value=\"S295-364-1\" />\n <field name=\"quantity\" value=\"1\" />\n <field name=\"invoice\" value=\"N1024415879957817\" />\n <field name=\"payment_status\" value=\"RegistrationCancelled\" />\n <field name=\"mc_currency\" value=\"CAD\" />\n <field name=\"mc_gross\" value=\"5.00000\" />\n <field name=\"recurring\" value=\"0\" />\n</record>\n','2010-07-16 18:04:46','364','70.35.173.91','6','1' )
31.
SELECT s.*
FROM jos_cbsubs_subscriptions s

WHERE s.user_id = 364
32.
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name

FROM jos_comprofiler_plugin

WHERE published = 1
AND access <= 1
AND type = 'user/plug_cbpaidsubscriptions/plugin'

ORDER BY ordering
33.
SELECT m.*, am.params AS adv_params
FROM jos_modules AS m
LEFT JOIN jos_advancedmodules AS am
ON am.moduleid = m.id
WHERE m.published = 1
AND m.access <= 1
AND m.client_id = 0
ORDER BY m.ordering, m.id
34.
SELECT name
FROM jos_users
WHERE id = 364
35.
SELECT id
FROM jos_menu
WHERE link LIKE '%com_uddeim%'
AND published=1
AND access<=1
LIMIT 1
36.
SELECT id
FROM jos_menu
WHERE link LIKE '%com_uddeim%'
AND published=0
AND access<=1
LIMIT 1
37.
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_uddeim&Itemid=263&lang=fr&task=inbox'
38.
SELECT a.*, b.name AS displayname
FROM jos_uddeim AS a
LEFT JOIN jos_users AS b
ON a.fromid=b.id
WHERE a.toread=0
AND a.totrash=0
AND a.toid=364
ORDER BY a.datum
39.
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_svmap&Itemid=266&lang=fr&view=svmap'
40.
SELECT oldurl
FROM jos_redirection
WHERE newurl = 'index.php?option=com_svmap&Itemid=266&lang=fr'
41.
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=179&lang=fr&view=archive'
42.
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_rokin&Itemid=206&lang=fr'
43.
SELECT *, RAND() AS ordering
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND catid = 2
ORDER BY sticky DESC, ordering
LIMIT 0, 1
44.
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 5[/code:1]

Please Log in to join the conversation.

10 years 11 months ago #138122 by krileon
Replied by krileon on topic Re:Cancelling a payment
Not the query information at the bottom of your screen, but any notices, warnings, or errors shown on-screen. If none the please review your server error log for any errors.


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.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.559 seconds

Facebook Twitter LinkedIn