Booking with status 'o'

Issue #36 resolved
Justin Hayes repo owner created an issue

Steve spotted a booking that showed no details when clicking on it to edit/view.

Had a look in the DB and the status was 'o', which shouldn't be possible. Appears to be 3 bookings like that:

mysql> select * from booking where status = 'o'; +------------+-----------+--------+---------------------+---------------------+---------+-------+---------------------+------------+---------------------+------------+ | booking_id | object_id | status | start | end | user_id | notes | created | created_by | updated | updated_by | +------------+-----------+--------+---------------------+---------------------+---------+-------+---------------------+------------+---------------------+------------+ | 3057 | 1 | o | 2012-09-08 08:00:00 | 2012-09-08 13:00:00 | 53 | | 2012-09-06 15:51:14 | 53 | 2012-09-08 06:49:28 | 12 | | 3061 | 1 | o | 2012-09-09 15:00:00 | 2012-09-09 19:00:00 | 35 | | 2012-09-07 17:28:25 | 35 | 2012-09-08 06:50:05 | 12 | | 3462 | 0 | o | 2013-01-07 10:00:00 | 2013-01-07 12:00:00 | 86 | | 2012-12-19 17:27:01 | 23 | 2013-01-05 14:15:13 | 12 | +------------+-----------+--------+---------------------+---------------------+---------+-------+---------------------+------------+---------------------+------------+ 3 rows in set (0.01 sec)

Need to see if I can figure out why...

Comments (2)

  1. Log in to comment