Booking

Hello All,
I have recently updated to moodle 3.5.3 and upgraded all my plugins as well. When I try to update the booking plugin I get the following error:
mod_booking
Error writing to database
More information about this error
×Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'bt
WHERE bt.optionid NOT IN
(SELECT bo.id FROM m' at line 1
DELETE FROM mdl_booking_teachers bt
WHERE bt.optionid NOT IN
(SELECT bo.id FROM mdl_booking_options bo
WHERE bo.id IS NOT NULL)
[array (
)]
Error code: dmlwriteexception
×Stack trace:
line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown
line 1139 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1787 of /mod/booking/db/upgrade.php: call to mysqli_native_moodle_database->execute()
line 806 of /lib/upgradelib.php: call to xmldb_booking_upgrade()
line 512 of /lib/upgradelib.php: call to upgrade_plugins_modules()
line 1857 of /lib/upgradelib.php: call to upgrade_plugins()
line 694 of /admin/index.php: call to upgrade_noncore()
When clicking on more information, I see that increasing the max_allowed_packets can sometimes work. I have increased out max_allowed_packets for 1.3 gigs and nothing changed. I have also converted our InnoDB to Barracuda as the dmlwriteexception instructions say might help and still the same error message pops up when trying to update the plug in. What do I do next? We utilize this plugin daily and would be heartbroken if we lost it

Hello All,
I have recently updated to moodle 3.5.3 and upgraded all my plugins as well. When I try to update the booking plugin I get the following error:
mod_booking
Error writing to database
More information about this error
×Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'bt
WHERE bt.optionid NOT IN
(SELECT bo.id FROM m' at line 1
DELETE FROM mdl_booking_teachers bt
WHERE bt.optionid NOT IN
(SELECT bo.id FROM mdl_booking_options bo
WHERE bo.id IS NOT NULL)
[array (
)]
Error code: dmlwriteexception
×Stack trace:
line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown
line 1139 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1787 of /mod/booking/db/upgrade.php: call to mysqli_native_moodle_database->execute()
line 806 of /lib/upgradelib.php: call to xmldb_booking_upgrade()
line 512 of /lib/upgradelib.php: call to upgrade_plugins_modules()
line 1857 of /lib/upgradelib.php: call to upgrade_plugins()
line 694 of /admin/index.php: call to upgrade_noncore()
When clicking on more information, I see that increasing the max_allowed_packets can sometimes work. I have increased out max_allowed_packets for 1.3 gigs and nothing changed. I have also converted our InnoDB to Barracuda as the dmlwriteexception instructions say might help and still the same error message pops up when trying to update the plug in. What do I do next? We utilize this plugin daily and would be heartbroken if we lost it

Hello All,
I have recently updated to moodle 3.5.3 and upgraded all my plugins as well. When I try to update the booking plugin I get the following error:
mod_booking
Error writing to database
More information about this error
×Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'bt
WHERE bt.optionid NOT IN
(SELECT bo.id FROM m' at line 1
DELETE FROM mdl_booking_teachers bt
WHERE bt.optionid NOT IN
(SELECT bo.id FROM mdl_booking_options bo
WHERE bo.id IS NOT NULL)
[array (
)]
Error code: dmlwriteexception
×Stack trace:
line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown
line 1139 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1787 of /mod/booking/db/upgrade.php: call to mysqli_native_moodle_database->execute()
line 806 of /lib/upgradelib.php: call to xmldb_booking_upgrade()
line 512 of /lib/upgradelib.php: call to upgrade_plugins_modules()
line 1857 of /lib/upgradelib.php: call to upgrade_plugins()
line 694 of /admin/index.php: call to upgrade_noncore()
When clicking on more information, I see that increasing the max_allowed_packets can sometimes work. I have increased out max_allowed_packets for 1.3 gigs and nothing changed. I have also converted our InnoDB to Barracuda as the dmlwriteexception instructions say might help and still the same error message pops up when trying to update the plug in. What do I do next? We utilize this plugin daily and would be heartbroken if we lost it

Hey David,
Thank you for your great Plugin!
One Question: When i duplicate the Activity, then all Institutions I've created get duplicated as well. Is this intended?

Hi David, Another issue we are seeing with Connected Bookings is if there are allready users booked into sessions when the connected booking is set, the option to copy users does not appear for teachers. Should I report this as a bug or was this intended?

Hi David, One of my schools is using the connected booking option to copy students from a Wednesday booking to a Tuesday booking for tutorial sessions. These tutorials happen on a weekly basis. When users are transferred, they go to the previous week's booking instead. I have looked at the database, and the connected booking ID's are correct. Is there any other place I should look to try to figure out why the mapping is not correct?

Hi David,
I have a list of booking options for my students where they can pick only one, so I setup to 1 on the section "Max current bookings per user". The help button claims this "The maximum of number of bookings an individual user can make in this activity at once. After an event end time has passed, it is not longer counted against this limit."
After the end time of the booking option has passed, the student can't book because they booked in another one previously.
Thank you for this great plugin, and I appreciate the time to check this issue.
All the best!

Hi David,
thank you for help. It seems to be working, just there is still problem with the title of booking - it is still not good.

Hi Jurgita,
the version, that provides support for your language is available now. Please give feedback, if it works.
Kind regards,
David

Hi Jurgita,
thank you for your question. In fact this is a known bug and has been fixed with this issue: https://github.com/dasistwas/moodle-mod_booking/commit/ed9d62d858575dcc81c74baeb7898f0ba208e6b0 I will release the new version with the fix this week here in the plugin database.
Kind regards,
David

Hi David,
When I download the sign in sheet the font does not sow the Lithuanian letters. How can I change the font the sign in sheet?

Hi, Clement Herr. I fixed the issue posted on github. There is no feature for e-mail notifications when a booking option date was changed. But you can always contract me if you want to add that feature. Kind regards, David

Hi David,
I am looking into e-mail notifications and posted an issue on your Github.
I also had a question because I'm not sure if this was a feature : are notification e-mails sent (with icalendar attachment) to users if the date of an existing booking option is changed ?
Thanks again

Hi Rob, if you mean the fields that can be configured in the site administration. Then these can not be imported. Kind regards, David

Hi David,
Can a custom field be populated via the csv import?