Error Mysql ! - Printable Version

Error Mysql ! - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Error Mysql ! (/showthread.php?tid=464505)

Error Mysql ! - nguyenquynh - 17.09.2013

Код:

[18:54:21] [part] TESTTTTT_S has left the server (0:0)
[18:54:21] [MySQL] Query Error - (ErrorID: 1064) (Handle: 1)
[18:54:21] [MySQL] Check /logs/querydump.log to review the query that threw the error.
[18:54:21] Dumping query from 2013/9/17 (18:54:21)

Description: 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 ' `Gioithieu` = 0, `FMember` = 255, `Rank` = 0, `DetSkill` = 0, `SexSkill` = 0, `' at line 1 (index 0). Query:


[18:54:21] UPDATE `accounts` SET `IP` = '192.168.1.104', `Registered` = 1, `ConnectedTime` = 0, `Sex` = 0, `Age` = 0, `Band` = 0, `PermBand` = 0, `Warnings` = 0, `Disabled` = 0, `Level` = 1, `AdminLevel` = 0, `DonateRank` = 0, `Respect` = 0, `Money` = 10000, `Bank` = 20000, `pHealth` = 100.00000, `pArmor` = 0.00000, `pSHealth` = 0.00000, `Int` = 0, `VirtualWorld` = 0, `Model` = 299, `Clothes` = 0, `SPos_x` = 0.00000, `SPos_y` = 0.00000, `SPos_z` = 4.88174, `SPos_r` = 0.99995, `BanAppealer` = 0, `PR` = 0, `ShopTech` = 0, `Undercover` = 0, `TogReports` = 0, `Radio` = 0, `RadioFreq` = 0, `UpgradePoints` = 0, `Origin` = 0, `Muted` = 0, `Crimes` = 0, `Accent` = 1, `CHits` = 0, `FHits` = 0, `Arrested` = 0, `Phonebook` = 0, `Coin` = 0, `Vang` = 0, `CuopVangTime` = 0, `SieuThiTime` = 0, `Dau` = 0, `Doibung` = 100, `Thucan` = 0, `LottoNr` = 0, `Fishes` = 0, `BiggestFish` = 0, `Job` = 0, `Job2` = 0, `Paycheck` = 15, `HeadValue` = 0, `JailTime` = 0, `WRestricted` = 0, `Materials` = 0, `Crates` = 0, `Pot` = 0, `Crack` = 0, `Leader
[18:54:21] ` = 0, `Member` = 0, `Division` = 0, `Cuahang` = -1, `Cuahang2` = -1, `HtOnline` = 0, `BusinessType` = -1, `BusinessEnter` = -1, `Nguoigioithieu` = , `Gioithieu` = 0, `FMember` = 255, `Rank` = 0, `DetSkill` = 0, `SexSkill` = 0, `BoxSkill` = 0, `LawSkill` = 0, `MechSkill` = 0, `TruckSkill` = 0, `DrugsSkill` = 0, `ArmsSkill` = 0, `SmugglerSkill` = 0, `FishSkill` = 0, `CheckCash` = 0, `Checks` = 0, `BoatLic` = 1, `FlyLic` = 0, `GunLic` = 1, `FishLic` = 1, `FishSkill` = 0, `FightingStyle` = 0, `PhoneNr` = 0, `Apartment` = -1, `Apartment2` = -1, `Renting` = -1, `CarLic` = 1 WHERE `id` = '53'
[18:54:34] Incoming connection: 192.168.1.104:59354
[18:54:35] [join] Pro_ne has joined the server (0:192.168.1.104)
[18:54:40] Pro ne has logged in.
[18:54:49] [MySQL] Query Error - (ErrorID: 1065) (Handle: 1)
[18:54:49] [MySQL] Check /logs/querydump.log to review the query that threw the error.
[18:54:49] Dumping query from 2013/9/17 (18:54:49)

Description: Query was empty (index 0). Query:


[18:54:49] (null)
[18:54:50] [part] Pro_ne has left the server (0:1)
[18:54:50] [MySQL] Query Error - (ErrorID: 1064) (Handle: 1)
[18:54:50] [MySQL] Check /logs/querydump.log to review the query that threw the error.
[18:54:50] Dumping query from 2013/9/17 (18:54:50)

Description: 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 ' `Gioithieu` = 1, `FMember` = 255, `Rank` = 0, `DetSkill` = 0, `SexSkill` = 0, `' at line 1 (index 0). Query:


[18:54:50] UPDATE `accounts` SET `IP` = '192.168.1.104', `Registered` = 1, `ConnectedTime` = 0, `Sex` = 1, `Age` = 18, `Band` = 0, `PermBand` = 0, `Warnings` = 0, `Disabled` = 0, `Level` = 1, `AdminLevel` = 0, `DonateRank` = 0, `Respect` = 0, `Money` = 10000, `Bank` = 20000, `pHealth` = 100.00000, `pArmor` = 0.00000, `pSHealth` = 0.00000, `Int` = 0, `VirtualWorld` = 0, `Model` = 299, `Clothes` = 0, `SPos_x` = 1607.01599, `SPos_y` = -1510.82177, `SPos_z` = -21.24764, `SPos_r` = 0.99995, `BanAppealer` = 0, `PR` = 0, `ShopTech` = 0, `Undercover` = 0, `TogReports` = 0, `Radio` = 0, `RadioFreq` = 0, `UpgradePoints` = 0, `Origin` = 0, `Muted` = 0, `Crimes` = 0, `Accent` = 1, `CHits` = 0, `FHits` = 0, `Arrested` = 0, `Phonebook` = 0, `Coin` = 0, `Vang` = 0, `CuopVangTime` = 0, `SieuThiTime` = 0, `Dau` = 0, `Doibung` = 100, `Thucan` = 0, `LottoNr` = 0, `Fishes` = 0, `BiggestFish` = 0, `Job` = 0, `Job2` = 0, `Paycheck` = 9, `HeadValue` = 0, `JailTime` = 0, `WRestricted` = 0, `Materials` = 0, `Crates` = 0, `Pot` = 0, `Crack` = 0
[18:54:50] , `Leader` = 0, `Member` = 0, `Division` = 0, `Cuahang` = -1, `Cuahang2` = -1, `HtOnline` = 0, `BusinessType` = -1, `BusinessEnter` = -1, `Nguoigioithieu` = , `Gioithieu` = 1, `FMember` = 255, `Rank` = 0, `DetSkill` = 0, `SexSkill` = 0, `BoxSkill` = 0, `LawSkill` = 0, `MechSkill` = 0, `TruckSkill` = 0, `DrugsSkill` = 0, `ArmsSkill` = 0, `SmugglerSkill` = 0, `FishSkill` = 0, `CheckCash` = 0, `Checks` = 0, `BoatLic` = 1, `FlyLic` = 0, `GunLic` = 1, `FishLic` = 1, `FishSkill` = 0, `FightingStyle` = 0, `PhoneNr` = 0, `Apartment` = -1, `Apartment2` = -1, `Renting` = -1, `CarLic` = 1 WHERE `id` = '54'

Code in my server :

Код:

else if(dialogid == NGUOIGIOITHIEU)
		{
		    if(response)
            {
                new query[356];
                if( strfind( inputtext, "_", true) == -1 )
				{
					ShowPlayerDialog(playerid, NGUOIGIOITHIEU, DIALOG_STYLE_INPUT, "{FA002E}Error - Invalid Roleplay Name", "That is not a roleplay name\nPlease enter a proper roleplay name.\n\nExample: FristName_LastName", "Enter", "Skip");
					return 1;
				}
				PlayerInfo[playerid][pGioithieu] += 1;
				SendClientMessageEx(playerid, COLOR_LIGHTRED, "Cam on ban da dien vao tat ca thong tin, bay gio ban co the tien hanh huong dan!");
				
				format(query, sizeof(query), "UPDATE `accounts` SET `Nguoigioithieu`='%s', `Gioithieu`=1 WHERE `id`=%d", inputtext, GetPlayerSQLId(playerid));
				mysql_function_query(MainPipeline, string, true, "OnQueryFinish", "ii", LOADUSERDATA_THREAD, playerid);

Re: Error Mysql ! - Misiur - 17.09.2013

The code you are showing is not related to the error. You've got somewhere in your query

Quote:

`Nguoigioithieu` = , `Gioithieu` = 1

Re: Error Mysql ! - nguyenquynh - 17.09.2013

Quote:

Originally Posted by Misiur

The code you are showing is not related to the error. You've got somewhere in your query

How to edit error , help me?

Re: Error Mysql ! - Misiur - 17.09.2013

Find the query which starts with "UPDATE `accounts` SET `IP` (...)" and fix it.

Re: Error Mysql ! - nguyenquynh - 17.09.2013

Quote:

Originally Posted by Misiur

Find the query which starts with "UPDATE `accounts` SET `IP` (...)" and fix it.

Код:

format(query, sizeof(query), "UPDATE `accounts` SET \
		`IP` = '%s', \
		`Registered` = %d, \
		`ConnectedTime` = %d, \
		`Sex` = %d, \
		`Age` = %d, \
		`Band` = %d, \
		`PermBand` = %d, \
		`Warnings` = %d, \
		`Disabled` = %d, \
		`Level` = %d, \
		`AdminLevel` = %d, \
		`DonateRank` = %d, \
		`Respect` = %d, \
		`Money` = %d, \
		`Bank` = %d,",
		PlayerInfo[playerid][pIP],
		PlayerInfo[playerid][pReg],
		PlayerInfo[playerid][pConnectHours],
		PlayerInfo[playerid][pSex],
		PlayerInfo[playerid][pAge],
		PlayerInfo[playerid][pBanned],
		PlayerInfo[playerid][pPermaBanned],
		PlayerInfo[playerid][pWarns],
		PlayerInfo[playerid][pDisabled],
		PlayerInfo[playerid][pLevel],
		PlayerInfo[playerid][pAdmin],
		PlayerInfo[playerid][pDonateRank],
		PlayerInfo[playerid][pExp],
		GetPlayerCash(playerid),
		PlayerInfo[playerid][pAccount]
	);

	format(query, sizeof(query), "%s \
		`pHealth` = %0.5f, \
		`pArmor` = %0.5f, \
		`pSHealth` = %0.5f, \
		`Int` = %d, \
		`VirtualWorld` = %d, \
		`Model` = %d, \
		`Clothes` = %d, \
		`SPos_x` = %0.5f, \
		`SPos_y` = %0.5f, \
		`SPos_z` = %0.5f, \
		`SPos_r` = %0.5f, \
		`BanAppealer` = %d, \
		`PR` = %d, \
		`ShopTech` = %d, \
		`Undercover` = %d, \
		`TogReports` = %d,",
		query,
		PlayerInfo[playerid][pHealth],
		PlayerInfo[playerid][pArmor],
		PlayerInfo[playerid][pSHealth],
		PlayerInfo[playerid][pInt],
		PlayerInfo[playerid][pVW],
		PlayerInfo[playerid][pModel],
		PlayerInfo[playerid][pClothes],
		PlayerInfo[playerid][pPos_x],
		PlayerInfo[playerid][pPos_y],
		PlayerInfo[playerid][pPos_z],
		PlayerInfo[playerid][pPos_r],
		PlayerInfo[playerid][pBanAppealer],
		PlayerInfo[playerid][pPR],
		PlayerInfo[playerid][pShopTech],
		PlayerInfo[playerid][pUndercover],
		PlayerInfo[playerid][pTogReports]
	);

	format(query, sizeof(query), "%s \
		`Radio` = %d, \
		`RadioFreq` = %d, \
		`UpgradePoints` = %d, \
		`Origin` = %d, \
		`Muted` = %d, \
		`Crimes` = %d, \
		`Accent` = %d, \
		`CHits` = %d, \
		`FHits` = %d, \
		`Arrested` = %d, \
		`Phonebook` = %d, \
		`Coin` = %d, \
		`Vang` = %d, \
		`CuopVangTime` = %d, \
		`SieuThiTime` = %d, \
		`Dau` = %d, \
		`Doibung` = %d, \
		`Thucan` = %d, \
		`LottoNr` = %d, \
		`Fishes` = %d, \
		`BiggestFish` = %d, \
		`Job` = %d,",
		query,
		PlayerInfo[playerid][pRadio],
		PlayerInfo[playerid][pRadioFreq],
		PlayerInfo[playerid][gPupgrade],
		PlayerInfo[playerid][pOrigin],
		PlayerInfo[playerid][pMuted],
		PlayerInfo[playerid][pCrimes],
		PlayerInfo[playerid][pAccent],
		PlayerInfo[playerid][pCHits],
		PlayerInfo[playerid][pFHits],
		PlayerInfo[playerid][pArrested],
		PlayerInfo[playerid][pPhoneBook],
		GetPlayerCoin(playerid),
		PlayerInfo[playerid][pVang],
		PlayerInfo[playerid][pCuopVangTime],
		PlayerInfo[playerid][pSieuThiTime],
		PlayerInfo[playerid][pDau],
		PlayerInfo[playerid][pDoibung],
		PlayerInfo[playerid][pThucan],
		PlayerInfo[playerid][pLottoNr],
		PlayerInfo[playerid][pFishes],
		PlayerInfo[playerid][pBiggestFish],
		PlayerInfo[playerid][pJob]
	);

	format(query, sizeof(query), "%s \
		`Job2` = %d, \
		`Paycheck` = %d, \
		`HeadValue` = %d, \
		`JailTime` = %d, \
		`WRestricted` = %d, \
		`Materials` = %d, \
		`Crates` = %d, \
		`Pot` = %d, \
		`Crack` = %d, \
		`Leader` = %d, \
		`Member` = %d, \
		`Division` = %d, \
		`Cuahang` = %d, \
		`Cuahang2` = %d, \
		`HtOnline` = %d, \
		`BusinessType` = %d, \
		`BusinessEnter` = %d, \
		`Nguoigioithieu` = %s, \
		`Gioithieu` = %d, \
		`FMember` = %d,",
		query,
		PlayerInfo[playerid][pJob2],
		PlayerInfo[playerid][pPayCheck],
		PlayerInfo[playerid][pHeadValue],
		PlayerInfo[playerid][pJailTime],
		PlayerInfo[playerid][pWRestricted],
		PlayerInfo[playerid][pMats],
		PlayerInfo[playerid][pCrates],
		PlayerInfo[playerid][pPot],
		PlayerInfo[playerid][pCrack],
		PlayerInfo[playerid][pLeader],
		PlayerInfo[playerid][pMember],
		PlayerInfo[playerid][pDivision],
		PlayerInfo[playerid][pBusiness],
  		PlayerInfo[playerid][pBusiness2],
  		PlayerInfo[playerid][pHtOnline],
  		PlayerInfo[playerid][pBusinessType],
  		PlayerInfo[playerid][pBusinessEnter],
  		PlayerInfo[playerid][pNguoigioithieu],
  		PlayerInfo[playerid][pGioithieu],
		PlayerInfo[playerid][pFMember]
	);

	format(query, sizeof(query), "%s \
		`Rank` = %d, \
		`DetSkill` = %d, \
		`SexSkill` = %d, \
		`BoxSkill` = %d, \
		`LawSkill` = %d, \
		`MechSkill` = %d, \
		`TruckSkill` = %d, \
		`DrugsSkill` = %d, \
		`ArmsSkill` = %d, \
		`SmugglerSkill` = %d, \
		`FishSkill` = %d, \
		`CheckCash` = %d,",
		query,
		PlayerInfo[playerid][pRank],
		PlayerInfo[playerid][pDetSkill],
		PlayerInfo[playerid][pSexSkill],
		PlayerInfo[playerid][pBoxSkill],
		PlayerInfo[playerid][pLawSkill],
		PlayerInfo[playerid][pMechSkill],
		PlayerInfo[playerid][pTruckSkill],
		PlayerInfo[playerid][pDrugsSkill],
		PlayerInfo[playerid][pArmsSkill],
		PlayerInfo[playerid][pSmugSkill],
		PlayerInfo[playerid][pFishSkill],
		PlayerInfo[playerid][pCheckCash]
	);

Re: Error Mysql ! - nguyenquynh - 17.09.2013

upppppppppppppppppppppppppppppppppppppppppppppppp

Re: Error Mysql ! - nguyenquynh - 17.09.2013

I have used code

Код:

strmid(PlayerInfo[playerid][pNguoigioithieu], inputtext, 0, strlen(inputtext), 255);

to query inputtext dialog pNguoigioithieu

Error : [19:33:00] [MySQL] Query Error - (ErrorID: 1054) (Handle: 1)
[19:33:00] [MySQL] Check /logs/querydump.log to review the query that threw the error.
[19:33:00] Dumping query from 2013/9/17 (19:33:0)

Error:

Код:

Description: Unknown column 'Lionel_Ryan' in 'field list' (index 0). Query:

Re: Error Mysql ! - Misiur - 17.09.2013

Quote:

`Nguoigioithieu` = %s, \

change to

Quote:

`Nguoigioithieu` = '%s', \

Don't forget to escape string with mysql_real_escape.