From: Flo G. <fl...@bi...> - 2005-04-15 19:44:27
|
Just put a delete before every insert. Example: delete from tiki_menu_options where menuId=42 and name='Member List' and position=188 INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Member list','tiki-list_users.php','188','feature_friends','tiki_p_list_users',''); Flo On Fri, 15 Apr 2005, Sylvie Greverend wrote: > I don't know how to fix this one, any help appreciated > > Each time we run tiki_1.8to1.9.sql we create a couple of duplicated options > in the table tiki_menu_options > I think I have about 50 times tiki-list_users.php now > There is no unique key in the table definition > UNIQUE KEY (menuId,type,name,url,position,section,perm,groupname) > gives the sql error > Specified key was too long. Max key length is 500 > > And I don't know how to fix this with a sql query in tiki_1.8to1.9.sql > Is it possible to do that in a tiki_1.8to1.9.sql? Do we need a temporary > table? Do we need a script to do that? Do we include some code in tiki (when > you go in admin_menu_option?) > > Any help is appreciated > Sylvie > > > > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > Tikiwiki-devel mailing list > Tik...@li... > https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel > |