Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

"Confirm Order" Error at checkout.


Deanna

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.

Link to comment
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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...