Fatal Error updating item information in shop.
-----
| Author | Message | |
|---|---|---|
|
idemon |
||
| Sat Jul 21, 2007 6:24 am Post subject: Fatal Error updating item information in shop. | ||
|
The above error appears everytime i try to edit anything to do with the effect store, I wish i had not updated this issue is causing me many hours of extra work to keep my board functioning
|
||
|
Thoul |
||
| Sat Jul 21, 2007 9:19 pm Post subject: Re: Fatal Error updating item information in shop. | ||
|
In your admin/shop_items.php, find this line:
Code: message_die(GENERAL_MESSAGE, 'Fatal Error updating item information in shop.');
Replace it with: Code: message_die(GENERAL_ERROR, 'Fatal Error updating item information in shop.', '', __LINE__, __FILE__, $sql);
That sound give an error message with more details that will be helpful in determining what is causing this problem. |
||
|
idemon |
||
| Sun Aug 12, 2007 7:21 am Post subject: | ||
|
Sorry about my slow reply works been running long recently so have not been online much but still
Code: Fatal Error updating item information in shop. DEBUG MODE SQL Error : 1054 Unknown column 'item_limit' in 'field list' UPDATE phpbb_shopitems SET name = 'Scratch Card', shop = '3C Forum Points Shop', sdesc = 'Win big on 3C scratch cards', ldesc = 'Win big on 3C scratch cards', synth = '', icon_location = '', special_link = 'javascript:void(0);\" onClick=\"window.open(''shop/scratch_card.php'',''Scratch_Card'',''scrollbars=no,width=320,height=260'')', download_link = '', cost = 10, cash_id = 0, stock = 250, maxstock = 250, sold = 464, no_give = 0, item_limit = 0, decay = 0, give_item = 0 WHERE id = 2 Line : 317 File : shop_items.php |
||
|
Thoul |
||
| Sun Aug 12, 2007 7:42 am Post subject: Re: Fatal Error updating item information in shop. | ||
|
Okay, you're missing part of the Shop's SQL upgrades. You'll need to run this query on your database.
Code: ALTER TABLE `phpbb_shopitems` ADD `item_limit` INT (10) DEFAULT 0;
Even after running that, you may get other errors in this area that mention a different "Unknown column." To fix those, you will need to run some of these queries. Just use the lines here that mention the column (like decay, no_give, etc) named in the error. Code: ALTER TABLE `phpbb_shopitems` ADD `decay` int (10) DEFAULT 0;
ALTER TABLE `phpbb_shopitems` ADD `icon_location` VARCHAR (255) NULL; ALTER TABLE `phpbb_shopitems` ADD `no_give` TINYINT (1) DEFAULT 0; ALTER TABLE `phpbb_shopitems` ADD `download_link` VARCHAR (255) NULL; ALTER TABLE `phpbb_shopitems` ADD `give_item` TINYINT (1) DEFAULT 1; |
||
Page 1 of 1