Cancelling a payment

13 years 9 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.

13 years 9 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.

13 years 9 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.

13 years 9 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.240 seconds

Facebook Twitter LinkedIn