[закрыто] Не сохраняет в БД

[Guest Андрей]

Сделал логи для сервера, но в БД не идет, пишет ошибку #1064 (MySQL), почитал на других форумах, там написано что из за размера, но с размером все хорошо.

 

Спойлер

[19:56:50] [plugins/mysql] error #1064 while executing query "INSERT INTO `logs` (`date`, `time`, `playersender` `playeraddressee`, `action`, `sum`) VALUES ('15.09.2020', '19:56:50', 'Test_Test', 'Test_Test', 'Создал деньги игроку', '9999')": 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 '`playeraddressee`, `action`, `sum`) VALUES ('15.09.2020', '19:56:50', 'Test_T' at line 1
[19:56:51] [plugins/mysql] error #1064 while executing query "INSERT INTO `logs` (`date`, `time`, `playersender` `playeraddressee`, `action`, `sum`) VALUES ('15.09.2020', '19:56:51', 'Test_Test', 'Test_Test', 'Создал деньги игроку', '999')": 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 '`playeraddressee`, `action`, `sum`) VALUES ('15.09.2020', '19:56:51', 'Test_T' at line 1
[19:56:52] [plugins/mysql] error #1064 while executing query "INSERT INTO `logs` (`date`, `time`, `playersender` `playeraddressee`, `action`, `sum`) VALUES ('15.09.2020', '19:56:52', 'Test_Test', 'Test_Test', 'Создал деньги игроку', '9999')": 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 '`playeraddressee`, `action`, `sum`) VALUES ('15.09.2020', '19:56:52', 'Test_T' at line 1
[19:56:52] [plugins/mysql] error #1064 while executing query "INSERT INTO `logs` (`date`, `time`, `playersender` `playeraddressee`, `action`, `sum`) VALUES ('15.09.2020', '19:56:52', 'Test_Test', 'Test_Test', 'Создал деньги игроку', '9999')": 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 '`playeraddressee`, `action`, `sum`) VALUES ('15.09.2020', '19:56:52', 'Test_T' at line 1
[19:56:53] [plugins/mysql] error #1064 while executing query "INSERT INTO `logs` (`date`, `time`, `playersender` `playeraddressee`, `action`, `sum`) VALUES ('15.09.2020', '19:56:53', 'Test_Test', 'Test_Test', 'Создал деньги игроку', '9999')": 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 '`playeraddressee`, `action`, `sum`) VALUES ('15.09.2020', '19:56:53', 'Test_T' at line 1
[19:56:53] [plugins/mysql] error #1064 while executing query "INSERT INTO `logs` (`date`, `time`, `playersender` `playeraddressee`, `action`, `sum`) VALUES ('15.09.2020', '19:56:53', 'Test_Test', 'Test_Test', 'Создал деньги игроку', '9999')": 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 '`playeraddressee`, `action`, `sum`) VALUES ('15.09.2020', '19:56:53', 'Test_T' at line 1
[19:56:54] [plugins/mysql] error #1064 while executing query "INSERT INTO `logs` (`date`, `time`, `playersender` `playeraddressee`, `action`, `sum`) VALUES ('15.09.2020', '19:56:54', 'Test_Test', 'Test_Test', 'Создал деньги игроку', '9999')": 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 '`playeraddressee`, `action`, `sum`) VALUES ('15.09.2020', '19:56:54', 'Test_T' at line 1

 

 

 

Спойлер

CMD:givemoney(playerid, params[])
{
	new giveid, money, string[54+MAX_PLAYER_NAME*2+3*2+20], log[11+6+32*2+512*2], hour, minute, second, vr[555], year, month, day, dt[555];
	if(PlayerInfo[playerid][pAdmin] < 8) return 1;
	if(!IsPlayerConnected(giveid)) return SendClientMessage(playerid, -1 ,PlayerOff);
	if(sscanf(params,"dd", giveid ,money)) return SendClientMessage(playerid, -1, "Используйте: /givemoney [Ид] [Сумма]");

    PlayerInfo[playerid][pMoney] += money;
    
	gettime(hour, minute, second);
	format(vr, sizeof(vr), "%02d:%02d:%d", hour, minute, second);
	getdate(year, month, day);
	format(dt, sizeof(dt), "%02d.%02d.%02d", day, month, year);

	format(log, sizeof(log), "INSERT INTO `logs` (`date`, `time`, `playersender` `playeraddressee`, `action`, `sum`) VALUES ('%s', '%s', '%s', '%s', 'Создал деньги игроку', '%d')", dt, vr, PlayerInfo[playerid][pName], PlayerInfo[giveid][pName], money);
	mysql_query(dbHandle, log);
	return 1;
}

 

 

 

P/s: В таблицу тоже ничего не записывается

[DEST Максимальный 1,018]

1 час назад, Гость Андрей сказал:

`playersender` `playeraddressee`

между этими двумя заголовками не хватает запятой, а в целом эта ошибка возникает, если есть синтаксические ошибки в запросе. Таковой ошибкой и является пропущенная запятая.