<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix"><br>
Hi,<br>
hope this helps:<br>
<br>
mysql> show create table cache_messages;<br>
+----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>
| Table | Create
Table
|<br>
+----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>
| cache_messages | CREATE TABLE `cache_messages` (<br>
`user_id` int(10) unsigned NOT NULL,<br>
`mailbox` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT
NULL,<br>
`uid` int(11) unsigned NOT NULL DEFAULT '0',<br>
`expires` datetime DEFAULT NULL,<br>
`data` longtext NOT NULL,<br>
`flags` int(11) NOT NULL DEFAULT '0',<br>
PRIMARY KEY (`user_id`,`mailbox`,`uid`),<br>
KEY `expires_index` (`expires`),<br>
CONSTRAINT `user_id_fk_cache_messages` FOREIGN KEY (`user_id`)
REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE<br>
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |<br>
+----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>
1 row in set (0.04 sec)<br>
<br>
Rgds.<br>
<br>
Franz<br>
<br>
Am 13.08.15 um 21:31 schrieb Thomas Spuhler:<br>
</div>
<blockquote cite="mid:1468087.OC1DhLJYqA@aargau.btspuhler.com"
type="cite">
<pre wrap="">I see a ton of these error in the roundcube log
DB Error: [1054] Unknown column 'expires' in 'field list' (SQL Query: INSERT
INTO cache_messages (user_id, mailbox, uid, .................
I cannot find when this column was added to the database. Does anybody
remember?
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:users@lists.kolab.org">users@lists.kolab.org</a>
<a class="moz-txt-link-freetext" href="https://lists.kolab.org/mailman/listinfo/users">https://lists.kolab.org/mailman/listinfo/users</a></pre>
</blockquote>
<br>
</body>
</html>