M
M
miniven2017-09-21 12:05:30
PHP
miniven, 2017-09-21 12:05:30

Why does MySQL error occur in Bitrix?

I'm trying to add a payment system to the site. I click "Add and get an error":

[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: (1146) Table 'service1_skoro.b_sale_bizval_code_1c' doesn't exist (400)
SELECT 
  `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`
FROM `b_sale_bizval_code_1c` `sale_internals_business_value_code1_c` 

ORDER BY `sale_internals_business_value_code1_c`.`CODE_INDEX` ASC
/***/***/***.ru/docs/bitrix/modules/main/lib/db/mysqliconnection.php:137

On the local server, this error does not appear. I just made a backup, restored it on a test server and I get an error. What is the problem?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
miniven, 2017-09-21
@miniven

In general, I ran the check, one error was found in the database. Bitrix himself successfully fixed it. Thanks to all

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question