SMF Shop

SMFShop => Bugs => Topic started by: kinggreg10 on February 07, 2008, 05:46:04 am

Title: Buying stuff and getting a error
Post by: kinggreg10 on February 07, 2008, 05:46:04 am

im getting this when i try to buy stuff in the shop:

Field 'trading' doesn't have a default value
File:htdocs/Forum/Sources/shop/Shop-Buy.php
Line: 206

know why?

This is what line 206 states:             
{$row['price']})",   __FILE__, __LINE__);

Title: Re: Buying stuff and getting a error
Post by: Daniel15 on February 15, 2008, 07:10:57 am

Try run this MySQL query in phpMyAdmin (on the "SQL" tab):

Code: [Select]

ALTER TABLE `smf_shop_items` CHANGE `trading` `trading` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0'
This should fix it