Results 1 to 2 of 2

Threaded View

  1. #1
    Join Date
    Apr 2007
    Posts
    6
    Plugin Contributions
    0

    Default Payment Module Error (SQL Patch Problem)

    Here is the error...

    I have setup the latest version of zen cart and attempted to install the latest downloadable transfirst payment module. There was an error in installation regarding configuring the database.

    Now when i go to checkout i receive this...


    Code:
    1146 Table 'heartdb.transfirst_epay' doesn't exist
    in:
    [insert into transfirst_epay (id, customer_id,order_id, trans_code, seq_num, trans_status, ref_num, auth_resp_code, auth_source_code, auth_char_ind, trans_id, valid_code, avs_resp_code, sent, received, time, session_id) values ('', '1', '3', '32', '00000000', '00', '', '999999', '9', '9', '999999999999999', '9999', '9', 'ePayAccountNum=blah&password=blah&transactionCode=32&orderNum=3&customerNum=1&transactionAmount=254.00&cardAccountNum=4111111111111111&expirationDate=1110&cardHolderZip=33333&TaxIndicator=2&TotalTaxAmount=0.00&cardHolderName=T+McAshan&cardHolderAddress=22+RR+99+N.+Apt.+%11&cardHolderCity=Austin&cardHolderState=Texas&cardHolderPhone=512-215-4236&cardHolderEmail=travis%blah.com&CVV2=123&ECommerce=Y&testTransaction=A&DuplicateChecking=Y&InstallmentNum=01&PaymentDescriptor=HM', 'R1|blah|32|00000000|1|4111111111111111|1110|25400|1212121|232323|00|1|3||999999|9|9|999999999999999|9999|9999|999|9| |99|||000|99|||', 'April 10, 2007, 5:51 pm', '010df3b32323233f43a8fc1111ab3ede')]
    Can anyone shed light or assist me in the problem. I am assuming that it is something to do with the SQL patch not updating the database properly. I spoke with my Transfirst representative and she said that the payment processed. So it looks like just a database problem. Pretty much that the site is trying to write information into a DB table that isn't there.

    Thanks you tremendously in advance for anyone willing to assist me. The zen cart system is great and I really enjoy all the devoted programmers.
    Last edited by DrByte; 12 Apr 2007 at 10:50 AM. Reason: removed personal information

 

 

Similar Threads

  1. v150 Error installing unwishlist SQL patch...
    By doooomed in forum Customization from the Admin
    Replies: 2
    Last Post: 27 Dec 2012, 02:29 PM
  2. v139h DB/SQL Error when using SQL Patch for Add Pages More Info Sidebox addon
    By maperr55 in forum All Other Contributions/Addons
    Replies: 6
    Last Post: 5 Mar 2012, 09:32 PM
  3. SQL patch error
    By bishop999 in forum Built-in Shipping and Payment Modules
    Replies: 4
    Last Post: 17 Jul 2008, 08:32 AM
  4. SQL Patch Error
    By arcanesanctuary in forum General Questions
    Replies: 6
    Last Post: 23 Jan 2007, 11:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg