Bug MySQL query error [1406]: Data too long for column 'dbtech_security_user_agent' at row 1

[Nirjonadda]

Server error log:

XF\Db\Exception: MySQL query error [1406]: Data too long for column 'dbtech_security_user_agent' at row 1 src/XF/Db/AbstractStatement.php:228

Generated by: Spellbinder May 24, 2021 at 1:14 PM

Stack trace

INSERT  INTO `xf_user_remember` (`user_id`, `remember_key`, `expiry_date`, `dbtech_security_user_agent`, `remember_id`, `start_date`) VALUES (?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1406, '22001')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1406, '22001')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1510): XF\Db\AbstractAdapter->insert('xf_user_remembe...', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1242): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Repository/UserRemember.php(15): XF\Mvc\Entity\Entity->save()
#7 src/XF/ControllerPlugin/Login.php(267): XF\Repository\UserRemember->createRememberRecord(18627)
#8 src/XF/Pub/Controller/Register.php(480): XF\ControllerPlugin\Login->createVisitorRememberKey()
#9 src/XF/Pub/Controller/Register.php(430): XF\Pub\Controller\Register->finalizeRegistration(Object(Datio\AllowedEmails\XF\Entity\User))
#10 src/addons/AddonFlare/PaidRegistrations/XF/Pub/Controller/Register.php(230): XF\Pub\Controller\Register->actionRegister()
#11 src/XF/Mvc/Dispatcher.php(350): AddonFlare\PaidRegistrations\XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#12 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(AddonFlare\PaidRegistrations\XF\Pub\Controller\Register), NULL)
#13 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(AddonFlare\PaidRegistrations\XF\Pub\Controller\Register), NULL)
#14 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#15 src/XF/App.php(2337): XF\Mvc\Dispatcher->run()
#16 src/XF.php(488): XF\App->run()
#17 index.php(20): XF::runApp('XF\\Pub\\App')
#18 {main}

Request state

array(4) {
  ["url"] => string(18) "/register/register"
  ["referrer"] => string(46) "/register/?accountType=1"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(19) {
    ["username"] => string(0) ""
    ["5f7da697f26650c1fc076ca1341e7b177e0839e8"] => string(11) "Spellbinder"
    ["ccc2828a8b835e35cf362ff91ab4cc0366bbb7d8"] => string(22) "@gmail.com"
    ["password"] => string(8) "********"
    ["2f7c7572af371aaae92dfd4fb7d839f8d9380ec7"] => string(8) "********"
    ["dob_month"] => string(1) "5"
    ["dob_day"] => string(1) "5"
    ["dob_year"] => string(4) "1986"
    ["location"] => string(9) "Maldives "
    ["custom_fields"] => array(2) {
      ["gender"] => string(4) "male"
      ["siropu_referrer"] => string(0) ""
    }
    ["g-recaptcha-response"] => string(2360) "P0_eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJwYXNza2V5IjoiekRJQnJYUDVwMkVYMUJiSEgvbEdFTlFGSnpRTkJCSXlURE56VDZYV1ZWMjJEdGdpSjVBSnBhZVoxZU02dkJGalNyZFdJbnJkOU5ScnZtNFQ5Sy8zYjhwcjgyTElndExkYzBPUnlleXVuQXFhZnJzRnhBRVp4a3d2WCs1Z2QrRERMdkYweWpoaVE4NGVEWWdKUExvZjhyNTIwS2VXY055Mldsc0p1MXQxbWFuVmJld1Fjc0FjK3JybjBjbEh1V0pBZFdEWTdzQW5TUTZZaW5uR29MMkR6elNQU21CVEhISENPblhjbHA1emNUdnFNYnVibXZmRVlLdFIzeWJRVkdiWXlsMEtsQXdvVkVRRFNWT2NBeVpxWDFPTGg0Zi9SUVNlTWZuQ0d0NGd6Q2lNTGRJTUM3Wi85eE41cGdXNC9ZekhvbVF0Mmx6Vzd3UjNaakZ1K2MzU0dIVnJ3MnpYcjhYdVdLSFM5UGlFMlZpdEYzcWN5aEdqTExwSjU5SllRNkNWYWxHQVlzWWRTbjFJSGZ2V1pSSC9Na2RJbFN5aGp5azFwWXVMSVBmS0hKaENPQTFVR3E1eXlUSHFGdnBvMFZ2dmk4MjE2cE5oM0ZneXhpZGRwTDFkbHZabXRqVFA4Zk1tTUdpNkdiSVpZdkwwYW9YZWMzR3ZBcDNpY09QNWF4TkVsZEpZOFhnNEFsZU9oKzd5QUxzazN5L1c5ZGY5eVRlWnIwcmw5Y1gwZEV0bm02TDNROFkrcmhBRW54dm1uK2dPL3dHRWdrOE5pV0VrczFEbUlqT3FCRHEwb2hLOHVxSnNuYVE1ViswTzFueElzK2dnUDJadEQrNGxBY3ZWYVhBWkhXQTFpZlEyQ2RvbW9TdzBZLzZiKzdiVmgwTVV4RzZBYWZqanhpZG1NOXV1MmdhVU9mdVkzcUk0VDBnNFQ0WWtBZkFVam1BZGM5OVdFeSttQmZYMjlKcndXL1RsS2Nia1AyUVNIWEorV3RJeVZpM3I4OGNKWkxPcDZFSkZqT2dHc25mTE5GcDF0UjBRSzM0OFhadllqYW5TdlNVUmh0VFZvT3FPWjBLQSt1MGg3b0c2YUgra2VjUUx0L3ZwM3JqRUU4RThGcHQ4VXh6OXdhTU1CR0dBZHZUeUVIcjN1akVDdmJ6VTF3M25EeFJ6MnNMT1c0N3IxQ25zMWsyVnVra2N6VGp3OHZmc2RrQVJFSWJsZlFaTFhpcnRPUTlYeU9CMjIrbzNuRTRqOU1jNjNmdEhMWWtmSVpvTXM3OHhJc3M2MnJPYmxIaGttQmkxS0dKQ1lVczd4cVFmb1U0azR2aXozczA1UmdQSHFxZ1ZQUE1YL1BnOEEzWGI2bnhRcUF1VURKZEIwRVpOcTRvbzluTGZnNVVpYjFiZ2NSeHZrYzNtTWNlYnNtMkVJQUdPMmJKUnNKT24rd2p1UUJaMllveHJpVW8zQVdRU2RDV0RMM1Y5eHFEckFSWXU5enZUeEp1SGNEYkp0am15ZXo2TWNvVmRVY2dyZlh3UUE3clQ0V3JoTEFMNEpML1NPUnV2c0Q2d2ZSNU1rSEk5S1d2Ky9NTFkrenlNUUhoTWZmRm1MeUNvd0Q3MjU3UGxBUGpQNnNGcFMxeEdOTkE0VGJUMEZjZ3FtNnFhdGdQZnJSbnM2ZW1HQTkwWDhhY0ZBM0Q5VjZEZUlqNGwxaGtJVjk2NW1QWDh1OG10bEN1TEpSaGNid0hwRlgxRHpDa3F4VmJPc0hYZjcvSjJGcFlaYVlEL2pWTUd5MGlJaGp5M3JMNHZoMjdCMnIxUHM2RThSaklkanZacUxrL3FxOTcyaTZRcDBCNzVqM3NpYkEvc2QwdVFKbWQxNnBOdGUvUTFSWFZrQjJScDRJeHBZWVYzdE04dDlxZFI5d0VuTDVMb1orSTU4MFppaXptM0NMNjBLakZHNkhsOVBKNjJpSlNRYWtnZnR2aFdqcktXWEN2KzNEOFI1TGJlV0d0MXZhYWZxRVgydnBpdm5GRzRwSXAvSm96V0JXUkZpTmxDN0ZGMVQ2ZytLVzVGWUtCSGtrZy9PWlhFMzY3NTlCTndQUGkvZ2NXaE1oQVRoYjNtR1BnZHNwam5nOEpLVy9qQVVZRm9Td1Z0blhIL21zVmVjMU8vTUtIVWcwc0ZkL0VsQWdMNzNjS1pZdFhBM1NBd0lkNERaTWdMdGZ6SiIsImV4cCI6MTYyMTg0MDU3Niwic2hhcmRfaWQiOjI1OTE4OTM1OSwicGQiOjB9.tOWn8UALvVA3Y-Bp-8wj32NcW8g6rg3RulHphB2w3BI"
    ["h-captcha-response"] => string(2360) "P0_eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJwYXNza2V5IjoiekRJQnJYUDVwMkVYMUJiSEgvbEdFTlFGSnpRTkJCSXlURE56VDZYV1ZWMjJEdGdpSjVBSnBhZVoxZU02dkJGalNyZFdJbnJkOU5ScnZtNFQ5Sy8zYjhwcjgyTElndExkYzBPUnlleXVuQXFhZnJzRnhBRVp4a3d2WCs1Z2QrRERMdkYweWpoaVE4NGVEWWdKUExvZjhyNTIwS2VXY055Mldsc0p1MXQxbWFuVmJld1Fjc0FjK3JybjBjbEh1V0pBZFdEWTdzQW5TUTZZaW5uR29MMkR6elNQU21CVEhISENPblhjbHA1emNUdnFNYnVibXZmRVlLdFIzeWJRVkdiWXlsMEtsQXdvVkVRRFNWT2NBeVpxWDFPTGg0Zi9SUVNlTWZuQ0d0NGd6Q2lNTGRJTUM3Wi85eE41cGdXNC9ZekhvbVF0Mmx6Vzd3UjNaakZ1K2MzU0dIVnJ3MnpYcjhYdVdLSFM5UGlFMlZpdEYzcWN5aEdqTExwSjU5SllRNkNWYWxHQVlzWWRTbjFJSGZ2V1pSSC9Na2RJbFN5aGp5azFwWXVMSVBmS0hKaENPQTFVR3E1eXlUSHFGdnBvMFZ2dmk4MjE2cE5oM0ZneXhpZGRwTDFkbHZabXRqVFA4Zk1tTUdpNkdiSVpZdkwwYW9YZWMzR3ZBcDNpY09QNWF4TkVsZEpZOFhnNEFsZU9oKzd5QUxzazN5L1c5ZGY5eVRlWnIwcmw5Y1gwZEV0bm02TDNROFkrcmhBRW54dm1uK2dPL3dHRWdrOE5pV0VrczFEbUlqT3FCRHEwb2hLOHVxSnNuYVE1ViswTzFueElzK2dnUDJadEQrNGxBY3ZWYVhBWkhXQTFpZlEyQ2RvbW9TdzBZLzZiKzdiVmgwTVV4RzZBYWZqanhpZG1NOXV1MmdhVU9mdVkzcUk0VDBnNFQ0WWtBZkFVam1BZGM5OVdFeSttQmZYMjlKcndXL1RsS2Nia1AyUVNIWEorV3RJeVZpM3I4OGNKWkxPcDZFSkZqT2dHc25mTE5GcDF0UjBRSzM0OFhadllqYW5TdlNVUmh0VFZvT3FPWjBLQSt1MGg3b0c2YUgra2VjUUx0L3ZwM3JqRUU4RThGcHQ4VXh6OXdhTU1CR0dBZHZUeUVIcjN1akVDdmJ6VTF3M25EeFJ6MnNMT1c0N3IxQ25zMWsyVnVra2N6VGp3OHZmc2RrQVJFSWJsZlFaTFhpcnRPUTlYeU9CMjIrbzNuRTRqOU1jNjNmdEhMWWtmSVpvTXM3OHhJc3M2MnJPYmxIaGttQmkxS0dKQ1lVczd4cVFmb1U0azR2aXozczA1UmdQSHFxZ1ZQUE1YL1BnOEEzWGI2bnhRcUF1VURKZEIwRVpOcTRvbzluTGZnNVVpYjFiZ2NSeHZrYzNtTWNlYnNtMkVJQUdPMmJKUnNKT24rd2p1UUJaMllveHJpVW8zQVdRU2RDV0RMM1Y5eHFEckFSWXU5enZUeEp1SGNEYkp0am15ZXo2TWNvVmRVY2dyZlh3UUE3clQ0V3JoTEFMNEpML1NPUnV2c0Q2d2ZSNU1rSEk5S1d2Ky9NTFkrenlNUUhoTWZmRm1MeUNvd0Q3MjU3UGxBUGpQNnNGcFMxeEdOTkE0VGJUMEZjZ3FtNnFhdGdQZnJSbnM2ZW1HQTkwWDhhY0ZBM0Q5VjZEZUlqNGwxaGtJVjk2NW1QWDh1OG10bEN1TEpSaGNid0hwRlgxRHpDa3F4VmJPc0hYZjcvSjJGcFlaYVlEL2pWTUd5MGlJaGp5M3JMNHZoMjdCMnIxUHM2RThSaklkanZacUxrL3FxOTcyaTZRcDBCNzVqM3NpYkEvc2QwdVFKbWQxNnBOdGUvUTFSWFZrQjJScDRJeHBZWVYzdE04dDlxZFI5d0VuTDVMb1orSTU4MFppaXptM0NMNjBLakZHNkhsOVBKNjJpSlNRYWtnZnR2aFdqcktXWEN2KzNEOFI1TGJlV0d0MXZhYWZxRVgydnBpdm5GRzRwSXAvSm96V0JXUkZpTmxDN0ZGMVQ2ZytLVzVGWUtCSGtrZy9PWlhFMzY3NTlCTndQUGkvZ2NXaE1oQVRoYjNtR1BnZHNwam5nOEpLVy9qQVVZRm9Td1Z0blhIL21zVmVjMU8vTUtIVWcwc0ZkL0VsQWdMNzNjS1pZdFhBM1NBd0lkNERaTWdMdGZ6SiIsImV4cCI6MTYyMTg0MDU3Niwic2hhcmRfaWQiOjI1OTE4OTM1OSwicGQiOjB9.tOWn8UALvVA3Y-Bp-8wj32NcW8g6rg3RulHphB2w3BI"
    ["accept"] => string(1) "1"
    ["reg_key"] => string(16) "NNRdotYybruiJ-Av"
    ["fc0b58b77158005d2479ccc3d8aac5d5f00105c3"] => string(13) "Asia/Tashkent"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(24) "/register/?accountType=1"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

 

[Fillip H.]

Check the column definition of dbtech_security_user_agent on the xf_user_remember table. It should be a BLOB type, which is 64 kb - no user agent will ever be that long.

 

[Nirjonadda]

Check the column definition of dbtech_security_user_agent on the xf_user_remember table. It should be a BLOB type, which is 64 kb - no user agent will ever be that long.

I do not find about BLOB type.

 

[Fillip H.]

Go to the "Structure" tab.

 

[DragonByte Technologies]

Hello @Nirjonadda,

We hope your ticket regarding DragonByte Security has been addressed to your satisfaction. This ticket has now been scheduled to be closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.

 

[Nirjonadda]

It should be a BLOB type, which is 64 kb - no user agent will ever be that long.

No this are not BLOB type.

 

[Fillip H.]

Then change it using the "Change" button and set it to blob.

 

[DragonByte Technologies]

Hello @Nirjonadda,

We hope your ticket regarding DragonByte Security has been addressed to your satisfaction. This ticket has now been scheduled to be closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.

 

[DragonByte Technologies]

Hello @Nirjonadda,

As we have not heard back from you, your ticket regarding DragonByte Security has now been closed.

If your ticket has not been resolved, please feel free to start a new support ticket and link back to this ticket.

If you have time, please leave a review on XenForo.com's Resource Manager.

Thank you.


- DragonByte Technologies, Ltd.