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?