search

bigbluebutton / greenlight

A really simple end-user interface for your BigBlueButton server.
GNU Lesser General Public License v3.0
796 stars 3.79k forks source link

Fix mails with uppercase letters #5744

Closed Lukas-Rotermund closed 7 months ago

Lukas-Rotermund commented 7 months ago

Hello,

in the patchnotes for release-3.0.9 it says there is a migration task to fix the mails in the db to be lowercase. The task runs aotomatically on update. Is it possible to run this task seperately without updating greenlight-v3?

farhatahmad commented 7 months ago

You can run these commands

docker exec -it greenlight-v3 rails c

and then paste this code in the console

User.all.find_each(batch_size: 250) do |user|
  downcase = user.email.downcase
  next if user.email == downcase

  user.update(email: downcase)
end