Title: Database table issues after update
Last modified: October 19, 2017

---

# Database table issues after update

 *  Resolved [ogenthe](https://wordpress.org/support/users/ogenthe/)
 * (@ogenthe)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/database-table-issues-after-update/)
 * I have updated from version 2.5 to 3.0.0 beta8 and in the process we have lost
   all of our old information for rooms, etc.
    After the update, the plugin was 
   disabled by WordPress.
 * When I do in to administer rooms and availability I am seeing the following error:
   [
   Table ‘klooffix.wp_awebooking_rooms’ doesn’t exist] SELECT * FROM `wp_awebooking_rooms`
   AS `room` INNER JOIN `wp_posts` AS `post` ON (post.ID = room.room_type AND post.
   post_status = ‘publish’ AND post.post_type = ‘room_type’) ORDER BY post.ID DESC,
   room.id ASC LIMIT 15 OFFSET 0
 * WordPress database error: [Table ‘klooffix.wp_awebooking_rooms’ doesn’t exist]
   
   SELECT COUNT(*) FROM `wp_awebooking_rooms` AS `room` INNER JOIN `wp_posts` AS`
   post` ON (post.ID = room.room_type AND post.post_status = ‘publish’ AND post.
   post_type = ‘room_type’)
 * I have attampted this twice and both times I get the same result.
    All our data
   is gone and there are problems.
 * The only thing I can imagine is that there is a required update that should be
   run for the plugin before updating to 3.0.0.
 * Please advise.
 * Thanks, Oliver
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdatabase-table-issues-after-update%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Contributor [anhskohbo](https://wordpress.org/support/users/anhskohbo/)
 * (@anhskohbo)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/database-table-issues-after-update/#post-9601217)
 * Maybe this will fixed in next release, wait for feedback.
 *  Thread Starter [ogenthe](https://wordpress.org/support/users/ogenthe/)
 * (@ogenthe)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/database-table-issues-after-update/#post-9601377)
 * Thanks
 *  Thread Starter [ogenthe](https://wordpress.org/support/users/ogenthe/)
 * (@ogenthe)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/database-table-issues-after-update/#post-9601378)
 * Thanks
 *  Plugin Contributor [anhskohbo](https://wordpress.org/support/users/anhskohbo/)
 * (@anhskohbo)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/database-table-issues-after-update/#post-9601560)
 * If this issue has been fixed in your site with latest version of awebooking (
   beta9), pls let me known to mark this resolved.
 * Thanks!
 *  Plugin Contributor [anhskohbo](https://wordpress.org/support/users/anhskohbo/)
 * (@anhskohbo)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/database-table-issues-after-update/#post-9610460)
 * Closed, seem fixed in latest version

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Database table issues after update’ is closed to new replies.

 * ![](https://ps.w.org/awebooking/assets/icon-256x256.png?rev=1687448)
 * [AweBooking - Hotel Booking System](https://wordpress.org/plugins/awebooking/)
 * [Support Threads](https://wordpress.org/support/plugin/awebooking/)
 * [Active Topics](https://wordpress.org/support/plugin/awebooking/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/awebooking/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/awebooking/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [anhskohbo](https://wordpress.org/support/users/anhskohbo/)
 * Last activity: [8 years, 7 months ago](https://wordpress.org/support/topic/database-table-issues-after-update/#post-9610460)
 * Status: resolved