From: Reini U. <ru...@x-...> - 2005-05-14 07:28:32
|
Fu-Hsiang Chen schrieb: > Which file should I modify ? I just want to make sure I modify the > right place. > Thanks for your response. RCS file: /cvsroot/phpwiki/phpwiki/lib/Request.php,v retrieving revision 1.91 diff -u -b -r1.91 Request.php --- Request.php 11 Apr 2005 19:40:14 -0000 1.91 +++ Request.php 14 May 2005 07:17:01 -0000 @@ -1118,7 +1118,7 @@ // duration problem: sprintf "%f" might use comma e.g. "100,201" in european locales $dbh->genericSqlQuery ( - sprintf("INSERT DELAYED INTO $log_tbl" + sprintf("INSERT INTO $log_tbl" . " (time_stamp,remote_host,remote_user,request_method,request_line,request_uri," . "request_args,request_time,status,bytes_sent,referer,agent,request_duration)" . " VALUES(%d,%s,%s,%s,%s,%s,%s,%s,%d,%d,%s,%s,'%s')", > On May 14, 2005, at 12:17 AM, Reini Urban wrote: > >> Fu-Hsiang Chen schrieb: >> >>> I installed phpwiki with postgreSQL as back-end. It works well but >>> on the end of every page, the following error was shown. lib/ >>> WikiDB/backend/PearDB.php:1014: Error: WikiDB_backend_PearDB_pgsql: >>> fatal database error >>> * DB Error: syntax error >>> * (INSERT DELAYED INTO accesslog >>> >>> (time_stamp,remote_host,remote_user,request_method,request_line,reque >>> st_uri,request_args,request_time,status,bytes_sent,referer,agent,requ >>> est_duration) >>> VALUES >>> (1115942580,'c-67-169-114-162.hsd1.ca.comcast.net','-','GET','GET >>> /~chenfu/phpwiki/index.php >>> HTTP/1.1','/~chenfu/phpwiki/index.php','','12/May/2005:17:03:00 >>> -0700',200,6872,'','Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en) >>> AppleWebKit/412 (KHTML, like Gecko) Safari/ 412','3.318451166153') >>> [nativecode=ERROR: syntax error at or near "DELAYED" at >>> character 8]) >>> I think it is because postgreSQL does not have INSERT DELAYED >>> statement as in MySQL. Could any one give me some ideas ? >>> >> >> Please remove the DELAYED. >> >> I'll commit a fix soon. -- Reini Urban http://xarch.tu-graz.ac.at/home/rurban/ http://phpwiki.org/ |