Shop?

[mark1]

Wilt iemand me helpen met de shop? want ik krijg steeds een fout bij de install

[cartoontje]

Wat voor foutmelding krijg je?

[mark1]

Code: Selecteer alles

Running :: create table `phpbb_shopitems` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `name` CHAR (32) NOT NULL, `shop` CHAR (32) NOT NULL, `sdesc` CHAR (80) NOT NULL, `ldesc` TEXT NOT NULL, `cost` INT (20) UNSIGNED DEFAULT '100', `stock` TINYINT (3) UNSIGNED DEFAULT '10', `maxstock` TINYINT (3) UNSIGNED DEFAULT '100', `sold` INT (5) UNSIGNED NOT NULL DEFAULT '0', `accessforum` INT (4) DEFAULT '0', PRIMARY KEY(`id`), INDEX(`name`)) -> FAILED ---> Table 'phpbb_shopitems' already exists

Running :: create table `phpbb_shops` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `shopname` CHAR (32) NOT NULL, `shoptype` CHAR (32) NOT NULL, PRIMARY KEY(`id`), `type` char (32) NOT NULL, `restocktime` INT (20) UNSIGNED DEFAULT '86400', `restockedtime` INT (20) UNSIGNED DEFAULT '0', `restockamount` INT (4) UNSIGNED DEFAULT '5', `amountearnt` INT (20) UNSIGNED DEFAULT '0', INDEX(`shopname`)) -> FAILED ---> Table 'phpbb_shops' already exists

Running :: insert into phpbb_config (config_name, config_value) values ('multibuys', 'on') -> FAILED ---> Duplicate entry 'multibuys' for key 1

Running :: insert into phpbb_config (config_name, config_value) values ('restocks', 'off') -> FAILED ---> Duplicate entry 'restocks' for key 1

Running :: insert into phpbb_config (config_name, config_value) values ('sellrate', '75') -> FAILED ---> Duplicate entry 'sellrate' for key 1

Running :: insert into phpbb_config (config_name, config_value) values ('viewtopic', 'images') -> FAILED ---> Duplicate entry 'viewtopic' for key 1

Running :: insert into phpbb_config (config_name, config_value) values ('viewprofile', 'images') -> FAILED ---> Duplicate entry 'viewprofile' for key 1

Running :: insert into phpbb_config (config_name, config_value) values ('viewinventory', 'grouped') -> FAILED ---> Duplicate entry 'viewinventory' for key 1

Running :: insert into phpbb_config (config_name, config_value) values ('specialshop', 'ßstoreÞdisabledßnameÞEffects StoreßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1') -> FAILED ---> Duplicate entry 'specialshop' for key 1

Running :: insert into phpbb_config (config_name, config_value) values ('viewtopiclimit', '5') -> FAILED ---> Duplicate entry 'viewtopiclimit' for key 1

Running :: insert into phpbb_config (config_name, config_value) values('shop_orderby', 'name') -> FAILED ---> Duplicate entry 'shop_orderby' for key 1

Running :: insert into phpbb_config (config_name, config_value) values('shop_give', 'on') -> FAILED ---> Duplicate entry 'shop_give' for key 1

Running :: insert into phpbb_config (config_name, config_value) values('shop_trade', 'on') -> FAILED ---> Duplicate entry 'shop_trade' for key 1

Running :: insert into phpbb_config (config_name, config_value) values('shop_invlimit', '0') -> FAILED ---> Duplicate entry 'shop_invlimit' for key 1

Running :: alter table phpbb_users add `user_effects` CHAR (255) -> FAILED ---> Duplicate column name 'user_effects'

Running :: alter table phpbb_users add `user_privs` CHAR (255) -> FAILED ---> Duplicate column name 'user_privs'

Running :: alter table phpbb_users add `user_custitle` TEXT -> FAILED ---> Duplicate column name 'user_custitle'

Running :: alter table phpbb_users add `user_specmsg` TEXT -> FAILED ---> Duplicate column name 'user_specmsg'

Running :: alter table phpbb_users add `user_items` TEXT -> FAILED ---> Duplicate column name 'user_items'

Running :: alter table phpbb_users add `user_trade` TEXT -> FAILED ---> Duplicate column name 'user_trade'


Finished!
Some of the querys have failed, contact me so I can fix the errors.

[cartoontje]

Het script zegt dat de tabellen e.d. al bestaan. Waarschijnlijk heb je het al eerder uitgevoerd. Ga dus gerust verder met de installatie. De SQL-stap was al voltooid!

[mark1]

Maar later krijg ik nog een fout

[Coen]

Maar later krijg ik nog een fout

Toevallig deze: http://www.phpbb.nl/viewtopic.php?t=14036 ?