If this is your first visit, check our documentation. To post, register or login.
Forums / Addon Payment Modules / Old finnish module contribution to 1.3.6

Old finnish module contribution to 1.3.6

Locked

Started by buzzy on 27 Jan 2007, 12:15 PM · Views: 2,914

Results 1 to 17 of 17
This thread is locked. New replies are disabled.
27 Jan 2007, 12:15 PM
#1
buzzy avatar

buzzy

New Zenner

Join Date:
Nov 2006
Posts:
28
Plugin Contributions:
0

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

27 Jan 2007, 3:09 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Old finnish module contribution to 1.3.6

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

Zen-Venom Get Bitten

27 Jan 2007, 5:57 PM
#3
buzzy avatar

buzzy

New Zenner

Join Date:
Nov 2006
Posts:
28
Plugin Contributions:
0

Re: Old finnish module contribution to 1.3.6

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.

31 Jan 2007, 8:35 AM
#4
buzzy avatar

buzzy

New Zenner

Join Date:
Nov 2006
Posts:
28
Plugin Contributions:
0

Re: Old finnish module contribution to 1.3.6

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

31 Jan 2007, 3:30 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Old finnish module contribution to 1.3.6

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.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

1 Feb 2007, 10:15 AM
#6
buzzy avatar

buzzy

New Zenner

Join Date:
Nov 2006
Posts:
28
Plugin Contributions:
0

Re: Old finnish module contribution to 1.3.6

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

1 Feb 2007, 11:16 PM
#7
bunyip avatar

bunyip

Totally Zenned

Join Date:
Sep 2004
Location:
Western Massachusetts
Posts:
2,361
Plugin Contributions:
1

Re: Old finnish module contribution to 1.3.6

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

Neville
An assumption is what you arrive at when you get tired of thinking...

9 Mar 2007, 9:39 AM
#8
buzzy avatar

buzzy

New Zenner

Join Date:
Nov 2006
Posts:
28
Plugin Contributions:
0

Re: Old finnish module contribution to 1.3.6

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

28 Mar 2007, 6:31 AM
#9
buzzy avatar

buzzy

New Zenner

Join Date:
Nov 2006
Posts:
28
Plugin Contributions:
0

Re: Old finnish module contribution to 1.3.6

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

15 May 2007, 2:34 PM
#10
buzzy avatar

buzzy

New Zenner

Join Date:
Nov 2006
Posts:
28
Plugin Contributions:
0

Re: Old finnish module contribution to 1.3.6

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

Still stuck with this thing. Anyone?

15 May 2007, 3:30 PM
#11
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Old finnish module contribution to 1.3.6

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

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

15 May 2007, 6:58 PM
#12
buzzy avatar

buzzy

New Zenner

Join Date:
Nov 2006
Posts:
28
Plugin Contributions:
0

Re: Old finnish module contribution to 1.3.6

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"]
15 May 2007, 7:51 PM
#13
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Old finnish module contribution to 1.3.6

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.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

16 May 2007, 7:30 AM
#14
buzzy avatar

buzzy

New Zenner

Join Date:
Nov 2006
Posts:
28
Plugin Contributions:
0

Re: Old finnish module contribution to 1.3.6

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.

16 May 2007, 8:55 AM
#15
buzzy avatar

buzzy

New Zenner

Join Date:
Nov 2006
Posts:
28
Plugin Contributions:
0

Re: Old finnish module contribution to 1.3.6

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.

16 May 2007, 1:16 PM
#16
buzzy avatar

buzzy

New Zenner

Join Date:
Nov 2006
Posts:
28
Plugin Contributions:
0

Re: Old finnish module contribution to 1.3.6

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.

24 Jul 2007, 8:56 PM
#17
buzzy avatar

buzzy

New Zenner

Join Date:
Nov 2006
Posts:
28
Plugin Contributions:
0

Re: Old finnish module contribution to 1.3.6

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