Pagina 1 van 1

Shop (opgelost)

Geplaatst: 07 jul 2005, 06:42
door tandarts
Ik ben mijn shop aan het instaleren.. maar krijg dit probleem..
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.
daarnaast krijg ik in mijn admin panel een foutmelding dat de template niet bestaat... iemand enig idee waar de fout ligt ?

Bedankt !!

Geplaatst: 07 jul 2005, 09:12
door Mark
is het een schone instal?
of waren er al tabellen aanwezig in de de database.

Zoals ik kan zien geeft hij aan dat er bepaalde tabellen al bestaan.

Geplaatst: 07 jul 2005, 11:44
door Coen
De tabellen in de database bestaan ook wel! Omdat je de querry al vaker hebt laten draaien! De errors in je admin paneel komen doordat je vergeten bent de .tpl bestanden te uploaden naar /templates/.../ en vooral /templates/.../admin/

Kijk dit dus nog eens goed na! :roll:

Succes! :bier:

Geplaatst: 07 jul 2005, 12:56
door tandarts
ja.. dat was het !!

ik heb hem nu geinstaleerd..

harstikke bedankt..

Geplaatst: 07 jul 2005, 12:57
door Coen
Graag gedaan! Succes verder met je forum! :bier:

Geplaatst: 07 jul 2005, 13:05
door tandarts
dank je wel.. ik loop gelijk al weer vast bij de job mod ..
ik geloof dat ik vandaag mijn dag niet helemaal heb..
alles wat ik doe loopt mis..

Geplaatst: 09 jul 2005, 11:21
door ik ben gek
wat gaat er mis? welke errors of ......

p.s. wat houdt de shopmod in?