Re: [Phpwiki-talk] SQLite database backend problems

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

Matthew Palmer schrieb:
> 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.

Do you really want it now, and not wait for the official PHP and PearDB 
+ ADODB support?

> 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).

Ok, I'll have a look, but it's not top-priority.

> 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).
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/