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

check your database ... does the table exist?

 

psigate_xml

 

if not, you have to check if there was a file with it you need to run

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...