Skip to content

fixes

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

fixes

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
001.sql
001.sql
 
 
002.sql
002.sql
 
 
003.sql
003.sql
 
 
004.rb
004.rb
 
 
005.rb
005.rb
 
 
006.rb
006.rb
 
 
007.rb
007.rb
 
 
008.rb
008.rb
 
 
009.rb
009.rb
 
 
010.rb
010.rb
 
 
011.rb
011.rb
 
 
012.rb
012.rb
 
 
013.rb
013.rb
 
 
014_note_ranges.rb
014_note_ranges.rb
 
 
015.rb
015.rb
 
 
016_fix_swf_dimensions.rb
016_fix_swf_dimensions.rb
 
 
017_fix_md5.rb
017_fix_md5.rb
 
 
018_fix_md5.rb
018_fix_md5.rb
 
 
019_fix_pool_names.rb
019_fix_pool_names.rb
 
 
020_retrieve_bad_md5_posts.rb
020_retrieve_bad_md5_posts.rb
 
 
021_fix_deleted_pool_strings.rb
021_fix_deleted_pool_strings.rb
 
 
022_expunge_missing_images.rb
022_expunge_missing_images.rb
 
 
023_remove_expunged_posts_from_pools.rb
023_remove_expunged_posts_from_pools.rb
 
 
024_move_favorites_to_parent.rb
024_move_favorites_to_parent.rb
 
 
025_last_commented_at.rb
025_last_commented_at.rb
 
 
026_fix_unicode_capitals.rb
026_fix_unicode_capitals.rb
 
 
027_fix_banned_artists.rb
027_fix_banned_artists.rb
 
 
028_fix_has_children.rb
028_fix_has_children.rb
 
 
029_iqdb_import.rb
029_iqdb_import.rb
 
 
030_calculate_has_active_children.rb
030_calculate_has_active_children.rb
 
 
031_fix_ugoira_dimensions.rb
031_fix_ugoira_dimensions.rb
 
 
032_add_pool_category_pseudo_tags.rb
032_add_pool_category_pseudo_tags.rb
 
 
033_enable_can_approve_posts_flag.rb
033_enable_can_approve_posts_flag.rb
 
 
034_fix_dmail_filters.rb
034_fix_dmail_filters.rb
 
 
035_fix_nico_seiga_artist_urls.rb
035_fix_nico_seiga_artist_urls.rb
 
 
036_fix_hentai_foundry_artist_urls.rb
036_fix_hentai_foundry_artist_urls.rb
 
 
037_enable_can_upload_free.rb
037_enable_can_upload_free.rb
 
 
038_reset_categorized_saved_search_setting.rb
038_reset_categorized_saved_search_setting.rb
 
 
039_fix_saved_search_categories.rb
039_fix_saved_search_categories.rb
 
 
040_fix_post_scores.rb
040_fix_post_scores.rb
 
 
041_remove_expunged_posts_from_iqdb.rb
041_remove_expunged_posts_from_iqdb.rb
 
 
042_fix_user_cache_counters.rb
042_fix_user_cache_counters.rb
 
 
043_fix_whitespace_usernames.rb
043_fix_whitespace_usernames.rb
 
 
044_initialized_saved_search_tags.rb
044_initialized_saved_search_tags.rb
 
 
045_dedup_users.rb
045_dedup_users.rb
 
 
046_fix_nicovideo_artist_urls.rb
046_fix_nicovideo_artist_urls.rb
 
 
047_trim_artcomm_whitespace.rb
047_trim_artcomm_whitespace.rb
 
 
048_remove_expunged_favorites.rb
048_remove_expunged_favorites.rb
 
 
049_spam_1.rb
049_spam_1.rb
 
 
050_fix_post_tagcount.rb
050_fix_post_tagcount.rb
 
 
051_purge_invalid_tags.rb
051_purge_invalid_tags.rb
 
 
052_fix_tag_timestamps.rb
052_fix_tag_timestamps.rb
 
 
053_normalize_ugoira_data.rb
053_normalize_ugoira_data.rb
 
 
054_recategorize_user_level_mod_actions.rb
054_recategorize_user_level_mod_actions.rb
 
 
055_reindex_replacements_in_iqdb.rb
055_reindex_replacements_in_iqdb.rb
 
 
056_message_nonascii_usernames.rb
056_message_nonascii_usernames.rb
 
 
057_create_dtext_links.rb
057_create_dtext_links.rb
 
 
059_fix_favorites.rb
059_fix_favorites.rb
 
 
059_fix_twitter_intent_urls.rb
059_fix_twitter_intent_urls.rb
 
 
060_fix_favgroup_posts.rb
060_fix_favgroup_posts.rb
 
 
061_fix_favgroup_privacy.rb
061_fix_favgroup_privacy.rb
 
 
062_initialize_upload_points.rb
062_initialize_upload_points.rb
 
 
063_migrate_emails.rb
063_migrate_emails.rb
 
 
064_initialize_bulk_update_request_tags.rb
064_initialize_bulk_update_request_tags.rb
 
 
065_fix_invalid_wiki_page_titles.rb
065_fix_invalid_wiki_page_titles.rb
 
 
066_initialize_appeal_and_flag_statuses.rb
066_initialize_appeal_and_flag_statuses.rb
 
 
067_delete_invalid_email_addresses.rb
067_delete_invalid_email_addresses.rb
 
 
068_regenerate_transparent_backgrounds.rb
068_regenerate_transparent_backgrounds.rb
 
 
069_migrate_restricted_users.rb
069_migrate_restricted_users.rb
 
 
070_renormalize_labels_in_saved_searches.rb
070_renormalize_labels_in_saved_searches.rb
 
 
071_renormalize_other_names_in_wiki_pages.rb
071_renormalize_other_names_in_wiki_pages.rb
 
 
072_renormalize_other_names_in_artists.rb
072_renormalize_other_names_in_artists.rb
 
 
073_change_default_comment_threshold.rb
073_change_default_comment_threshold.rb
 
 
074_delete_duplicate_comment_votes.rb
074_delete_duplicate_comment_votes.rb
 
 
075_delete_duplicate_post_votes.rb
075_delete_duplicate_post_votes.rb
 
 
076_clear_inviters.rb
076_clear_inviters.rb
 
 
077_symlink_subdirectories.rb
077_symlink_subdirectories.rb
 
 
078_unflat.sh
078_unflat.sh
 
 
079_fix_duration.rb
079_fix_duration.rb
 
 
080_delete_duplicate_favorites.rb
080_delete_duplicate_favorites.rb
 
 
081_delete_duplicate_post_disapprovals.rb
081_delete_duplicate_post_disapprovals.rb
 
 
082_fix_expunged_media_assets.rb
082_fix_expunged_media_assets.rb
 
 
083_generate_media_asset_variants.rb
083_generate_media_asset_variants.rb
 
 
084_fix_invalid_emails.rb
084_fix_invalid_emails.rb
 
 
085_fix_invalid_foreign_keys.rb
085_fix_invalid_foreign_keys.rb
 
 
086_fix_user_count_columns.rb
086_fix_user_count_columns.rb
 
 
087_fix_post_fav_counts.rb
087_fix_post_fav_counts.rb
 
 
088_fix_post_tag_category_counts.rb
088_fix_post_tag_category_counts.rb
 
 
089_add_non-web_source_tag.rb
089_add_non-web_source_tag.rb
 
 
090_create_pool_dtext_links.rb
090_create_pool_dtext_links.rb
 
 
091_delete_invalid_custom_css.rb
091_delete_invalid_custom_css.rb
 
 
092_normalize_artist_group_names.rb
092_normalize_artist_group_names.rb
 
 
093_fix_invalid_artist_names.rb
093_fix_invalid_artist_names.rb
 
 
094_mark_modreports_as_handled.rb
094_mark_modreports_as_handled.rb
 
 
095_delete_forum_posts_in_deleted_topics.rb
095_delete_forum_posts_in_deleted_topics.rb
 
 
096_delete_invalid_moderation_reports.rb
096_delete_invalid_moderation_reports.rb
 
 
097_normalize_post_sources.rb
097_normalize_post_sources.rb
 
 
098_fix_aliased_artists.rb
098_fix_aliased_artists.rb
 
 
099_delete_old_uploads.rb
099_delete_old_uploads.rb
 
 
100_migrate_upload_errors.rb
100_migrate_upload_errors.rb
 
 

README.md

Fixes

This directory contains one-off scripts designed to fix various problems with the production database. Most of these scripts are for the production database and aren't meant to be run by downstream users.

Most of the older scripts here no longer work because of changes to the code over the years.