Hi,
Is it possible to use the calendar (which contains to the myroundcube package combined) with a sqlite database.
I have only found sql scipts for mysql and postgres in the "SQL"-Folder.
So I have tried to convert those scripts in sqlite syntax manually.
Result:
CREATE TABLE 'events' (
'event_id' INTEGER,
'uid' TEXT,
'recurrence_id' TEXT,
'user_id' INTEGER NOT NULL DEFAULT '0',
'start' datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
'end' datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
'expires' datetime NOT NULL DEFAULT '9999-12-31 23:59:59',
'rr' TEXT default NULL,
'recurring' TEXT NOT NULL,
'occurrences' INTEGER DEFAULT '0',
'byday' TEXT,
'bymonth' TEXT,
'bymonthday' TEXT,
'summary' TEXT NOT NULL,
'description' TEXT NOT NULL,
'location' TEXT NOT NULL DEFAULT '',
'categories' TEXT NOT NULL DEFAULT '',
'all_day' INTEGER NOT NULL DEFAULT '0',
'group' TEXT,
'timestamp' timestamp NULL DEFAULT CURRENT_TIMESTAMP,
'del' INTEGER NOT NULL DEFAULT '0',
'notified' INTEGER NOT NULL default '0',
PRIMARY KEY ('event_id' ASC),
CONSTRAINT 'user_id_fk_events' FOREIGN KEY ('user_id')
REFERENCES 'users'('user_id') ON DELETE CASCADE ON UPDATE CASCADE
);
CREATE INDEX events_user_id ON events (user_id, del);
I was able to run this on my sqlite database und the calendar is available in my roundcube.
But the problem: In the calendar are some example entries not from me.
If i try to select one nothing happens.
If i try to add a new entry the form to create opens but after saving there is no new entry in the calendar.
I can't find something suspicious in roundcubes error logs.
Thanks for help.
