Change Name Error [MySQL] :( - Printable Version

Change Name Error [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: Change Name Error [MySQL] :( (/showthread.php?tid=633299)

Change Name Error [MySQL] - aoky - 28.04.2017

I've added a /changecname command but get this error when the player changes their name:

Код:

[20:44:44] [MYSQL ERROR]: ID: 1054
[20:44:44] [MYSQL ERROR]: Error: Unknown column 'SQLID' in 'where clause'
[20:44:44] [MYSQL ERROR]: Query: UPDATE `Characters` SET `Name` = 'Austin_Cock' WHERE SQLID = 42 LIMIT 1

Help would be great.

e: I don't see why it says unkown column for the SQLID, what should I set it to? I really don't know, lol.

Re: Change Name Error [MySQL] :( - aoky - 28.04.2017

bump

Re: Change Name Error [MySQL] :( - iLearner - 28.04.2017

Post your name change query.

Re: Change Name Error [MySQL] :( - Cypress - 28.04.2017

Quote:

Originally Posted by iLearner

Post your name change query.

Why would you need to check the query if it says that SQLID column does not exist in his table. Query runs fine.

Re: Change Name Error [MySQL] :( - aoky - 28.04.2017

Fixed.