Thread: State issue

I'm getting the following error while executing the state SQL patch.
Any thoughts on why & what I need to do to fix this?

Thanks!

/*---------------------------------------------------------------------*/
Try to execute 1th query at line 2

INSERT INTO `ProfilesDesc` ( `ID` , `name` , `namedisp` , `namenote` , `extra` , `type` , `order` , `visible` , `check` , `because` , `group_mark` , `group_text_b` , `group_text_a` , `to_db` , `show_on_page` , `get_value` , `get_value_db` , `search_type` , `search_cols` , `search_hide` , `search_extra` , `search_order` , `search_default` , `search_where` , `match_field` , `match_type` , `match_extra`)
VALUES (
'', 'State', '_State', '', 'global $prof; return $prof[\'state\'];', 'r', '4.1', 'user,memb,adm', '', '', '', '', '', '1', '0', '', '', 'check', '3', '1', '', '10.1', '', '', '', 'none', '')

[MySql Server DMO Error][ErrNo:1062][Description: Duplicate entry 'State' for key 2]

/*---------------------------------------------------------------------*/

Originally Posted by Beaker

I'm getting the following error while executing the state SQL patch. Any thoughts on why & what I need to do to fix this?

Yes - you already have a record in the ProfilesDesc table.

Smoge

Originally Posted by Beaker

INSERT INTO `ProfilesDesc` ( `ID` , `name` , `namedisp` , `namenote` , `extra` , `type` , `order` , `visible` , `check` , `because` , `group_mark` , `group_text_b` , `group_text_a` , `to_db` , `show_on_page` , `get_value` , `get_value_db` , `search_type` , `search_cols` , `search_hide` , `search_extra` , `search_order` , `search_default` , `search_where` , `match_field` , `match_type` , `match_extra`)
VALUES (
'', 'State', '_State', '', 'global $prof; return $prof[\'state\'];', 'r', '4.1', 'user,memb,adm', '', '', '', '', '', '1', '0', '', '', 'check', '3', '1', '', '10.1', '', '', '', 'none', '')

Duplicate entry 'State' for key 2]