alex54
Местный
- Сообщения
- 389
- Реакции
- 144
- Баллы
- 183
собсно история началась с того, что на новом проекте настраивал почту, а поскольку майл.ру сейчас требует новых паролей для приложений, малость помучался и решил проверит регу на старом форуме
опа ( а тут предстоит секс (
при регистрации выдает ошибку, щас с другого компа пишу, поэтому ошибку показать не могу, ну да ладно, я сделал бэкап базы, отключил все плагины, запустил апгрейд форума, начинаю регистрацию юзера и получаю
в журнале пишет
и все, приехали (((( но ведь работало же (
вот восстановил из бэкапа и вот такая ошибка при реге
после некоторых манипуляций, перестроением данных плагинов, ошибка на форуме одна и та же
после отключения упомянутых плагинов, один черт ошибка (
разговаривал с хостером, он говорит
опа ( а тут предстоит секс (
при регистрации выдает ошибку, щас с другого компа пишу, поэтому ошибку показать не могу, ну да ладно, я сделал бэкап базы, отключил все плагины, запустил апгрейд форума, начинаю регистрацию юзера и получаю
в журнале пишет
Код:
XF\Db\Exception: MySQL query error [1364]: Field 'siropu_easy_user_ban_forum' doesn't have a default value src/XF/Db/AbstractStatement.php:230
Сгенерирована пользователем: Неизвестная учётная запись 5 Мар 2023 в 16:54
Трассировка стека
INSERT INTO `xf_user` (`visible`, `activity_visible`, `user_group_id`, `timezone`, `language_id`, `last_summary_email_date`, `username`, `email`, `user_state`, `privacy_policy_accepted`, `terms_accepted`, `display_style_group_id`, `secondary_group_ids`, `secret_key`, `user_id`, `username_date`, `username_date_visible`, `style_id`, `permission_combination_id`, `message_count`, `question_solution_count`, `alerts_unviewed`, `alerts_unread`, `conversations_unread`, `register_date`, `last_activity`, `trophy_points`, `avatar_date`, `avatar_width`, `avatar_height`, `avatar_highdpi`, `gravatar`, `security_lock`, `is_moderator`, `is_admin`, `is_staff`, `is_banned`, `reaction_score`, `vote_score`, `custom_title`, `warning_points`) 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', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1253): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Service/User/Registration.php(301): XF\Mvc\Entity\Entity->save()
#7 src/XF/Service/ValidateAndSavableTrait.php(42): XF\Service\User\Registration->_save()
#8 src/XF/Pub/Controller/Register.php(427): XF\Service\User\Registration->save()
#9 src/XF/Mvc/Dispatcher.php(352): XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#11 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#12 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2482): XF\Mvc\Dispatcher->run()
#14 src/XF.php(525): XF\App->run()
#15 index.php(20): XF::runApp('XF\\Pub\\App')
#16 {main}
Содержимое запроса
array(4) {
["url"] => string(18) "/register/register"
["referrer"] => string(24) "https://travel-sibir.ru/"
["_GET"] => array(0) {
}
["_POST"] => array(12) {
["_xfToken"] => string(8) "********"
["username"] => string(0) ""
["d0b2a0068ed11e10e696392751801fb8ed49b936"] => string(3) "sos"
["66eaa4ea08ed1e8a63e839005209853c2a201658"] => string(0) ""
["8f64b89f01a83b40e107825962183c2aca4baf27"] => string(18) "e.alex54@yandex.ru"
["ae03e32dc3ee45ea8c38aabf5dc484688699ccc9"] => string(8) "********"
["accept"] => string(1) "1"
["reg_key"] => string(16) "TYQ-wOTBi9ak2xYj"
["d4d4f0ce97842ca6e9dc60906cab571fa0703caa"] => string(12) "Asia/Bangkok"
["_xfRequestUri"] => string(1) "/"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}и все, приехали (((( но ведь работало же (
вот восстановил из бэкапа и вот такая ошибка при реге
Код:
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'ap_post_style' in 'field list' in src/XF/Db/AbstractStatement.php at line 230
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 41
XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 56
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 220
XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1521
XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
XF\Mvc\Entity\Entity->save() in src/XF/Service/User/Registration.php at line 301
XF\Service\User\Registration->_save() in src/addons/NF/Tickets/XF/Service/User/Registration.php at line 11
NF\Tickets\XF\Service\User\Registration->_save() in src/addons/SV/ModeratorEssentials/XF/Service/User/Registration.php at line 24
SV\ModeratorEssentials\XF\Service\User\Registration->_save() in src/XF/Service/ValidateAndSavableTrait.php at line 42
XF\Service\User\Registration->save() in src/XF/Pub/Controller/Register.php at line 427
XF\Pub\Controller\Register->actionRegister() in src/addons/MMO/ExternalAccounts/XF/Pub/Controller/Register.php at line 14
MMO\ExternalAccounts\XF\Pub\Controller\Register->actionRegister() in src/addons/SV/SignupAbuseBlocking/XF/Pub/Controller/Register.php at line 70
SV\SignupAbuseBlocking\XF\Pub\Controller\Register->actionRegister() in src/addons/AddonFlare/PaidRegistrations/XF/Pub/Controller/Register.php at line 131
AddonFlare\PaidRegistrations\XF\Pub\Controller\Register->actionRegister() in src/XF/Mvc/Dispatcher.php at line 352
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2482
XF\App->run() in src/XF.php at line 525
XF::runApp() in index.php at line 20
Код:
Журнал ошибок сервера
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'ap_post_style' in 'field list' src/XF/Db/AbstractStatement.php:230
Сгенерирована пользователем: Неизвестная учётная запись 5 Мар 2023 в 18:31
Трассировка стека
INSERT INTO `xf_user` (`visible`, `activity_visible`, `user_group_id`, `timezone`, `language_id`, `last_summary_email_date`, `username`, `email`, `user_state`, `privacy_policy_accepted`, `terms_accepted`, `dbtech_shop_purchase`, `display_style_group_id`, `secondary_group_ids`, `secret_key`, `user_id`, `username_date`, `username_date_visible`, `style_id`, `permission_combination_id`, `message_count`, `question_solution_count`, `alerts_unviewed`, `alerts_unread`, `conversations_unread`, `register_date`, `last_activity`, `trophy_points`, `avatar_date`, `avatar_width`, `avatar_height`, `avatar_highdpi`, `gravatar`, `security_lock`, `is_moderator`, `is_admin`, `is_staff`, `is_banned`, `reaction_score`, `vote_score`, `custom_title`, `warning_points`, `ld_link_count`, `dbtech_credits_credits`, `dbtech_credits_lastdaily`, `dbtech_credits_lastinterest`, `dbtech_credits_lastpaycheck`, `dbtech_credits_lasttaxation`, `dbtech_ecommerce_store_credit`, `dbtech_ecommerce_tos_accept`, `dbtech_ecommerce_product_count`, `dbtech_ecommerce_license_count`, `dbtech_ecommerce_amount_spent`, `dbtech_ecommerce_cart_items`, `dbtech_ecommerce_is_distributor`, `dbtech_ecommerce_api_key`, `dbtech_shop_points`, `dbtech_shop_purchases`, `dbtech_shop_immunity`, `dbtech_shop_pendingtrades`, `dbtech_shop_item_count`, `mjst_ticket_count`, `mjst_department_ids`, `nf_tickets_count`, `nf_tickets_unread`, `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`, `siropu_easy_user_ban_count`, `siropu_easy_user_ban_forum`, `siropu_easy_user_ban_thread`, `thdonate_total_donation`, `thdonate_total_public_donation`, `thdonate_total_anonymous_donation`, `thdonate_num_donation`, `thdonate_num_public_donation`, `thdonate_num_anonymous_donation`, `thfeature_feature_count`, `wmt_true_last_activity`, `wmt_time_spent`, `xa_ams_article_count`, `xa_ams_series_count`, `xa_ams_comment_count`, `xa_sc_item_count`, `xa_sc_comment_count`, `xa_ubs_blog_count`, `xa_ubs_blog_entry_count`, `xa_ubs_series_count`, `xc_pv_profile_view_count`, `xentr_verified`, `xfmg_album_count`, `xfmg_media_count`, `xfmg_media_quota`, `xfrm_resource_count`, `xp_fm_see_fm`, `z61_classifieds_listing_count`, `tlg_total_own_groups`, `tlg_badge_group_id`, `andrew_user_note_count`, `siropu_rs_referrer_id`, `siropu_rs_referral_count`, `siropu_rs_referral_rewards`, `siropu_rs_referrer_credit`, `mvb_verified`, `ap_username_style`, `ap_title_style`, `ap_post_style`, `ap_tooltip_style`, `ap_frame`, `andy_weekly_newsletter`, `bratr_receive_ratings`, `bratr_receive_rating_count`, `bratr_be_donated_ratings`, `bratr_ratings`, `liamw_threadsolutions_solution_count`, `ozzmodz_badges_badge_count`, `ozzmodz_badges_tier_counts`, `ozzmodz_badges_cache`, `ozzmodz_badges_received_badge_ids`, `ozzmodz_badges_last_award_date`, `ozzmodz_gui_is_ignored`, `snog_forms`, `xfa_ft_disable`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(41): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(220): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1521): XF\Db\AbstractAdapter->insert('xf_user', Array, false)
#6 src/XF/Mvc/Entity/Entity.php(1253): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/XF/Service/User/Registration.php(301): XF\Mvc\Entity\Entity->save()
#8 src/addons/NF/Tickets/XF/Service/User/Registration.php(11): XF\Service\User\Registration->_save()
#9 src/addons/SV/ModeratorEssentials/XF/Service/User/Registration.php(24): NF\Tickets\XF\Service\User\Registration->_save()
#10 src/XF/Service/ValidateAndSavableTrait.php(42): SV\ModeratorEssentials\XF\Service\User\Registration->_save()
#11 src/XF/Pub/Controller/Register.php(427): XF\Service\User\Registration->save()
#12 src/addons/MMO/ExternalAccounts/XF/Pub/Controller/Register.php(14): XF\Pub\Controller\Register->actionRegister()
#13 src/addons/SV/SignupAbuseBlocking/XF/Pub/Controller/Register.php(70): MMO\ExternalAccounts\XF\Pub\Controller\Register->actionRegister()
#14 src/addons/AddonFlare/PaidRegistrations/XF/Pub/Controller/Register.php(131): SV\SignupAbuseBlocking\XF\Pub\Controller\Register->actionRegister()
#15 src/XF/Mvc/Dispatcher.php(352): AddonFlare\PaidRegistrations\XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#16 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(AddonFlare\PaidRegistrations\XF\Pub\Controller\Register), Object(XF\Mvc\Reply\Reroute))
#17 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(AddonFlare\PaidRegistrations\XF\Pub\Controller\Register), Object(XF\Mvc\Reply\Reroute))
#18 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#19 src/XF/App.php(2482): XF\Mvc\Dispatcher->run()
#20 src/XF.php(525): XF\App->run()
#21 index.php(20): XF::runApp('XF\\Pub\\App')
#22 {main}
Содержимое запроса
array(4) {
["url"] => string(24) "/login/register-register"
["referrer"] => string(52) "https://travel-sibir.ru/login/register?accountType=1"
["_GET"] => array(0) {
}
["_POST"] => array(12) {
["_xfToken"] => string(8) "********"
["username"] => string(0) ""
["043db9b0532c0df537a528c3551036e65490c8d1"] => string(3) "sos"
["a8e6e06f556f4f086c9807ffb417777f3b782edc"] => string(18) "e.alex54@yandex.ru"
["password"] => string(8) "********"
["448a93bcd2f981d3da1a48c28c3d1e6cedfe5879"] => string(8) "********"
["accept"] => string(1) "1"
["reg_key"] => string(16) "glzJv1s0Fs17j9RY"
["ba454952b9d28e69f09613da37fd54ee161b5d99"] => string(12) "Asia/Bangkok"
["_xfRequestUri"] => string(29) "/login/register?accountType=1"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}после отключения упомянутых плагинов, один черт ошибка (
Код:
Журнал ошибок сервера
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'ap_post_style' in 'field list' src/XF/Db/AbstractStatement.php:230
Сгенерирована пользователем: Неизвестная учётная запись 5 Мар 2023 в 18:50
Трассировка стека
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(41): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(220): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1521): XF\Db\AbstractAdapter->insert('xf_user', Array, false)
#6 src/XF/Mvc/Entity/Entity.php(1253): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/XF/Service/User/Registration.php(301): XF\Mvc\Entity\Entity->save()
#8 src/XF/Service/ValidateAndSavableTrait.php(42): XF\Service\User\Registration->_save()
#9 src/XF/Pub/Controller/Register.php(427): XF\Service\User\Registration->save()
#10 src/XF/Mvc/Dispatcher.php(352): XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(OzzModz\QuestionCaptchaLogger\XF\Pub\Controller\Register), NULL)
#12 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(OzzModz\QuestionCaptchaLogger\XF\Pub\Controller\Register), NULL)
#13 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(2482): XF\Mvc\Dispatcher->run()
#15 src/XF.php(525): XF\App->run()
#16 index.php(20): XF::runApp('XF\\Pub\\App')
#17 {main}можно каким то запросом добавить столбец ? и куда он мог подеваться (
Последнее редактирование:
