[Phpwiki-talk] Oracle invalid character error preventing virgin DB loading

[umfan866 <mh...@so...>]

Hi, I am starting to use phpwiki. My goal is to have
this in an Oracle database eventually, but I am using
MySql at first to get it going.

I am using the following: 
  RHEL4 with SELinux turned off 
  phpwiki-1.3.12p3
  ZendCoreForOracle-v1.4.1-Linux-x86.tar.gz1
    (provides php 5 pre-compiled)
  MySql 5.0.22-0 for rhel4
  Oracle 10g R2 (10.2.0.2)
 
For both MySql and Oracle, I am finding 
DATABASE_TYPE = ADODB works better/fewer 
errors than with DATABASE_TYPE = SQL so,
I don't change this value anymore. 

Also, for both MySql and Oracle, I have prepended
phpwiki_ to every table, so that I can go between
the 2 databases in the future (and Oracle needs it
for sure). Have edited the create/destroy schema
scripts accordingly.
 
I am able to get the virgin wiki to load
nicely in MySql using  

DATABASE_DSN="mysql://phpwiki:passwd@localhost(/var/lib/mysql/mysql.sock)/phpwiki" 

 
For Oracle, I was able to get connectivity working by
installing ZendCore for Oracle (basically a pre-compiled 
verusion of php 5).  I also had to unlock the phpwiki user
for it to work at all (as sysadmin, "alter user phpwiki 
account unlock") -- this is a new 10g security feature 
and so is not in the oci install doc for phpwiki. FOr 

Oracle my connect string is  
DATABASE_DSN="oci8://phpwiki:phpwiki@192.168.0.100:1521/pwiki>"
(where the SERVICE_NAME / SID = pwiki, the 1521 is optional 
as it is the default db port). 
 
I am able to connect to the oracle, but the virgin wiki still
does not load. It connects (was able to get through past 
connect errors, but then shows the  following ADODB error): 
 
lib/WikiDB/adodb/adodb-errorhandler.inc.php:76: Error[256]:
oci8 error: [911: ORA-00911: invalid character] in EXECUTE
("UPDATE phpwiki_page SET hits=?, pagedata=? WHERE pagename=?")  
 
I think that Oracle does not like the question marks --it
probably wants quotes around the question marks - that
may be the issue, but not sure how to fix that (which file
or part of the code). Thanks for any pointers. 

-- 
View this message in context: http://www.nabble.com/Oracle-invalid-character-error-preventing-virgin-DB-loading-tf2155588.html#a5954792
Sent from the phpwiki-talk forum at Nabble.com.