install borked: no login screen

[cbrace]

Hi all,

I have stepped through the installer, and everything seems OK. I have copied to the two files to config/

But when I go to the login screen now (index.php) it is totally blank. Zippo. I see this in the error log:

Code Select Expand

[16-Apr-2008 23:39:31] PHP Warning: sqlite_exec() expects parameter 1 to be resource, string given in /usr/local/www/lim.nl/roundcube/program/include/rcube_mdb2.inc on line 548
[16-Apr-2008 23:39:31] PHP Warning: sqlite_create_function() expects parameter 1 to be resource, integer given in /usr/local/www/lim.nl/roundcube/program/include/rcube_mdb2.inc on line 563
[16-Apr-2008 23:39:31] PHP Warning: sqlite_create_function() expects parameter 1 to be resource, integer given in /usr/local/www/lim.nl/roundcube/program/include/rcube_mdb2.inc on line 564
[16-Apr-2008 23:39:31] PHP Warning: sqlite_create_function() expects parameter 1 to be resource, integer given in /usr/local/www/lim.nl/roundcube/program/include/rcube_mdb2.inc on line 565
[16-Apr-2008 23:39:31] PHP Warning: sqlite_create_function() expects parameter 1 to be resource, integer given in /usr/local/www/lim.nl/roundcube/program/include/rcube_mdb2.inc on line 566
[16-Apr-2008 23:39:31] PHP Warning: sqlite_last_error() expects parameter 1 to be resource, integer given in /usr/local/www/lim.nl/roundcube/program/lib/MDB2/Driver/sqlite.php on line 534
[16-Apr-2008 23:39:31 +0200] DB Error: MDB2 Error: unknown error Query: _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='ed494i1kk98mi0i13c2ctp0fk3'] [Native message: sqlite_last_error() expects parameter 1 to be resource, integer given] in /usr/local/www/lim.nl/roundcube/program/include/rcube_mdb2.inc on line 494
[16-Apr-2008 23:39:31] PHP Fatal error: Call to a member function fetchRow() on a non-object in /usr/local/www/lim.nl/roundcube/program/include/rcube_mdb2.inc on line 360

Any clues as to what might be going wrong?

I am using v0.1 under FreeBSD 7 with sqlite.

Thanks.

[bnet1978]

Hi there you have to run the database script, I also got the blank screen when istalling this morning.
I did the following:
1 - copy the sql script from folder /SQL mysql.initial.sql
2 - Opening PHPMyAdmin clicking on the database you use, click on SQL copy the contents of mysql.initial.sql
3 - click run
... there you go, enjoy .. just did this so still want to try version 0.1.1

[cbrace]

Thanks, but I don't have PHPMyAdmin installed. That's for mySQL, right? I am using sqlite.

I don't know whether this is related, but everytime I open the third page of the installer, it says:

DB Schema: NOT OK (Database not initialized)

So I click the "initialize database" button, but it doesn't seem to "take"; all I see are a bunch of warning messages like this:

Code Select Expand

Warning: sqlite_create_function() expects parameter 1 to be resource, integer given in /usr/local/www/lim.nl/roundcube/program/include/rcube_mdb2.inc on line 563

[grooverdan]

This the same as trac ticket 1485821 and http://www.roundcubeforum.net/pending-issues/2981-installation-not-working-sqlite.html.

Use a path with the database name.