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

6.0.0-git

2019-04-24

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)
Due
Updated	2007-02-26 (4440 days ago)
Assigned	2007-02-25 (4441 days ago)
Resolved	2007-02-25 (4441 days ago)
Milestone
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 anymore.

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.