Upgrade MM 5.3.1 to latest version fails

Troubleshooting
28

Hello @XxLilBoPeepsxX,

thank you for your help and also for your confidence. (y)

current version MySQL running with MariaDB

mysql -V
mysql Ver 15.1 Distrib 10.0.38-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

my schema for the OutgoingWebhooks table

mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 548
Server version: 10.0.38-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [(none)]>
MariaDB [(none)]> use mattermost;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [mattermost]> describe OutgoingWebhooks;

+--------------+--------------+------+-----+---------+-------+
| Field        | Type         | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| Id           | varchar(26)  | NO   | PRI | NULL    |       |
| Token        | varchar(26)  | YES  |     | NULL    |       |
| CreateAt     | bigint(20)   | YES  | MUL | NULL    |       |
| UpdateAt     | bigint(20)   | YES  | MUL | NULL    |       |
| DeleteAt     | bigint(20)   | YES  | MUL | NULL    |       |
| CreatorId    | varchar(26)  | YES  |     | NULL    |       |
| ChannelId    | varchar(26)  | YES  |     | NULL    |       |
| TeamId       | varchar(26)  | YES  | MUL | NULL    |       |
| TriggerWords | text         | YES  |     | NULL    |       |
| TriggerWhen  | int(11)      | YES  |     | NULL    |       |
| CallbackURLs | text         | YES  |     | NULL    |       |
| DisplayName  | varchar(64)  | YES  |     | NULL    |       |
| Description  | text         | YES  |     | NULL    |       |
| ContentType  | varchar(128) | YES  |     | NULL    |       |
| Username     | varchar(64)  | YES  |     | NULL    |       |
| IconURL      | text         | YES  |     | NULL    |       |
+--------------+--------------+------+-----+---------+-------+
16 rows in set (0.00 sec)
1 Like