WordPress database error (Unknown column ‘tags’)

  • Resolved Jan Boddez

    (@janboddez)


    7 months, 2 weeks ago

    Hi!

    I ran into an issue lately with v23.7. Whenever I submit a new appointment from a front-end form, Bookly runs into a database error. As a result, the customer isn’t inserted. The appointment is created, but no contact details are stored!

    I see the following errors in WordPress’ debug log:

    WordPress database error Unknown column 'tags' in 'field list' for query INSERT INTO wp_bookly_customers ... made by do_action('wp_ajax_nopriv_bookly_save_appointment') ...
    WordPress database error Column 'customer_id' cannot be null for query INSERT INTO wp_bookly_customer_appointments ... made by do_action('wp_ajax_nopriv_bookly_save_appointment') ...

    On version 23.6, everything seems to work as it should.

    Looks like maybe a database migration failed to run? When updating to the latest version?

    Would there be any way I can still trigger this migration? Or manually add the missing columns or …?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support booklysupport

    (@booklysupport)

    Hi, please reach out to us directly at [email protected] with access to your WP admin panel, and we’ll look into this matter. In your request, please mention ticket #300294.

    Thread Starter Jan Boddez

    (@janboddez)

    Before I do that (afraid I can’t just give WP-Admin access), I just noticed the update_23_7 function in lib/Updater.php, which seems to hold exactly the changes I was missing.

    I was able to run, essentially, ALTER TABLE wp_bookly_customers ADD COLUMN tags TEXT DEFAULT NULL AFTER info_fields. The problem looks solved. (While I was at it, I also added the newly introduced option to the options table.)

    No idea why the migration failed to run when the plugin was first updated.

    Plugin Support booklysupport

    (@booklysupport)

    Hello,

    Thank you for your message.

    Glad to hear that everything is working correctly.

    Let us know if you have any other questions.

    @janboddez Thanks! This was our issue as well and your solution fixed it for us ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WordPress database error (Unknown column ‘tags’)’ is closed to new replies.