Rawi Posted August 10, 2009 Share Posted August 10, 2009 Hi ! I just installed a contribution for coupon codes (http://www.oscommerce.com/community/contributions,4269) but unfortunately it made my control panel disappear. Now when i go to the admin control panel and log in I do see all the usual options (configuration/catalog,modules etc) but when i click on any it only shows the admin header and the first menubox left (configuration). None of the links in that menu work either. I've checked and double checked all the steps and files but cant seem to find what went wrong. The only thing i can think of is something went wrong when i installed the sql file (note: i dont have much knowledge/experience with sql); I dont know how hard it is to find the error but i hope someone can help me, below a copy/paste of the message from php myadmin after the sql installation : SQL-query: CREATE TABLE `discount_coupons` ( `coupons_id` varchar( 32 ) NOT NULL default '', `coupons_description` varchar( 64 ) NOT NULL default '', `coupons_discount_amount` decimal( 15, 2 ) default NULL , `coupons_discount_type` varchar( 35 ) default NULL , `coupons_date_start` datetime default NULL , `coupons_date_end` datetime default NULL , `coupons_max_use` int( 3 ) NOT NULL default '0', `coupons_min_order` decimal( 15, 4 ) NOT NULL default '0.0000', `coupons_min_order_type` varchar( 50 ) default NULL , `coupons_number_available` int( 3 ) NOT NULL default '0', PRIMARY KEY ( `coupons_id` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1;# MySQL gaf een lege resultaat set terug (0 rijen). # # Structure for the `discount_coupons_to_categories` table : # CREATE TABLE `discount_coupons_to_categories` ( `coupons_id` varchar( 32 ) default NULL , `categories_id` int( 11 ) default NULL ) ENGINE = InnoDB DEFAULT CHARSET = latin1;# MySQL gaf een lege resultaat set terug (0 rijen). # # Structure for the `discount_coupons_to_customers` table : # CREATE TABLE `discount_coupons_to_customers` ( `coupons_id` varchar( 32 ) default NULL , `customers_id` int( 11 ) default NULL ) ENGINE = InnoDB DEFAULT CHARSET = latin1;# MySQL gaf een lege resultaat set terug (0 rijen). # # Structure for the `discount_coupons_to_manufacturers` table : # CREATE TABLE `discount_coupons_to_manufacturers` ( `coupons_id` varchar( 32 ) default NULL , `manufacturers_id` int( 11 ) default NULL ) ENGINE = InnoDB DEFAULT CHARSET = latin1;# MySQL gaf een lege resultaat set terug (0 rijen). # # Structure for the `discount_coupons_to_orders` table : # 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` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1;# MySQL gaf een lege resultaat set terug (0 rijen). # # Structure for the `discount_coupons_to_products` table : # CREATE TABLE `discount_coupons_to_products` ( `coupons_id` varchar( 32 ) default NULL , `products_id` int( 11 ) default NULL ) ENGINE = InnoDB DEFAULT CHARSET = latin1;# MySQL gaf een lege resultaat set terug (0 rijen). # # Structure for the `discount_coupons_to_zones` table : # CREATE TABLE `discount_coupons_to_zones` ( `discount_coupons_to_zones_id` int( 11 ) NOT NULL AUTO_INCREMENT , `coupons_id` varchar( 32 ) default NULL , `geo_zone_id` int( 11 ) default NULL , PRIMARY KEY ( `discount_coupons_to_zones_id` ) , UNIQUE KEY `discount_coupons_to_zones_id` ( `discount_coupons_to_zones_id` ) ) ENGINE = InnoDB DEFAULT CHARSET = latin1;# MySQL gaf een lege resultaat set terug (0 rijen). # # Data for the `discount_coupons` table (LIMIT 0,500) # INSERT INTO `discount_coupons` ( `coupons_id` , `coupons_description` , `coupons_discount_amount` , `coupons_discount_type` , `coupons_date_start` , `coupons_date_end` , `coupons_max_use` , `coupons_min_order` , `coupons_min_order_type` , `coupons_number_available` ) VALUES ( 'testing001', 'testing', 2, 'percent', NULL , NULL , 2, 1, 'price', 1 );# Getroffen rijen:1 COMMIT ;# MySQL gaf een lege resultaat set terug (0 rijen). # # Data for the `discount_coupons_to_categories` table (LIMIT 0,500) # INSERT INTO `discount_coupons_to_categories` ( `coupons_id` , `categories_id` ) VALUES ( 'testing001', 22 );# Getroffen rijen:1 COMMIT ;# MySQL gaf een lege resultaat set terug (0 rijen). # # Data for the `discount_coupons_to_customers` table (LIMIT 0,500) # INSERT INTO `discount_coupons_to_customers` ( `coupons_id` , `customers_id` ) VALUES ( 'testing001', 4 );# Getroffen rijen:1 COMMIT ;# MySQL gaf een lege resultaat set terug (0 rijen). I hope someone can help me. Thanks in advance, Rawi Quote Link to comment Share on other sites More sharing options...
duurmerk7 Posted September 14, 2010 Share Posted September 14, 2010 I ran ito a similar problem and saw that in catalog.php & reports.php, the coe should not be replaced, but just add the differences around line 29. so no/KGT & *** etc. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.