Code: Selecteer alles
Er is een fout opgetreden
DEBUG MODE
SQL Error : 1146 Table 'psd_psd2.phpbb_shopitems' doesn't exist
SELECT a.*, b.name FROM phpbb_user_shops_items a, `phpbb_shopitems` b WHERE a.shop_id = '4' AND b.id = a.item_id
Line : 143
File : shop_users_edit.phpJa want als ik het nog eens uitvoer krijg ik dit:paul schreef:sql wel uitgevoerd?
Code: Selecteer alles
Running :: CREATE TABLE `phpbb_user_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_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 , `shop_updated` INT(30) DEFAULT '0' NOT NULL , PRIMARY KEY ( `user_id` ) , INDEX ( `id` ) ); -> FAILED ---> Table 'phpbb_user_shops' already exists
Running :: CREATE TABLE `phpbb_user_shops_items` ( `id` INT( 10 ) NOT NULL AUTO_INCREMENT , `shop_id` INT( 10 ) NOT NULL , `item_id` INT( 10 ) NOT NULL , `seller_notes` VARCHAR( 255 ) NOT NULL , `cost` INT( 10 ) NOT NULL , `time_added` MEDIUMINT( 30 ) NOT NULL , INDEX ( `shop_id` ) , PRIMARY KEY ( `id` ) ); -> FAILED ---> Table 'phpbb_user_shops_items' already exists
Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('u_shops_enabled', '0'); -> FAILED ---> Duplicate entry 'u_shops_enabled' for key 1
Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('u_shops_open_cost', '0'); -> FAILED ---> Duplicate entry 'u_shops_open_cost' for key 1
Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('u_shops_tax_percent', '0'); -> FAILED ---> Duplicate entry 'u_shops_tax_percent' for key 1
Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('u_shops_max_items', '100'); -> FAILED ---> Duplicate entry 'u_shops_max_items' for key 1
Finished!
Some of the querys have failed, contact me so I can fix the errors.Code: Selecteer alles
Er is een fout opgetreden
DEBUG MODE
SQL Error : 1054 Unknown column 'b.name' in 'field list'
SELECT a.*, b.name FROM phpbb_user_shops_items a, `phpbb_user_shops_items` b WHERE a.shop_id = '4' AND b.id = a.item_id
Line : 143
File : shop_users_edit.php