Reply to thread

Message

<blockquote data-quote="linuslind" data-source="post: 169580" data-attributes="member: 8055">How do i fix this?I tried &nbsp;[CODE]ALTER TABLE `furniture`ADD COLUMN `effectM`&nbsp; int(3) NOT NULL DEFAULT 0,ADD COLUMN `effectF`&nbsp; int(3) NOT NULL DEFAULT 0;ALTER TABLE `furniture`MODIFY COLUMN `interaction_type`&nbsp; enum('default','gate','postit','roomeffect','dimmer','trophy','bed','scoreboard','vendingmachine','alert','onewaygate','loveshuffler','habbowheel','dice','bottle','teleport','rentals','pet','roller','water','ball','bb_red_gate','bb_green_gate','bb_yellow_gate','bb_puck','bb_blue_gate','bb_patch','bb_teleport','blue_score','green_score','red_score','yellow_score','fbgate','tagpole','counter','red_goal','blue_goal','yellow_goal','green_goal','wired','wf_trg_onsay','wf_act_saymsg','wf_trg_enterroom','wf_act_moveuser','wf_act_togglefurni','wf_trg_furnistate','wf_trg_onfurni','pressure_pad','wf_trg_offfurni','wf_trg_gameend','wf_trg_gamestart','wf_trg_timer','wf_act_givepoints','wf_trg_attime','wf_trg_atscore','wf_act_moverotate','rollerskate','stickiepole','wf_xtra_random','wf_cnd_trggrer_on_frn','wf_cnd_furnis_hv_avtrs','wf_act_matchfurni','wf_cnd_has_furni_on','puzzlebox','switch','wf_act_give_phx','wf_cnd_phx') NOT NULL DEFAULT 'default'; [/CODE]&nbsp;But it only says : #1060 - Duplicate column name 'effectM' &nbsp;<img src="http://i48.tinypic.com/s497yw.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" /></blockquote>

[QUOTE="linuslind, post: 169580, member: 8055"] [FONT=Verdana][COLOR=#333333]How do i fix this?[/COLOR][/FONT] [FONT=Verdana][COLOR=#333333]I tried [/COLOR][/FONT] [CODE]ALTER TABLE `furniture`ADD COLUMN `effectM` int(3) NOT NULL DEFAULT 0,ADD COLUMN `effectF` int(3) NOT NULL DEFAULT 0; ALTER TABLE `furniture`MODIFY COLUMN `interaction_type` enum('default','gate','postit','roomeffect','dimmer','trophy','bed','scoreboard','vendingmachine','alert','onewaygate','loveshuffler','habbowheel','dice','bottle','teleport','rentals','pet','roller','water','ball','bb_red_gate','bb_green_gate','bb_yellow_gate','bb_puck','bb_blue_gate','bb_patch','bb_teleport','blue_score','green_score','red_score','yellow_score','fbgate','tagpole','counter','red_goal','blue_goal','yellow_goal','green_goal','wired','wf_trg_onsay','wf_act_saymsg','wf_trg_enterroom','wf_act_moveuser','wf_act_togglefurni','wf_trg_furnistate','wf_trg_onfurni','pressure_pad','wf_trg_offfurni','wf_trg_gameend','wf_trg_gamestart','wf_trg_timer','wf_act_givepoints','wf_trg_attime','wf_trg_atscore','wf_act_moverotate','rollerskate','stickiepole','wf_xtra_random','wf_cnd_trggrer_on_frn','wf_cnd_furnis_hv_avtrs','wf_act_matchfurni','wf_cnd_has_furni_on','puzzlebox','switch','wf_act_give_phx','wf_cnd_phx') NOT NULL DEFAULT 'default'; [/CODE] [FONT=Verdana][COLOR=#333333]But it only says : #1060 - Duplicate column name 'effectM' [/COLOR][/FONT] [IMG]http://i48.tinypic.com/s497yw.jpg[/IMG] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members