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

Thanks Franz. I added that column but it didn't help (restarted mysqld after)
This is now my output:

> 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',
  `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `expires` datetime NOT NULL,
  `data` longtext NOT NULL,
  `flags` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`mailbox`,`uid`),
  KEY `changed_index` (`changed`),
  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 |

I have this column that you didn't
 `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',


-- 
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/b8e12101/attachment.sig>