Mysql row not created
#2

You have size of 130 for storing the password and the query itself is only 128? Increase its length so it will be enough.

Also cache_insert_id will fail. It must be in a public function (always advised to use cache, even in INSERT/UPDATE):
pawn Код:
mysql_function_query(mysql,str,true,"OnPlayerRegisterAccount","i", playerid);

// somewhere outside of any other function/callback:
forward OnPlayerRegisterAccount(playerid);
public OnPlayerRegisterAccount(playerid)
{
    FieldID[playerid] = cache_insert_id(mysql);
    return 1;
}
and what's the point in executing a query directly after that and selecting all the data? I mean, the player just registered so obviously you know all the rest of the data.
Reply


Messages In This Thread
Mysql row not created - by DetoNater - 10.06.2015, 09:22
Re: Mysql row not created - by Konstantinos - 10.06.2015, 09:27
Re: Mysql row not created - by DetoNater - 10.06.2015, 09:47
Re: Mysql row not created - by DetoNater - 10.06.2015, 12:46
Re: Mysql row not created - by mamorunl - 10.06.2015, 14:04
Re: Mysql row not created - by DetoNater - 10.06.2015, 14:35
Re: Mysql row not created - by mamorunl - 11.06.2015, 07:35
Re: Mysql row not created - by DetoNater - 11.06.2015, 09:48

Forum Jump:


Users browsing this thread: 1 Guest(s)