Delete booking but room still locked for that time and there is a phantom booking

Hello,

When I delete a booking, it is no longer in the booking list view but still appears on the bulk calendar page. When I click it, I get an AJAX error and the room cannot be booked for that time period.

In the DB I do see "event 5" under Rooms Booking Locks but there is no way to delete it in phpMyAdmin.

I also found the Rooms Availability table. I made a backup and deleted entries for that unit (I only had the booking so I wasn't worried about deleting old bookings) and that seemed to release the unit for booking. I was able to make a successful booking.

The issue still persists in that if I delete a booking, there is still a phantom booking and the Rooms Availability table is not updated.

I ended up starting from scratch and migrating the work I had done over.

I have been able to replicate the problem: I emptied the Rooms Unit Type and Rooms Unit tables, recreated unit types and units and saw the phantom bookings from the old units. I believe that there is another table that I may be missing.

UPDATE: Third install and I still have this issue. I can provide a Teamviewer login to any of the devs or the DB. The only way I can delete them is by going to the rooms_availability table and deleting the rows for those units.

UPDATE2: I think I found what the issue is: when deleting using VBO, it doesn't completely remove the booking properly.

Thanks.