Problem installing STS template

[jsaleem 0]

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

[♥multimixer 325]

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