Update: added as History items with unbalanced parentheses, braces, brackets or double quotes. taxt-hist
Unbalanced parentheses
Unbalanced curly braces
Unbalanced square brackets
Unbalanced parentheses
Unbalanced curly braces
Unbalanced square brackets
Script
def puts_links(history_items, heading) puts "**Unbalanced #{heading}**\n\n" history_items.each do |history_item| puts "* https://antcat.org/history_items/#{history_item.id}\n" end puts "\n\n\n" end puts_links TaxonHistoryItem.where(!!~SQL), "parentheses" CHAR_LENGTH(taxt) - CHAR_LENGTH( REPLACE ( taxt, '(', '') ) != CHAR_LENGTH(taxt) - CHAR_LENGTH( REPLACE ( taxt, ')', '') ) SQL puts_links TaxonHistoryItem.where(!!~SQL), "curly braces" CHAR_LENGTH(taxt) - CHAR_LENGTH( REPLACE ( taxt, '{', '') ) != CHAR_LENGTH(taxt) - CHAR_LENGTH( REPLACE ( taxt, '}', '') ) SQL puts_links TaxonHistoryItem.where(!!~SQL), "square brackets" CHAR_LENGTH(taxt) - CHAR_LENGTH( REPLACE ( taxt, ']', '') ) != CHAR_LENGTH(taxt) - CHAR_LENGTH( REPLACE ( taxt, '[', '') ) SQL
Fredrik Palmkron commented almost 5 years ago: show raw@user6 Results of the rerun: **Unbalanced parentheses** * https://antcat.org/taxon_history_items/242449 * https://antcat.org/taxon_history_items/254220 * https://antcat.org/taxon_history_items/272538 **Unbalanced curly braces** * https://antcat.org/taxon_history_items/279053 **Unbalanced square brackets** * https://antcat.org/taxon_history_items/275592 * https://antcat.org/taxon_history_items/278765 * https://antcat.org/taxon_history_items/279071
@Brian Fisher Results of the rerun:
Unbalanced parentheses
Unbalanced curly braces
Unbalanced square brackets
Brian Fisher commented almost 5 years ago: show raw@user60 lets see if I got them all this time.
@Fredrik Palmkron lets see if I got them all this time.
Fredrik Palmkron commented over 4 years ago: show rawRe-opened with a new batch.
Re-opened with a new batch.
Brian Fisher commented over 4 years ago: show raw@user60 Batch 3 finished
@Fredrik Palmkron Batch 3 finished
Brian Fisher commented almost 5 years ago: show raw@user60 I fixed these but rerun the script to see if I missed any.
@Fredrik Palmkron
I fixed these but rerun the script to see if I missed any.