[ic] Protx issues

[Michael Curtis]

Hi all

FreeBSD 6.0
IC 5.4
Mysql
Protx 1.0.9f

Configuring the Standard store for Protx Payment Gateway using Lynn StGeorges module and instructions

All went well until I tried to create the new transactions table

I copied the new transactions.txt to the correct location
I copied the new transactions.mysql to the correct location
I deleted .transactions.sql

Then restarted Interchange

Errors are that generated are:
Snip...................
> sync2 varchar(128),
> protx1 varchar(128),
> protx2 varchar(128),
> protx3 varchar(128)
> )
> 
- - - [11/December/2006:22:54:50 +0000] - - table transactions index failed: Table 'test_standard.transactions' doesn't exist
- - - [11/December/2006:22:54:50 +0000] - - DBI: Post creation query 'CREATE  INDEX transactions_order_number ON transactions (order_number)' failed: Table 'test_standard.transactions' doesn't exist
- - - [11/December/2006:22:54:50 +0000] - - table 'transactions' failed: list_fields execute on transactions: Table 'test_standard.transactions' doesn't exist at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1752.

I have been over all file permissions etc and they are all o.k

If I roll back to the standard transaction files the standard transaction table is created and all is o.k

I could create the table by creating a .sql and importing that but I do not know if that may create other problems

TIA

Mike Curtis



-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.15.16/582 - Release Date: 11/12/2006 16:32