Payment Module Error (SQL Patch Problem)

[tmcashan]

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...

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.

[DrByte]

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...

1146 Table 'heartdb.transfirst_epay' doesn't exist

1. When you say "There was an error in installation regarding configuring the database.", what error message did you see?

2. Did you run any SQL Patch code?

3. How did you install the module?

4. What happens if you put this into the SQL patch screen and click Send ?

CREATE TABLE transfirst_epay (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, 
`customer_id` INT(11) DEFAULT '0' NOT NULL, 
`order_id` INT(11) DEFAULT '0' NOT NULL, 
`trans_code` INT(2) DEFAULT '0' NOT NULL, 
`seq_num` INT(8) DEFAULT '0' NOT NULL,
`trans_status` VARCHAR(2) NOT NULL,
`ref_num` VARCHAR(14) NOT NULL,
`auth_resp_code` VARCHAR(6) NOT NULL,
`auth_source_code` INT(1) DEFAULT '0' NOT NULL,
`auth_char_ind` INT(1) DEFAULT '0' NOT NULL,
`trans_id` VARCHAR(15) NOT NULL,
`valid_code` VARCHAR(4) NOT NULL,
`avs_resp_code` VARCHAR(1) NOT NULL,
`sent` LONGTEXT NOT NULL,
`received` LONGTEXT NOT NULL,
`time` VARCHAR(50) NOT NULL,
`session_id` VARCHAR(255) NOT NULL,
UNIQUE (`id`));