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