Zen Cart Logo
Forums / Addon Payment Modules / Nochex error connecting to database

Nochex error connecting to database

Views: 848

Results 1 to 3 of 3
18 Sep 2013, 1:41 PM
#1
candleman avatar

candleman

Zen Follower

Join Date:
May 2008
Posts:
183
Plugin Contributions:
0

Nochex error connecting to database

fresh install of 1.5.1 with a few mods.

mainly a new template - Bristol Lace
Supertracker
Reward points
Facebook comment
Google merchant feeder

now Nochex.....
I get an error message when trying to checkout. Ran the log file and got the following.

[18-Sep-2013 14:32:45 Europe/London] PHP Fatal error: 1146:Table 'candlewi_zenc227.TABLE_NOCHEX_SESSION' doesn't exist :: delete from TABLE_NOCHEX_SESSION where session_id = 'ftt1431e0duhkf10p8m5ji8677' in /home2/candlewi/public_html/includes/classes/db/mysql/query_factory.php on line 120

Now I have checked via PHP admin and the Table is there, although it has a prefix of Zen_Nochex_session.
I have tried removing the 's' from the php file.

now I am at a complete loss. I have double checked, unInstalled, Reinstalled etc all the files for Nochex and cannot find anything.

the website is a test site so feel free to have a look.

http://pegasus.terrassl.net/~candlewi/

The only thing else I can think of is an issue with the SSL certificate but im sure that would just show a page saying "are you sure?"

18 Sep 2013, 3:15 PM
#2
nochexsupport avatar

nochexsupport

New Zenner

Join Date:
Jun 2010
Posts:
16
Plugin Contributions:
0

Re: Nochex error connecting to database

Hi CandleMan,

Have you made sure you have added the following into your database_tables.php file located within your {zencart root}/includes folder:
define('TABLE_NOCHEX', DB_PREFIX . 'nochex_apc_transactions');
define('TABLE_NOCHEX_SESSION', DB_PREFIX . 'nochex_sessions');

Kind Regards,
Matthew Iveson
Nochex Technical Support

18 Sep 2013, 3:36 PM
#3
candleman avatar

candleman

Zen Follower

Join Date:
May 2008
Posts:
183
Plugin Contributions:
0

Re: Nochex error connecting to database

Matthew - you're a star!!
I seemed to have reverted back to an original file in all the confusion.
All works ok