Database Error: 1064 - You have an error in your SQL syntax

[m.melnikov37]

Database Error: 1064 - 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 'from app_entity_98 msq where - limit 1),0)
as field_1945 from app_entity_99 e wh' at line 1
Query: select e.* , ((e.field_1340*(select (msq.field_1330+0) from app_entity_98 msq where e.field_1338=id limit 1))*(select (msq.field_1331+0)
from app_entity_98 msq where e.field_1338=id limit 1)) as field_1342, ((e.field_1347*(select (msq.field_1330+0)
from app_entity_98 msq where e.field_1338=id limit 1))*(select (msq.field_1331+0) from app_entity_98 msq where e.field_1338=id limit 1))
as field_1348, (e.field_1347/(select (msq.field_1353+0) from app_entity_98 msq where e.field_1338=id limit 1)) as field_1355,
(e.field_1340+e.field_1347) as field_1370, (((e.field_1347/e.field_1340)-1)*100) as field_1374, (e.field_1347-e.field_1401) as
field_1445, ((e.field_1401*(select (msq.field_1330+0) from app_entity_98 msq where e.field_1338=id limit 1))*(select (msq.field_1331+0)
from app_entity_98 msq where e.field_1338=id limit 1)) as field_1626, (FROM_UNIXTIME(e.date_added,'%Y-%m')) as field_1818,IFNULL((select
(msq.field_1330+0) from app_entity_98 msq where e.field_1338=id limit 1),0) as field_1341,IFNULL((select (msq.field_1331+0)
from app_entity_98 msq where e.field_1338=id limit 1),0) as field_1343,IFNULL((select (msq.field_1353+0) from app_entity_98
msq where e.field_1338=id limit 1),0) as field_1354,IFNULL((select - from app_entity_98 msq where - limit 1),0) as field_1945
from app_entity_99 e where e.id='597212'
Page: /index.php?module=items/&action=save&token=

[m.melnikov37]

Подскажите что это. Возникает при добавлении записи.

[support]

Ошибка где то в поле mysql запрос или в формуле, может где скобку пропустили.
или возможно проблема тут:

Код: Выделить всё

e.field_1338=id

Возможно надо сделать так

Код: Выделить всё

msq.id = e.field_1338

или так:

Код: Выделить всё

msq.field_1338=e.id