Added two additional order status fields

[gloerick]

Hello All,

I was just wondering if anyone had added additional order staus fields and started to get the error
1366 Incorrect integer value: '' for column 'orders_status' at row 1"

Been seaching and have not found anything on it ? is it an illigal character ?

Orders Status
Pending (default)
Processing
Order Complete UPS Delay=+/-Week
Order Complete, Awaiting UPS #
Shipped
Delivered


Any help would be appriciated.

Thx
Erick

[gjh42]

Try renaming the new statuses without the non-alphameric characters =+/-,# and see if the error goes away. If it does, add them back one at a time.

[gloerick]

1366 Incorrect integer value: '' for column 'orders_status' at row 1
in:
[update orders set orders_status = '', last_modified = now() where orders_id = '28']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


is the error even when I rename to "Awaiting Tracking No"
and the "Order Complete UPS Delay=+/-Week" updates fine no error,
only with this on spot # 4 and the 2 spots after it 5,6, shipped and delivered update ok.

very odd.

[gloerick]

also, where to I adjust the NEW ORDER table in the admin home page ?
I need to make the right side that displays the status and $ amount a bit wider
to fit my longer status names.