[Phpwiki-talk] SQLite database backend problems

[Matthew P. <mp...@he...>]

I'm working on an SQLite backend helper for PHPWiki, so that I don't have to
use BDB (ugh!), flat file, or do nassssty setup on a real SQL engine. 
However, it wouldn't be an SQL database without foibles, and I'm getting
them by the truckload.

If someone with a smattering more experience at hacking PHPWiki could try
out the sqlite.php backend stub and the sqlite.sql schema at
http://www.hezmatt.org/~mpalmer/sqlite-phpwiki and try and work out what's
*really* going on behind the scenes, I'd be grateful.  I've been banging my
head against these problems for hours now, without getting anywhere useful
(lots of dead ends and useless tracebacks, but that's about it).

Particular problems:

* Page names don't get set in a lot of WikiDB_Page creations, which makes
the page explode.  Commenting out the assert seems to make things work a
bit, but it's obviously not happy...

* I noticed the BackLinks action page doesn't exist.  No idea why.

* Several "Undefined variable" problems (versiondata, mtime, have_content)
in backend/PearDB.php at lines 255, 257, and 261 respectively.

* None of the top links are appearing (but I presume that's related to the
page naming thing - in fact, most things are probably page name related).

- Matt