[luccagomes15]

Quote:

Originally Posted by PawnHunter May I see your columns? table columns? The Error says you inserting some values inside a column which isn't in the table.

Help me to put all, i try but line is so long
http://imgur.com/KWTVtdu

Quote:

Originally Posted by PrO.GameR [04:37:04] [ERROR] CMySQLQuery::Execute[r@MySQL_CreateFaction] - (error #1136) Column count doesn't match value count at row 1 I'm not even sure if you can insert this way, but if you can the error is simply telling you that you are sending too many variables into the table (example: you have ID, name, pass in the table, you are sending ID, name, pass and money into it.)

I think i need insert on this mode

Код:

                format(query, sizeof(query), "INSERT INTO `accounts` (`Username`, `Senha`, `IP`) VALUES ('%s', '%s', '%s')", GetName(playerid), pInfo[playerid][pSenha], ip);

But i try and my lines is so long, can u help me to fix it?





--------------------------------------------------------------------------------------------------------------------------------------------

Код:

	format(query, sizeof(query), "INSERT INTO `factions` (`facname`, `membro1`, `membro2`, `membro3`, `membro4`, `membro5`, `membro6`, `membro7`, `membro8`, `membro9`, `membro10`, `membro11`, `membro12`, `membro13`, `membro14`, `membro15`, `cargo1`, `cargo2`, `cargo3`, `cargo4`, `cargo5`, `cargo6`, `cargo7`, `cargo8`, `cargo9`, `cargo10`, `cargo11`, `cargo12`, `cargo13`, `cargo14`, `cargo15`)
	VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d')"
	, 
		name, 
		seunome, 
		ept, 
		ept, 
		ept, 
		ept, 
		ept, 
		ept, 
		ept, 
		ept, 
		ept, 
		ept, 
		ept, 
		ept, 
		ept, 
		ept, 
		cargocinco, 
		cargozero, 
		cargozero, 
		cargozero, 
		cargozero, 
		cargozero, 
		cargozero, 
		cargozero, 
		cargozero, 
		cargozero, 
		cargozero, 
		cargozero, 
		cargozero, 
		cargozero, 
		cargozero, 
		cargozero);
	mysql_function_query(ConnectMYSQL,query,true,"r@MySQL_CreateFaction","d",playerid);