[Issues] [mod_log_sql 0000032]: Apache2 using MySQL 4.1.7 trouble using the 'a' flag for LogSQLTransferLogFormat

[issues at outoforder.cc]

The following issue has been RESOLVED.
======================================================================
<http://issues.outoforder.cc/view.php?id=32> 
======================================================================
Reported By:                kibble
Assigned To:                urkle
======================================================================
Project:                    mod_log_sql
Issue ID:                   32
Category:                   Database Issue
Reproducibility:            always
Severity:                   block
Priority:                   normal
Status:                     resolved
Apache Version:             2.0.XX
Resolution:                 fixed
Fixed in Version:           1.100
======================================================================
Date Submitted:             04-13-2005 16:14 EST
Last Modified:              04-13-2005 18:58 EST
======================================================================
Summary:                    Apache2 using MySQL 4.1.7 trouble using the 'a' flag
for LogSQLTransferLogFormat
Description: 

When using this:
LogSQLTransferLogFormat a

in my httpd.conf it will fill my '/var/www/logs/mod_log_sql-preserve' with
these:
insert into www_access_log
(agent,request_args,bytes_sent,request_file,request_protocol,remote_host,request_method,referer,request_line,time_stamp,status,request_duration,request_time,request_uri,remote_user,virtual_host)
values ('Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
1.1.4322)',,'50332','/home/www/domain.com/www/phpinfo.php','HTTP/1.1','62.245.38.169','GET','-','GET
/phpinfo.php HTTP/1.1','1113425347','200','0','[13/Apr/2005:20:49:07
+0000]','/phpinfo.php','-','domain.com')

Running it through mysql manually the error is in the SQL statement here:
...1.4322)',,'50332','/home/www...

Where there is a double ',,' if this read ', NULL,', then things would be
fine, or if the insert statement looked a little more like this:
insert into www_access_log
(agent,request_args,bytes_sent,request_file,request_protocol,remote_host,request_method,referer,request_line,time_stamp,status,request_duration,request_time,request_uri,remote_user,virtual_host)
values ('Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
1.1.4322)',NULL,'50332','/home/www/domain.com/www/phpinfo.php','HTTP/1.1','62.245.38.169','GET','-','GET
/phpinfo.php HTTP/1.1','1113425347','200','0','[13/Apr/2005:20:49:07
+0000]','/phpinfo.php','-','domain.com')

So that the 'request_args' field would have some value there.

======================================================================

----------------------------------------------------------------------
 urkle - 04-13-05 18:58 
----------------------------------------------------------------------
This was fixed in mod_log_sql 1.100.

Issue History
Date Modified  Username       Field                    Change              
======================================================================
04-13-05 16:14 kibble         New Issue                                    
04-13-05 16:14 kibble         Apache Version            => 2.0.XX          
04-13-05 18:58 urkle          Status                   new => resolved     
04-13-05 18:58 urkle          Fixed in Version          => 1.100           
04-13-05 18:58 urkle          Resolution               open => fixed       
04-13-05 18:58 urkle          Assigned To               => urkle           
04-13-05 18:58 urkle          Note Added: 0000037                          
======================================================================