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: [IMG]http://www.zen-cart.com/forum/includes/languages/english/images/buttons/button_invoice.gif[/IMG] [IMG]http://www.zen-cart.com/forum/includes/languages/english/images/buttons/button_packingslip.gif[/IMG] [IMG]http://www.zen-cart.com/forum/includes/languages/english/images/buttons/button_orders.gif[/IMG] [IMG]http://www.zen-cart.com/forum/images/small_zen_logo.gif[/IMG]

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

you have a define table name missing
make sure that you have followed the directions carefully

Merlinpa1969:

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)
);

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 ...

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.

Thanks for the update ... and glad that you found the missing file ... :smile:

Ajeh:

Thanks for the update ... and glad that you found the missing file ... :smile:

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