From c04c1ef17df97144e2effa74f105a2db125e5b19 Mon Sep 17 00:00:00 2001 From: yashodha Date: Wed, 19 Oct 2022 13:48:04 +0530 Subject: [PATCH] (dev/core#3926) Need to increase data size for 'url' column on 'civicrm_website' table --- CRM/Core/DAO/Website.php | 4 ++-- CRM/Upgrade/Incremental/sql/5.56.alpha1.mysql.tpl | 3 +++ xml/schema/Core/Website.xml | 4 ++-- 3 files changed, 7 insertions(+), 4 deletions(-) diff --git a/CRM/Core/DAO/Website.php b/CRM/Core/DAO/Website.php index 30828b7801..55eb56f922 100644 --- a/CRM/Core/DAO/Website.php +++ b/CRM/Core/DAO/Website.php @@ -159,8 +159,8 @@ class CRM_Core_DAO_Website extends CRM_Core_DAO { 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Website'), 'description' => ts('Website'), - 'maxlength' => 128, - 'size' => 30, + 'maxlength' => 255, + 'size' => CRM_Utils_Type::HUGE, 'import' => TRUE, 'where' => 'civicrm_website.url', 'headerPattern' => '/Website/i', diff --git a/CRM/Upgrade/Incremental/sql/5.56.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.56.alpha1.mysql.tpl index 9d88af10fa..4fc320d501 100644 --- a/CRM/Upgrade/Incremental/sql/5.56.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/5.56.alpha1.mysql.tpl @@ -44,3 +44,6 @@ UPDATE civicrm_state_province SET is_active = 0 WHERE country_id = @indianCountr UPDATE civicrm_preferences_date SET description = '{ts escape="sql"}Date for relationships. activities. contributions: receive, receipt, cancel. membership: join, start, renew. case: start, end.{/ts}' WHERE civicrm_preferences_date.name = 'activityDate'; UPDATE civicrm_preferences_date SET description = '{ts escape="sql"}Used in search forms.{/ts}' WHERE civicrm_preferences_date.name = 'searchDate'; + +-- dev/core#3926 Need to increase data size for 'url' column on 'civicrm_website' table +ALTER TABLE civicrm_website CHANGE url url VARCHAR( 255 ); \ No newline at end of file diff --git a/xml/schema/Core/Website.xml b/xml/schema/Core/Website.xml index 5c33851b79..3ce921cb17 100644 --- a/xml/schema/Core/Website.xml +++ b/xml/schema/Core/Website.xml @@ -44,10 +44,10 @@ url Website varchar - 128 + 255 Text - 30 + 45 true /Website/i -- 2.25.1