MySQL problema vėl

['Eko]

mysql_log rodo, kad vėl kažką negerai darau su mysql. visą info rodau žemiau

 

TAIP PAT, Update3DLabel nepanaikina praeito teksto, bet sukūrią naują tekstą ant viršaus seno.

 

mysql error:

[19:44:00] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Numeris = 2' at line 1

pilnas mysql_log:

[19:44:00] [DEBUG] mysql_format - connection: 1, len: 150, format: "SELECT * FROM `namai` WHERE `Numeris` = %i"
[19:44:00] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM `namai` WHERE `Numeris` = 2", use_cache: true
[19:44:00] [DEBUG] CMySQLQuery::Execute - starting query execution
[19:44:00] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.400 milliseconds
[19:44:00] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[19:44:00] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 2)
[19:44:00] [DEBUG] cache_get_row_count - connection: 1
[19:44:00] [DEBUG] orm_update - orm_id: 7
[19:44:00] [DEBUG] mysql_format - connection: 1, len: 150, format: "UPDATE namai WHERE Numeris = %i"
[19:44:00] [DEBUG] mysql_query - connection: 1, query: "UPDATE namai WHERE Numeris = 2", use_cache: true
[19:44:00] [DEBUG] CMySQLQuery::Execute - starting query execution
[19:44:00] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:44:00] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Numeris = 2' at line 1
[19:44:00] [DEBUG] orm_update - orm_id: 7
[19:44:00] [DEBUG] cache_get_row_count - connection: 1
[19:44:00] [WARNING] cache_get_row_count - no active cache
[19:44:00] [DEBUG] cache_delete - cache_id: 2, connection: 1
[19:44:00] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[19:44:00] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[19:44:00] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 2.129 milliseconds
[19:44:00] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[19:44:00] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:44:00] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 2.1 milliseconds
[19:44:00] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

SQL table:

 

Pawn kodas:

	if(dialogid == DIALOG_N_NAMAS) // ============== Jei namas neturi savininko
	{
		new numeris[150];
		mysql_format(DbHandle,numeris,sizeof(numeris),"SELECT * FROM `namai` WHERE `Numeris` = %i",Namo_ID[playerid]);
		new Cache:result = mysql_query(DbHandle,numeris);
  		for(new n; n < cache_get_row_count(); n++)
		{
			if(pInfo[playerid][Namas] == 1) return SendClientMessage(playerid,RAUDONA,"Jûs jau turite namà!");
			if(GautiPinigus(playerid) >= NamoKaina[Namo_ID[playerid]])
			{
			    DuotiPinigus(playerid,-NamoKaina[Namo_ID[playerid]]);
			    SendClientMessage(playerid,ZALIA,"Sveikiname nusipirkus namà!");
			    new tekstas[150];
			    format(tekstas,sizeof(tekstas),"Jûsø namo numeris yra: %i",Namo_ID[playerid]);
			    SendClientMessage(playerid,RAUDONA,"[ BÛTINA ] {FFFFFF}Perskaitykite Los Santos namø savinikø taisykles ({CF0404}/namutaisykles{FFFFFF})");
			    pInfo[playerid][Namas] = 1;
			    nInfo[n][nKaina] = NamoKaina[Namo_ID[playerid]];
			    GetPlayerName(playerid,nInfo[n][Savininkas],24);
			    new update[150];
			    mysql_format(DbHandle,update,sizeof(update),"UPDATE namai WHERE Numeris = %i",Namo_ID[playerid]);
				mysql_query(DbHandle,update);
			    orm_update(pInfo[playerid][ORM_ID]);
			    new naujastxt[300];
			    format(naujastxt,sizeof(naujastxt),"Namo numeris: {FFFFFF}%i{09E84D}\nNamo savininkas: {FFFFFF}%s\n{09E84D}Rajonas: {FFFFFF}El Corona{09E84D}\nVertë: {FFFFFF}%i{09E84D}",Namo_ID[playerid],nInfo[n][Savininkas],nInfo[n][nKaina]);
			    Update3DTextLabelText(NamaiTXT[Namo_ID[playerid]], ZALIA, naujastxt);
			}
			else if(GautiPinigus(playerid) < NamoKaina[Namo_ID[playerid]])
			{
			    SendClientMessage(playerid,RAUDONA,"Neturite pakankamai pinigø!");
			}
		}
		cache_delete(result);
		return 1;
	}

Redaguota Kovo 29, 2014, nario E-Me

[bebras]

UPDATE namai WHERE Numeris = %i

Kad betikslė užklausa: "ATNAUJINTI namai KUR Numeris = x", bet kad tu nieko neatnaujini.

UPDATE namai SET Kanors = kam_nors WHERE Numeris = %i

['Eko]

[20:02:03] [DEBUG] mysql_format - connection: 1, len: 250, format: "UPDATE namai SET Savininkas = '%s' nKaina = %i WHERE Numeris = %i"
[20:02:03] [DEBUG] mysql_query - connection: 1, query: "UPDATE namai SET Savininkas = 'Eric_Heranco' nKaina = 130000 WHE", use_cache: true
[20:02:03] [DEBUG] CMySQLQuery::Execute - starting query execution
[20:02:03] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'nKaina = 130000 WHERE Numeris = 3' at line 1

Suprasčiau, jei būčiau nesukūręs stulpelių, bet viskas yra...

Redaguota Kovo 29, 2014, nario E-Me

[bebras]

UPDATE namai SET Savininkas = '%s', nKaina = %i WHERE Numeris = %i

Po kiekvienos SET reikšmės, reikia kablelio.

['Eko]

UPDATE namai SET Savininkas = '%s', nKaina = %i WHERE Numeris = %i

Po kiekvienos SET reikšmės, reikia kablelio.

 

Darai stebuklus su kableliais..

 

O žėk, dėl dvigubo 3D label gal žinai, kas galėtų būti? Ne tai, kad atnaujina, bet uždeda tekstą ant viršaus.