[szogun]

Hello
Looking for a store I came across a modified version of the store at which I have a problem to add items to the database https://build.kxnrl.com/Store/1.9/

PHP Code:

ALTER TABLE `store_item_child`
ADD `idle` varchar(32) NOT NULL DEFAULT 'ITEM_NO_IDLE' COMMENT 'pet',
ADD `run` varchar(32) NOT NULL DEFAULT 'ITEM_NO_RUN' COMMENT 'pet',
ADD `death` varchar(32) NOT NULL DEFAULT 'ITEM_NO_DEATH' COMMENT 'pet',
ADD `seed` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'weaponskin',
ADD `weart` tinyint(3) NOT NULL DEFAULT '-1' COMMENT 'weaponskin',
ADD `paint` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'weaponskin',
ADD `wearf` float(7,6) unsigned NOT NULL DEFAULT '0.01' COMMENT 'weaponskin'

#1060 - Duplicate column name 'idle' 


[DarkDeviL]

Originally Posted by szogun PHP Code: #1060 - Duplicate column name 'idle'

ALTER TABLE is meant to alter the table with new information, not to alter it with the full schema of how the new table should look like after the procecure.

Remove the

PHP Code:

ADD `idle` [...] 


line, and then continue removing all of the other columns that already exist in your current "store_item_child" table as well, to avoid the "Duplicate column name" error.