phpwiki-talk

[Phpwiki-talk] Lot's of fatal php errors...

[John C. <joh...@ua...>]

I'm running the latests CVS code in a test directory on our live database,
and I have been getting a LOT of database errors lately.

Here is an example when saving a new page:

Fatal PhpWiki Error

lib\WikiDB\adodb\adodb-errorhandler.inc.php:76: Fatal[256]: mysql error:
[1062: Duplicate entry '0' for key 1] in ADODB_Error_Handler(INSERT INTO
page (pagename,hits) VALUES('jcole/test4',0), ) 

I seem to be getting a lot more errors when using SQL instead of ADODB.
I'll start saving my error messages for both providers.

John

-------------------------------------
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.

[Phpwiki-talk] Praise and one RFE

[Stan B. <sb...@po...>]

After waiting (sorry, I know I should rather say "after helping" but no 
time, right now!) several weeks I checked today again if the current 
wiki is better in terms of user authentication.  I was nicely 
surprised.  With my combination of parms (see at the bottom), it works 
very good.  I haven't done much testing just for the problems I observed 
(and complained) several weeks ago. 

Good job guys!  Looks like I'll be finally able to upgrade from 1.3.4 to 
the current release.

One RFE: in 1.3.4, when I'm in a sub page, I can click on the title (the 
parent part of it) to get back directly to the parent page.  Current 
version doesn't let me do this.  What should I do to have this feature back?

Stan Berka

My user authentication parms:
ALLOW_ANON_USER = true, ALLOW_ANON_EDIT = false, ALLOW_BOGO_LOGIN = 
true, ALLOW_USER_PASSWORDS = false (here it actually works the other way 
around, I've found),
USER_AUTH_ORDER = "PersonalPage"

>  
>

Re: [Phpwiki-talk] Lot's of fatal php errors...

[Reini U. <ru...@x-...>]

John Cole schrieb:

> I'm running the latests CVS code in a test directory on our live database,
> and I have been getting a LOT of database errors lately.
> 
> Here is an example when saving a new page:
> 
> Fatal PhpWiki Error
> 
> lib\WikiDB\adodb\adodb-errorhandler.inc.php:76: Fatal[256]: mysql error:
> [1062: Duplicate entry '0' for key 1] in ADODB_Error_Handler(INSERT INTO
> page (pagename,hits) VALUES('jcole/test4',0), ) 
> 
> I seem to be getting a lot more errors when using SQL instead of ADODB.
> I'll start saving my error messages for both providers.

ADODB is the experimental one, and SQL (PearDB) the stable one.

Your mysql page table does seem to have a working auto_increment for the 
id column, which is not in the query.
Maybe we should use
"INSERT INTO page (id,pagename) VALUES(NULL,$pagename)"
to use an explicit NULL value, which obviously is not used implicitly, 
but the number 0 instead.
I'll test that.

Which mysql version?

PS: I found recently some charset bugs/problems in recent windows mysql 
versions, which need to be fixed also in phpwiki.
   http://bugs.mysql.com/?id=4398
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/