[Support Thread] Nochex APC

[Ned]

Hi,

I seem to be having a few issues with the NOCHEX apc modules at the moment.

I am using a merchant account.

I have been getting the following error via the APC debug emails:

APC FATAL ERROR::Could not establish fsockopen. Host Details = ssl://www.nochex.com:443

I thought I had fixed it by editing the nochex_handler_apc.php and changing the callback url to use http rather than https.

Test orders now go through fine without issue.


However live orders do not seem to get posted back to zen cart properly. I get redirected the the checkout success page and an order number is generated ok but it will not add any products into the order.

Everything seems fine on the order apart from it being void of products. Total cost/shipping e.t.c are all recorded ok.

Does anyone have any ideas on how I can fix this?

Thanks in advance.

[CJPinder]

Hi,

Everything seems fine on the order apart from it being void of products. Total cost/shipping e.t.c are all recorded ok.

Two things to check....
1. In Admin, look under Modules... Order Total ... check that Total ot_total is installed and active.
2. Upload the NoChex Payment Module in the attached zip file (v1.2.1) and try orders again. I'll know that you are using the exact same files that I am then and we can go from there.

Regards,
Christian.

[Ned]

Hi Christian,

Thanks for helping.

The ot_total module is installed and active.

I've uploaded the files in the zip and tried again.


I ran through a test transaction and a live transaction and I got this message:

APC FATAL ERROR::Could not establish fsockopen. Host Details = ssl://www.nochex.com:443

In the APC debug emails, and it has not put the order into the database at all.


I then edited the nochex_apc_handler.php (I'll change this back after testing so we are on the same files).

I've changed:

$callback_url = "https://www.nochex.com/nochex.dll/apc/apc";

to

$callback_url = "http://www.nochex.com/nochex.dll/apc/apc";

Ran through a test transaction and everything went though fine, order all ok in zen cart, products listed in the order.

Next I tried a live transaction, everything went through fine, except that the order shows no products so no difference really.

When doing the live test it doesn't seem to append the comments of the order with the "nochex payment received" message either.

[Ned]

Its very strange that it works fine for test transactions but not live ones.

Its almost if it is not processing these lines on live orders:

zen_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array);
$order->create_add_products($insert_id, 2);
$order->send_order_email($insert_id, 2);

but looking at the code I can't see why that would be the case, I know php but unfamiliar with zencart and how modules e.t.c work.

[CJPinder]

Hi,

I ran through a test transaction and a live transaction and I got this message:

APC FATAL ERROR::Could not establish fsockopen. Host Details = ssl://www.nochex.com:443

Looks like your host does not have SSL compiled into your PHP or is somehow blocking the outgoing SSL connection. Probably something you should talk to your host about (or change host).

I've changed:
$callback_url = "https://www.nochex.com/nochex.dll/apc/apc";
to
$callback_url = "http://www.nochex.com/nochex.dll/apc/apc";

AFAIK, NoChex support both SSL and Non-SSL connections back for APC so that should work but it is not something I have tried before.

Ran through a test transaction and everything went though fine, order all ok in zen cart, products listed in the order.

Next I tried a live transaction, everything went through fine, except that the order shows no products so no difference really.

Do you have PayPal IPN installed? The original NoChex APC module author based it on the PayPal IPN module and I think there are still some dependencies in there. If PayPal IPN is not installed and enabled could you do so and try again.

Regards,
Christian.

[Ned]

Fixed.

The PAYPAL IPN wasn't installed.

I've now installed it and set it to false (I don't want to take paypal yet).

It is now working.



Many thanks Christian, if you PM me your paypal email i'll send you a couple of beers :)

[CJPinder]

Fixed.
The PAYPAL IPN wasn't installed.

Cool. I tried removing the PayPal IPN dependencies in a previous version but I had a report that doing so caused the exact problem you've been experiencing. I'll have another go.

I've now installed it and set it to false (I don't want to take paypal yet).

It is useful to have PayPal as an alternative card handler as NoChex has been known to randomly decline valid cards. I think PayPal UK have fixed the PayPal Account Optional setting as well now.

It is now working.

Many thanks Christian, if you PM me your paypal email i'll send you a couple of beers :)

Glad it is now working for you. Thank you for the kind offer of the beers, better to send some coffee to the Zen Cart team though. They are powered by Coffee apparently. Especially Linda, have you seen the number of posts she makes each day? Must be drinking the extra strong stuff

Regards,
Christian.

[Ned]

I shall send them a few coffees on your behalf :)

I'm using google checkout as an alternative, i've had very bad experiences with paypal just refunding customers willy nilly without any seller support at all.

[e-hol.co.uk]

Hi, guys I noticed some other posts with this error and apparently it worked after adding the 2 lines to the database_tables.php file in /includes. I have already added the values to the file under the last define and have executed the SQL in nochex_apc.sql to create the 2 tables via phpmyadmin and am having the following problem.

When trying to process a transaction through this module (Nochex apc 1.2) I get to step 3 of 3 (order confirmation) then at the bottom where confirm order button usually is it says:

1146 Table 'debiryin_zc1.zen_nochex_sessions' doesn't exist
in:
[delete from zen_nochex_sessions where session_id = '40f56a65ebccd1340e33cddd8a74cb43']

I have configured the module as follows:

Enable Nochex Module
True

Nochex Email Address
[email protected]

Nochex Account Type
Seller

Merchant ID


Payment Zone
--none--

Set Pending Notification Status
Pending [1]

Set Order Status
Pending [1]

Sort order of display.
0

Debug Mode
Log File

Status Live/Testing
Test

If it helps I installed Zencart through cpanel.


I would really appreciate your help as it is a clients site.


Thanks very much for your time,

Ian

[PGlad]

Hi, I've installed the Nochex mod and things appear to work fine. I would like to add my logo to the Nochex checkout page though as described on their site:

[FONT=Arial]Logo parameter [/FONT]

This is an optional parameter that can be used to customize the NOCHEX checkout page to include your companies logo.

Example:
logo=https://www.nochex.com/web/images/test_logo.gif
Please can anyone tell me if I can do this and how to go about it?