From 4942c6893d0daf3b98dcb6b2aa05cefb1290fd4e Mon Sep 17 00:00:00 2001
From: yashodha <yashodha@cividesk.com>
Date: Wed, 12 Oct 2022 09:26:57 +0530
Subject: [PATCH] (dev/core#3905) Need to increase data size for 'data' column
 on 'civicrm_job_log' table

---
 CRM/Core/DAO/JobLog.php                           | 4 ++--
 CRM/Upgrade/Incremental/sql/5.56.alpha1.mysql.tpl | 3 +++
 xml/schema/Core/JobLog.xml                        | 2 +-
 3 files changed, 6 insertions(+), 3 deletions(-)

diff --git a/CRM/Core/DAO/JobLog.php b/CRM/Core/DAO/JobLog.php
index 3206263c1c..cde28a06ae 100644
--- a/CRM/Core/DAO/JobLog.php
+++ b/CRM/Core/DAO/JobLog.php
@@ -97,7 +97,7 @@ class CRM_Core_DAO_JobLog extends CRM_Core_DAO {
    * Potential extended data for specific job run (e.g. tracebacks).
    *
    * @var string|null
-   *   (SQL type: text)
+   *   (SQL type: longtext)
    *   Note that values will be retrieved from the database as a string.
    */
   public $data;
@@ -250,7 +250,7 @@ class CRM_Core_DAO_JobLog extends CRM_Core_DAO {
         ],
         'data' => [
           'name' => 'data',
-          'type' => CRM_Utils_Type::T_TEXT,
+          'type' => CRM_Utils_Type::T_LONGTEXT,
           'title' => ts('Extended Data'),
           'description' => ts('Potential extended data for specific job run (e.g. tracebacks).'),
           'where' => 'civicrm_job_log.data',
diff --git a/CRM/Upgrade/Incremental/sql/5.56.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.56.alpha1.mysql.tpl
index 6b9e3fa1cf..aabf417db0 100644
--- a/CRM/Upgrade/Incremental/sql/5.56.alpha1.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/5.56.alpha1.mysql.tpl
@@ -1,5 +1,8 @@
 {* file to handle db changes in 5.56.alpha1 during upgrade *}
 
+-- dev/core#3905 Update data type for data to LONGTEXT
+ALTER TABLE civicrm_job_log MODIFY COLUMN data LONGTEXT COMMENT 'Potential extended data for specific job run (e.g. tracebacks).';
+
 -- Add in missing indian states as per iso-3166-2
 SELECT @indianCountryID := id FROM civicrm_country WHERE name = 'India' AND iso_code = 'IN';
 INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES
diff --git a/xml/schema/Core/JobLog.xml b/xml/schema/Core/JobLog.xml
index d0764fc2c4..9fb80bfdac 100644
--- a/xml/schema/Core/JobLog.xml
+++ b/xml/schema/Core/JobLog.xml
@@ -85,7 +85,7 @@
   <field>
     <name>data</name>
     <title>Extended Data</title>
-    <type>text</type>
+    <type>longtext</type>
     <comment>Potential extended data for specific job run (e.g. tracebacks).</comment>
     <add>4.1</add>
   </field>
-- 
2.25.1