Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Sign in to follow this  
jsaleem

Problem installing STS template

Recommended Posts

The readme says the following...

 

 

 

**Define Menu**

 

Before you install the template, run the following query on your database:

 

--

-- Table structure for table `menu`

--

 

CREATE TABLE IF NOT EXISTS `menu` (

`menu_id` int(11) unsigned NOT NULL auto_increment,

`menu_text` varchar(255) NOT NULL default '',

`menu_url` varchar(255) NOT NULL default '',

`sort_order` int(1) NOT NULL default '0',

PRIMARY KEY (`menu_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

 

--

-- Dumping data for table `menu`

--

 

INSERT INTO `menu` (`menu_id`, `menu_text`, `menu_url`, `sort_order`) VALUES

(2, 'Home', 'http://mysite.com/index.php', 1),

(3, 'New Products', 'http://mysite.com/products_new.php', 2),

(4, 'Specials', 'http://mysite.com/specials.php', 3),

(5, 'Featured Products', 'http://mysite.com/featured_products.php.', 4),

(6, 'Contact Us', 'http://mysite.com/contact_us.php', 5);

 

 

IMPORTANT: make sure to use complete url’s (including file names) in the define menu admin area, or you can edit before inserting into your database.

 

Can anyone make sense of this for me? I cant seem to figure this out

Share this post


Link to post
Share on other sites

This is not part of the default STS installation, and has in real nothing to do with STS

 

The template you purchased is asking you to run a sql query in order to set up some menu. Who knows why the url's have to be stored in the database and who can say if the links will work like this?

 

However, to run this sql, you need to go to your phpMyAdmin, via your host cpanel, select your DB, then sql, then paste this inside, then go. Keep a backup of your current database in any case, and change the urls to be yours, I think there will be no way to change this later via admin, only directly in the DB, an other highlight of the story !

 

Good luck

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  

×