• Уважаемый Гость.
    - Прежде чем создать свою тему, пожалуйста, попробуй воспользоваться этим -> ПОИСКОМ !!!
    - После решения Вашего вопроса (проблемы) - нажмите "Лучший ответ", на сообщении, которое его решило. За игнорирование этого действия - Вы получите соответствующее предупреждение. Мы - стараемся Вам помочь. Уделите 10 секунд - чтобы нажать кнопку. (Если у Вас нет такой возможности - укажите в последнем своем сообщении какой ответ Вы считаете лучшим. Наши модераторы сделают это за Вас)
    ЗАПРЕЩЕНО:
    - Cоздавать темы с названиями "Помогите", "Плиз", "Ошибка", "Не могу найти", "Хелп" и тому подобное;
    - Cоздавать темы без детального описания того, что нужно исправить.
    - Cоздавать темы из одного скриншота.
    За игнор правил форума - Ваша тема будет удалена, а Вы получите системное предупреждение.

Ошибка в MySQL

Статус
В этой теме нельзя размещать новые ответы.

#Alex_Wexler

Начинающий
Пользователь
Регистрация
18 Дек 2019
Сообщения
13
Лучшие ответы
0
Репутация
1
Добрый день.
Прошу помощи в исправлении ошибки MySql
При старте сервера все работает, однако ServerLog спамит подобной ошибкой
Код:
[14:04:55] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pRub` = '21' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:55] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pDonateAdd` = '0' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:55] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pRub` = '21' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:55] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pDonateAdd` = '0' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:56] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pRub` = '21' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:56] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pDonateAdd` = '0' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:56] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pRub` = '21' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:56] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pDonateAdd` = '0' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:56] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pRub` = '21' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:56] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pDonateAdd` = '0' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:56] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pRub` = '21' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:56] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pDonateAdd` = '0' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:56] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pRub` = '21' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:56] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pDonateAdd` = '0' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:56] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pRub` = '21' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:56] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pDonateAdd` = '0' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:56] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pRub` = '21' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:56] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pDonateAdd` = '0' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:57] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pRub` = '21' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:57] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pDonateAdd` = '0' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:57] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pRub` = '21' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:57] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pDonateAdd` = '0' WHERE `Chelovek` = 'Maurice_Wardness`, 1
[14:04:57] 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 ''Maurice_Wardness`' at line 1, , UPDATE `accounts` SET `pRub` = '21' WHERE `Chelovek` = 'Maurice_Wardness`, 1
В MySql логе аналогично
Код:
[18:10:30] [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 ''Tema_Kytyzov`' at line 1
[18:10:30] [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 ''Tema_Kytyzov`' at line 1
[18:10:30] [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 ''Don_Clemente`' at line 1
[18:10:30] [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 ''Don_Clemente`' at line 1
[18:10:30] [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 ''Alex_Wexler`' at line 1
[18:10:30] [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 ''Alex_Wexler`' at line 1
[18:10:30] [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 ''Danil_Temix`' at line 1
[18:10:30] [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 ''Danil_Temix`' at line 1
[18:10:30] [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 ''Tema_Kytyzov`' at line 1
[18:10:30] [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 ''Tema_Kytyzov`' at line 1
[18:10:30] [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 ''Don_Clemente`' at line 1
[18:10:30] [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 ''Don_Clemente`' at line 1
[18:10:30] [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 ''Anna_Dennico`' at line 1
[18:10:30] [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 ''Anna_Dennico`' at line 1
В чем может быть дело? Как исправить?
С меня магарыч :)
 
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу