The plugin doesn’t create database tables

  • Resolved sesolovyev

    (@sesolovyev)


    6 years, 3 months ago

    I installed and activated the latest version of the plugin 8.7.5 and it didn’t create needed database tables. I’ve checked the db user permissions (they seem to be okay. I tried to run SQL queries manually and they succeeded). I also tried to check the database logs with https://ww.wp.xz.cn/plugins/query-monitor/ but the only failed request during the plugin activation came from the admin panel menu:

    SELECT bk.booking_id
    FROM wp_linkopingsklatterklubb_se_booking as bk
    WHERE bk.is_new = 1
    AND bk.trash != 1 +
    wpbc_get_number_new_bookings()
    Plugin: booking Table ‘linkopingsklatterklubb_se.wp_linkopingsklatterklubb_se_booking’ doesn’t exist

    Note that there was no prior call to the database with “CREATE TABLE …” meaning that the plugin never tried to create the table in the first place.
    Obviously when I try to create a booking I’m getting an error “Table ‘linkopingsklatterklubb_se.wp_linkopingsklatterklubb_se_booking’ doesn’t exist”.

    What am I doing wrong? Why the plugin doesn’t create the table automatically as it should?

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

    (@wpdevelop)

    6 years, 3 months ago

    Hello.
    1) Please open the Booking > Settings General page and in Uninstall deactivation section set checked this option “Delete booking data, when plugin deactivated”.

    2) Then try to deactivate the Booking Calendar plugin at the WordPress > Plugins menu, and wait until its show message that plugin successfully deactivated.

    3) After this activate the Booking Calendar, plugin and wait for the message that is was successfully activated.

    If you still will have issue, please recheck your error.log in the server configuration.
    Thank you.

    Thread Starter sesolovyev

    (@sesolovyev)

    6 years, 3 months ago

    Hi, thank you for the prompt response. I did these steps many times yesterday and they didn’t help. I’ll check error.log (if there is one) and come back here.

    Thread Starter sesolovyev

    (@sesolovyev)

    6 years, 3 months ago

    Checked the log and indeed the issue was caused by not enough rights for the database account (in the admin panel the same account has different rights depending on what tool is used). I granted the permissions and the plugin created the tables during the activation.

    Thank you for your help, the issue can be closed.

    Plugin Author wpdevelop

    (@wpdevelop)

    6 years, 3 months ago

    Thank you for let me know.
    Kind Regards.

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

The topic ‘The plugin doesn’t create database tables’ is closed to new replies.