Skip to content

Instantly share code, notes, and snippets.

@jennyq

jennyq/clear_invalid_timezone.sh

Last active August 29, 2015 14:16
Show Gist options
  • Save jennyq/71d1c4b69f8806c40074 to your computer and use it in GitHub Desktop.
Save jennyq/71d1c4b69f8806c40074 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
clear_invalid_timezone.sh
#!/bin/bash
sql="update articles_article set timezone='US/Hawaii' where timezone='US/Hawaii: HST';"
sudo -u postgres psql -d tendenci_site -c "$sql"
sql="update news_news set timezone='US/Hawaii' where timezone='US/Hawaii: HST';"
sudo -u postgres psql -d tendenci_site -c "$sql"
sql="update directories_directory set timezone='US/Hawaii' where timezone='US/Hawaii: HST';"
sudo -u postgres psql -d tendenci_site -c "$sql"
sql="update events_event set timezone='US/Hawaii' where timezone='US/Hawaii: HST';"
sudo -u postgres psql -d tendenci_site -c "$sql"
sql="update profiles_profile set time_zone='US/Hawaii' where time_zone='US/Hawaii: HST';"
sudo -u postgres psql -d tendenci_site -c "$sql"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment