Another There was an error while saving item

  • Resolved elarson

    (@elarson)


    9 years, 1 month ago

    I already saw previous posts about “There was an error while saving item”, and I have the same problem with a new install of version 1.3.6. It happened with a booking from the admin interface. When I did a booking from the front end with CTF7 I received a notification, but did not see a booking in the admin interface.

    I am unclear as to how this was fixed. I have tried Option 1: deactivating, removing and reinstalling the plugin, but that did not work.

    I also tried Option 2, but am stuck on the last step: Go the structure tab and add the column uid varchar(500) NOT NULL DEFAULT ”. Please see the following screenshots of the structure of the table AvailabilityBooking_Bookings.

    This is the structure of the table before I altered it: https://www.tropikalmaio.com/wp-content/uploads/AvailabilityBooking_Bookings.png

    This is how I added column uid: https://www.tropikalmaio.com/wp-content/uploads/AvailabilityBooking_Bookings-add-column-uid.png

    This is after I added column uid: https://www.tropikalmaio.com/wp-content/uploads/AvailabilityBooking_Bookings-after-add-column-uid-.png

    I then tried to “Go to the table prefix_options and search for the option AvailabilityBooking_Uid_Updated and delete this option.” I am not understanding what you mean by this. Can you please try to explain more?

    I’d really appreciate if you can help resolve this quickly, because the owner of the site is visiting this weekend and I want to show them.

    I really like the concept of your plugin with CTF7 and hope you keep at it. I’ve used the Booking Calendar plugin a few years on a few sites (both free and paid), but am getting frustrated with the lack of basic functionality in the free version for small customers — like the possibility to have multiple rooms and to be able to send e-mails notifications in various languages.

    BTW, I’m a native English speaker living in the Netherlands. Let me know if you want some help with documentation (once I figure it all out).

    https://www.ads-software.com/plugins/jm-avail-booking/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter elarson

    (@elarson)

    After writing that very long message I just went to test again, even though I did not do the last step “Go to the table prefix_options and search for the option AvailabilityBooking_Uid_Updated and delete this option.”.

    It appears to work now. Will it cause me any problems not having done this last step?

    Plugin Contributor Jan Maat

    (@jan-maat)

    Hi,

    If last step is only required when you plan to synchronize (upload) to an external calendar. Even in this case only when you update from a previous version with bookings in the database.

    If the option “AvailabilityBooking_Uid_Updated” is not set or not present at activation the UID for each booking is calculated and entered into the database. This UID needs a value when uploaded to an external calendar.

    Regards,

    Jan

    Thread Starter elarson

    (@elarson)

    Thanks Jan. That’s good to hear. My next step is to sync with Airbnb.

    Plugin Contributor Jan Maat

    (@jan-maat)

    Hi,

    In my previous answer I forgot to mention that for new bookings (either via the CTF7 or Admin) the UID is generated and stored. So the procedure with the AvailabilityBooking_Uid_Updated? is only required for bookings already in the database before the update.

    If you start with the synchronization with Airb&b read my remarks about external calendars in the description. They are valid for Airb&b.

    To sync to Airb&b (upload to ) works fine. The synch from Airb&b (download) duplicate the booking each time it is downloaded. For each download Airb&b generate a new UID for al the bookings. So I am not able to detect if it is a new or an already existing booking.

    Regards,

    Jan

    Thread Starter elarson

    (@elarson)

    Thanks Jan. I think that pretty much makes a bidirectional sync not possible. It’s understandable, but disappointing. I had wondered how you did that! I appreciate your candor (directness) about it.

    I think that means that it would be better to add Airbnb bookings directly in the admin interface. I am not sure if I have an error, or if it is within known functionality, but I could not get a datepicker working within admin. That will make it hard for the user to add these bookings manually. Any input?

    Plugin Contributor Jan Maat

    (@jan-maat)

    Hi,

    I did a quick check on some site but did not see any problems with the datepicker in the admin forms.
    Can you give me the source code of the page with one of the forms. I suspect an jQuery issue.

    Today and tomorrow I am real busy so I not sure to give you an answer before Monday.

    As to the bidirectional sync it is AirB&B not following the iCal specification. The UID is like a social security number. When born an agenda item gets an UID and this should not be changed when traveling through different calendars.

    Regards,

    Jan

    Thread Starter elarson

    (@elarson)

    Hi Jan,

    I just went to check again and the datepicker is working in admin. So please, don’t spend any time on this.

    Interesting about Airbnb not using persistent UIDs. That kind of goes against what they are there for!

    — Ellyn

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Another There was an error while saving item’ is closed to new replies.