View Issue Details

IDProjectCategoryView StatusLast Update
1991Composr alpha bug reportsGeneral / Uncategorisedpublic2015-07-27 17:18
ReporterJason Verhagen Assigned ToChris Graham  
PrioritynormalSeverityminor 
Status resolvedResolutionfixed 
Summary1991: Missing columns from digestives_tin table
DescriptionI 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.
Additional InformationThe error was generated due to a notification sent by the Disastr addon. It also appeared to be preventing @mention notifications.
TagsNo tags attached.
Attach Tags
Sponsorship open

Sponsor

Date Added Member Amount Sponsored

Activities

Chris Graham

2015-07-27 17:17

administrator   ~2993

For reference, change is

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

Issue History

Date Modified Username Field Change
2023-02-26 18:29 Chris Graham Category General => General / Uncategorised