Database tables differing

[nmcgowan]

I am trying to connect epdq and zen-cart(linux) together and am getting problems. My colleague has received some epdq modules files that appear to work but they reference differing tables that exists on the actual mysql database.

The code is referencing a table named tblTransLog however this does not appear on the database, all the tables are prefixed with zen and the closest i can find to transactions is zen_orders but this has differing fields.

I am not sure whether the epdq module is for a previous version of zen-cart or a differing OS.

Please can someone help or supply me with the correct epdq module files. Thanks

[kobra]

Table names have not been altered appreciably for some time - does not sound as though this is even designed for Zen Cart

[nmcgowan]

Table names have not been altered appreciably for some time - does not sound as though this is even designed for Zen Cart

This is the code that is contained in the module i downloaded from this site

$transLog = mysql_query("select * from tblTransLog where invoiceID = '".$stransID."'");

$row_transLog = mysql_fetch_assoc($transLog);

It was in the epdqresponse.php file.

[kobra]

This is the code that is contained in the module i downloaded from this site

What module?

[nmcgowan]

What module?

Basically i am receiving these error messages when completing the payment on epdq site and it refers back to my zen-cart site.

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/.sites/123/site19/web/store/epdq_response.php on line 30

Warning: Cannot add header information - headers already sent by (output started at /home/.sites/123/site19/web/store/epdq_response.php:30) in /home/.sites/123/site19/web/store/epdq_response.php on line 56

These are the instructions i am trying to make sense of

Originally posted by dreamstudio@Dec 22 2005, 12:00 PM


$transLog = mysql_query("select * from tblTransLog where invoiceID = '".$stransID."'");

$row_transLog = mysql_fetch_assoc($transLog);

The line above the one you placed in bold here selects the record from the transactions table that corresponds to the order.

If you use phpMyAdmin to look at your Zen Cart database you should be able to see what the transactions table is called in your database. For example it may have a prefix such as zen_ added to it when the table was created, so it would be called zen_tblTransLog.

Change the name of tblTranslog in this file and epdqresponse.php so that it is the same as the name of this table in your database.

Whatever prefix you added to the orders tables as instructed in the read me for the epdq module should be the same as that required here, eg zen_ .

Keiran

[kobra]

Great!!! What module?

[nmcgowan]

Great!!! What module?

It was posted by a member on here, however the link has since been broken. I have the zip file on my works pc and can supply you tomorrow. It was a zip that contained all the php files in order to connect epdq and zen-cart. Below is the thread

Hi,

I wanted to reply here but I couldn't....

http://www.zen-cart.com/forum/showthread.php?t=11765

I made some modification to this module so yopu donc need to customize the database, URL to the php files. Now it includes the includes/configure.php and find it itself.

http://www.indule.fr/epdq.zip

It is a very simple update but it makes it even simpler to install !

Thanks,

Gerome.romey(at)medea.co.uk

[kobra]

This is the code that is contained in the module i downloaded from this site
and
posted by a member on here

are completly different animals.

Best that you contact the author if possible - I suspect there is a reason that it is not in the ACTUAL downloads section of this site.

[nmcgowan]

are completly different animals.

Best that you contact the author if possible - I suspect there is a reason that it is not in the ACTUAL downloads section of this site.

Do you know who i can contact or how or i can get the epdq files to connect to my zen-cart. The epdq support team are being very unsupportive.

[gjh42]

You are working from two-year-old posts... I don't know if anybody involved is still around, except possibly Gerome Romey who I believe has the Multisite Module. You might ask on his thread to get his attention (if it is the same person). You can look up usernames as well as anyone else can, so try getting their contact info from their profiles.