Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

To avoid massiv SQL Bug on next update: Make sure empty string availability columns get "[]" #765

Closed
georgmaisser opened this issue Dec 12, 2024 · 0 comments
Closed

To avoid massiv SQL Bug on next update: Make sure empty string availability columns get "[]" #765

georgmaisser opened this issue Dec 12, 2024 · 0 comments
Assignees
@georgmaisser @eynimeni
Labels
INTERN-2024

Comments

@georgmaisser
Copy link
Contributor

georgmaisser commented Dec 12, 2024 •
edited
Loading

in Upgrade php:

UPDATE {booking_options}
SET availability = '[]'
WHERE availability = '' OR availability IS NULL

Also!
in get_all_answers_for_user_cached function introduce try-catch to avoid error
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@georgmaisser georgmaisser

@eynimeni eynimeni

Labels
INTERN-2024
Projects
None yet
Milestone
No milestone
Development

When branches are created from issues, their pull requests are automatically linked.

refs/heads/765-to-avoid-massiv-sql-bug-on-next-update-make-sure-empty-string-availability-columns-get Wunderbyte-GmbH/moodle-mod_booking
3 participants
@georgmaisser @bernhard-wunderbyte @eynimeni