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;
'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' );
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;
','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
).
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!
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' );
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
). 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!
