
Originally Posted by
titangen
Hello Clyde,
I've put your sql line I my database I can see the table in phpmysql but I sill don't receive the options in admin and allways this error
1062 Duplicate entry '1-1' for key 1
in:
[update links_to_link_categories set link_categories_id = '1' where links_id = '1']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
strange
Chris

How many links do you have?
You can try running the following SQL script and then Update your links again.
Code:
DROP TABLE IF EXISTS `links_to_link_categories`;
CREATE TABLE `links_to_link_categories` (
`links_id` int(11) NOT NULL auto_increment,
`link_categories_id` int(11) NOT NULL default '0',
PRIMARY KEY (`links_id`,`link_categories_id`)
) ENGINE=MyISAM;
Bookmarks