PDA

Просмотр полной версии : [Вопрос] Ошибки MySQL



stimorol
05.08.2015, 11:45
Здравствуйте.

В логах MySQL появляются вот такие ошибки:




[15:42:55] [ERROR] CMySQLQuery::Execute[] - (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
[15:42:55] [ERROR] CMySQLQuery::Execute[] - (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
[15:42:55] [ERROR] CMySQLQuery::Execute[] - (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
[15:42:55] [ERROR] CMySQLQuery::Execute[] - (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
[15:42:55] [ERROR] CMySQLQuery::Execute[] - (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
[15:42:55] [ERROR] CMySQLQuery::Execute[] - (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
[15:42:55] [ERROR] CMySQLQuery::Execute[] - (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
[15:42:55] [ERROR] CMySQLQuery::Execute[] - (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
[15:42:55] [ERROR] CMySQLQuery::Execute[] - (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
[15:42:55] [ERROR] CMySQLQuery::Execute[] - (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
[15:42:55] [ERROR] CMySQLQuery::Execute[] - (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 '`Vip` = '0'' at line 1
[15:42:55] [ERROR] CMySQLQuery::Execute[] - (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 '`Vip` = '0' `Helper` = '0'' at line 1
[15:42:55] [ERROR] CMySQLQuery::Execute[] - (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 '`Vip` = '0' `Helper` = '0' WHERE `ID` = '2'' at line 1



С чем это может быть связано?

Nurick
05.08.2015, 12:28
Попробуйте заменить TYPE = MYISAM на ENGINE = MYISAM.

stimorol
05.08.2015, 12:40
Попробуйте заменить TYPE = MYISAM на ENGINE = MYISAM.

Вы имеете ввиду эту строчку?:


ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

Nurick
05.08.2015, 13:26
[15:42:55] [ERROR] CMySQLQuery::Execute[] - (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 '`Vip` = '0' `Helper` = '0' WHERE `ID` = '2'' at line 1 проверьте не поставлена ли лишняя запятая

Роуди.
05.08.2015, 15:07
Пожалуйста, дай код. Так тяжело определить ;(

$continue$
05.08.2015, 15:30
Нужен запрос.

Blood
05.08.2015, 17:31
[15:42:55] [ERROR] CMySQLQuery::Execute[] - (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 '`Vip` = '0' `Helper` = '0' WHERE `ID` = '2'' at line 1 проверьте не поставлена ли лишняя запятая

Да он пропустил запятую .

stimorol
06.08.2015, 09:53
Всем огромное спасибо, проблему решил. Был косяк с сохранением аккаунта.