Old finnish module contribution to 1.3.6

[buzzy]

Hi! I tried to intall finnish bank gateways to my zencart v 1.3.6. That contribution is really old, but I decided to test if I could somehow get it work. Everything else goes fine, but I get error

1146 Table 'mydatabase.MOD_FI_BANK_ID' doesn't exist
in:
[SELECT id FROM MOD_FI_BANK_ID WHERE referid="0" AND session_id="fea02e9f7e9f7b82ae5902c616965d36"]

Does someone get any ideas is there something I can do to correct this?

The error occures at index.php?main_page=checkout_confirmation

thanks

[kobra]

With this older module was there also a mysql update to create this table? and did you try to apply it?

[buzzy]

Yes there was and I applied it from the admin. I also tried to apply it throug phpMyadmin, but the same error occures both ways. Prefix is also ok.

[buzzy]

Anyone have any ideas? It seems that many have had this same 1146 -error with other modules too. What confuses me is that I have the table installed with right prefix but still the mod doesn't find it....

[DrByte]

Please post the contents of the SQL update that you used to install the table.

Tables are case-sensitive, and are VERY SELDOM in all uppercase. It suggests that either you've incorrectly installed the SQL, or perhaps you're missing a constant defined to point to the actual table name.

[buzzy]

The content of the sql file is:

CREATE TABLE `zenmod_fi_bank_id` (
`id` int(5) unsigned zerofill NOT NULL auto_increment,
`orders_id` int(11) NOT NULL default '0',
`referid` bigint(20) NOT NULL default '0',
`session_id` varchar(32) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM


My database shows that I have a table there called: kauppa_zenmod_fi_bank_id

kauppa_ is my prefix

[bunyip]

looks like the cart is missing the define statement for the database table name. In the folder includes/extra_datafiles/ is there a file that has the database table definition in it?

define('MOD_FI_BANK_ID', DB_PREFIX . 'zenmod_fi_bank_id');

[buzzy]

Hi there and sorry that I haven't answered earlier... i have been really busy and on the road for 6 weeks now...

In the folder includes/extra_datafiles/ I do not have any file with that definition. There's only database_tables.php -file with this line define('TABLE_MOD_FI_BANK_ID', DB_PREFIX . 'zenmod_fi_bank_id');

[buzzy]

I haven't been able to make this work yet. Anyone have any ideas?

[buzzy]

My last cry for help, 'cause nobody seems to know the solution and I got no answer myself...

Still stuck with this thing. Anyone?