Title: Error adding new service
Last modified: August 30, 2016

---

# Error adding new service

 *  Resolved [Matthew Welch](https://wordpress.org/support/users/matthew-welch/)
 * (@matthew-welch)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/error-adding-new-service/)
 * I’ve just installed WordPress and the JoeBooking plugin. An error is generated
   when adding a new service. Output from the screen shows:
 * The query was:
    INSERT INTO wp_ha_v6_services (title, description, duration, 
   duration_break, duration2, lead_out, id, recur_total, recur_options, min_cancel,
   show_order, blocks_location, blocks_resource, duration_increment, duration_max,
   lead_in, price, price_increment, prepay, return_url, allow_queue)
 * VALUES (‘Test2’, ‘Desc’, 900, 0, 0, 0, 0, 1, ‘d-2d-w’, 86400, 5, 0, 0, 1800, 
   1800,
    ”, ”, ”, ”, ”, 0)
 * MySQL error occurred ERROR: MySQL error – 0:
 * Attempting to apply the same INSERT in the Navicat for MySQL tool also errored
   out but with an additional message:
    [Err] 1366 – Incorrect integer value: ” 
   for column ‘lead_in’ at row 1
 * It appears that the ‘lead_in’ column in the database is of type INT but an empty
   string is used in the INSERT statement. Updates to existing entries works fine.
 * Note, I am not using the premium version of the plugin. Any help on this would
   be appreciated.
 * [https://wordpress.org/plugins/joebooking/](https://wordpress.org/plugins/joebooking/)

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

 *  Thread Starter [Matthew Welch](https://wordpress.org/support/users/matthew-welch/)
 * (@matthew-welch)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/error-adding-new-service/#post-6203151)
 * Note, the site can be found here (webapp parrot1):
    [http://ccchicap.azurewebsites.net/booking/](http://ccchicap.azurewebsites.net/booking/)
 *  Plugin Author [hitcode](https://wordpress.org/support/users/hitcode/)
 * (@hitcode)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/error-adding-new-service/#post-6203154)
 * Hello,
    sorry for not replying sooner. This was a bug (only appearing with some“
   strict” SQL database configurations), it’s fixed now in 6.3.6 version.

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

The topic ‘Error adding new service’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/joebooking_f1f1f1.svg)
 * [JoeBooking - Time Slot Booking](https://wordpress.org/plugins/joebooking/)
 * [Support Threads](https://wordpress.org/support/plugin/joebooking/)
 * [Active Topics](https://wordpress.org/support/plugin/joebooking/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/joebooking/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/joebooking/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [hitcode](https://wordpress.org/support/users/hitcode/)
 * Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/error-adding-new-service/#post-6203154)
 * Status: resolved