I have a table ("tasks") with:
and more fields
when I do the following (using phpMyAdmin):
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it does change.
To make it even more wacky, if I (using phpMyAdmin) change it to
'H' it will change and the row is shown change, but when I go to
examine the row (using the pencil icon=Edit) it changes back to 'W'.
Either there is something really strange or my mysql is possessed.
I am using Server version: 5.1.63-0ubuntu0.10.04.
Anyone have any thoughts about this or suggestions on how to
I discovered this because the application was failing to change
the W to a H using update syntax.