FluxCP paypal problems

[HeikoS]

Hi there,

i have troubles using paypal donation in our flux cp (last version from CalciumKid).

Testings were done in the paypal sandbox mode.

In the paypal business account the IPN-URL is set correctly to http://www.EXAMPLE.com/FLUXPATH/?module=donate&action=notify

For testing purposes I set the access.php als followed:

'donate'    => array(
				    'index'    => AccountLevel::ADMIN,  //ANYONE
				    'notify'   => AccountLevel::ANYONE,
				    'update'   => AccountLevel::ADMIN, //ANYONE,
				    'complete' => AccountLevel::ADMIN,  //ANYONE
				    'history'  => AccountLevel::ADMIN,  //NORMAL
				    'trusted'  => AccountLevel::ADMIN  //NORMAL

My problem: I can donate (using ADMIN-account and paypal-sandbox-customer), I will be forwarded to paypal, after paypal I will be forwarded to the page "Donation complete" in flux, but nothing else happens. No credit, no entries in ?module=donate&action=history, no entries in ?module=cplog&action=paypal, no entries in cp_txnlog.

Any suggestions, where to search an error?

[HeikoS]

Hm. I noticed, that there are problems with the IPN in sandbox mode.

So I tested the donation with paypal live enviroment.

Now I got the IPN and the table cp_txnlog was filled. I made 2 donations, which are both completed at paypal.

In cp_txnlog both transaction have 'payment_status' 'Completed', but the field 'credits' is empty respectively '0'.

So I will be shown the transactions in ?module=donate&action=history as 'completed' AND 'failed'. And no credits are on the account.

I searched the source code, but did not found the part where the field 'credit' is set.

Error found and fixed:

/lib/Flux/PaymentNotifyRequest.php, line 179

replace:

  $sql = "SELECT COUNT(account_id) AS acc_id_count FROM {$servGroup->loginDatabase}.login WHERE sex != 'S' AND level >= 0 AND account_id = ?";

with:

  $sql = "SELECT COUNT(account_id) AS acc_id_count FROM {$servGroup->loginDatabase}.login WHERE sex != 'S' AND group_id >= 0 AND account_id = ?";

Thread may be marked as "solved". :-)

[Breaker]

can you share your control panel files? i cant get my cp to work with donations