$booking = Booking::findFirst(3278); $booking->BookingStatus = Booking::STATUS_CANCELLED; $booking->update();
Produce this sql:
UPDATE `Booking` SET `QrCode` = '', `isOnSchedule` = 0 WHERE `Id` = 3278 AND `Route` = 2 AND `UBR` = 'UBR-58974' AND `CreatedAt` = '2014-06-13 21:22:35' AND `SlotTime` = '11:00' AND `FlightDate` = '2014-08-02' AND `BookingStatus` = '0'
That is totaly wrong!!!! Who this can be?
1) Why QrCode and isOnSchedule is updated?
2) Why BookingStatus is not updated?
I notice this problem on several ocasions. Booking table have one foreign key. I noticed that all tbales with forwign keys have same problem. This is big issue.