Package: libapache2-mod-log-sql Version: 1.100-14 Severity: normal Tags: patch
The script /usr/share/doc/libapache2-mod-log-sql/create_tables.sql creates some database tables; however, one of them is misnamed. The table 'score_board' should be 'scoreboard'. -- System Information: Debian Release: 5.0 APT prefers stable APT policy: (500, 'stable') Architecture: i386 (i686) Kernel: Linux 2.6.26-1-openvz-686 (SMP w/1 CPU core) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages libapache2-mod-log-sql depends on: ii apache2-mpm-prefork 2.2.9-10+lenny2 Apache HTTP Server - traditional n ii libc6 2.7-18 GNU C Library: Shared libraries Versions of packages libapache2-mod-log-sql recommends: ii perl 5.10.0-19 Larry Wall's Practical Extraction libapache2-mod-log-sql suggests no packages. -- no debconf information
--- create_tables.sql.original 2009-03-19 10:04:54.000000000 +0000 +++ create_tables.sql 2009-03-19 10:05:20.000000000 +0000 @@ -53,7 +53,7 @@ # Added by Thomas Goirand (Debian maintainer and score_board patch upstream) # take care that the UNIQUE KEY is really VITAL of you don't want your server # to die with a huge MySQL load... -create table score_board ( +create table scoreboard ( id int(14) NOT NULL auto_increment, vhost varchar(50) NOT NULL default '', bytes_sent bigint(14) unsigned NOT NULL default '0',