XF 2.1 Невозможна регистрация из-за 'secret_key'

Zevulum · 14 Янв 2020

При нажатии на кнопку 'Регистрация' появляется ошибка "Пожалуйста, заполните обязательное поле 'secret_key'". Такого поля нет. Кто-нибудь знает к чему принадлежит это? Может плагин какой-то?

Opera Снимок_2020-01-14_113550_mod.cx.png

Zevulum · 14 Янв 2020

Captain написал(а):
В журнал ошибок зайти в панели управления

Но не раздавать советы по удалению движка колонки

из MySQL statement prepare error [1054]: Unknown column 'th_unco_user_name_data' in 'field list':

Код:

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'th_unco_user_name_data' in 'field list' src/XF/Db/AbstractStatement.php:228

INSERT INTO `xf_user` (`visible`, `activity_visible`, `user_group_id`, `timezone`, `language_id`, `username`, `email`, `user_state`, `privacy_policy_accepted`, `terms_accepted`, `display_style_group_id`, `secondary_group_ids`, `secret_key`, `user_id`, `style_id`, `permission_combination_id`, `message_count`, `alerts_unread`, `conversations_unread`, `register_date`, `last_activity`, `trophy_points`, `avatar_date`, `avatar_width`, `avatar_height`, `avatar_highdpi`, `gravatar`, `is_moderator`, `is_admin`, `is_staff`, `is_banned`, `reaction_score`, `custom_title`, `warning_points`, `xfrm_resource_count`, `af_as_award_total`, `af_as_award_points`, `th_unco_user_name_data`, `siropu_chat_room_id`, `siropu_chat_conv_id`, `siropu_chat_rooms`, `siropu_chat_conversations`, `siropu_chat_settings`, `siropu_chat_room_join_time`, `siropu_chat_status`, `siropu_chat_is_sanctioned`, `siropu_chat_message_count`, `siropu_chat_last_activity`, `snog_forms`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_user', Array, false)
#6 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/XF/Service/User/Registration.php(279): XF\Mvc\Entity\Entity->save()
#8 src/XF/Service/ValidateAndSavableTrait.php(40): XF\Service\User\Registration->_save()
#9 src/XF/Pub/Controller/Register.php(419): XF\Service\User\Registration->save()
#10 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#12 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#13 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#15 src/XF.php(391): XF\App->run()
#16 index.php(20): XF::runApp('XF\\Pub\\App')
#17 {main}

array(4) {
["url"] => string(18) "/register/register"
["referrer"] => string(15) "Modded Forums"
["_GET"] => array(0) {
}
["_POST"] => array(13) {
["9ff7a4129d69c2b9adea94962dfc7930a1be3814"] => string(7) "testusr"
["username"] => string(0) ""
["93760df8e5cb3092b3b4838c679fbed1901eeebc"] => string(0) ""
["fe85fecd3c97ebf8eafd700f0ba8368b788808c6"] => string(14) "testusr@m"
["3fcea2b367b991048863bd961f2c6803a0a98ddc"] => string(8) "********"
["g-recaptcha-response"] => string(505) "03AOLTBLSbbVZJAL_5sjCBQBgL4oFC-s_2mq5jJKa8S1W3WlqmNcrvOxeZqlWvGO6OWgy3HRj1oKqy1C--SFpT9b_Fr3D_6GmWANws0tmaFYnHilIOaedrIvudh5xu3-PjrDLYPwgcDlD05qyuRG2bQ4x1_o6pNGqbkF753rvSoXLaBJYxBVBhbTyq_6uLt6lMt_Vbav6Sf5zP-80-qTUopjvbRQZy2vR77UbHuNNIYJXUCajfzJbCgYsUGF92pV_Gq6dP9AoD19b8gOO3qpzGCkH-MJbVYnpSvkFrVr0OPp75PZCDO859mksDu6b-hAdJk_hy3aOMPr0_iDZ06mvbp6BHhAEYuwjsJ5-oOzYYXLJGp7JchJkcePnS7_Rx5RdhZcbxdst2y9yCU2XTtruS48XQ4oIrXfpOK23RNOMkjgEgsxxZxHfxqgjnx8C8eAHW8XOayU9OO7CVtnhTLz7BO9LfSbiDSdxd77JGSaIMLRKBItf2klXj5ds"
["accept"] => string(1) "1"
["reg_key"] => string(16) "MG2xoSrUK-lXTiBq"
["9da76eb86465389a21f1c4848afdf7e9c4442dfe"] => string(14) "Africa/Nairobi"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(1) "/"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}

MySQL statement prepare error [1054]: Unknown column 'secret_key' in 'field list'

INSERT INTO `xf_user` (`visible`, `activity_visible`, `user_group_id`, `timezone`, `language_id`, `username`, `email`, `user_state`, `privacy_policy_accepted`, `terms_accepted`, `display_style_group_id`, `secondary_group_ids`, `secret_key`, `user_id`, `style_id`, `permission_combination_id`, `message_count`, `alerts_unread`, `conversations_unread`, `register_date`, `last_activity`, `trophy_points`, `avatar_date`, `avatar_width`, `avatar_height`, `avatar_highdpi`, `gravatar`, `is_moderator`, `is_admin`, `is_staff`, `is_banned`, `reaction_score`, `custom_title`, `warning_points`, `siropu_chat_room_id`, `siropu_chat_conv_id`, `siropu_chat_rooms`, `siropu_chat_conversations`, `siropu_chat_settings`, `siropu_chat_room_join_time`, `siropu_chat_status`, `siropu_chat_is_sanctioned`, `siropu_chat_message_count`, `siropu_chat_last_activity`, `af_as_award_total`, `af_as_award_points`, `xfrm_resource_count`, `th_unco_user_name_data`, `snog_forms`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_user', Array, false)
#6 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/XF/Service/User/Registration.php(279): XF\Mvc\Entity\Entity->save()
#8 src/XF/Service/ValidateAndSavableTrait.php(40): XF\Service\User\Registration->_save()
#9 src/XF/Pub/Controller/Register.php(419): XF\Service\User\Registration->save()
#10 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#12 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#13 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#15 src/XF.php(391): XF\App->run()
#16 index.php(20): XF::runApp('XF\\Pub\\App')
#17 {main}

array(4) {
["url"] => string(18) "/register/register"
["referrer"] => string(15) "https://*******"
["_GET"] => array(0) {
}
["_POST"] => array(12) {
["da0954336feb4c4bd86cc5422cc003ae916e5584"] => string(7) "testusr"
["username"] => string(0) ""
["f73fb98e826735d40c69e541c9a59bba6a4fc027"] => string(14) "testusr@m"
["bdcea34b0a8bb2b9207a4d7a3a3c8367c1d91b04"] => string(8) "********"
["g-recaptcha-response"] => string(505) "03AOLTBLTdqFcRTlTU40kEesPkKcGAdtuD7XuwTCQh5K32TynMYNGxDsF6aOacIBYAm9o2w_A6-lYan6dVRIvX8YlDcOCgp_vFmnXr7UCs8OXUf_YkSCP-nqajubO6HCgXZUiIMa3Fw52GAp4jFagKgIFIjNctsks4rs2AcBf6Ir1V-bu6Q9pVoAJDhrFbahi3F_o_kYdX4Y6vYnu9e2PFLYLHgMxD6CqbAYw3V2VTXjVi9az2maWdlSFAZQvkBbeyoiN2Ykq1JvAv6dmNQ-4s-x8LQHCDdEWjgvlaS15sCYO1HrO-n140cy2fRlmJ5L9rqvnZZkTzf7wWHabWA8AXVxB8Rn7Sh7_As0q_nRa8-5m3EM7wXF-YWvpAGZ1knSfPIeAUuOGiKDPc4NKB4f911kod6oi4AtEdysq2NbXGkiG23fgc1a_40JnNYLXuU4_BESQpA6FxCMeGy3Bp-c3CqwSi6U0_UJDPMOWRjXncFeICL08kKuaoesQ"
["accept"] => string(1) "1"
["reg_key"] => string(16) "xByclL7ly_1KE1Fy"
["1d237c8271c0a1d56dadbd5fc5a981253f2597f6"] => string(14) "Africa/Nairobi"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(1) "/"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}

Captain · 14 Янв 2020

ALTER TABLE xf_user DROP COLUMN th_unco_user_name_data;
Где копирайт локализации?

Zevulum · 14 Янв 2020

Captain написал(а):
ALTER TABLE xf_user DROP COLUMN th_unco_user_name_data;
Где копирайт локализации?

плагин [SVG]Custom Copyright походу снес. сейчас посмотрю

Ну да. "В Копирайт перевода" было пусто и был выключен. Серьезно, я не убирал. Поставил вручную.

Не могу дропнуть. Ее нет

Captain · 14 Янв 2020

Список дополнений

Zevulum · 14 Янв 2020

[8WR] Discord Integration 2.1.0.9
[AL] Core Package 1.0.4
[Nulumia] Breadcrumb Essentials 1.0.0 Beta
[Nulumia] Logo Essentials 1.0.0.1
[TH] UI.X Pro 1.0.3
Efficiently monitor your UI.X performance.
[TH] User Name Change 1.0.0
[Xen-Soluce] Invite System 2.1.5 Fix 1
[XTR] Block Proxies 1.0.0
Unlimited scroll 1.0.0

[AddonFlare] XF2 Awards System 1.1.0.1
[cXF] Thread scroll enhancement 1.0.4
[JUM] Resource Download Limit 2.0.0
[MMO] Tagged Users 2.1.1
[MMO] Visitor 2.1.2
[NZMD] Hide System 2.1.1
[SVG]Custom Copyright 2.1.4.4
[TB] Okuma Süresi 1.0.0
[TG] Staff Bar Settings 1.3.0
[TH] Covers 1.0.4 Patch Level 2
[TH] UI.X 2.1.2 Patch Level 3
[TH] User Name Color 1.0.0
[tl] Profile Vanity URL 1.0.6
[Xenbros] Download Page 104
Advanced Forms 2.0.27
Chat 2.1.4
Lazy Image Loader 2.2.1
Member Self Delete 1.2.0 Beta 7
No Contact Us For Guests 1.0.0
Photo contest 1.3
Resource Manager Moderator Actions 1.0.0
s9e/MediaSites 2.3.22
Sysnative: Improved Member Stats Widgets 1.0.2
Ultimate Custom Nodes 2.0.0
XenForo Resource Manager 2.1.5

Captain · 14 Янв 2020

[TH] User Name Color - удалять

Zevulum · 14 Янв 2020

[TH] User Name Color удалил. Все так же

Captain · 14 Янв 2020

логи где?

Zevulum · 14 Янв 2020

XF\Db\Exception: MySQL query error [1366]: Incorrect integer value: 'PqcvqYufpMJ6LommD9_d-8fRUeF2yUU5' for column 'secret_key' at row 1 src/XF/Db/AbstractStatement.php:228

INSERT INTO `xf_user` (`visible`, `activity_visible`, `user_group_id`, `timezone`, `language_id`, `username`, `email`, `user_state`, `privacy_policy_accepted`, `terms_accepted`, `display_style_group_id`, `secondary_group_ids`, `secret_key`, `user_id`, `style_id`, `permission_combination_id`, `message_count`, `alerts_unread`, `conversations_unread`, `register_date`, `last_activity`, `trophy_points`, `avatar_date`, `avatar_width`, `avatar_height`, `avatar_highdpi`, `gravatar`, `is_moderator`, `is_admin`, `is_staff`, `is_banned`, `reaction_score`, `custom_title`, `warning_points`, `xfrm_resource_count`, `af_as_award_total`, `af_as_award_points`, `siropu_chat_room_id`, `siropu_chat_conv_id`, `siropu_chat_rooms`, `siropu_chat_conversations`, `siropu_chat_settings`, `siropu_chat_room_join_time`, `siropu_chat_status`, `siropu_chat_is_sanctioned`, `siropu_chat_message_count`, `siropu_chat_last_activity`, `snog_forms`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1366, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1366, 'HY000')
#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(1452): XF\Db\AbstractAdapter->insert('xf_user', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Service/User/Registration.php(279): XF\Mvc\Entity\Entity->save()
#7 src/XF/Service/ValidateAndSavableTrait.php(40): XF\Service\User\Registration->_save()
#8 src/XF/Pub/Controller/Register.php(419): XF\Service\User\Registration->save()
#9 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#11 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#12 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2184): XF\Mvc\Dispatcher->run()
#14 src/XF.php(391): XF\App->run()
#15 index.php(20): XF::runApp('XF\\Pub\\App')
#16 {main}

array(4) {
["url"] => string(18) "/register/register"
["referrer"] => string(15) "https://"
["_GET"] => array(0) {
}
["_POST"] => array(13) {
["9ff7a4129d69c2b9adea94962dfc7930a1be3814"] => string(7) "testusr"
["username"] => string(0) ""
["93760df8e5cb3092b3b4838c679fbed1901eeebc"] => string(0) ""
["fe85fecd3c97ebf8eafd700f0ba8368b788808c6"] => string(14) "testusr@m"
["3fcea2b367b991048863bd961f2c6803a0a98ddc"] => string(8) "********"
["g-recaptcha-response"] => string(505) "03AOLTBLTQIQt8o3kiiknjBnvSanU9_kTgdAie2cYHqJ_MRSZLdzPDcBR4zGcWZVvWbeyf8eUrddwgmhuUN7g5G3qT4RR5ByubzQqaFUyfpeOc43F2VTt2PMW_HDYB2WAERLE5gj4uZuC7EToFa2IEwFzOYJ2db2v9WNXKn9cFJDrjZIbT7G4BkQOLbKTmGbIUA7yPbAUB-gxOOxpAzPUc9g3kHOKLPFYXpq4iWRpf0BuIF9hZw9cTHIcqHFzA094I9g76phqr_sMTxJZNfnRYEfEh5np4i-u9sKUWjaNkoz9jJYC-y7kKYQxU9lwJgm2p-ZDzqWs4F2RA16prqqKM7zyNFF9GqLrFcUrvifg1SkiRyXM6tYPIbuWZGSz9SdU1TuoIVlr6TUetf-ZakHxkFByfUKZcQDQxmlx5583XQN8XUGUd6-lTdhkghCvnhHN4GDUkmLuRVWjOr1HsLwFPOFJ0AUUJDbdk__Z4BrplqvXGeXlWSYnOWRw"
["accept"] => string(1) "1"
["reg_key"] => string(16) "MG2xoSrUK-lXTiBq"
["9da76eb86465389a21f1c4848afdf7e9c4442dfe"] => string(14) "Africa/Nairobi"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(1) "/"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}

Captain · 14 Янв 2020

Zevulum написал(а):
Incorrect integer value

Captain написал(а):
слушая советы с удалением системных колонок форума.

Zevulum написал(а):
Столбец secret_key в xf_user я восстановил.

Хреново восстановил.
Сначала дропаем, что надобавлял
ALTER TABLE xf_user DROP COLUMN secret_key;
Теперь добавляем как должно быть
ALTER TABLE `xf_user` ADD `secret_key` VARBINARY(32) NOT NULL AFTER `is_staff`;

Zevulum · 14 Янв 2020

Captain написал(а):
Хреново восстановил.
Сначала дропаем, что надобавлял
ALTER TABLE xf_user DROP COLUMN secret_key;
Теперь добавляем как должно быть
ALTER TABLE `xf_user` ADD `secret_key` VARBINARY(32) NOT NULL AFTER `is_staff`;

Я так и подумал что я хреново восстановил из-за Incorrect integer value. Добавлял столбец не так. Сейчас регистрация проходит успешно. Огромное спасибо!

XF 2.1 Невозможна регистрация из-за 'secret_key'

Zevulum

Zevulum

Вложения

Captain

Какие бекапы? О_о

Zevulum

Captain

Какие бекапы? О_о

Zevulum

Captain

Какие бекапы? О_о

Zevulum

Captain

Какие бекапы? О_о

Zevulum

Captain

Какие бекапы? О_о

Zevulum

Вложения

Похожие темы

Мы ценим вашу конфиденциальность