Can't send announcement, only triggers an exception

ℹ️ Support
8

Question:

  • MySQL/MariaDB or PostgreSQL?

Could you please post the output from this SQL-Query:

This is for MySQL/MariaDB, if you are using PostgreSQL, it is slightly different:

SHOW COLUMNS FROM oc_announcements;

It SHOULD look like this example:

MariaDB [nextcloud]> SHOW COLUMNS FROM oc_announcements;
+----------------------------+--------------+------+-----+---------+----------------+
| Field                      | Type         | Null | Key | Default | Extra          |
+----------------------------+--------------+------+-----+---------+----------------+
| announcement_id            | int(11)      | NO   | PRI | NULL    | auto_increment |
| announcement_time          | int(11)      | NO   |     | 0       |                |
| announcement_user          | varchar(64)  | NO   |     | NULL    |                |
| announcement_subject       | varchar(512) | NO   |     | NULL    |                |
| announcement_message       | longtext     | YES  |     | NULL    |                |
| allow_comments             | smallint(6)  | YES  |     | 1       |                |
| announcement_plain_message | longtext     | YES  |     | NULL    |                |
+----------------------------+--------------+------+-----+---------+----------------+
7 rows in set (0,002 sec)

If in your database the ‘allow_comments’ column is missing, then you should add it with this Query:

ALTER TABLE oc_announcements ADD COLUMN allow_comments smallint(6) DEFAULT 1;

If you are on a debian/ubuntu box and don’t know how to get an SQL console, use → nc-sql ←

I hope this was helpfull.

Much and good luck,
ernolf

2 Likes