Little Help with MySQL - Printable Version

Little Help with MySQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Little Help with MySQL (/showthread.php?tid=497382)

Little Help with MySQL - gotwarzone - 26.02.2014

How do I fix the warning below?

Код:

1054, Unknown column 'Warnings' in 'field list', OnQueryFinish, SELECT `XPos`,`YPos`,`ZPos`,`AdminLevel`,`VIPLevel`,`WantedLevel`,`Kills`,`Deaths`,`Money`,`Score`,`Health`,`Armour`,`Hours`,`Minutes`,`Seconds`,`KickCount`,`LastSkin`,`SpawnCount`,`ReportCount`,`Warnings`,`FailLogin`,`RconAttempt`,`RegDate` FROM `account` WHERE `PlayerName` = 'DICE', 1

Because everytime I use any kind of command. It always say "You must be logged in" even though I was already logged in.

Re: Little Help with MySQL - Misiur - 26.02.2014

You don't have field "Warnings" in your database. Case matters, "warnings" != "Warnings"

Re: Little Help with MySQL - gotwarzone - 26.02.2014

Quote:

Originally Posted by Misiur

You don't have field "Warnings" in your database. Case matters, "warnings" != "Warnings"

thanks grandpa! It is now all working fine! +coffee