MySQL error, displayed on Samp-server - 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: MySQL error, displayed on Samp-server (/showthread.php?tid=282583)
+- 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: MySQL error, displayed on Samp-server (/showthread.php?tid=282583)
MySQL error, displayed on Samp-server - Dokins - 11.09.2011
Very strange:
Quote:
|
MySQL error 1054: unknown column `id` in `where clause` |
Re: MySQL error, displayed on Samp-server - Kingunit - 11.09.2011
You are using MySQL. Do you even know what MySQL is?
Re: MySQL error, displayed on Samp-server - Mean - 11.09.2011
You need to create the "id" column in your MySQL database.
For example, now you have:
name, password, money, score.
You should have:
id, name, password, money, score.
Re: MySQL error, displayed on Samp-server - Dokins - 11.09.2011
Yes, It already exists.
It loads the name etc too.
Re: MySQL error, displayed on Samp-server - Kingunit - 11.09.2011
Not sure if it doens't matter - but did you watched highercast / lowercast?
Re: MySQL error, displayed on Samp-server - Mean - 11.09.2011
Are you sure you are selecting the right table and database?
Re: MySQL error, displayed on Samp-server - Dokins - 11.09.2011
Yes, I'm sure.
It may be something to do with the MySQL plugin, it still works, its just a strange error.