Data truncated for column (since upgrade to php5 and mysql5)

[duff1]

I'm having this since since I upgraded from MySQL 4.0 to 5.1

1265 - Data truncated for column 'customers_credit_left' at row 1

insert into orders (customers_id, orders_status, purchase_order_number, customers_credit_left, customers_credit_amount, currency, currency_value) values ('2', '1', '', '', '', 'CAD', '1.00000000')

and the field is configured as:

customers_credit_left decimal(9,2) NOT NULL DEFAULT '250.00',

anybody can help me solve this problem?

[Weedpacket]

I see you're trying to insert an empty string into the customers_credit_left field (I don't know what MySQL would do in that situation, but most DBMSs would complain about bad syntax).

If you want to use the default value for the field, don't supply one in the insert statement.

[duff1]

Because the customer can choose to pay with credit account. But it was working well with MySQL4 but I'm now having this error since I upgraded to MySQL5.

[bradgrafelman]

You might try replacing '' with NULL, but as Weedpacket suggests, if no value is specified then you should simply leave it out of the SQL query altogether.