I'm still having problem :(
Doing a "tail" on the Perl error_log, gives me;
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 ).
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!
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 ).
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!