Tickets :: [#5034] SQLite not properly set up

6.0.0-beta1

7/8/25

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	02/24/2007 (6709 days ago)
Due
Updated	02/26/2007 (6707 days ago)
Assigned	02/25/2007 (6708 days ago)
Resolved	02/25/2007 (6708 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

02/26/2007 12:27:43 PM	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 anymore.

02/26/2007 08:48:20 AM	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?

02/25/2007 07:45:44 PM	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.

02/25/2007 10:23:17 AM	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.

02/25/2007 09:41:43 AM	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.

02/25/2007 09:29:15 AM	Jan Schneider	Comment #4 State ⇒ Feedback	Reply to this comment
You should be able to use the scripts/sql/groupware.sql script.

02/24/2007 08:09:42 PM	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.

02/24/2007 07:45:27 PM	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?

02/24/2007 06:49:54 PM	fbusse (at) gmx (dot) de	Comment #1 Priority ⇒ 2. Medium Type ⇒ Bug Summary ⇒ SQLite not properly set up Queue ⇒ Horde Groupware Webmail Edition State ⇒ Unconfirmed	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.