mysql bug - either php 5 or mysql 5 problem

[feeble]

been getting

Code: [Select]

Database Error: Field 'trading' doesn't have a default value
File: D:\htdocs\Sources\shop\Shop-Buy.php
Line: 206
to fix your install daniel can you consider changing:

Code: [Select]

db_query("
CREATE TABLE IF NOT EXISTS {$db_prefix}shop_inventory (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`ownerid` INT UNSIGNED NOT NULL ,
`itemid` INT UNSIGNED NOT NULL ,
`amtpaid` DECIMAL(8, 2) UNSIGNED DEFAULT '0.00' NOT NULL,
`trading` TINYINT(1) UNSIGNED NOT NULL,
`tradecost` DECIMAL(8, 2) NOT NULL,
PRIMARY KEY (`id`)
)", __FILE__, __LINE__);to

Code: [Select]

db_query("
CREATE TABLE IF NOT EXISTS {$db_prefix}shop_inventory (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`ownerid` INT UNSIGNED NOT NULL ,
`itemid` INT UNSIGNED NOT NULL ,
`amtpaid` DECIMAL(8, 2) UNSIGNED DEFAULT '0.00' NOT NULL,
`trading` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL,
`tradecost` DECIMAL(8, 2) DEFAULT '0.00' NOT NULL,
PRIMARY KEY (`id`)
)", __FILE__, __LINE__);

[Daniel15]

Grrr... Looks like a MySQL Strict Mode problem. Strict mode is a new MySQL mode introduced with MySQL 5. Basically, it's very strict about all the little things that it never used to care about

I'll try fix this as soon as possible

[feeble]

Grrr... Looks like a MySQL Strict Mode problem. Strict mode is a new MySQL mode introduced with MySQL 5. Basically, it's very strict about all the little things that it never used to care about

I'll try fix this as soon as possible

bah

clean up your code

mysql 5 is the future.

[Daniel15]

clean up your code

It's not my fault, most of the table creation queries were taken directly from either phpMyAdmin or mysqldump (both running under MySQL 4)

I do a lot of development work on a server running PHP 5.2.1 and MySQL 5.0.32, and haven't experienced any problems - I guess strict mode is turned off in my config.

[palatable]

I have this problem. It's great advice for me. Thank you.