MySQL Account save problem
#8

Actually I fixed the problem by setting default values to all of them. But I've another problem now, when I register the server crashes, but the account is registered in the database.

When I turn on the server again, I log back with it, everything seems to work just fine. Now the problem is filonly in registration.




Код:
[20:08:36 08/09/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT `ID` FROM `players` WHERE `name` = 'Mark_Banger' LIMIT 1")
[20:08:36 08/09/17] [ERROR] cache_get_field_content_int - invalid datatype
[20:08:58 08/09/17] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
This is from the server script:
Код:
SQLSave(playerid);
		mysql_format(sqlGameConnection, saveQuery, sizeof(saveQuery), "SELECT `ID` FROM `players` WHERE `name` = '%e' LIMIT 1", PlayerName(playerid));
		mysql_tquery(sqlGameConnection, saveQuery, "SetPlayerID", "d", playerid);
		printf("mysql_tquery SetPlayerID");
Reply


Messages In This Thread
MySQL Account save problem - by Scofield11 - 08.08.2017, 03:44
Re: MySQL Account save problem - by Storm94 - 08.08.2017, 03:57
Re: MySQL Account save problem - by Scofield11 - 08.08.2017, 04:19
Re: MySQL Account save problem - by Storm94 - 08.08.2017, 06:06
Re: MySQL Account save problem - by Vince - 08.08.2017, 08:20
Re: MySQL Account save problem - by Scofield11 - 08.08.2017, 10:23
Re: MySQL Account save problem - by Scofield11 - 08.08.2017, 13:33
Re: MySQL Account save problem - by Scofield11 - 09.08.2017, 22:26

Forum Jump:


Users browsing this thread: 2 Guest(s)