[cgi-wiki-dev] SQLite Backend

Tom Insam cgi-wiki-dev@earth.li
Wed, 5 Nov 2003 13:46:41 +0000


On Wed, Nov 05, 2003 at 08:41:42AM -0500, Naved, Masroor wrote:
> 
> I am having some problems get a basic CGI::Wiki up and running. I have one
> script which only opens a SQLite database, a DB_File_SplitHash for an index,
> and one write_node command. The problem is that there are no tables in the
> SQLite database so the write fails (it seems to fail silently) and the
> subsequent display_node function call throws an error "table does not
> exist",

The utility you want to create the tables is 'cgi-wiki-setupdb', there's
docs for it here:

  http://search.cpan.org/~kake/CGI-Wiki-0.49/bin/cgi-wiki-setupdb

You probably want something like

  cgi-wiki-setupdb --type sqlite --name wiki.db --user root

That command works for me, anyway.

.tom