Database lost on upgrade
-
When updating from 2.9.9.5.8 to 2.9.9.6.2 the complete booking part of the database drops, the calendars/bookings gets deleted.
Is this a known issue?
My server is php8.3, db is mariadb 10.5-
This topic was modified 3 months, 1 week ago by
fagylaltdev.
-
This topic was modified 3 months, 1 week ago by
-
Hi,
This is not something that should happen. In the FREE version, the plugin database is not deleted, even when the plugin is uninstalled (this is done intentionally to support upgrades to PRO). Also, we have not made any database changes since version you previously had.
If possible, please send any relevant error logs (WordPress debug log and/or server PHP error log) so we can further investigate.
Regards, Marius
I am having the same issue.
The WordPress debug log does not show any errors. I can’t see the php logs because I am using managed WordPress via GoDaddy and they only give you access to the wordpress logs. In the request for the bookings on the wp admin site I see the following request params:
action=dopbsp_reservations_list_get&calendar_id=undefined&start_date=&end_date=&start_hour=00%3A00&end_hour=23%3A59&status_pending=false&status_approved=false&status_rejected=false&status_canceled=false&status_expired=false&payment_methods=&search=&page=1&per_page=25&order=ASC&order_by=check_in&nonce=b7e484402c
I think the issue is that the admin site is not loading the calendars properly and then passing undefined rather than an id number as the calendar id.
On the website side of things the calendar shows correctly and the bookings seem to be present because the calendar shows the booked days.
Is there a way to downgrade the version of the plugin to get it to load again?
-
This reply was modified 3 months, 1 week ago by
alexkunger.
I used WP Rollback and went back to version 2.9.9.5.8 and now my reservations are showing in the admin site. There seems to be a bug between that version and the newer versions.
I have disabled automatic updates on the plugin for now. Please advise how to proceed.
It is likely that the user who originally installed the plugin has been deleted or you are currently logged in with a different WordPress user account.
You can regain access to the calendars and reservations by adjusting the plugin’s permissions here: Plugin Settings → User Permissions
From there you can allow administrators to view all calendars or assign access to specific users.
Regards, Marius
I have a similiar issue after upgrading to the latest version. Calendars and bookings weren’t deleted from database at all, but they aren’t accessible by Author users even when corresponding user permissions are set – they are visible only by administrators. Downgrading the plugin to version 2.9.9.5.8 “resolves” the issue.
Yeah, i mispoke, the DB is still there, but the UI shows that i have no reservations or calendars.
But i can still query the tables just fine manually.Updating user permissions does get the calendars/reservations back, thank you!
If you have a lower-permission user who needs access to other users’ calendars, you must grant permissions for each calendar individually. We identified a bug affecting this behavior; it has been fixed and will be included in the next update.
Regards, Marius
-
This reply was modified 3 months, 1 week ago by
You must be logged in to reply to this topic.