SmartCJ Support Forum

2013-06-04 10:58:38 : Mysql 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 ')' at line 1) in query UPDATE rot_pages set shows = CASE WHEN id = '4' THEN shows + 5 WHEN id = '0' THEN shows + 0 END WHERE id IN (4,)
2013-06-04 11:04:40 : Mysql 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 ')' at line 1) in query UPDATE rot_pages set shows = CASE WHEN id = '4' THEN shows + 8 WHEN id = '0' THEN shows + 0 END WHERE id IN (4,)
2013-06-04 11:10:27 : Mysql 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 ')' at line 1) in query UPDATE rot_pages set shows = CASE WHEN id = '4' THEN shows + 9 WHEN id = '0' THEN shows + 0 END WHERE id IN (4,)
2013-06-04 11:11:19 : Mysql 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 ')' at line 1) in query UPDATE rot_pages set shows = CASE WHEN id = '5' THEN shows + 2 WHEN id = '0' THEN shows + 0 END WHERE id IN (5,)

как поправить

это логи смартсж, началось скорее всего после сегодняшнего обновления
mysql_error.log

ошибки остались
error.log
00.20 UPDATE rot_pages set shows = CASE WHEN id = '4' THEN shows + 4 WHEN id = '0' THEN shows + 0 END WHERE id IN (4,):: :
00.24 UPDATE rot_pages set shows = CASE WHEN id = '0' THEN shows + 0 WHEN id = '4' THEN shows + 3 END WHERE id IN (,4):: :
01.30 UPDATE rot_pages set shows = CASE WHEN id = '5' THEN shows + 9 WHEN id = '0' THEN shows + 0 END WHERE id IN (5,):: :
01.49 UPDATE rot_pages set shows = CASE WHEN id = '4' THEN shows + 2 WHEN id = '0' THEN shows + 0 END WHERE id IN (4,):: :
01.57 UPDATE rot_pages set shows = CASE WHEN id = '4' THEN shows + 5 WHEN id = '0' THEN shows + 0 END WHERE id IN (4,):: :
01.58 UPDATE rot_pages set shows = CASE WHEN id = '0' THEN shows + 0 WHEN id = '4' THEN shows + 3 END WHERE id IN (,4):: :
02.01 UPDATE rot_pages set shows = CASE WHEN id = '0' THEN shows + 0 WHEN id = '4' THEN shows + 3 END WHERE id IN (,4):: :
04.21 UPDATE rot_pages set shows = CASE WHEN id = '4' THEN shows + 4 WHEN id = '5' THEN shows + 2 WHEN id = '0' THEN shows + 0 END WHERE id IN (4,5,):: :
05.04 UPDATE rot_pages set shows = CASE WHEN id = '5' THEN shows + 1 WHEN id = '4' THEN shows + 6 WHEN id = '0' THEN shows + 0 END WHERE id IN (5,4,):: :
06.32 UPDATE rot_pages set shows = CASE WHEN id = '4' THEN shows + 8 WHEN id = '5' THEN shows + 1 WHEN id = '0' THEN shows + 0 END WHERE id IN (4,5,):: :
06.34 UPDATE rot_pages set shows = CASE WHEN id = '4' THEN shows + 2 WHEN id = '0' THEN shows + 0 WHEN id = '5' THEN shows + 2 END WHERE id IN (5,):: :

Это на последнем билде такое ?

admin wrote:Это на последнем билде такое ?

да

Сорри, неверно поставил вопрос, на каком билде, потому как я понял понятия о последнем могут несколько отличаться.

admin wrote:Сорри, неверно поставил вопрос, на каком билде, потому как я понял понятия о последнем могут несколько отличаться.

Build 201306030701

Однозначно это не последний, с начала июня уже много раз заливался новый билд.

после апдейта ошибок нет

Ok