MySQL problem
#1

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 ?
Reply
#2

Look in mysql_log.txt, any errors?
Reply
#3

I have nothing about this...
Reply
#4

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.
Reply
#5

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
Reply
#6

pawn Код:
Error ID: 1054, Unknown column 'BoomBox' in 'field list'
You sure there's a field called BoomBox in your database table?
Reply
#7

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

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.
Reply
#9

Thank you, it's work now !
Reply
#10

No problem
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)