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?"
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
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