#1 SQLite DB Problems with index page

[Anonymous]

I am attempting to install wheatblog on an Apache
server, PHP 4, using the SQLite 2.8x backend. For
wheatblog to function, I had to put the wheatblog.db
file in both the top-level wheatblog directory AND in
the admin directory.

In settings.php, if the database variable is set

$databse = 'wheatblog.db';

I can login as admin and see the admin links
functionality. However, blog posts do not appear on
the Home page (index.php).

Setting the database variable to

$databse = 'admin/wheatblog.db';

allows all posts to show on the index.php page, but
logins no longer work correctly (i.e. you can login,
but the the administrative links do not show).

It appears as though wheatblog may be trying to find
certain data in a default directory when SQLite is the
chosen backend.

[Nobody/Anonymous]

Logged In: NO

Additional info: If $database = 'admin/wheatblog.db', posts
can be viewed on the front page (index.php) or in the post
index. If $database = 'wheatblog.db', neither index.php nor
post index function, but you can login and see posts under
the "manage posts" interface.

Also, if there is no database file located within the admin
directory, something in wheatblog attempts to create a new
file, even if $database doesn't reference admin.

[James E. Martin]

Logged In: YES
user_id=168317

Peiter,

You want to take a crack at this one? I haven't done any
SQLite testing in a while. Are you still running that as
your backend?

Wheat