[#5034] SQLite not properly set up
Summary SQLite not properly set up
Queue Horde Groupware Webmail Edition
Type Bug
State Not A Bug
Priority 2. Medium
Owners jan (at) horde (dot) org
Requester fbusse (at) gmx (dot) de
Created 2007-02-24 (4442 days ago)
Updated 2007-02-26 (4440 days ago)
Assigned 2007-02-25 (4441 days ago)
Resolved 2007-02-25 (4441 days ago)
Patch No

2007-02-26 12:27:43 fbusse (at) gmx (dot) de Comment #9 Reply to this comment
Please ignore my last comment, probably PEBKAC. After a new 
SQLite-initalisation, Horde doesn't complain about missing tables 
2007-02-26 08:48:20 fbusse (at) gmx (dot) de Comment #8 Reply to this comment
Well, groupware.sql is not enough for horde-webmail, just noticed that 
the tables for kronolith are missing.

And for other stuff is probably missing as well:

[nativecode=no such table: horde_datatree]

Is there a simple way to get SQLIte running with horde-webmail?
2007-02-25 19:45:44 fbusse (at) gmx (dot) de Comment #7 Reply to this comment
"State: Not A Bug"? Might not be a bug in setup.php, but I still 
consider it a bug. The setup doesn't work as it supposed to (manual 
setup works with on command).

And I think SQLite is very useful for small setups.
2007-02-25 10:23:17 Jan Schneider Comment #6
State ⇒ Not A Bug
Reply to this comment
This is most likely a bug in MDB2_Schema or MDB2_Driver_sqlite which 
are responsible for creating the tables. The database is obviously 
creates, so there don't seem to be a bug in setup.php. I'll extend the 
install document to include instructions for manual sql setup.
2007-02-25 09:41:43 fbusse (at) gmx (dot) de Comment #5 Reply to this comment
'sqlite -init sql/groupware.sql /tmp/horde.sql' seems to work.

I got some errors during the first login ("nativecode=database schema 
has changed"), but that seems to be OK as there's not yet a profile.

BTW, setup.php terminates after (not) creating the SQLite-tables, 
while other settings bring you back to the initial screen. Looks like 
it crashes. Whatever is wrong, setup.php doesn't create the 
SQLite-stuff correctly, but manually it works.
2007-02-25 09:29:15 Jan Schneider Comment #4
State ⇒ Feedback
Reply to this comment
You should be able to use the scripts/sql/groupware.sql script.
2007-02-24 20:09:42 fbusse (at) gmx (dot) de Comment #3 Reply to this comment
Regarding user-error: I simply followed setup.php. The sql-file is 
created, but the tables aren't.

Don't know what I could've possibly have done wrong.
2007-02-24 19:45:27 Chuck Hagenbuch Comment #2
Assigned to Jan Schneider
State ⇒ Assigned
Reply to this comment
Not sure how much of this is user error and how much is missing sqlite 
scripts - maybe a create.sqlite is needed?
2007-02-24 18:49:54 fbusse (at) gmx (dot) de Comment #1
Type ⇒ Bug
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Summary ⇒ SQLite not properly set up
Queue ⇒ Horde Groupware Webmail Edition
Reply to this comment
Following the INSTALL-file, I ran scripts/setup.php and choose sqlite 
as database.

The database gets set up just fine, however no tables are created, the 
database-file is 0 bytes long. setup.php doesn't give any errors and 
running 'sqlite -init sql/$file.sql /tmp/horde.sql' gives me some of 
the tables, but tables for Kronolith etc are still missing.

Saved Queries