getting lot's of db errors after upgrade

[Thomas Spuhler]

On Thursday, August 13, 2015 09:58:14 PM Franz Skale wrote:
> Hi,
> hope this helps:
> 
> mysql> show create table cache_messages;
> +----------------+----------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> --------------------------+
> | Table          | Create
> 
> Table
> 
> +----------------+----------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> --------------------------+
> | cache_messages | CREATE TABLE `cache_messages` (
> 
>   `user_id` int(10) unsigned NOT NULL,
>   `mailbox` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
>   `uid` int(11) unsigned NOT NULL DEFAULT '0',
>   `expires` datetime DEFAULT NULL,
>   `data` longtext NOT NULL,
>   `flags` int(11) NOT NULL DEFAULT '0',
>   PRIMARY KEY (`user_id`,`mailbox`,`uid`),
>   KEY `expires_index` (`expires`),
>   CONSTRAINT `user_id_fk_cache_messages` FOREIGN KEY (`user_id`)
> REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
> +----------------+----------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> --------------------------+ 1 row in set (0.04 sec)
> 
> Rgds.
> 
> Franz
> 
> Am 13.08.15 um 21:31 schrieb Thomas Spuhler:
> > 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?
> > 
> > 
> > 
> > _______________________________________________
> > users mailing list
> > users at lists.kolab.org
> > https://lists.kolab.org/mailman/listinfo/users


Just for the record, table cache needs this line too. It's now resolved.

> show create table cache;
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
|
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| cache | CREATE TABLE `cache` (
  `user_id` int(10) unsigned NOT NULL,
  `cache_key` varchar(128) CHARACTER SET ascii NOT NULL,
  `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  >> `expires` datetime DEFAULT NULL,
  `data` longtext NOT NULL,
  KEY `created_index` (`created`),
  KEY `user_cache_index` (`user_id`,`cache_key`),
  CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`) REFERENCES `users` 
(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |

-- 
Best regards
Thomas Spuhler

All of my e-mails have a valid digital signature
ID 60114E63
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 181 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.kolab.org/pipermail/users/attachments/20150813/454f62d9/attachment.sig>