No replies to this topic

[visiblesoul]

Sometimes the MKPortal navigation links database table may become corrupted causing various errors when trying to create links in the Portal CP.

If you don't mind losing all of your nav links and recreating them do this...

1. BACKUP YOUR DATABASE. I cannot be responsible for any loss or damage to the database.

2. Drop the mainlinks table using this query...

DROP TABLE `mkp_mainlinks`;

3. Re-create the default nav links using these queries...

CREATE TABLE `mkp_mainlinks` (
  `id` int(10) NOT NULL auto_increment,
  `icon` text NOT NULL,
  `title` varchar(255) NOT NULL default '',
  `url` text NOT NULL,
  `type` tinyint(2) NOT NULL default '0',
  `position` int(2) NOT NULL default '12',
  `target` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
);


INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_home.gif', '<LNG>home', '<MKURL>/index.php', '1', '1');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_forum.gif', '<LNG>forum', '<MKFURL>', '1', '2');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_blog.gif', '<LNG>blog', '<MKURL>/index.php?ind=blog', '1', '3');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_foto.gif', '<LNG>gallery', '<MKURL>/index.php?ind=gallery', '1', '4');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_urlo.gif', '<LNG>urlobox', '<MKURL>/index.php?ind=urlobox', '1', '5');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_down.gif', '<LNG>download', '<MKURL>/index.php?ind=downloads', '1', '6');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_racconti.gif', '<LNG>news', '<MKURL>/index.php?ind=news', '1', '7');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_toplist.gif', '<LNG>topsite', '<MKURL>/index.php?ind=topsite', '1', '8');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_media.gif', '<LNG>reviews', '<MKURL>/index.php?ind=reviews', '1', '9');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_chat.gif', '<LNG>chat', '<MKURL>/index.php?ind=chat', '1', '10');


INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_home.gif', '<LNG>home', '<MKURL>/index.php', '2', '1');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_forum.gif', '<LNG>forum', '<MKFURL>', '2', '2');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_blog.gif', '<LNG>blog', '<MKURL>/index.php?ind=blog', '2', '3');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_foto.gif', '<LNG>gallery', '<MKURL>/index.php?ind=gallery', '2', '4');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_urlo.gif', '<LNG>urlobox', '<MKURL>/index.php?ind=urlobox', '2', '5');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_down.gif', '<LNG>download', '<MKURL>/index.php?ind=downloads', '2', '6');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_racconti.gif', '<LNG>news', '<MKURL>/index.php?ind=news', '2', '7');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_toplist.gif', '<LNG>topsite', '<MKURL>/index.php?ind=topsite', '2', '8');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_media.gif', '<LNG>reviews', '<MKURL>/index.php?ind=reviews', '2', '9');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_quote.gif', '<LNG>quote', '<MKURL>/index.php?ind=quote', '2', '10');

INSERT INTO `mkp_mainlinks` (icon, title, url, type, position) VALUES ('<IMG>/atb_chat.gif', '<LNG>chat', '<MKURL>/index.php?ind=chat', '2', '11');