hacker
Местный
- Сообщения
- 1.221
- Реакции
- 808
- Баллы
- 1.153
Код:
Журнал ошибок сервера
XF\Db\Exception: MySQL query error [1364]: Field 'bs_fsptabs_ignored_threads' doesn't have a default value src/XF/Db/AbstractStatement.php:230
Сгенерировано пользователем: Неизвестная учётная запись 1 Ноя 2023 в 15:06
Код:
Трассировка стека
INSERT INTO `xf_user_profile` (`user_id`, `location`, `password_date`, `dob_day`, `dob_month`, `dob_year`, `custom_fields`, `signature`, `website`, `following`, `ignored`, `avatar_crop_x`, `avatar_crop_y`, `banner_date`, `banner_position_y`, `about`, `connected_accounts`, `xa_ams_about_author`, `xa_ams_author_name`, `mdv_background_date`, `ozzmodz_usi_ignored`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1364, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1364, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(220): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1521): XF\Db\AbstractAdapter->insert('xf_user_profile', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1253): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Mvc/Entity/Entity.php(1271): XF\Mvc\Entity\Entity->save(true, false)
#7 src/XF/Service/User/Registration.php(306): XF\Mvc\Entity\Entity->save()
#8 src/addons/Hampel/ApprovalQueuePlus/XF/Service/User/Registration.php(7): XF\Service\User\Registration->_save()
#9 src/addons/NF/Tickets/XF/Service/User/Registration.php(11): Hampel\ApprovalQueuePlus\XF\Service\User\Registration->_save()
#10 src/addons/SV/ModeratorEssentials/XF/Service/User/Registration.php(24): NF\Tickets\XF\Service\User\Registration->_save()
#11 src/XF/Service/ValidateAndSavableTrait.php(42): SV\ModeratorEssentials\XF\Service\User\Registration->_save()
#12 src/XF/Pub/Controller/Register.php(429): XF\Service\User\Registration->save()
#13 src/addons/MMO/ExternalAccounts/XF/Pub/Controller/Register.php(14): XF\Pub\Controller\Register->actionRegister()
#14 src/XF/Mvc/Dispatcher.php(352): MMO\ExternalAccounts\XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#15 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(MMO\ExternalAccounts\XF\Pub\Controller\Register), NULL)
#16 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(MMO\ExternalAccounts\XF\Pub\Controller\Register), NULL)
#17 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#18 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#19 src/XF.php(524): XF\App->run()
#20 index.php(20): XF::runApp('XF\\Pub\\App')
Код:
array(4) {
["url"] => string(18) "/register/register"
["referrer"] => string(26) "https://**********"
["_GET"] => array(0) {
}
["_POST"] => array(13) {
["_xfToken"] => string(8) "********"
["username"] => string(0) ""
["dc272ff4ef590ffaaaed2bd471ac9dc48542258d"] => string(13) "hacker.anonim"
["d59579ea84a55cb4e62ff6c84a55b9e3f53dec4b"] => string(0) ""
["7160f5cd25f67106dc1e1c01d74bb2667588fcf9"] => string(13) "lux777"
["8ae9d428bd056c986a92b833a717d7b7bc02d8f1"] => string(8) "********"
["custom_fields"] => array(3) {
["ls_surname"] => string(18) "Аверьянов"
["ls_name"] => string(12) "Максим"
["ls_patronymic"] => string(18) "Сергеевич"
}
["accept"] => string(1) "1"
["reg_key"] => string(16) "OXM07mRairTks8T5"
["7765ddec6e9fae3411d82c32b08b5c083bae33e1"] => string(13) "Asia/Tashkent"
["_xfRequestUri"] => string(1) "/"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
Решение --
Удалить столбец bs_
fsptabs_ignored_threads
из таблицы xf_user_profile
И регистрация будет работать. Сам сломал сам сделал. Вот и руки до катились до базы данных. И ни чего тут страшного нету. Одна только логика и подсказки из ошибок.