6.0.0-beta1
7/8/25

[#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 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

History
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.

Saved Queries