phpwiki-talk Mailing List for PhpWiki

Reini Urban wrote:
> The default version (1.3.12p2 and p3) worked fine for some time without 
> any change from our side, until sf.net changed something in their 
> webserver configuration, which probably causes a loop somewhere.
Any news about this?
I'm experiencing also problems with 1.3.12p3. Yesterday I ran into 
the "20 concurrent processes" limit of my hoster suspending any 
access to the pages for several minutes.
Although Yahoo! Slurp was crawling the wiki at the same time, the 
server log told me that there were _many_ minutes between the twenty 
requests, so I suspect that some requests lead to a hanging process.
I can't get performance logs, but only the requests. Some of them are 
rather strange, so I post some examples (only the "action" part, not 
the page names):
?action=PageInfo&version=2
?action=browse&version=25
?action=edit&version=4
?action=viewsource&version=2
?action=LikePages&version=1
?action=DebugInfo&version=3
?action=diff&version=7
I wonder where the version= part comes from - all requested pages 
have only version 1. The page text doesn't have direct links to these 
requests, so I wonder how the crawler assembled them?
Oliver
-- 
Oliver Betz, Muenchen

Note - I get this error message when using "ADODB" in config.ini, 
when using "SQL" I get the message:
Fatal Error: 
lib/WikiDB/backend/PearDB.php:59:Error[256]:Can't connect to database:
WikiDB_backend_PearDB_oci8:
fatal database erorr 
 * DB error: connect failed
 *([ nativecode=ORA-12514:TNS:listener does not currently know of service
requested in connect descriptor]**
 oci8://phpwiki:XXXXXX@192.168.0.100:1521/pwiki)
Note: I am an Oracle DBA and the Database PWIKI is up on this machine, and I
can connect to it fine when
using php calls 
If anyone is able to get Phpwiki to work with Oracle at all, in any shape or
form, please let me know. Oracle
is a requirement -- I am not allowed to use MySql for the backend. Thanks
Marvin. 
umfan866 wrote:
> 
> 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#a6765833
Sent from the phpwiki-talk mailing list archive at Nabble.com.

Hello,
I am using phpwiki-1.3.12. I want to make some pages display in other =
way.
I created a new template for this new look.
I inserted a link that is supposed to take to this new look of wiki =
pages. When pressed, this link constructs an url with a new parameter.
What I want to know is how to call the new template once my link is =
pressed =3D> new URL generated.
Thanks for your help,
Sabri.

Hi,
Reini Urban wrote:
[...]
> Can you send me your ZIP please to rei...@gm...
> 
> I fixed a problem with loadfile and archived version to recreate the old 
> versions recently in CVS. But a CRC32 problem would be interesting.
I ran into the same trouble tonight importing a zip dump from 1.3.10
into a fresh installation of 1.3.12p3 - I have some diagnostic info and
a workaround. Hint: the problem is with the CRC32 checksum comparison,
not the zip files.
First, in order to get better diagnostics, I changed lib/ziplib.php to:
 186 function zip_inflate ($data, $crc32, $uncomp_size)
 187 {
 188 if (function_exists('gzinflate')) {
 189 $data = gzinflate($data);
 190 if (strlen($data) != $uncomp_size)
 191 trigger_error("not enough output from gzinflate",
E_USER_ERROR);
 192 # if (zip_crc32($data) != $crc32)
 193 $zcrc32 = zip_crc32($data);
 194 if ($zcrc32 != $crc32)
 195 trigger_error("CRC32 mismatch: calculated=$zcrc32,
expected=$crc32 ", E_USER_ERROR);
 196 return $data;
 197 }
My zip file upload fails with:
lib/ziplib.php:195: Error: CRC32 mismatch: calculated=-337476845,
expected=3957490451
Note that 2^32 = 4294967296 and 4294967296 -ひく 337476845 =わ 3957490451
My guess is there's some problem with signed vs unsigned 32-bit
integers, pack/unpack, or something along those lines - once I changed
lib/ziplib.php to
 186 function zip_inflate ($data, $crc32, $uncomp_size)
 187 {
 188 if (function_exists('gzinflate')) {
 189 $data = gzinflate($data);
 190 if (strlen($data) != $uncomp_size)
 191 trigger_error("not enough output from gzinflate",
E_USER_ERROR);
 192 # if (zip_crc32($data) != $crc32)
 193 $zcrc32 = zip_crc32($data);
 194
 195 if ($zcrc32 < 0) {
 196 $zcrc32 += 4294967296;
 197 }
 198
 199 if ($zcrc32 != $crc32)
 200 trigger_error("CRC32 mismatch: calculated=$zcrc32,
expected=$crc32 ", E_USER_ERROR);
 201 return $data;
 202 }
the zip file uploaded and imported just fine. Well, it stopped importing
anything past the first version of a page (not what I wanted) but I've
been fighting with that particular problem for *years* with phpwiki. I
worked around the CRC issue at least.
hth,
-- Bob