Isiah Posted January 30, 2009 Share Posted January 30, 2009 ok i installed and reinstalled this coupon contribution and still when i got to admin->customers->Coupons i get 1054 - Unknown column 'coupon_id' in 'field list' select coupon_id, coupon_code, coupon_status, coupon_type, coupon_amount, coupon_use from coupons limit 0, 10 [TEP STOP] and on the checkout page when you trying to checkout on the checkout payment page i get 1054 - Unknown column 'coupon_status' in 'where clause' select count(*) as total from coupons where coupon_status = '1' [TEP STOP] Has anyone experienced this before. Does anyone know what to do i would appreciate anyone who can help Link to comment Share on other sites More sharing options...
FIMBLE Posted January 30, 2009 Share Posted January 30, 2009 Probably not ran the sql file Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
Isiah Posted January 30, 2009 Author Share Posted January 30, 2009 when i run the sql i get Error SQL query: CREATE TABLE coupon_to_customer( coupon_id int( 11 ) NOT NULL default '0', customer_id int( 11 ) NOT NULL default '0', order_id int( 11 ) NOT NULL default '0', redeem_date datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY ( coupon_id, customer_id, order_id ) ) TYPE = MYISAM MySQL said: Documentation #1050 - Table 'coupon_to_customer' already exists Doesnt that mean ive already ran it? Link to comment Share on other sites More sharing options...
Isiah Posted January 30, 2009 Author Share Posted January 30, 2009 oh mistake on my part got it now. thanks for the help Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.