Old finnish module contribution to 1.3.6

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

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

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.

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

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.

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

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');

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');

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

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

Still stuck with this thing. Anyone?

Creating a file, based on bunyip's info will get you a step further.

In extra_datafiles there is now a file with definition ```
define('TABLE_MOD_FI_BANK_ID', DB_PREFIX . 'zenmod_fi_bank_id');

But still same problem... I get error :

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

bunyip:

define('[B]MOD_FI_BANK_ID[/B]', DB_PREFIX . 'zenmod_fi_bank_id');

> **buzzy:**
>
> In extra_datafiles there is now a file with definition ```
define('[B]TABLE_MOD_FI_BANK_ID[/B]', DB_PREFIX . 'zenmod_fi_bank_id');
```. 
> 
> But still same problem... I get error :
> 
> 1146 Table 'mydatabasename.**MOD_FI_BANK_ID**' doesn't exist

Perhaps you can remove the "TABLE_" portion.

The module is poorly written in that it doesn't appear to use the standard constant naming conventions. Making the change above should get you closer to success.

Perhaps I should get myself a pair of new eyes or at least glasses... I've been working around these files for so long now that I never noticed that one little word there.

I can't say it works perfectly now, but I sure am closer. Thank you! I report you after the module is fully working and tested.

Oh yes, it works almost perfectly. There's only one small problem left to solve:

The idea is that customer pays only 10% of the price as a reserve payment when ordering. I'm using quantity discount to calculate this (customer always gets -90% discount). Now the bank module wants to charge the whole amount, not this 10%. I'll have to figure out how to make this work and then it's ready.

After searching from forums I found this http://www.zen-cart.com/forum/showthread.php?t=32641&highlight=discount+bank

I probably have the same problem. I will start checking the paypal module and compare it to my bankmodule. I hope I'll find something.

If someone has already done this I would be happy to get some help, 'cause my PHP skills are limited.

I still haven't found any solution to my problem, so any help would be great...