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 1It 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.
- The topic ‘Error adding new service’ is closed to new replies.