Results 1 to 3 of 3
  1. #1
    Join Date
    May 2008
    Posts
    182
    Plugin Contributions
    0

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

  2. #2
    Join Date
    Jun 2010
    Posts
    16
    Plugin Contributions
    1

    Default 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

  3. #3
    Join Date
    May 2008
    Posts
    182
    Plugin Contributions
    0

    Default 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

 

 

Similar Threads

  1. v150 Connecting to a second database
    By strelitzia in forum General Questions
    Replies: 2
    Last Post: 5 Mar 2013, 11:41 PM
  2. Connecting to ZenCart Database Error
    By KoboltBlue in forum General Questions
    Replies: 2
    Last Post: 13 Nov 2008, 09:06 PM
  3. Connecting to database
    By Lmichael in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 10 Feb 2008, 06:41 PM
  4. reconnecting to Database after connecting to PhpBB database.
    By rainthebat in forum General Questions
    Replies: 0
    Last Post: 6 Feb 2008, 09:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR