MySQL Error
#1

Код:
[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?
Reply
#2

Because no such column exists. Fairly self-explanatory.
Reply
#3

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.
Reply
#4

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

Can you post a screenshot of the table?
Reply
#6

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
Reply
#7

Fixed it, changed "SQLID" to ID.
Reply


Forum Jump:


Users browsing this thread: 4 Guest(s)