[jcvag44800]

Hello ,

Sorry for my english

On my server, when I buy a walkie-talkie or anything like this, I set my pTalkie variable as 1.
This is my SQL script for update this:

Код:

			format(string,sizeof(string),"UPDATE players_stats SET Roop=%d,Baillon=%d,Jerrican=%d,Confiserie=%d,Adrenaline=%d,Cigarettes=%d,Feuilles=%d,Tabac=%d,Connected=%d,Talkie=%d,CarKeyOffer=%d,OfferTime=%d,Wanted=%d,Ip='%s',CombatStyle=%d,Journal=%d,Parrain=%d,Email='%s',De=%d,Bombe=%d,BoomBox=%d,Cheque=%d WHERE ID=%d",
			PlayerInfo[playerid][pRoop],
			PlayerInfo[playerid][pBaillon],
			PlayerInfo[playerid][pJerrican],
			PlayerInfo[playerid][pConfiserie],
			PlayerInfo[playerid][pAdrenaline],
			PlayerInfo[playerid][pCigarettes],
			PlayerInfo[playerid][pFeuilles],
			PlayerInfo[playerid][pTabac],
			PlayerInfo[playerid][pConnected],
			PlayerInfo[playerid][pTalkie],
			PlayerInfo[playerid][pCarKeyOffer],
			PlayerInfo[playerid][pCarKeyOfferTime],
			PlayerInfo[playerid][pWantedLevel],
			PlayerInfo[playerid][pIP],
			PlayerInfo[playerid][pCombatStyle],
			PlayerInfo[playerid][pJournal],
			PlayerInfo[playerid][pParrain],
			PlayerInfo[playerid][pEmail],
			PlayerInfo[playerid][pDe],
			PlayerInfo[playerid][pCheque],
			PlayerInfo[playerid][pBombe],
			PlayerInfo[playerid][pBoomBox],
			PlayerInfo[playerid][pSQLID]);
			MySQLCheckConnection();
			mysql_query(string);

And this is the message in "debug logs"

Код:

[20:25:15] CMySQLHandler::Query(UPDATE players_stats SET Roop=0,Baillon=0,Jerrican=0,Confiserie=0,Adrenaline=0,Cigarettes=0,Feuilles=0,Tabac=0,Connected=0,Talkie=1,CarKeyOffer=9999,OfferTime=-1,Wanted=0,Ip='127.0.0.1',CombatStyle=3,Journal=0,Parrain=-1,Email='findedline@gmail.com',De=0,Bombe=0,BoomBox=0,Cheque=0 WHERE ID=1055) - An error has occured. (Error ID: 1054, Unknown column 'BoomBox' in 'field list')

[20:25:16] >> mysql_ping( Connection handle: 1 )

[20:25:16] CMySQLHandler::Ping() - Connection is still alive.

[20:25:16] >> mysql_query( Connection handle: 1 )

[20:25:16] CMySQLHandler::Query(SELECT * FROM server_reload) - Successfully executed.

[20:25:16] >> mysql_store_result( Connection handle: 1 )

[20:25:16] CMySQLHandler::StoreResult() - Result was stored.

[20:25:16] >> mysql_fetch_row_format( Connection handle: 1 )

[20:25:16] CMySQLHandler::FetchRow() - Return: 0|0|0|0|0|0|0|0|0|0|0

[20:25:16] >> mysql_free_result( Connection handle: 1 )

[20:25:16] CMySQLHandler::FreeResult() - Result was successfully free'd.

But, when I look phpmyadmin, the pTalkie is not set as 1, but 0...

Have you any idea ?

[AphexCCFC]

Look in mysql_log.txt, any errors?

[jcvag44800]

I have nothing about this...

[AphexCCFC]

Under OnGameModeInit

pawn Код:

mysql_debug(1);

Retry your script ingame and post your errors in the mysql_log.txt file it creates in your server directory.

[jcvag44800]

Ok,

I connect to the server, I buy a Walkie Talkie and I disconnect.
There is Debug.txt (mysql_log.txt if you want) and server_log.txt

https://www.mediafire.com/?s18qux5yq5998j1

[AphexCCFC]

pawn Код:

Error ID: 1054, Unknown column 'BoomBox' in 'field list'

You sure there's a field called BoomBox in your database table?

[jcvag44800]

Oh, no. You think tt can be cancel all data (like pTalkie) after this ?

[AphexCCFC]

pawn Код:

[21:33:27] CMySQLHandler::Query(UPDATE players_stats SET Roop=0,Baillon=0,Jerrican=0,Confiserie=0,Adrenaline=0,Cigarettes=0,Feuilles=0,Tabac=0,Connected=0,Talkie=1,CarKeyOffer=9999,OfferTime=-1,Wanted=0,Ip='127.0.0.1',CombatStyle=3,Journal=0,Parrain=-1,Email='findedline@gmail.com',De=0,Bombe=0,BoomBox=0,Cheque=0 WHERE ID=1055) - An error has occured. (Error ID: 1054, Unknown column 'BoomBox' in 'field list')

That usually means there's no such field named 'BoomBox' in your MySQL database, so either remove or create it.

[jcvag44800]

Thank you, it's work now !

[AphexCCFC]

No problem