MerchantAnywhere/TC Module Problem?

[ArfArf]

I'm running Zen 1.3.8 and installed the Transaction Central (MerchantAnywhere) module for 1.3.8 (v.2.3). Admin/Modules/Payment install appeared to go ok with no problems.

However when I go to Admin/Customers/Transaction Central Orders I receive the following error:
----------------
1050 Table 'tc_transactions' already exists
in:
[CREATE TABLE tc_transactions (zen_tct_id mediumint(9) NOT NULL auto_increment,zen_tct_oid mediumint(9) NOT NULL default '0',zen_tct_transid bigint(20) NOT NULL default '0',zen_tct_AuthCode mediumint(9) NOT NULL default '0',zen_tct_AVSResponse varchar(255) NOT NULL default '0',zen_tct_CVV2Response varchar(255) NOT NULL default '0',zen_tct_Notes varchar(255) NOT NULL default '0',zen_tct_status varchar(255) NOT NULL default '0',PRIMARY KEY (zen_tct_id))]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
-----------------
For the heck of it I deleted the offending table (tc_transactions) and received a similar error, now beginning with the the phrase "1050 Table 'tc_transactions' does not exist."

Any ideas? I'm a little hesitant to go live until I can nail this down - thanks!

[ArfArf]

Found it! Commenting out the following section of transactioncentral_orders_functions.php at admin/includes/functions/extra_functions seems to work fine BUT you'll need to make sure that you first install the Transaction Central module under admin/modules/payment in order to create the table tc_transactions.

        ### Check to see if the Database is already installed...
//        $check_for_tc_db = $db->Execute("SHOW TABLES FROM " . DB_DATABASE . " LIKE '" . DB_PREFIX . "tc_transactions'"); 
//        $TCDBCheck = $check_for_tc_db->fields["Tables_in_zencart (zen_tc_transactions)"];
//
//        if(!$TCDBCheck){
//            ### No Database is currently installed.
//            if(!$install){
//           return false;
//           }else{
//            ### Install Database
//            $db->Execute("CREATE TABLE " . DB_PREFIX . "tc_transactions (zen_tct_id mediumint(9) NOT NULL auto_increment,zen_tct_oid mediumint(9) NOT //NULL default '0',zen_tct_transid bigint(20) NOT NULL default '0',zen_tct_AuthCode mediumint(9) NOT NULL default '0',zen_tct_AVSResponse //varchar(255) NOT NULL default '0',zen_tct_CVV2Response varchar(255) NOT NULL default '0',zen_tct_Notes varchar(255) NOT NULL default //'0',zen_tct_status varchar(255) NOT NULL default '0',PRIMARY KEY (zen_tct_id))");
//           return true;
//           }
//        }else{
//           return true;
//        }
} 

In addition, the same file attempts to run a query against a non-existent table zen_tc_transactions in the following section. It should reference the valid table tc_transactions:

  function zen_get_tc_transID($RefID) {
    global $db;
    $transaction = $db->Execute("SELECT zen_tct_oid ,zen_tct_transid ,zen_tct_AuthCode ,zen_tct_AVSResponse ,zen_tct_CVV2Response FROM zen_tc_transactions WHERE zen_tct_oid = '$RefID'");

    return $transaction->fields['zen_tct_transid'];
  } 

The mysterious table zen_tc_transactions is also referenced in includes/modules/payment/merchantanywhere.php & should probably be changed to tc_transactions there too.

The Invoice and Packing Slip links still won't function, but I can get those from the regular Orders module. Hope this helps someone!