Jump to content
Sign in to follow this  
Deanna

"Confirm Order" Error at checkout.

Recommended Posts

I am using psiGate. I am trying to do a test transaction. I can get through to the confirmation page but when I press "Confirm Order" at the bottom of the page I get this code:

 

1146 - Table 'holly11_osc1.psigate_xml' doesn't exist

 

insert into psigate_xml (id, customer_id, osc_order_id, psi_order_id,

transaction_time, approved, return_code, error_message, trans_ref,

cvv_result, avs_result, card_auth, card_ref, ip_result, ip_country,

ip_region, ip_city) values ('', '', '', '2005101620390008891', 'Sun Oct 16

20:39:00 EDT 2005', 'APPROVED', 'Y:TEST:TESTTRANS:M:X:NNN', '',

'1bd38d4cdde8183b', 'M', 'X', 'TEST', 'TESTTRANS', 'NNN', 'UN', 'UNKNOWN',

'UNKNOWN')

 

[TEP STOP]

 

What does this mean?? and how do I get rid of it?

 

Thank you.

Share this post


Link to post
Share on other sites

It's trying to insert a record of the transaction into your database, but the database table 'psigate_xml' doesn't exist. There's probably a .sql file in the psigate installation that you forgot to import into your database.


Please use the forums for support! I am happy to help you here, but I am unable to offer free technical support over instant messenger or e-mail.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×