Maybe interesting for some?
---------- Forwarded message ----------
From: Massimo Danieli <m.danieli(a)freshnet.org>
Date: Thu, Apr 3, 2008 at 2:33 PM
Subject: Roundcube debs for Debian etch
If you think was interessant for someone I have done some debs for
Debian etch
http://www.freshnet.org/wordpress/2008/04/03/roundcube-01-4-backport-for-de…
C u and THANKS for Roundcube
Massimo
_______________________________________________
List info: http://lists.roundcube.net/dev/
Thomas Bruederli wrote:
> Actually we don't have an automated update-scenario. I think MDB2 has
> some Schema creation/reverse-engineering functions that might me useful
> to update any existing database schema. It operates with an XML-based
> specification of the desired database schema. But I haven't worked with
> it so far.
>
> Regarding the ticket: I've done some index-optimization in
> http://trac.roundcube.net/changeset/1218 but not for Postgres.
Ok, I see that you don't have a history of schema changes, so I do it in
the same way. I think it should be changed in feature versions.
In LMS project we have an auto-update feature. We're creating a script
for each change (one for each database type) in upgradedb directory. In
database is stored database schema version number. So when user opens
LMS, system's to campare database version from database and from source
code and execute all scripts from upgradedb dir when versions differ.
Scripts have date in its names so are sorted first.
That scenario needs one sql query for version checking. In roundcube we
may do this not for each login to webmail, but in some update-script
(maybe in installer) to call it once.
--
Aleksander 'A.L.E.C' Machniak http://alec.pl gg:2275252
LAN Management System Developer http://lms.alec.pl
_______________________________________________
List info: http://lists.roundcube.net/dev/
I have three issues with using the stable relase.
OS : Win 2000 IIS 5.0
Mysql 5.0
PHP 5.2.5.5 ISAPI
1) I get this error followed usually by a crashing of IIS
[02-Apr-2008 04:56:39 -0700] DB Error: DB Error: constraint violation Query: INSERT INTO messages (user_id, del, cache_key, created, idx, uid, subject, `from`, `to`, cc, date, size, headers, structure) VALUES ('20', 0, 'Inbox.msg', now(), NULL, '11669', '', '', '', '', FROM_UNIXTIME(0), 5519, 'O:8:\"stdClass\":8:{s:3:\"uid\";s:5:\"11669\";s:4:\"size\";s:4:\"5519\";s:4:\"seen\";b:0;s:6:\"recent\";b:0;s:7:\"deleted\";b:0;s:8:\"answered\";b:0;s:5:\"flags\";s:0:\"\";s:12:\"internaldate\";s:20:\"23-Mar-2008 08:28:18\";}', NULL) [nativecode=1048 ** Column 'idx' cannot be null] in D:\roundbackup\program\include\rcube_db.inc on line 505
I am guessing it is trying to read an email with a blank subject or sender field...
2) I cannot attach files when I send. I don't have this problem with RC2. I think I altered some code to get this to work, but I forget where.
3) When clicking the (+) sign to add an email address as a contact, it fails....
Thanks for any possible help.....
Jason
_______________________________________________
List info: http://lists.roundcube.net/dev/