A
A
Anumik2016-10-06 09:03:06
1C-Bitrix
Anumik, 2016-10-06 09:03:06

What causes such a Bitrix error?

Good day
The problem arose with placing an order, after filling in all the fields and pressing the checkout button, it gave an error "An error occurred while executing the script. You can enable extended error output in the settings file .settings.php" Turned on
advanced mode and saw

[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: Table 'u0037701_klassika.b_sale_bizval_code_1C' doesn't exist (400) 
SEL ECT 
`sale_internals_business_value_code1_c`.`PERSON_TYPE_ID` AS `PERSON_TYPE_ID`, 
`sale_internals_business_value_code1_c`.`CODE_INDEX` AS `CODE_INDEX`, 
`sale_internals_business_value_code1_c`.`NAME` AS `NAME` 
FR OM `b_sale_bizval_code_1C` `sale_internals_business_value_code1_c` 

ORDER BY `sale_internals_business_value_code1_c`.`CODE_INDEX` ASC 
/var/www/u0037701/data/www/klassika.megamir38.ru/bitrix/modules/main/lib/db/mysqlconnection.php:116 
#0: Bitrix\Main\DB\MysqlConnection->queryInternal(string, array, NULL) 
/var/www/u0037701/data/www/klassika.megamir38.ru/bitrix/modules/main/lib/db/connection.php:329 
#1: Bitrix\Main\DB\Connection->query(string) 
/var/www/u0037701/data/www/klassika.megamir38.ru/bitrix/modules/main/lib/entity/query.php:1821 
#2: Bitrix\Main\Entity\Query->query(string) 
/var/www/u0037701/data/www/klassika.megamir38.ru/bitrix/modules/main/lib/entity/query.php:454 
#3: Bitrix\Main\Entity\Query->exec() 
/var/www/u0037701/data/www/klassika.megamir38.ru/bitrix/modules/main/lib/entity/datamanager.php:242 
#4: Bitrix\Main\Entity\DataManager::getList(array) 
/var/www/u0037701/data/www/klassika.megamir38.ru/bitrix/modules/sale/lib/businessvalue.php:1150 
#5: Bitrix\Sale\BusinessValueConsumer1C::getConsumers() 

#6: call_user_func_array(array, array) 
/var/www/u0037701/data/www/klassika.megamir38.ru/bitrix/modules/main/classes/general/module.php:475 
#7: ExecuteModuleEventEx(array) 
/var/www/u0037701/data/www/klassika.megamir38.ru/bitrix/modules/sale/lib/businessvalue.php:334 
#8: Bitrix\Sale\BusinessValue::getConsumers() 
/var/www/u0037701/data/www/klassika.megamir38.ru/bitrix/modules/sale/general/pay_system_action.php:830 
#9: CAllSalePaySystemAction::getParamsByConsumer(string, string) 
/var/www/u0037701/data/www/klassika.megamir38.ru/bitrix/modules/sale/general/pay_system_action.php:362 
#10: CAllSalePaySystemAction->InitParamArrays(array, integer, string, array, array) 
/var/www/u0037701/data/www/klassika.megamir38.ru/bitrix/components/bitrix/sale.order.ajax/class.php:4406 
#11: SaleOrderAjax->showOrderAction() 

#12: call_user_func(array) 
/var/www/u0037701/data/www/klassika.megamir38.ru/bitrix/components/bitrix/sale.order.ajax/class.php:4298 
#13: SaleOrderAjax->doAction(string) 
/var/www/u0037701/data/www/klassika.megamir38.ru/bitrix/components/bitrix/sale.order.ajax/class.php:4517 
#14: SaleOrderAjax->executeComponent() 
/var/www/u0037701/data/www/klassika.megamir38.ru/bitrix/modules/main/classes/general/component.php:585 
#15: CBitrixComponent->includeComponent(string, array, boolean) 
/var/www/u0037701/data/www/klassika.megamir38.ru/bitrix/modules/main/classes/general/main.php:1035 
#16: CAllMain->IncludeComponent(string, string, array, boolean) 
/var/www/u0037701/data/www/klassika.megamir38.ru/personal/payment/index.php:77

I was very surprised, because I use a standard component with a standard template and have not yet had time to start customizing, maybe someone can explain to a novice developer what the essence of the problem is?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Anumik, 2016-10-06
@Anumik

I caught and solved the problem by restoring the database from the standard system check

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question