XF\Db\Exception: xf_dbtech_security_bad_behavior: MySQL query error [1406]: Data too long for column 'request_method' at row 63945
src/XF/Db/AbstractStatement.php:225
Generated by: Unknown account
Oct 18, 2026 at 8:37 AM
Stack trace
ALTER TABLE `xf_dbtech_security_bad_behavior`
MODIFY COLUMN `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
MODIFY COLUMN `ip` VARCHAR(45) NOT NULL,
MODIFY COLUMN `date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
MODIFY COLUMN `request_method` VARCHAR(8) NOT NULL,
MODIFY COLUMN `request_uri` VARCHAR(2048) NOT NULL,
MODIFY COLUMN `server_protocol` VARCHAR(12) NOT NULL,
MODIFY COLUMN `http_headers` MEDIUMTEXT NOT NULL,
MODIFY COLUMN `user_agent` MEDIUMTEXT NOT NULL,
MODIFY COLUMN `request_entity` MEDIUMTEXT NOT NULL,
MODIFY COLUMN `key` VARCHAR(50) NOT NULL,
ADD `status_message` MEDIUMTEXT DEFAULT NULL,
ADD `support_key` VARCHAR(64) NOT NULL DEFAULT '',
ADD `bot_category` VARCHAR(32) NOT NULL DEFAULT '',
ADD `bot_verified` TINYINT UNSIGNED NOT NULL DEFAULT '0',
ADD `ja3` VARCHAR(64) NOT NULL DEFAULT '',
ADD `h2_hash` VARCHAR(16) NOT NULL DEFAULT '',
ADD `header_order_hash` VARCHAR(16) NOT NULL DEFAULT '',
ADD `asn` VARCHAR(32) NOT NULL DEFAULT '',
ADD `country` VARCHAR(2) NOT NULL DEFAULT '',
ADD `request_time_ms` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `enforcement_action` VARCHAR(16) NOT NULL DEFAULT 'enforced',
ADD `original_code` VARCHAR(50) NOT NULL DEFAULT '',
ADD KEY `idx_ip` (`ip`),
ADD KEY `idx_date` (`date`),
ADD KEY `idx_bot` (`bot_category`, `bot_verified`),
ADD KEY `idx_enforcement` (`enforcement_action`, `date`),
ADD KEY `idx_request_method` (`request_method`)
------------
#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1406, '22001')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1406, '22001')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/Schema/AbstractDdl.php(158): XF\Db\AbstractAdapter->query('ALTER TABLE `xf...')
#4 src/XF/Db/SchemaManager.php(157): XF\Db\Schema\AbstractDdl->apply()
#5 src/addons/DBTech/Security/Setup.php(326): XF\Db\SchemaManager->alterTable('xf_dbtech_secur...', Object(Closure))
#6 src/addons/DBTech/Security/Install/Upgrade905999970Trait.php(50): DBTech\Security\Setup->applyTables()
#7 src/XF/AddOn/StepRunnerUpgradeTrait.php(124): DBTech\Security\Setup->upgrade905020011Step1(Array)
#8 src/XF/AddOn/StepRunnerUpgradeTrait.php(73): DBTech\Security\Setup->upgradeStepRunner(905020011, 1, Array, NULL)
#9 src/XF/Cli/Command/AddOnActionTrait.php(116): DBTech\Security\Setup->upgrade(Array)
#10 src/XF/Cli/Command/AddOnSubAction.php(79): XF\Cli\Command\AddOnSubAction->performAddOnAction(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput), Object(XF\AddOn\AddOn), Object(XF\Phrase), 'upgrade')
#11 src/vendor/symfony/console/Command/Command.php(298): XF\Cli\Command\AddOnSubAction->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 src/vendor/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#13 src/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand(Object(XF\Cli\Command\AddOnSubAction), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#14 src/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#15 src/XF/Cli/Runner.php(115): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#16 cmd.php(17): XF\Cli\Runner->run()
#17 {main}