Ajutor erroare MYSQL

[Rayan]

Am o erroare de genul:

Error ID: 1136, Error: Column count doesn't match value count at row 1
Callback:
gQuery: INSERT INTO `crimes` (`name`,`Crime1`,`Crime2`,`Crime3`,`Crime4`,`Crime5`,`Crime6`,`Crime7`,`Crime8`,`Crime9`,`Crime10`,`Crime11`,`Crime12`,`Crime13`,`Crime14`,`Crime15`,`Crime16`,`Crime17`,`Crime18`,`Crime19`,`Crime20`) VALUES ('RedGun')

Redgun (e numele) atunci cand mi se inregistreaza un cont

Asta e public-ul OnPlayerRegister

public OnPlayerRegister(playerid, password[])
{
	if(IsPlayerConnected(playerid))
	{
		new playername3[MAX_PLAYER_NAME];
		GetPlayerName(playerid, playername3, sizeof(playername3));
		new Str[500],Str2[500],criptedpassword[129],y,m,d,h,mi,s;
		getdate(y, m, d);
		gettime(h, mi, s);
		WP_Hash(criptedpassword, sizeof(criptedpassword), password);
		mysql_format(SQL,Str,sizeof(Str),"INSERT INTO `users` (`name`,`password`,`RegisterDate`) VALUES ('%s','%s','%d-%d-%d %d:%d:%d')",playername3,criptedpassword,y,m,d,h,mi,s);
		mysql_tquery(SQL,Str,"","");
		mysql_format(SQL,Str2,sizeof(Str2),"INSERT INTO `crimes` (`name`,`Crime1`,`Crime2`,`Crime3`,`Crime4`,`Crime5`,`Crime6`,`Crime7`,`Crime8`,`Crime9`,`Crime10`,`Crime11`,`Crime12`,`Crime13`,`Crime14`,`Crime15`,`Crime16`,`Crime17`,`Crime18`,`Crime19`,`Crime20`) VALUES ('%s')",playername3);
		mysql_tquery(SQL,Str2,"","");
		strmid(PlayerInfo[playerid][pKey], criptedpassword, 0, strlen(criptedpassword), 255);
		PlayerInfo[playerid][pCash] = GetPlayerCash(playerid);
		if ((PlayerInfo[playerid][pPos_x]==0.0 && PlayerInfo[playerid][pPos_y]==0.0 && PlayerInfo[playerid][pPos_z]==0.0))
		{
     	    PlayerInfo[playerid][pPos_x] = 2246.6;
     	    PlayerInfo[playerid][pPos_y] = -1161.9;
     	    PlayerInfo[playerid][pPos_z] = 1029.7;
		}
		if(Spectate[playerid] != -1)
		{
			PlayerInfo[playerid][pPos_x] = Unspec[playerid][sPx];
			PlayerInfo[playerid][pPos_y] = Unspec[playerid][sPy];
			PlayerInfo[playerid][pPos_z] = Unspec[playerid][sPz];
			PlayerInfo[playerid][pInt] = Unspec[playerid][sPint];
			PlayerInfo[playerid][pLocal] = Unspec[playerid][sLocal];
		}
		ShowPlayerDialog(playerid,DIALOG_LOGIN2,DIALOG_STYLE_PASSWORD,"SERVER: Login","Welcome to the ExGaming RPG Server.\n\nPlease enter your password below!","Login","Cancel");
		return 1;
	}
	return 1;
}

 

[Banditul]

Ai doua variante

1:

mysql_format(SQL,Str2,sizeof(Str2),"INSERT INTO `crimes` (`name`) VALUES ('%s')",playername3);

Cu mentiunea ca trebuie sa ai setata o valoare default pentru crime(merge si fara, e putin mai naspa)

2:

mysql_format(SQL,Str2,sizeof(Str2),"INSERT INTO `crimes` (`name`,`Crime1`,`Crime2`,`Crime3`,`Crime4`,`Crime5`,`Crime6`,`Crime7`,`Crime8`,`Crime9`,`Crime10`,`Crime11`,`Crime12`,`Crime13`,`Crime14`,`Crime15`,`Crime16`,`Crime17`,`Crime18`,`Crime19`,`Crime20`) VALUES ('%s', 'Crima1', 'Crima2', 'Crima3', 'Crima4', 'S.A.M.D.')",playername3);

Iti da eroarea pentru ca tu specifici toate coloanele, da ii dai doar 1 valoare dar el asteapta mai multe

Edited August 3, 2017 by Banditul

[Rayan]

1 oră în urmă, Banditul a spus:

Ai doua variante

1:

mysql_format(SQL,Str2,sizeof(Str2),"INSERT INTO `crimes` (`name`) VALUES ('%s')",playername3);

Cu mentiunea ca trebuie sa ai setata o valoare default pentru crime(merge si fara, e putin mai naspa)

2:

mysql_format(SQL,Str2,sizeof(Str2),"INSERT INTO `crimes` (`name`,`Crime1`,`Crime2`,`Crime3`,`Crime4`,`Crime5`,`Crime6`,`Crime7`,`Crime8`,`Crime9`,`Crime10`,`Crime11`,`Crime12`,`Crime13`,`Crime14`,`Crime15`,`Crime16`,`Crime17`,`Crime18`,`Crime19`,`Crime20`) VALUES ('%s', 'Crima1', 'Crima2', 'Crima3', 'Crima4', 'S.A.M.D.')",playername3);

Iti da eroarea pentru ca tu specifici toate coloanele, da ii dai doar 1 valoare dar el asteapta mai multe

Daca folosesc prima varianta, cand jucatorul se inregistreaza, se insereaza automat crimele?

Edited August 3, 2017 by Rayan

[Banditul]

Acum 5 ore, Rayan a spus:

Daca folosesc prima varianta, cand jucatorul se inregistreaza, se insereaza automat crimele?

Da , cele defautl care sunt setate, daca nu e nimic pus la default va fi null

 

Edited August 3, 2017 by Banditul

[Rayan]

Acum 18 minute, Banditul a spus:

Da , cele defautl care sunt setate, daca nu e nimic pus la default va fi null

 

Ok si mai e problema aceasta

Error ID: 1064, Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''' at line 1
Callback:
gQuery: UPDATE users SET `CarLic`='1',`CarLicT`='10',`GunLic`='1',`GunLicT`='10',`FlyLic`='1',`FlyLicT`='10',`BoatLic`='1',`BoatLicT`='

nu inteleg ce nu e pus bine..

else if(TutTime[i] == 75)
			    {
			        TutTime[i] = 0; PlayerInfo[i][pTut] = 1;
					gNews[i] = 0;
					TogglePlayerControllable(i, 1);
					SetCameraBehindPlayer(i);
					TogglePlayerSpectating(i, 0);
					SetPlayerSpawn(i);
					PlayerInfo[i][pAccount] = 10000;
					ResetPlayerCash(i);
					GivePlayerCash(i,50000);
					SetPlayerInterior(i,0);
					SetPlayerVirtualWorld(i,0);
					TogglePlayerControllable(i,true);
					new str1[256];
					mysql_format(SQL,str1,256,"UPDATE users SET `Tutorial`='1',`Bank`='10000',`Money`='50000' WHERE `name`='%s'",PlayerInfo[i][pNormalName]);
					mysql_tquery(SQL,str1,"","");
					//Bonus
					GivePlayerCash(i, 500000);
					PlayerInfo[i][pLevel] = 3;
					Update(i, pCashx);
					Update(i, pLevelx);
					SetPlayerScore(i, PlayerInfo[i][pLevel]);
					//Licences
					PlayerInfo[i][pCarLic] = 1;
			        PlayerInfo[i][pCarLicT] = 10;
					PlayerInfo[i][pCarLicSuspend] = 0;
					Update(i, pCarLicSuspendx);
					PlayerInfo[i][pFlyLic] = 1;
			        PlayerInfo[i][pFlyLicT] = 10;
			        PlayerInfo[i][pBoatLic] = 1;
			        PlayerInfo[i][pBoatLicT] = 10;
			        PlayerInfo[i][pGunLic] = 1;
			        PlayerInfo[i][pGunLicT] = 10;
					PlayerInfo[i][pGunLicSuspend] = 0;
					Update(i, pGunLicSuspendx);
					new str[128];
					mysql_format(SQL,str,128,"UPDATE users SET `CarLic`='1',`CarLicT`='10',`GunLic`='1',`GunLicT`='10',`FlyLic`='1',`FlyLicT`='10',`BoatLic`='1',`BoatLicT`='10' WHERE `name`='%s'",PlayerInfo[i][pNormalName]);
					mysql_tquery(SQL,str,"","");
					SS(i, COLOR_RUBY, "(Server) {FFFFFF}Ai primit level 3, $500,000 si toate licentele pentru 10 ore bonus de bun venit.", "(Server) {FFFFFF}You received level 3, $500,000 and all licences for 10 hours for welcome.");
			    }

 

[Banditul]

new str[180];
mysql_format(SQL,str,sizeof(str),"UPDATE users SET CarLic = 1,CarLicT = 10,GunLic = 1,GunLicT = 10,FlyLic = 1,FlyLicT = 10,BoatLic = 1,BoatLicT = 10  WHERE name = '%e'",PlayerInfo[i][pNormalName]);
mysql_tquery(SQL,str,"","");

Lungimea la str nu era destul de mare sa suporte 148 caractere(fara numele juatorului care e 24)

Se se observa faptul ca nu ti-a mai scris nimic dupa ' , si asa iti dai seamna de faptul ca nu poate "scrie" tot

Edited August 3, 2017 by Banditul

[Rayan]

Mersi!