Page 1 of 1

MySQL erros

Posted: Thu Jun 13, 2013 4:55 pm
by S_Flash
V 1.50 Build 201306100628

2013-06-13 16:00:04 : 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 = '0' THEN shows + 0 END WHERE id IN ()
2013-06-13 16:00:43 : 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 = '0' THEN shows + 0 END WHERE id IN ()
2013-06-13 16:01:25 : 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 = '0' THEN shows + 0 END WHERE id IN ()
2013-06-13 16:02:13 : 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 = '0' THEN shows + 0 END WHERE id IN ()
2013-06-13 16:11:04 : 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 = '0' THEN shows + 0 END WHERE id IN ()

Re: MySQL erros

Posted: Fri Jun 14, 2013 9:53 am
by admin
Добавил проверку на пустые значения.

Re: MySQL erros

Posted: Fri Jun 14, 2013 2:48 pm
by S_Flash
admin wrote:Добавил проверку на пустые значения.
Где с моей стороны идут пустые значения?

Re: MySQL erros

Posted: Fri Jun 14, 2013 3:03 pm
by admin
Где-то у меня.