#1991 - Missing columns from digestives_tin table
| Identifier | #1991 |
|---|---|
| Issue type | Minor issue (breaks specific functionality) |
| Title | Missing columns from digestives_tin table |
| Status | Completed |
| Handling member | Chris Graham |
| Addon | General / Uncategorised |
| Description | I ran into a query error running cron_bridge.php that relates to notifications. It looks like d_message__text_parsed (longtext) and d_message__source_user (int) columns need to be added to the digestives_tin table. |
| Steps to reproduce | |
| Additional information | The error was generated due to a notification sent by the Disastr addon. It also appeared to be preventing @mention notifications. |
| Funded? | No |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".


Comments
diff --git a/adminzone/pages/modules/admin_version.php b/adminzone/pages/modules/admin_version.php
index 06850e1..8f0f774 100644
--- a/adminzone/pages/modules/admin_version.php
+++ b/adminzone/pages/modules/admin_version.php
@@ -486,7 +486,7 @@ class Module_admin_version
$GLOBALS['SITE_DB']->create_table('digestives_tin', array( // Notifications queued up ready for the regular digest email
'id' => '*AUTO',
'd_subject' => 'LONG_TEXT',
- 'd_message' => 'LONG_TRANS',
+ 'd_message' => 'LONG_TRANS__COMCODE',
'd_from_member_id' => '?MEMBER',
'd_to_member_id' => 'MEMBER',
'd_priority' => 'SHORT_INTEGER',
but needs manual DB edit if not reinstalling