Help with Nochex

Hi I've used Nochex for years without a problem but I'm beginning to get fed up with having to manually add the customers details from the email I receive from nochex after payment has been made. I know what's been ordered but I was wondering if I could get Nochex to fill in the address, phone number and email address of the customer like paypal does?

Any ideas appreciated

Thanks

Kerrie

Hi

I'm using Zen Cart 1.3.9 and with cPanel and have installed the Nochex module. The site has not yet got my products set up - I am brand new to this and getting thoroughly confused. I've entered one product that I can test. When testing the module I get a message at the checkout page stating

1146 Table 'thelairc_db1.nochex_sessions' doesn't exist
in:
[delete from nochex_sessions where session_id = '']

I have followed the instructions and don't know where I've one wrong or where to go to rectify this.

Please, please help ::dontgetit

Thanks

I am getting this error on checkout:

"1146 Table '******_0Kqsqze.iusw_nochex_sessions' doesn't exist
in:
[delete from iusw_nochex_sessions where session_id = 'f09adedd67416ec8a9d2ed1df64dd9a5']

The problem is that the tables created in by the nochex SQL patches were created WITHOUT the iusw prefix whereas all my other tables have the isuw prefix.

I am not sure whether the tables ere created with the wrong name, whether I have some old files that not get replaced or something else is wrong. Any ideas?

Use phpmyadmin and rename the table to include/match your other tables

Thanks. That was my first thought but then I had doubts.

Seems to work OK in text mode so now to see if it works when I go live.

This looks like the same problem that I had. Either you do not have the Nochex tables installed OR like me they have the wrong names.

If you have phpmyadmin, then check your databases. Do you have

nochex_apc_transactions & nochex_sessions

listed as tables in your database?

If not then you need to install them.

If you install them or they are already there and you still have the problem, check that they have the same prefix as your other tables.

i.e. myprefix_nochex_apc_transactions & myprefix_nochex_sessions

Then while in test mode, run through the checkout process again.

Good luck

Is no one else having these problems, I've noticed there's Nochex support hanging around on this forum which is great do they have a solution?

That worked OK in test and live mode but now I have the problem that there are no transaction details showing in the Nochex emails for either admin or the customer.

I'll keep trying but in the meantime if anyone has any ideas then thanks in advance.

OK I have just looked in orders and found the following error message:

"1054 Unknown column 'zen_order_id' in 'where clause'
in:
[select * from iusw_nochex_apc_transactions where zen_order_id = '18' order by nochex_apc_id DESC LIMIT 1]"
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Now a I understand it the name of the field zen_order_id changed to order_id from ZC V1.3.8.

So I have a query being generated that is trying to operate on a non-existent field.

Does anyone know where this query comes from?

zen_ is a table prefix not a change in the DB between versions

Plain vanilla is order_id

kobra:

zen_ is a table prefix not a change in the DB between versions

Plain vanilla is order_id

I was told that in the past the field was called zen_order_id and that it changed later to order_id.

I used the developer's toolkit and found references to zen_order_id in a number of payment modules, including nochex and paypal.

I edited the nochex_apc.php file and now error message has gone.
The original problem remains however.

Transaction details i.e. products ordered are not shown on the Nochex emails and the customer is sent back to the shop before the Nochex success message can be read or printed.

It worked - thanks for all the help.:clap:

Sorry to keep posting but am finding things out as I go and I hope it helps others.

This shop was installed some time ago and has gone through several ZC upgrades. I am only now using it in earnest.

It seems that a lot of old code is hanging around and this is what is causing my problems. The Old code is also in the paypal modules and as I plan to offer this at a later date, I will tackle those then.

I am not sure whether I should reinstall all the Nochex Modules or keep working through. The system works in that can take payment but the description of the purchase is missing for the customer and in the admin email from Nochex.

Why use Nochex? Just my opinion but for the UK, better rates than PayPal and I had a nasty experience with a chargeback with PayPal.

karinascott:

It worked - thanks for all the help.:clap:
Glad that worked Karina. Are you getting all the info back from Nochex.

The bit in the email that says TRANSACTION DETAILS?

Running v1.3.8a

Running Nochex in Test mode I get the order confirmation, emails etc BUT I don't get an order actually created and Stock is not reduced. Is this purely because it is in Test mode or should it all go as if it was live?

I have another (live) site that uses Nochex so transferred the modules from there to be sure they should work ok.
thanks

Decided to try it in Live anyway - same problem...!!

Hi,

I am having the same problem Nochex payment conformation says what the items are but zencart does not. Have spoken with Nochex and am awaiting them to call me back. Any proper help from fellow zenn'ers would be great.