MySQL "unknown column" but its their!
#1

Код:
						new CasefileName[MAX_PLAYER_NAME], CasefileInfo[256];
						szMiscArray[0] = 0;

						GetPVarString(playerid, "CasefileName", CasefileName, sizeof(CasefileName));
						GetPVarString(playerid, "CasefileInfo", CasefileInfo, sizeof(CasefileInfo));

						mysql_format(MainPipeline, szMiscArray, sizeof(szMiscArray), "INSERT INTO `casefiles` (`suspect`, `issuer`, `information`, `group`, `active`) VALUES (`%s`, `%s`, `%s`, `%d`, `1`)", CasefileName, GetPlayerNameEx(playerid), CasefileInfo, PlayerInfo[playerid][pMember]);
						mysql_tquery(MainPipeline, szMiscArray, "OnQueryFinish", "ii", SENDDATA_THREAD, playerid);


Код:
[08:35:49] [zcmd] [Eatlag]: /casefile
[08:35:51] [MySQL] Query Error - (ErrorID: 1054)
[08:35:51] [MySQL] Check mysql_log.txt to review the query that threw the error.
[08:35:51] Dumping query from 2018/7/22 (8:35:51)

Description: Unknown column 'Eatlag' in 'field list' (index 0). Query:


[08:35:51] INSERT INTO `casefiles` (`suspect`, `issuer`, `information`, `group`, `active`) VALUES (`Eatlag`, `Eatlag`, `jjjgjgjjgjg`, `29`, `1`)
WTF IS GOING ON
Reply


Messages In This Thread
MySQL "unknown column" but its their! - by NinjaChicken - 22.07.2018, 08:56
Re: MySQL "unknown column" but its their! - by Banditul18 - 22.07.2018, 09:05
Re: MySQL "unknown column" but its their! - by NinjaChicken - 22.07.2018, 12:18
Re: MySQL "unknown column" but its their! - by grymtn - 22.07.2018, 13:24
Re: MySQL "unknown column" but its their! - by GTLS - 23.07.2018, 14:35

Forum Jump:


Users browsing this thread: 1 Guest(s)