SA-MP Forums Archive
MySQL Error - 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 (/showthread.php?tid=633290)


MySQL Error - aoky - 28.04.2017

Код:
[17:27:11] [MYSQL ERROR]: ID: 1054
[17:27:11] [MYSQL ERROR]: Error: Unknown column 'SQLID' in 'where clause'
[17:27:11] [MYSQL ERROR]: Query: SELECT `Name` FROM Characters WHERE SQLID = 0 LIMIT 1


[17:27:20] [MYSQL ERROR]: ID: 1054
[17:27:20] [MYSQL ERROR]: Error: Unknown column 'SQLID' in 'where clause'
[17:27:20] [MYSQL ERROR]: Query: SELECT `Name` FROM `Characters` WHERE `SQLID` = `1` LIMIT 1
Why does this happen?

Re: MySQL Error - Vince - 28.04.2017

Because no such column exists. Fairly self-explanatory.

Re: MySQL Error - aoky - 28.04.2017

Quote:
Originally Posted by Vince
Посмотреть сообщение
Because no such column exists. Fairly self-explanatory.
I get this now:
Код:
[18:03:45] [MYSQL ERROR]: ID: 1054
[18:03:45] [MYSQL ERROR]: Error: Unknown column 'SQLID' in 'where clause'
[18:03:45] [MYSQL ERROR]: Query: SELECT `Name` FROM `Characters` WHERE SQLID = 41 LIMIT 1
[18:03:45] [MYSQL ERROR]: ID: 1054
[18:03:45] [MYSQL ERROR]: Error: Unknown column 'SQLID' in 'where clause'
[18:03:45] [MYSQL ERROR]: Query: SELECT `Name` FROM `Characters` WHERE SQLID = 41 LIMIT 1
[18:03:45] [MYSQL ERROR]: ID: 1054
[18:03:45] [MYSQL ERROR]: Error: Unknown column 'SQLID' in 'where clause'
[18:03:45] [MYSQL ERROR]: Query: SELECT `Name` FROM `Characters` WHERE SQLID = 42 LIMIT 1
[18:03:45] [MYSQL ERROR]: ID: 1054
[18:03:45] [MYSQL ERROR]: Error: Unknown column 'SQLID' in 'where clause'
[18:03:45] [MYSQL ERROR]: Query: SELECT `Name` FROM `Characters` WHERE SQLID = 1 LIMIT 1
But I just checked the code and there is no `SQLID` anywhere in the script? I'm very confused.

Re: MySQL Error - DRIFT_HUNTER - 28.04.2017

SQLID column is missing inside Characters table in your database. You should go and learn mysql before using it.

Re: MySQL Error - AndreiWow - 28.04.2017

Can you post a screenshot of the table?

Re: MySQL Error - aoky - 28.04.2017

Quote:
Originally Posted by AndreiWow
Посмотреть сообщение
Can you post a screenshot of the table?


And it's now:
Код:
[18:42:25] [MYSQL ERROR]: ID: 1054
[18:42:25] [MYSQL ERROR]: Error: Unknown column 'SQLID' in 'where clause'
[18:42:25] [MYSQL ERROR]: Query: SELECT `Name` FROM Characters WHERE SQLID = 1 LIMIT 1
[18:42:25] [MYSQL ERROR]: ID: 1054
[18:42:25] [MYSQL ERROR]: Error: Unknown column 'SQLID' in 'where clause'
[18:42:25] [MYSQL ERROR]: Query: SELECT `Name` FROM Characters WHERE SQLID = 1 LIMIT 1


Re: MySQL Error - aoky - 28.04.2017

Fixed it, changed "SQLID" to ID.