phpBB.de

Server: localhostlocalhost
Datenbank: usr1usr1
Fehler

SQL-Befehl:

CREATE TABLE `phpBB2user_shops` (
`id` INT( 5 ) NOT NULL AUTO_INCREMENT ,
`user_id` INT( 10 ) NOT NULL ,
`username` VARCHAR( 32 ) NOT NULL ,
`shop_name` VARCHAR( 32 ) NOT NULL ,
`shop_type` VARCHAR( 32 ) NOT NULL ,
`shop_opened` INT( 30 ) NOT NULL ,
`shop_updated` INT( 30 ) NOT NULL ,
`shop_status` INT( 1 ) DEFAULT '0' NOT NULL ,
`amount_earnt` INT( 10 ) DEFAULT '0' NOT NULL ,
`amount_holding` INT( 10 ) DEFAULT '0' NOT NULL ,
`items_sold` INT( 10 ) DEFAULT '0' NOT NULL ,
`items_holding` INT( 10 ) DEFAULT '0' NOT NULL ,
PRIMARY KEY ( `user_id` ) ,
INDEX ( `id` )
)

MySQL meldet: Dokumentation
#1050 - Table 'phpBB2user_shops' already exists
[ Zurück ]

Ein Fehler ist aufgetreten.

DEBUG MODE

SQL Error : 1146 Table 'usr1.phpbb_shopitems' doesn't exist

SELECT a.*, b.name FROM phpBB2user_shops_items a, `phpbb_shopitems` b WHERE a.shop_id = '3' AND b.id = a.item_id

Line : 143
File : shop_users_edit.php