Package: libapache2-mod-log-sql Version: 1.100-15 Severity: normal Tags: patch
Hello Thomas When preparing a database according to /usr/share/doc/libapache2-mod-log-sql/manual.html one get: mysql -p apachelogs mysql> source create_tables.sql Query OK, 0 rows affected (0.18 sec) Query OK, 0 rows affected (0.15 sec) Query OK, 0 rows affected (0.13 sec) Query OK, 0 rows affected (0.12 sec) Query OK, 0 rows affected (0.13 sec) ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 17 This is a debian-specific bug introduced in 1.100-15. The fix looks trivial: just remove "TYPE=MyISAM". -- System Information: Debian Release: 8.0 APT prefers stable APT policy: (990, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 3.16.0-4-amd64 (SMP w/2 CPU cores) Locale: LANG=en_GB.utf8, LC_CTYPE=en_GB.utf8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: sysvinit (via /sbin/init) Versions of packages libapache2-mod-log-sql depends on: ii apache2-bin [apache2-api-20120211] 2.4.12-3 ii libc6 2.19-18 Versions of packages libapache2-mod-log-sql recommends: ii perl 5.20.2-3 libapache2-mod-log-sql suggests no packages. -- no debconf information
diff --git a/debian/patches/008-create_tables.sql_adds-doc.patch b/debian/patches/008-create_tables.sql_adds-doc.patch index 3f1466c..8a70fad 100644 --- a/debian/patches/008-create_tables.sql_adds-doc.patch +++ b/debian/patches/008-create_tables.sql_adds-doc.patch @@ -27,4 +27,4 @@ Subject: Documents the score_board table format + domain varchar(50) NOT NULL default '', + PRIMARY KEY (id), + UNIQUE KEY `vhost` (`vhost`,`month`,`year`,`domain`) -+) TYPE=MyISAM; ++);
