Quote:
Originally Posted by OciXCrom
I asked a friend who knows more about MySQL and he said that the error is because you're using an old MySQL version, just like you said. Try updating to the latest one.
|
MySQL update didn't helped, but one thing helped. I changed all these symbols '' to `` in SQL lines.
A part from code how it looks now (full code in attachment):
PHP Code:
formatex(szQuery, charsmax(szQuery), "INSERT INTO %s (`Player`,`XP`,`Level`,`Next XP`,`Rank`,`Next Rank`) VALUES ('%s','%i','1','0','n/a','n/a');", g_eSettings[SQL_TABLE], szPlayer, iXP)
-->>>
PHP Code:
formatex(szQuery, charsmax(szQuery), "INSERT INTO %s (`Player`,`XP`,`Level`,`Next XP`,`Rank`,`Next Rank`) VALUES (`%s`,`%i`,`1`,`0`,`n/a`,`n/a`);", g_eSettings[SQL_TABLE], szPlayer, iXP)
But now I have a new one error..
PHP Code:
L 01/27/2019 - 17:55:18: [crx_ranksystem.amxx] Unknown column 'BOT' in 'where clause'
L 01/27/2019 - 17:56:10: [crx_ranksystem.amxx] [SQL Error] Query failed (1054): Unknown column 'STEAM_0:1:156416040' in 'where clause'
L 01/27/2019 - 17:56:10: [crx_ranksystem.amxx] [SQL Error] Query failed (1054): Unknown column 'BOT' in 'where clause'
Can you check this please?