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.
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;
The Team Behind DealByEthan.com | Curating unique finds for a discerning community. Committed to a seamless and inspiring shopping experience. Connect with us: https://linktr.ee/dealbyethan
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
.
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.
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?
The Team Behind DealByEthan.com | Curating unique finds for a discerning community. Committed to a seamless and inspiring shopping experience. Connect with us: https://linktr.ee/dealbyethan
Then try this:
http://www.zen-cart.com/forum/showpo...357#post378357
.
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.
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?
The Team Behind DealByEthan.com | Curating unique finds for a discerning community. Committed to a seamless and inspiring shopping experience. Connect with us: https://linktr.ee/dealbyethan
Bookmarks