can’t save changes

  • Resolved adamtcc

    (@adamtcc)


    3 years, 4 months ago

    I have the latest version 1.3.14 of Appointment Hour Booking plugin installed.

    When I go to any of my calendars and click “edit” and then go to the field settings and make a change, for example, I change the Duration from 75 mins to 60 mins OR I check the box “Generate time slots automatically based on service duration” THEN I click the button “Save Changes and Continue Editing” OR I click the box at the top “Save Changes and Return” I get the message at the top saying “Settings saved.” BUT when I go back into the calendar nothing was changed.

    I upgraded word press to the latest version 5.8 but that didn’t fix the problem.

    I see someone else posted the same problem a year ago but the post doesn’t have a solution.

    Any ideas?

    Thanks.

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

  • You need to delete the caches, it happens in WP due caches are saved, just inactive cache plugin if you are using

    Thread Starter adamtcc

    (@adamtcc)

    Thanks for the reply @launchme10x

    I’m not sure what you are suggesting that I do.

    I installed a new plugin called WP Super Cache and used it to delete the cache, that didn’t fix it. I also deactivated the Appointment Hour Booking plugin and reactivated it, that didn’t fix it. Is that what you were suggesting?

    Also, I found out that updates were done this morning which might have caused this new problem.

    Plugin Author codepeople

    (@codepeople)

    Hi,

    Please try installing a “Query Monitor” plugin to check if it reports some database queries issue after clicking “Save changes”.

    Thank you.

    Thread Starter adamtcc

    (@adamtcc)

    Thanks for the reply @codepeople

    I installed “Query Monitor” and I did get 2 database errors after clicking save changes:

    Query
    —–
    ALTER TABLE wp4t_cpappbk_forms
    ADD vs_text_nmore text

    Caller
    ——
    CP_APPBOOK_BaseClass->add_field_verify()

    Component
    ———
    Plugin: appointment-hour-booking

    Error Message
    ————-
    Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

    Error Code
    ———-
    1118

    ===
    AND
    ===

    Query
    —–
    UPDATEwp4t_cpappbk_forms`

    Caller
    ——
    CP_AppBookingPlugin->save_options()

    Component
    ———
    Plugin: appointment-hour-booking

    Error Message
    ————-
    Unknown column ‘vs_text_nmore’ in ‘field list’

    Error Code
    ———-
    1054

    Thread Starter adamtcc

    (@adamtcc)

    Anyone have any idea how to fix this without having to completely remove/uninstall the app and then reinstall it?

    Plugin Author codepeople

    (@codepeople)

    Hi,

    That’s a problem with an incomplete database update from an older version of the plugin.

    Please post a message at the following page and we will give you a plugin version with an automatic patch for that issue: https://apphourbooking.dwbooster.com/contact-us

    Thank you!

    Dear codepeople,

    I guess I have a similar issue. No changes can be saved.
    The Query Monitor says:
    “Row size too large.”
    and
    “Unknown column ‘vs_text_nmore’ in ‘field list'”

    I should have the last unpaid version, like I uninstalled and installed the plugin again.
    Thank you for your help.

    Plugin Author codepeople

    (@codepeople)

    Hi,

    That’s a problem with an incomplete database update from an older version of the plugin.

    Please post a message at the following page and we will give you a plugin version with an automatic patch for that issue: https://apphourbooking.dwbooster.com/contact-us

    Thank you!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘can’t save changes’ is closed to new replies.