phpwiki-talk

[Phpwiki-talk] Wrong table in mysql_initialize.sql ?

[RubyCon <dm...@ik...>]

Hello,

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---

Now everything works fine.


But a very nice wiki   I'm still testing but it looks good

Thanks

-- 
View this message in context: http://www.nabble.com/Wrong-table-in-mysql_initialize.sql---tf4269441.html#a12151392
Sent from the phpwiki-talk mailing list archive at Nabble.com.

Re: [Phpwiki-talk] Wrong table in mysql_initialize.sql ?

[Reini U. <ru...@x-...>]

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.

Re: [Phpwiki-talk] Wrong table in mysql_initialize.sql ?

[RubyCon <dm...@ik...>]

Sorry, I searched in the wrong direction. Forget my  1. posting .. I'm sorry.


The error still appears:


ib/WikiDB/backend/PearDB.php:1059 Error: WikiDB_backend_PearDB_mysql: fatal
database error

    * DB Error: value count on row
    * (INSERT INTO accesslog
(time_stamp,remote_host,remote_user,request_method,request_line,request_uri,request_args,request_time,status,bytes_sent,referer,agent,request_duration)
VALUES (1187156181,'xxx.xxx.xxx','-','GET','GET /quicky/
HTTP/1.0','/quicky/','','15/Aug/2007:07:36:21 0200',200,7800,'','Mozilla/5.0
(Windows; U; Windows NT 5.1; de; rv:1.8.1.6) Gecko/20070725
Firefox/2.0.0.6',1,2147881984711) [nativecode=1136 ** Column count doesn't
match value count at row 1])



What is going wrong here ?   PHP Version is 5.1.6 , MySQL is 5.0.22 on
Scientific Linux 5.

If you need more infos feel free to ask

Thanks
-- 
View this message in context: http://www.nabble.com/Re%3A-Wrong-table-in-mysql_initialize.sql---tf4269624.html#a12156931
Sent from the phpwiki-talk mailing list archive at Nabble.com.

Re: [Phpwiki-talk] Wrong table in mysql_initialize.sql ?

[Reini U. <ru...@x-...>]

RubyCon schrieb:
> Sorry, I searched in the wrong direction. Forget my  1. posting .. I'm sorry.
> The error still appears:
> ib/WikiDB/backend/PearDB.php:1059 Error: WikiDB_backend_PearDB_mysql: fatal
> database error
> 
>     * DB Error: value count on row
>     * (INSERT INTO accesslog
> (time_stamp,remote_host,remote_user,request_method,request_line,request_uri,request_args,request_time,status,bytes_sent,referer,agent,request_duration)
> VALUES (1187156181,'xxx.xxx.xxx','-','GET','GET /quicky/
> HTTP/1.0','/quicky/','','15/Aug/2007:07:36:21 0200',200,7800,'','Mozilla/5.0
> (Windows; U; Windows NT 5.1; de; rv:1.8.1.6) Gecko/20070725
> Firefox/2.0.0.6',1,2147881984711) [nativecode=1136 ** Column count doesn't
> match value count at row 1])
  >
> What is going wrong here ?   PHP Version is 5.1.6 , MySQL is 5.0.22 on
> Scientific Linux 5.

Ok, your system looks sane, just european.

The error is the request_duration as 1,2147881984711
It should be 1.2147881984711
Know problem with PEAR DB quoting. ? should be escape floats with ,

// duration problem: sprintf "%f" might use comma e.g. "1,201" in 
european locales

The fix is

     function setDuration ($seconds) {
         // Pear DB does not correctly quote , in floats using ?. e.g. 
in european locales.
         // Workaround:
         $this->duration = strtr(sprintf("%f", $seconds),",",".");
     }

in Request.php
-- 
Reini Urban
http://phpwiki.org/  http://murbreak.at/
http://helsinki.at/  http://spacemovie.mur.at/

Re: [Phpwiki-talk] Wrong table in mysql_initialize.sql ?

[RubyCon <dm...@ik...>]

Thanks for your quick reply. :-)

Your solution works. No errormessage and the database gets data.

Thank you for your nice wiki
-- 
View this message in context: http://www.nabble.com/Re%3A-Wrong-table-in-mysql_initialize.sql---tf4269624.html#a12157830
Sent from the phpwiki-talk mailing list archive at Nabble.com.

Re: [Phpwiki-talk] Wrong table in mysql_initialize.sql ?

[Reini U. <ru...@x-...>]

RubyCon schrieb:
> Thanks for your quick reply. :-)
> 
> Your solution works. No errormessage and the database gets data.
> 
> Thank you for your nice wiki

Glad I could help you.

It's just no "my" wiki, I just happen maintain it now.

It's the collaborate work of dozens of developers and people sending 
patches.
-- 
Reini Urban
http://phpwiki.org/  http://murbreak.at/
http://helsinki.at/  http://spacemovie.mur.at/