Jump to content
Sign in to follow this  
Rawi

Part of control Panel disappeared

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×