Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2006
    Location
    Summer:Ontaio, Winter:Texas
    Posts
    211
    Plugin Contributions
    0

    Default Ceon_manual_card

    1146 Table '_pridepak5.table_ceon_manual_card' doesn't exist
    in:
    [ SELECT * FROM TABLE_CEON_MANUAL_CARD WHERE order_id = '15']
    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.

    I get the above message when checking orders via admin (to obtain the middle digits for credit card). None of the CC orders have the following (like orders by Fax or Purchase Order):
    Date Added Customer Notified Status Comments 01/31/2007 23:45:47 Processing
    Comments
    Status: Pending [1]Processing [2]Delivered [3]Update [4] Notify Customer: Append Comments:

  2. #2
    Join Date
    Dec 2006
    Location
    Summer:Ontaio, Winter:Texas
    Posts
    211
    Plugin Contributions
    0

    Default Re: Ceon_manual_card

    Ajeh, I did not intend to make 2 posts! I was modifying the original post to take out the end of the message as it did not show what I had in mind. I did not post it twice. I was probably working too long on changing that original message.
    I still don't know how to cancel a message, once you open thread..., but that would not helped me this time.
    Cheers

  3. #3
    Join Date
    Mar 2004
    Posts
    16,042
    Plugin Contributions
    5

    Default Re: Ceon_manual_card

    you have a define table name missing
    make sure that you have followed the directions carefully
    Zen cart PCI compliant Hosting

  4. #4
    Join Date
    Dec 2006
    Location
    Summer:Ontaio, Winter:Texas
    Posts
    211
    Plugin Contributions
    0

    Default Re: Ceon_manual_card

    Quote Originally Posted by Merlinpa1969 View Post
    you have a define table name missing
    make sure that you have followed the directions carefully
    There is an error in supplied sql statement:
    CREATE TABLE `ceon_manual_card` (
    `id` int(11) unsigned NOT NULL auto_increment,
    `order_id` int(11) NOT NULL default '0',
    `cc_start` varchar(4) default NULL,
    `cc_issue` varchar(1) default NULL,
    UNIQUE KEY `id` (`id`)
    );

    should be:
    CREATE TABLE `table_ceon_manual_card` (
    `id` int(11) unsigned NOT NULL auto_increment,
    `order_id` int(11) NOT NULL default '0',
    `cc_start` varchar(4) default NULL,
    `cc_issue` varchar(1) default NULL,
    UNIQUE KEY `id` (`id`)
    );

  5. #5
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Ceon_manual_card

    TABLE_CEON_MANUAL_CARD is meant to be a constant like all other tables are setup in the:
    /includes/database_tables.php

    Example: the table products is used with the constant:
    define('TABLE_PRODUCTS', DB_PREFIX . 'products');

    This allows for tables with or without the prefix ...

    There should be a define for this table that can be added to the:
    /includes/extra_datafiles

    directory so that the table name will work ...

    What you have done is addressed the table as the constant and not as its real name ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  6. #6
    Join Date
    Dec 2006
    Location
    Summer:Ontaio, Winter:Texas
    Posts
    211
    Plugin Contributions
    0

    Default Re: Ceon_manual_card

    Thank you! By mistake I only "linked" this file on my laptop so when I ftp'ed it to ISP well, it was not available.
    All can see that "little" knowledge is "dangres"s knowledge.

  7. #7
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Ceon_manual_card

    Thanks for the update ... and glad that you found the missing file ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  8. #8
    Join Date
    Dec 2006
    Location
    Summer:Ontaio, Winter:Texas
    Posts
    211
    Plugin Contributions
    0

    Default Re: Ceon_manual_card

    Quote Originally Posted by Ajeh View Post
    Thanks for the update ... and glad that you found the missing file ...
    What's the difference between this mod and the "cc" which is included in 1.3.7?? Do I really need this for "in house cc processing"? Can I use just the module in 1.3.7 without going through ?Payment Company??

 

 

Similar Threads

  1. Ceon_manual_card
    By Sunabac in forum Addon Payment Modules
    Replies: 1
    Last Post: 8 Feb 2007, 03:37 AM

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