Re: 1146 - Table 'store.coupon_gv_customer' doesn't exist

This message was sent from: Contributions
http://forums.oscommerce.com/viewtopic.php?p=229014#229014
----------------------------------------------------------------

[quote="djdn"]Hi,

I am getting the following error when user clicks on "My Account" and in left side it shows..

"1146 - Table 'store.coupon_gv_customer' doesn't exist

select amount from coupon_gv_customer where customer_id = '2'

[TEP STOP]"

Please help me bring my site live.

Thank you!

Regards,

DJDN[/quote]


[code]You have to edit two files: 
Catalog/includes/filenames.php 

Add this: 
Code: 
  define('FILENAME_ADD_CHECKOUT_SUCCESS', 'add_checkout_success.php'); 
  define('FILENAME_GV_FAQ', 'gv_faq.php'); 
  define('FILENAME_GV_REDEEM.PHP', 'gv_redeem.php'); 
  define('FILENAME_GV_SEND', 'gv_send.php'); 
  define('FILENAME_POPUP_COUPON_HELP', 'popup_coupon_help.php'); 


catalog/admin/includes/filenames.php 

Add this: 
Code: 
  define('FILENAME_COUPON_ADMIN', 'coupon_admin.php'); 
  define('FILENAME_COUPON_RESTRICT', 'coupon_restrict.php'); 
  define('FILENAME_GV_MAIL', 'gv_mail.php'); 
  define('FILENAME_GV_QUEUE', 'gv_queue.php'); 
  define('FILENAME_GV_SENT', 'gv_sent.php'); 
  define('FILENAME_LISTCATEGORIES', 'listcategories.php');  
  define('FILENAME_LISTPRODUCTS', 'listproducts.php');  
  define('FILENAME_VALIDCATEGORIES', 'validcategories.php'); 
  define('FILENAME_VALIDPRODUCTS', 'validproducts.php'); 


You should also add these lines in admin/includes/database_tables.php and catalog/includes/database_tables.php 
Code: 
  define('TABLE_COUPONS', 'coupons'); 
  define('TABLE_COUPONS_DESCRIPTION', 'coupons_description'); 
  define('TABLE_COUPON_EMAIL_TRACK', 'coupon_email_track'); 
  define('TABLE_COUPON_GV_CUSTOMER', 'coupon_gv_customer'); 
  define('TABLE_COUPON_GV_QUEUE', 'coupon_gv_queue'); 
  define('TABLE_COUPON_REDEEM_TRACK', 'coupon_redeem_track'); 
[/code]

Edit the above two files.