Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Possible bug with WorldPay validation....

Quote Reply
Possible bug with WorldPay validation....
Hi. In /Links/Payments/Remote/WorldPay.pm, there is;

Code:
sprintf(Links::language('PAYMENT_REMOTE_RECURRING_DECLINED') => 'WorldPay') . "\n" .

...yet a "grep" just gives me;

Code:
linkssql@east cgi-bin $ grep -r -l 'PAYMENT_REMOTE_RECURRING_DECLINED' .
./admin/Links/Payment/Remote/WorldPay.pm
linkssql@east cgi-bin $

Anyone got any ideas? Shouldn't there be an entry for this in the language.txt file? Unsure

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Possible bug with WorldPay validation.... In reply to
I didn't think worldpay passed back details if a card was declined... only if the transaction was cancelled or successful.

I could be wrong... it has happened before. Wink

r
Quote Reply
Re: [Andy] Possible bug with WorldPay validation.... In reply to
It's not a big issue. Just the error messages will look a little strange. The missing entries in the language are:
'PAYMENT_REMOTE_RECURRING_ACCEPTED' => 'Recurring payment notification received from %s',
'PAYMENT_REMOTE_RECURRING_DECLINED' => 'Declined payment notification received from %s',

Adrian
Quote Reply
Re: [ryel01] Possible bug with WorldPay validation.... In reply to
In Reply To:
I didn't think worldpay passed back details if a card was declined... only if the transaction was cancelled or successful.

I could be wrong... it has happened before. Wink

Not sure. Its really doing my head in here :( payment_status is being set by postback.cgi ok for the link in question. BUT in the admin panel, it doesn't matter what you do...(except manually accept the payment).. the link still shows up as "Awaiting Payment" Frown

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [brewt] Possible bug with WorldPay validation.... In reply to
In Reply To:
It's not a big issue. Just the error messages will look a little strange. The missing entries in the language are:
'PAYMENT_REMOTE_RECURRING_ACCEPTED' => 'Recurring payment notification received from %s',
'PAYMENT_REMOTE_RECURRING_DECLINED' => 'Declined payment notification received from %s',

Thanks Adrian :)

I'm not sure this will fix the validation problems I'm having... but at least its one less bug =)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Possible bug with WorldPay validation.... In reply to
Have you got the latest package? That's always a first to check... You can always test with WorldPay's test mode.

Adrian
Quote Reply
Re: [brewt] Possible bug with WorldPay validation.... In reply to
Hi Adrian,

Quote:
Have you got the latest package?

Yeah (unless it changed in the last 2 days).

Quote:
You can always test with WorldPay's test mode.

Yeah, thats what I'm doing. I've been talking to Aki and Jack, but no-one can see whats going on :( (it works fine on the same server, same domain name, but with a different folder/database).

Back to debugging still I guess :(

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [brewt] Possible bug with WorldPay validation.... In reply to
I'm still having problem :(

Doing a "tail" on the Perl error_log, gives me;

Quote:
GT::SQL::Driver::MYSQL::sth (15085): Executing query: SELECT * FROM lsql_Payments WHERE payments_id = 'c6988b232bc31a0b' from Links::Payment::Remote::WorldPay::postback at /home/.../admin/Links/Payment/Remote/WorldPay.pm line 111
GT::SQL::Driver::MYSQL::sth (15085): Executing query: SELECT payments_last,payments_id,payments_status FROM lsql_Payments WHERE payments_id = 'c6988b232bc31a0b' from Links::Payment::Remote::WorldPay::__ANON__ at /home/.../admin/Links/Payment/Remote/WorldPay.pm line 208
GT::SQL::Driver::MYSQL::sth (15085): Executing query: UPDATE lsql_Payments SET payments_last = 1092991211 , payments_status = 3 WHERE payments_id = 'c6988b232bc31a0b' from Links::Payment::Remote::WorldPay::__ANON__ at /home/.../admin/Links/Payment/Remote/WorldPay.pm line 208
GT::SQL::Driver::MYSQL::sth (15085): Executing query: INSERT INTO lsql_PaymentLogs (paylogs_type,paylogs_time,paylogs_text,paylogs_payments_id,paylogs_id) VALUES (3,1092991211,'
','c6988b232bc31a0b',NULL) from Links::Payment::Remote::WorldPay::__ANON__ at /home/.../admin/Links/Payment/Remote/WorldPay.pm line 213

...so it seems to be entering most of the info in correctly (and updating payment_status => 3). However, in the admin panel, its still showing up as "Awaiting Payment" .. which it shouldn't be :/

Please note; the "..." in the paths was edited by me for this post (or else it was too long winded). Just in case you were wondering if that was the problem =)

Any ideas? (been trying to get this friggin thing going for 2 weeks+ now Pirate).

TIA

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Possible bug with WorldPay validation.... In reply to
Quote:
Yeah, thats what I'm doing. I've been talking to Aki and Jack, but no-one can see whats going on :( (it works fine on the same server, same domain name, but with a different folder/database).
Perhaps you've don't have the postback url setup correctly (ie. it's setup to go to the other setup)?

Adrian
Quote Reply
Re: [brewt] Possible bug with WorldPay validation.... In reply to
Thanks for the reply. I don't think thats the problem though. I thought it was to start with, but then I added in a bit of code to email me the output from Dumper($IN), and it gives;

Code:
$VAR1 = bless( {
                 'param_order' => [
                                    'testMode',
                                    'authCost',
                                    'currency',
                                    'address',
                                    'countryString',
                                    'callbackPW',
                                    'installation',
                                    'fax',
                                    'countryMatch',
                                    'transId',
                                    'AVS',
                                    'amountString',
                                    'postcode',
                                    'msgType',
                                    'name',
                                    'tel',
                                    'transStatus',
                                    'desc',
                                    'cardType',
                                    'lang',
                                    'transTime',
                                    'authAmountString',
                                    'authAmount',
                                    'ipAddress',
                                    'cost',
                                    'instId',
                                    'amount',
                                    'compName',
                                    'country',
                                    'MC_callback',
                                    'rawAuthMessage',
                                    'email',
                                    'authCurrency',
                                    'rawAuthCode',
                                    'cartId',
                                    'authMode'
                                  ],
                 'params' => {
                               'cost' => [
                                           '45.0'
                                         ],
                               'postcode' => [
                                               'RH12 3HE'
                                             ],
                               'installation' => [
                                                   '12345'
                                                 ],
                               'testMode' => [
                                               '100'
                                             ],
                               'authMode' => [
                                               'A'
                                             ],
                               'MC_callback' => [
                                                  'www.domain.com/cgi-bin/global/postback.cgi'
                                                ],
                               'lang' => [
                                           'en'
                                         ],
                               'instId' => [
                                             '12345'
                                           ],
                               'ipAddress' => [
                                                '207.135.43.234'
                                              ],
                               'compName' => [
                                               'Ultranerds'
                                             ],
                               'desc' => [
                                           'Test (Lifetime)'
                                         ],
                               'fax' => [
                                          ''
                                        ],
                               'authCurrency' => [
                                                   'USD'
                                                 ],
                               'transId' => [
                                              '82242364'
                                            ],
                               'email' => [
                                            'andy@ultranerds.com'
                                          ],
                               'country' => [
                                              'GB'
                                            ],
                               'rawAuthCode' => [
                                                  'A'
                                                ],
                               'cartId' => [
                                             '4ae9e2db6559bb7e'
                                           ],
                               'countryMatch' => [
                                                   'B'
                                                 ],
                               'transTime' => [
                                                '1092994915061'
                                              ],
                               'authAmountString' => [
                                                       'US$45.00'
                                                     ],
                               'transStatus' => [
                                                  'Y'
                                                ],
                               'amount' => [
                                             '45.0'
                                           ],
                               'msgType' => [
                                              'authResult'
                                            ],
                               'name' => [
                                           'A.J.Newby'
                                         ],
                               'authCost' => [
                                               '45.0'
                                             ],
                               'countryString' => [
                                                    'United Kingdom'
                                                  ],
                               'currency' => [
                                               'USD'
                                             ],
                               'AVS' => [
                                          '0000'
                                        ],
                               'callbackPW' => [
                                                 'sufgk49Wi3'
                                               ],
                               'amountString' => [
                                                   'US$45.00'
                                                 ],
                               'authAmount' => [
                                                 '45.0'
                                               ],
                               'rawAuthMessage' => [
                                                     'cardbe.msg.testSuccess'
                                                   ],
                               'cardType' => [
                                               'Visa'
                                             ],
                               'address' => [
                                              'ogj pgwe
tjwt
wetwet'
                                            ],
                               'tel' => [
                                          '01403 123123'
                                        ]
                             },
                 'p' => '',
                 'nph' => 0,
                 '_debug' => 0,
                 'cookies' => {},
                 'data_loaded' => 1
               }, 'GT::CGI' );


Unsure

This is why I'm so confused. The script is running ok, sending me the email, and it even seems to be updating the lsql_Payments table (setting payment_status to 3).

The only thing I can, which could be the problem, is;

Quote:
GT::SQL::Driver::MYSQL::sth (15085): Executing query: INSERT INTO lsql_PaymentLogs (paylogs_type,paylogs_time,paylogs_text,paylogs_payments_id,paylogs_id) VALUES (3,1092991211,'
','c6988b232bc31a0b',NULL) from Links::Payment::Remote::WorldPay::__ANON__ at /home/.../admin/Links/Payment/Remote/WorldPay.pm line 213

I can send over FTP/SSH details if required (my head is just about ready to explode with this one Pirate).

TIA

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!