Jump to content

Rawi

Members
  • Content count

    1
  • Joined

  • Last visited

Everything posted by Rawi

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