phpwiki-talk

[Phpwiki-talk] db error - no visible consequences

[Tara S. <te...@cl...>]

Hi :)

upon editing a new page, I got the following db error:

lib/WikiDB/backend/PearDB.php:653: Fatal[256]: wikidb_backend_mysql:=20
fatal database error

     * DB Error: unknown error<\li>
     * (OPTIMIZE TABLE page)<\li>
     * <\li>

lib/WikiDB.php:513: Notice[1024]: "Optimizing" backend

lib/WikiDB/backend/PearDB.php:52: Notice[8]: Undefined property: _lock_co=
unt

lib/WikiDB/backend/PearDB.php:625: Notice[8]: Undefined property:=20
_lock_count

lib/WikiDB/backend/PearDB.php:653: Fatal[256]: wikidb_backend_mysql:=20
fatal database error

     * DB Error: unknown error<\li>
     * (OPTIMIZE TABLE page)<\li>
     * <\li>


Is it my fault? is it the wiki's fault? is it the db's fault?

The page got created, though - I saw that in RecentChanges. Oh. I might=20
note that I created the page directly by typing the url in the browser=20
bar - could that be the reason?

Any input welcome. Thanks!


--=20
Je r=E9ponds au mieux de mes connaissances
Climb to the Stars! - http://climbtothestars.org/
SpiroLattic - http://spirolattic.net/
Pompeurs Associ=E9s - http://pompage.net/

Re: [Phpwiki-talk] db error - no visible consequences

[Jeff D. <da...@da...>]

On Tue, 20 Nov 2001 15:32:26 +0100
"Tara Star" <te...@cl...> wrote:

>      * DB Error: unknown error<\li>
>      * (OPTIMIZE TABLE page)<\li>
>      * <\li>
 
> Is it my fault? is it the wiki's fault? is it the db's fault?

You've discovered another bug.  Phpwiki and your older MySQL are
squabbling.  Apparently the "OPTIMIZE" command is only supported
in newer MySQL's.  The reason you haven't seen the error before
is that the OPTIMIZE gets done at random, on about 1 out 
of every 50 page saves.
 
> The page got created, though - I saw that in RecentChanges.

I don't _think_ there should be any bad side effects other than the error
message itself.

> Oh. I might 
> note that I created the page directly by typing the url in the browser 
> bar - could that be the reason?

Red herring, I think.