K
K
Kyrsorf2019-04-23 12:35:31
MySQL
Kyrsorf, 2019-04-23 12:35:31

DB error after Bitrix update, how to fix?

MySQL Query Error: SEL ECT BEP.* FR OM INNER JOIN b_iblock_element_prop_s2 BEP ON BEP.IBLOCK_ELEMENT_ID = BE.ID WHERE 1=1 ORDER BY BEP.IBLOCK_ELEMENT_ID [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN b_iblock_element_prop_s2 BEP ON BEP.IBLOCK_ELEMENT_ID = BE.ID ' at line 5]
DB query error.
Please try later.
Send error report to support

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
Satisfied IT, 2019-04-23
@Kyrsorf

Send error report to support

At least start with this (you paid a lot of money for something, let them work it out) and roll back to the working version.
In the future, first update on the test server (which repeats the working config), and only then on the working one.

A
Andrey, 2019-04-23
@VladimirAndreev

spaces in SELECT and FROM somehow inspire me with fear :-)
well, after FROM somehow the table name is not visible, from where to FROM

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question