Users cannot make a booking

  • Resolved Cebetyr

    (@cebetyr)


    3 years, 5 months ago

    Hi,

    When filling in the form, when clicking on Send you get this message at the bottom of the booking form page (and no form details are being sent or registered):

    Error during updating hash in BD
    [F:/booking_hash.php| L:110|V:9.4.1| DB:Unknown column bk.hash in field list::UPDATE wp_menton_inweb_nu_booking AS bk SET bk.hash = MD5(1667978710_961503) WHERE bk.booking_id = 52]

    Best regards
    Cecilia

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author wpdevelop

    (@wpdevelop)

    3 years, 5 months ago

    Hello.
    Please be sure that your MySQL user (which is using in config.php file) have the rights for database creation and modification fields in table.

    If you do not sure about this, please contact support of your hosting company about helping with checking this.

    In case, if your WordPress user do not have such rights, so then during activation of plugin will not be created new fields in DB table and also possible that some tables will not be created.

    P.S. If you do not have some important bookings or settings, we recommend making a FULL reinstall of plugin. For this please open the general booking settings page and make checked the “Delete booking data during deactivation of plugin” at the right side. Then open the WordPress plugins menu and click on “Deactivate” link. Wait for the message that plugin is deactivated successfully. After this Click on “Activate” link of Booking Calendar plugin and wait for the message that plugin is activated successfully. After this test it again.

    Kind Regards.

    • This reply was modified 3 years, 5 months ago by wpdevelop.
    Thread Starter Cebetyr

    (@cebetyr)

    3 years, 5 months ago

    Hi,

    Thank you very much for your prompt response!

    I have followed your instructions:
    – Checked the database access for users (who had full rights)
    – Deactivated the plugin (after having checked the box for “Delete …”) and activating it again.

    Unfortunately, I get the same message (but different table line figures):
    Error during updating hash in BD
    [F:/booking_hash.php| L:110|V:9.4.1| DB:Unknown column bk.hash in field list::UPDATE wp_menton_inweb_nu_booking AS bk SET bk.hash = MD5(1667997101_29661) WHERE bk.booking_id = 57]

    Is the only option now to to delete the plugin, reinstall it and remake all configuration incl rewriting all e-mail messages? Or is there any other option to handle the failure?

    Best regards,
    Cecilia

    Plugin Author wpdevelop

    (@wpdevelop)

    3 years, 5 months ago

    Hello.
    I do not sure that your MySQL user, what is configured for using in your WordPress website, still have the permission for altering of the DB tables. Please recheck it.

    Otherwise you can execute manually this SQL command in phpMyAdmin or in some other DB editing tool:
    ALTER TABLE wp_menton_inweb_nu_booking ADD hash TEXT AFTER form
    Kind Regards.

    • This reply was modified 3 years, 5 months ago by wpdevelop.
Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Users cannot make a booking’ is closed to new replies.