2CheckOut for Zen 1.3.0.2 Released

Solution to my problem: in includes/modules/payment/as2checkout.php I had to change HTTPS_SERVER to HTTP_SERVER (around line 181), as we aren't using SSL for this site.

Hello, I am having trouble installing 2checkout payment module. Your help would be appreciated.


I am using Zen Cart 1.3.6.


I've copied the following files to the corresponding directories:

process_2checkout.php - (root folder, the rest of the folder below sit within the cart folder)
includes/modules/payment/as2checkout.php
includes/languages/english/modules/payment/as2checkout.php
includes/extra_configures/as2checkout_defines.php


but when I tried to run SQL patch from Zen Cart admin, it gave me this error ;

"ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate latin1_general_ci NOT NULL default '' ,


I found a slightly different SQL patch (below) from this forum, and run it again, and it seems to have worked without any errors;


CREATE TABLE `2checkout` (
`2co_id` int(11) NOT NULL auto_increment,
`start_time` datetime NOT NULL default '0000-00-00 00:00:00',
`finish_time` datetime NOT NULL default '0000-00-00 00:00:00',
`status` varchar(50) NOT NULL default '',
`return_md5` text NOT NULL,
`amount` float NOT NULL default '0',
`2co_order_id` int(11) NOT NULL default '0',
`session_id` varchar(50) NOT NULL default '',
PRIMARY KEY (`2co_id`)
) ENGINE=MyISAM;



But now the problem is that when I go to the Payment Module menu, it gives me this message,


Cannot redeclare class as2checkout in /homepages/25/d200017079/htdocs/includes/modules/payment/as2checkout.php on line 23


I searched this forum and it seems this error message is for Zen Cart install prior to v1.3 but I am using 1.3.6.


Please help!

Does anyone found the workable solution for the currency conversion bug at the 2CO module?


the default currency in my cart and in 2co admin is in USD
while my cart support other currencies such as GBP.

For a buyer checkout a product in value GBP13.14 (Default USD is $25.75 Total: ), the 2CO payment page shown up in USD 50.46

the zen cart conversion pass to 2CO for almost double than should be.

my paypal module is working fine, so this must be something to do with the code of this module

does anyone knows the solution to this bug ?

please help

thanks

Hi serigold,

how did you configure values of USD and GBP?

regards,
kruna

Hi Kruna;

Thanks for your reply.

So certainly there are some a bugs in the code of this module.

For those having the same currency conversion problem, to fix this one, we have commented in line 128( adding //) of /includes\modules/payment/as2checkout.php

and that's it, is working fine now , including enable currency conversion.

Hi,

After installing the 2checkout payment module and running the sql, I am having the following problems on my homepage:
Warning: Variable passed to each() is not an array or object in /home/dealbyet/public_html/includes/classes/db/mysql/query_factory.php on line 114
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCT' at line 6
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from zen_products p, zen_products_description pd where to_days(products_date_available) > to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

I read some threads, dropped the previous 2checkout table and run the following sql script. However the problems persist.
CREATE TABLE `2checkout` (
`2co_id` int(11) NOT NULL auto_increment,
`start_time` datetime NOT NULL default '0000-00-00 00:00:00',
`finish_time` datetime NOT NULL default '0000-00-00 00:00:00',
`status` varchar(50) NOT NULL default '',
`return_md5` text NOT NULL,
`amount` float NOT NULL default '0',
`2co_order_id` int(11) NOT NULL default '0',
`session_id` varchar(50) NOT NULL default '',
PRIMARY KEY (`2co_id`)
) ENGINE=MyISAM;

Did your hosting company recently upgrade you to PHP 5 ?
If so, then this will likely help: http://www.zen-cart.com/forum/showthread.php?t=67521

Hi DrByte,

Thanks for your response. No, my hosting company hasn't upgraded me to php5. The php version I have is 4.4.4. Any suggestion?

Then try this:
http://www.zen-cart.com/forum/showpo...357#post378357

Hi DrByte,

The problem I had previously seems to have disappeared. However, when I checkout using 2checkout, I get the following a Parameter Error. What did I do wrong?