View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 4939 | Composr non-bundled addons | General / Uncategorised | public | 2022-09-16 15:25 | 2022-09-16 18:00 |
| Reporter | Chris Graham | Assigned To | Chris Graham | ||
| Priority | normal | Severity | minor | ||
| Status | resolved | Resolution | fixed | ||
| Summary | 4939: Trickstr failing to install if the default collation is for a multibyte string | ||||
| Description | MySQL returns "Specified key was too long; max key length is 1000 bytes". A prospective fix is attached. As the issue happens to Patrick, I'll need to get them to test it. | ||||
| Tags | No tags attached. | ||||
| Attach Tags | |||||
| Attached Files | trickstr-fix.diff (1,346 bytes)
diff --git a/sources_custom/hooks/modules/chat_bots/trickstr.php b/sources_custom/hooks/modules/chat_bots/trickstr.php
index d187a278d1..1f6d8e594d 100755
--- a/sources_custom/hooks/modules/chat_bots/trickstr.php
+++ b/sources_custom/hooks/modules/chat_bots/trickstr.php
@@ -134,7 +134,7 @@ class Hook_chat_bot_trickstr
name varchar(255) NOT NULL default '',
value text NOT NULL,
PRIMARY KEY (id),
- KEY botname (bot,name)
+ KEY botname (bot,name(200))
) ENGINE=MyISAM");
$GLOBALS['SITE_DB']->query("CREATE TABLE bots (
id tinyint(3) unsigned NOT NULL auto_increment,
@@ -172,7 +172,7 @@ class Hook_chat_bot_trickstr
inputmatched text,
combined text NOT NULL,
PRIMARY KEY (id),
- KEY combined (bot,combined(255))
+ KEY combined (bot,combined(200))
) ENGINE=MyISAM");
$GLOBALS['SITE_DB']->query("CREATE TABLE gossip (
bot tinyint(3) unsigned NOT NULL default '0',
@@ -189,7 +189,7 @@ class Hook_chat_bot_trickstr
parent int(11) NOT NULL default '0',
isend tinyint(4) NOT NULL default '0',
PRIMARY KEY (id),
- KEY wordparent (parent,word),
+ KEY wordparent (parent,word(200)),
KEY botid (bot)
) ENGINE=MyISAM");
$GLOBALS['SITE_DB']->query("CREATE TABLE templates (
| ||||
| Time estimation (hours) | |||||
| Sponsorship open | |||||
|
|
Automated response: Trickstr will not install on databases with a default multibyte collation MySQL returns "Specified key was too long; max key length is 1000 bytes". |
|
|
Fixed in git commit 4c6db34c11 (https://gitlab.com/composr-foundation/composr/commit/4c6db34c11 - link will become active once code pushed to GitLab) A hotfix (a TAR of files to upload) has been uploaded to this issue. These files are made to the latest intra-version state (i.e. may roll in earlier fixes too if made to the same files) - so only upload files newer than what you have already. If there are files in a hot-fix that you don't have then they probably relate to addons that you don't have installed and should be skipped. Always take backups of files you are replacing or keep a copy of the manual installer for your version, and only apply fixes you need. These hotfixes are not necessarily reliable or well supported. Not sure how to extract TAR files to your Windows computer? Try 7-zip (http://www.7-zip.org/). |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-09-16 15:25 | Chris Graham | New Issue | |
| 2022-09-16 15:25 | Chris Graham | Status | Not Assigned => Assigned |
| 2022-09-16 15:25 | Chris Graham | Assigned To | => user4172 |
| 2022-09-16 15:25 | Chris Graham | File Added: trickstr-fix.diff | |
| 2022-09-16 15:25 | Chris Graham | Severity | Feature or Request => Major Bug |
| 2023-02-26 18:29 | Chris Graham | Category | General => General / Uncategorised |
