Sat 13 Mar 2004 10:08:42 PM UTC, comment #5:
This function will fail:
function write()
{
$this->db->query("INSERT INTO $this->PgTbl".
" (title,version,time,supercede,mutable,username,author,comment,body)".
" VALUES ('$this->dbname',$this->version,".time().','.time().",'".
($this->mutable ? 'on' : 'off') . "','$this->username','$this->hostname',".
"'$this->comment','$this->text')",__LINE__,__FILE__);
Slightly modified it will work:
function write()
{
$this->db->query("INSERT INTO $this->PgTbl".
" (title,version,time,supercede,mutable,username,author,comment,body)".
" VALUES ('$this->dbname',$this->version,".time().','.time().",'".
($this->mutable ? 'on' : 'off') . "','$this->username','$this->hostname','".
addslashes($this->comment). "','" .addslashes($this->text)."')",__LINE__,__FILE__);
|
Thu 26 Feb 2004 11:11:07 AM UTC, comment #3:
Still the same after the cvs update at UTC 11:11:00 on 26. Feb 2004:
Database error: Invalid SQL: INSERT INTO phpgw_wiki_pages (title,version,time,supercede,mutable,username,author,comment,body) VALUES ('phpGroupWare',6,1077793439,1077793439,'on','Erich','xxx.xxx.xxx.xxx','',''''Testing.''' ')
MySQL Error: 1064 (You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Testing.''' ')' at lin)
File: /usr/share/phpgroupware/wiki/inc/class.sowiki.inc.php
Line: 116
Session halted.
|
Mon 09 Feb 2004 10:22:03 PM UTC, original submission:
Database error: Invalid SQL: INSERT INTO phpgw_wiki_pages (title,version,time,supercede,mutable,username,author,comment,body) VALUES ('phpGroupWare',4,1076365136,1076365136,'on','Erich','xxx.xxx.xxx.233','',''''')
MySQL Error: 1064 (You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '''''')' at line 1)
File: /usr/share/phpgroupware/wiki/inc/class.sowiki.inc.php
Line: 116
Session halted.
|