Bug#425027: libapache2-mod-log-sql: scoreboard patch uses non-portable sql incompatible with pgsql

2007-05-24 Thread Thomas Goirand
James Cloos wrote: Package: libapache2-mod-log-sql Version: 1.100-8 Severity: normal The scoreboard patch hardcodes the query: insert ignore into %s (domain,vhost,month,year,count_impressions) values ('%s','%s','%s','%s','0') but insert ignore is not portable and fails when using

Bug#425027: libapache2-mod-log-sql: scoreboard patch uses non-portable sql incompatible with pgsql

2007-05-24 Thread James Cloos
Thomas == Thomas Goirand [EMAIL PROTECTED] writes: Thomas The goal of making a INSERT IGNORE query is to create a record for the Thomas current month and year, plus the specified domain. As there is a UNIQUE Thomas KEY, there will be only ONE record, and the INSERT will fail if the Thomas record

Bug#425027: libapache2-mod-log-sql: scoreboard patch uses non-portable sql incompatible with pgsql

2007-05-24 Thread James Cloos
I just (binary) edited my /usr/lib/apache2/modules/mod_log_sql.so and replaced the string: , | insert ignore into %s (domain,vhost,month,year,count_impressions) values ('%s','%s','%s','%s','0') ` with the same-length string: , | begin;insert into %s

Bug#425027: libapache2-mod-log-sql: scoreboard patch uses non-portable sql incompatible with pgsql

2007-05-18 Thread James Cloos
Package: libapache2-mod-log-sql Version: 1.100-8 Severity: normal The scoreboard patch hardcodes the query: insert ignore into %s (domain,vhost,month,year,count_impressions) values ('%s','%s','%s','%s','0') but insert ignore is not portable and fails when using pgsql as the backend. It