Author Topic: Buying stuff and getting a error  (Read 2492 times)

Offline kinggreg10

Buying stuff and getting a error
« 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__);

Offline Daniel15

Re: Buying stuff and getting a error
« Reply #1 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