kgt Posted June 9, 2006 Author Share Posted June 9, 2006 I did a manual install..since I'm not fluent in sql. (wouldn't know where to begin) I've made the suggested mods : tep_db_input($_POST["coupons_description"]) . "', '" . tep_db_input($_POST["coupons_discount_percent"]) ."', " . Still no ability to create a coupon. I'm getting this error: 1146 - Table 'libidolondon_com_-_store.discount_coupons' doesn't exist select count(*) as total from discount_coupons cd Step 3 of the instructions tells you that you need to run two statements via phpMyAdmin (generally available via your host's control panel). You need to select your OSC database, then click the SQL tab along the top. Copy and paste the following two statements into the text area provided and click Go. **************** STEP 2 ****************Create the database tables Run these statements via the SQL tab in phpMyAdmin. CREATE TABLE discount_coupons ( coupons_id varchar(32) NOT NULL default '', coupons_description varchar(64) NOT NULL default '', coupons_discount_percent decimal(7,4) default NULL, date_start datetime default NULL, date_end datetime default NULL, max_use int(3) NOT NULL default 0, min_order decimal(15,4) NOT NULL default '0.0000', PRIMARY KEY (coupons_id) ); CREATE TABLE discount_coupons_to_orders ( discount_coupons_to_orders_id int(11) NOT NULL auto_increment, coupons_id varchar(32) default NULL, orders_id int(11) default '0', PRIMARY KEY (discount_coupons_to_orders_id), KEY coupons_id (coupons_id) ); Quote Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.