[aoky]

Код:

[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?

[Vince]

Because no such column exists. Fairly self-explanatory.

[aoky]

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.

[DRIFT_HUNTER]

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

[AndreiWow]

Can you post a screenshot of the table?

[aoky]

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

[aoky]

Fixed it, changed "SQLID" to ID.