Re: [cgi-wiki-dev] SQLite Backend

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