Re: Wrong table in mysql_initialize.sql ?

RubyCon schrieb:
> I just installed a new and fresh phpwiki 1.3.14  (timestamp July 1th 12:15.)
> Everything works fine except an errormessge at the end of each page:  pear
> ... mysql .. access_log something-wrong  table_rows
> 
> The following patch fixes the problem. 
> 
> ---cut here---
> *** schemas/mysql-initialize.sql        2007-08-14 21:03:16.000000000 +0200
> --- schemas/mysql-initialize.sql.orig   2007-07-01 12:11:27.000000000 +0200
> ***************
> *** 130,138 ****
>         remote_user   VARCHAR(50),
>           request_method VARCHAR(10),
>         request_line  VARCHAR(255),
> -       request_uri   VARCHAR(255),
>         request_args  VARCHAR(255),
>         request_file  VARCHAR(255),
>         request_time  CHAR(28),
>         status        SMALLINT UNSIGNED,
>         bytes_sent    SMALLINT UNSIGNED,
> --- 130,138 ----
>         remote_user   VARCHAR(50),
>           request_method VARCHAR(10),
>         request_line  VARCHAR(255),
>         request_args  VARCHAR(255),
>         request_file  VARCHAR(255),
> +       request_uri   VARCHAR(255),
>         request_time  CHAR(28),
>         status        SMALLINT UNSIGNED,
>         bytes_sent    SMALLINT UNSIGNED,
> 
> ---cut here---

Please always do diff old new, not new old.
I looked for 10 minutes for the sequence request_uri request_args 
request_file request_time, but could not find it.

What a stupid mysql do you have? Or a pear or adodb bug?
lib/WikiDB/backend.php is okay. Just the order is different.

I also wonder now what request_file should do here.
Seems not to be used at all.


-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/