Nochex table error

[jaxbo]

Hi...bit of a noob at this but just this one problem else i look ready to roll.

I have installed the nochex module (seller account) which has added the two tables to my database, but when i process a test order, on step 3 right at the bottom i get the sql error as follows:

1146 Table 'user_zc1.TABLE_NOCHEX_SESSION' doesn't exist
in:
[delete from TABLE_NOCHEX_SESSION where session_id = '2455fb0b3f38d9ba10716aaba63419a2']


So it won't et me get past that bit, and there does appear to be a record in the Nochex APC but i can't see what it is. I've looked at the database and there is a table called nochex_sessions ...does anybody know why it can't find it, and is it asking me to delete the session ID from it? I've looked around and can't find the solution.

Cheers

[bekinky]

Hi...bit of a noob at this but just this one problem else i look ready to roll.

I have installed the nochex module (seller account) which has added the two tables to my database, but when i process a test order, on step 3 right at the bottom i get the sql error as follows:

1146 Table 'user_zc1.TABLE_NOCHEX_SESSION' doesn't exist
in:
[delete from TABLE_NOCHEX_SESSION where session_id = '2455fb0b3f38d9ba10716aaba63419a2']


So it won't et me get past that bit, and there does appear to be a record in the Nochex APC but i can't see what it is. I've looked at the database and there is a table called nochex_sessions ...does anybody know why it can't find it, and is it asking me to delete the session ID from it? I've looked around and can't find the solution.

Cheers

There is a mysql dump file in the nochex module package. You need to dump this into the database to create the required tables.

[jaxbo]

thanks, but yes i did that part, and it created 2 new tables in the zencart database: nochex_apc_transactions & nochex_sessions, thats why this error is a bit odd, as it seems to be unable to find the tables that are already there.

After some more checking i did find someone else with the same issue and it appears to be unresolved as yet. So any further suggestions most welcome, thanks

[atomickarma]

Hi

I'm currently having the same problem, has anyone found a solution yet?

[CJPinder]

I'm currently having the same problem, has anyone found a solution yet?

Sounds like you have missed a step out of the installation...

Add the following two instructions anywhere in the includes/database_tables.php file:

define('TABLE_NOCHEX', DB_PREFIX . 'nochex_apc_transactions');
define('TABLE_NOCHEX_SESSION', DB_PREFIX . 'nochex_sessions'); 

Regards,
Christian.

[atomickarma]

Sounds like you have missed a step out of the installation...

Add the following two instructions anywhere in the includes/database_tables.php file:

define('TABLE_NOCHEX', DB_PREFIX . 'nochex_apc_transactions');
define('TABLE_NOCHEX_SESSION', DB_PREFIX . 'nochex_sessions'); 

Regards,
Christian.

Hi - I've added these instructions to the file however there is no change, the error remains the same.

WHat should I do next? Should I remove the new tables and start again?