Seite 1 von 1

Shop Mod (und CashMod)

Verfasst: 03.07.2004 15:05
von phanatos
Ich erhalte beim dem ShopMod folgenden Fehler wenn ich die shop_install.php ausführe:
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.
Außerdem wird der Shop nicht angezeigt, ich hab auch keine Ahnung, wie ich den ShopMod und den CashMod zusammenbringen soll ...

Verfasst: 03.07.2004 15:07
von REincarnation
Na im Grunde stehts ja schon da. Die tabellen können nicht angelegt werden, weil sie bereits existieren. Ich würde per PHPmyAdmin mal einfach die betreffenden Tabellen löschen und es dann erneut versuchen.

Verfasst: 03.07.2004 15:31
von phanatos
OK der Shop funktioniert jetzt, muss ich nur noch den CashMod verbinden und dieser CashMod sollte auch noch laufen siehe http://www.phpbb.de/topic58335.html ... jemand eine Idee?