Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Part of control Panel disappeared


Rawi

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

Link to comment
Share on other sites

  • 1 year later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...