Apache error log list ordered by most common errors

apache_error_log_parser.sh

#!/bin/bash
sed 's^\[.*\]^^g' error.log | sed 's^\, referer: [^\n]*^^g' | sort | uniq -c | sort -n

credits.txt

Based in http://strictcoder.blogspot.com/2012/02/linux-count-unique-error-log-entries.html

example_output.txt

      1  AH00126: Invalid URI in request GET  HTTP/1.1
      1  PHP Fatal error:  Allowed memory size of 536870912 bytes exhausted (tried to allocate 32 bytes) in /var/www/con/libraries/joomla/database/driver/mysql.php on line 425
    108  PHP Fatal error:  Allowed memory size of 536870912 bytes exhausted (tried to allocate 512 bytes) in /var/www/es/libraries/joomla/database/driver/mysql.php on line 425
    156  PHP Notice:  Undefined index: select in /var/www/con/cli/form_output.php on line 3
    156  PHP Notice:  Undefined index: inputfrom_value in /var/www/con/cli/form_output.php on line 2
    157  PHP Fatal error:  Allowed memory size of 536870912 bytes exhausted (tried to allocate 83 bytes) in /var/www/es/libraries/joomla/database/driver/mysql.php on line 425
    202  PHP Fatal error:  Allowed memory size of 536870912 bytes exhausted (tried to allocate 32 bytes) in /var/www/es/libraries/joomla/database/driver/mysql.php on line 425
    218  PHP Fatal error:  Allowed memory size of 536870912 bytes exhausted (tried to allocate 80 bytes) in /var/www/es/libraries/joomla/database/driver/mysql.php on line 425
    316  PHP Notice:  Undefined index:  in /var/www/conven/cli/units.php on line 513
    520  PHP Fatal error:  Allowed memory size of 536870912 bytes exhausted (tried to allocate 81 bytes) in /var/www/es/libraries/joomla/database/driver/mysql.php on line 425

thanks for wonderful script. below is for compressed log file (e.g. error.log.gz):

!/bin/bash

zcat error.log.gz | sed 's^[.]^^g' | sed 's^, referer: [^\n]^^g' | sort | uniq -c | sort -n