From: Valerie Pond <redacted>
Date: Sat, 10 Aug 2024 05:53:49 +0000 (+0800)
Subject: Make some SQL values LONGTEXT instead of VARCHAR(255)
X-Git-Url: https://jfr.im/git/irc/unrealircd/unrealircd-webpanel.git/commitdiff_plain/0356d3b130992c100a68b5dd2536dd964e43b769?ds=sidebyside

Make some SQL values LONGTEXT instead of VARCHAR(255)
---

diff --git a/plugins/sql_db/sql_db.php b/plugins/sql_db/sql_db.php
index a6f3cff..78a6ebf 100644
--- a/plugins/sql_db/sql_db.php
+++ b/plugins/sql_db/sql_db.php
@@ -96,7 +96,7 @@ class sql_db
 		$conn->query("CREATE TABLE IF NOT EXISTS " . get_config("mysql::table_prefix") . "settings (
 			id int AUTO_INCREMENT NOT NULL,
 			setting_key VARCHAR(255) NOT NULL,
-			setting_value VARCHAR(5000),
+			setting_value LONGTEXT,
 			PRIMARY KEY (id),
 			UNIQUE(setting_key)
 		)");
@@ -113,7 +113,7 @@ class sql_db
 		if (($columns = $conn->query("SHOW COLUMNS FROM ".get_config("mysql::table_prefix")."user_meta")))
 			$c = $columns->fetchAll();
 		if (!empty($c))
-			$conn->query("ALTER TABLE ".get_config("mysql::table_prefix")."user_meta CHANGE `meta_value` `meta_value` VARCHAR(5000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL");
+			$conn->query("ALTER TABLE ".get_config("mysql::table_prefix")."user_meta CHANGE `meta_value` `meta_value` LONGTEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL");
 
 		/* - settings: add UNIQUE(setting_key) */
 		$c = [];
@@ -124,7 +124,7 @@ class sql_db
 			$conn->query("ALTER TABLE " . get_config("mysql::table_prefix") . "settings ADD CONSTRAINT setting_key UNIQUE(setting_key)");
 		}
 		else
-			$conn->query("ALTER TABLE ".get_config("mysql::table_prefix")."settings CHANGE setting_value setting_value VARCHAR(5000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL");
+			$conn->query("ALTER TABLE ".get_config("mysql::table_prefix")."settings CHANGE setting_value setting_value LONGTEXT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL");
 		
 		/* - user_meta: add UNIQUE(meta_key,user_id) */
 		$c = [];