PDO não esta gravando no BD

[11closed 0]

olá pessoal estou tentando gravar os dados no BD, porém esta me retornando esse erro

Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in C:\wamp\www\.....\admin\adm\anuncio_config_promocao_alterando.php on line 160

array (size=3)
0 => string 'HY093' (length=5)
1 => null
2 => null

Essa é a pagina

$sql = "UPDATE $tabela23 SET PONTOS1 = :PONTOS1, 
			PONTOS2 = :PONTOS2,
			PONTOS3 = :PONTOS3,
			PONTOS4 = :PONTOS4,
			PONTOS5 = :PONTOS5,
			PONTOS6 = :PONTOS6,
			PONTOS7 = :PONTOS7,
			PONTOS8 = :PONTOS8,
			PONTOS9 = :PONTOS9,
			PONTOS10 = :PONTOS10,
			QTS_ADPACKS1 = :QTS_ADPACKS1,
			QTS_ADPACKS2 = :QTS_ADPACKS2,
			QTS_ADPACKS3 = :QTS_ADPACKS3,
			QTS_ADPACKS4 = :QTS_ADPACKS4,
			QTS_ADPACKS5 = :QTS_ADPACKS5,
			QTS_ADPACKS6 = :QTS_ADPACKS6,
			QTS_ADPACKS7 = :QTS_ADPACKS7,
			QTS_ADPACKS8 = :QTS_ADPACKS8,
			QTS_ADPACKS9 = :QTS_ADPACKS9,
			QTS_ADPACKS10 = :QTS_ADPACKS10,
			BONUS_COMPRA_ADPACKS1 = :BONUS_COMPRA_ADPACKS1,
			BONUS_COMPRA_ADPACKS2 = :BONUS_COMPRA_ADPACKS2,
			BONUS_COMPRA_ADPACKS3 = :BONUS_COMPRA_ADPACKS3,
			BONUS_COMPRA_ADPACKS4 = :BONUS_COMPRA_ADPACKS4,
			BONUS_COMPRA_ADPACKS5 = :BONUS_COMPRA_ADPACKS5,
			BONUS_COMPRA_ADPACKS6 = :BONUS_COMPRA_ADPACKS6,
			BONUS_COMPRA_ADPACKS7 = :BONUS_COMPRA_ADPACKS7,
			BONUS_COMPRA_ADPACKS8 = :BONUS_COMPRA_ADPACKS8,
			BONUS_COMPRA_ADPACKS9 = :BONUS_COMPRA_ADPACKS9,
			BONUS_COMPRA_ADPACKS10 = :BONUS_COMPRA_ADPACKS10,
			BONUS_BRINDE_ADPACKS1 = :BONUS_BRINDE_ADPACKS1,
			BONUS_BRINDE_ADPACKS2 = :BONUS_BRINDE_ADPACKS2,
			BONUS_BRINDE_ADPACKS3 = :BONUS_BRINDE_ADPACKS3,
			BONUS_BRINDE_ADPACKS4 = :BONUS_BRINDE_ADPACKS4,
			BONUS_BRINDE_ADPACKS5 = :BONUS_BRINDE_ADPACKS5,
			BONUS_BRINDE_ADPACKS6 = :BONUS_BRINDE_ADPACKS6,
			BONUS_BRINDE_ADPACKS7 = :BONUS_BRINDE_ADPACKS7,
			BONUS_BRINDE_ADPACKS8 = :BONUS_BRINDE_ADPACKS8,
			BONUS_BRINDE_ADPACKS9 = :BONUS_BRINDE_ADPACKS9,
			BONUS_BRINDE_ADPACKS10 = :BONUS_BRINDE_ADPACKS10,
			LIBERADO_PONTOS = :LIBERADO_PONTOS,
			LIBERADO_BRINDES = :LIBERADO_BRINDES
			WHERE ID = :ID"; 
				
	$stmt = $con->prepare($sql);   
 

	$stmt->bindParam(':PONTOS1', $qts_pontos1); 
	$stmt->bindParam(':PONTOS2', $qts_pontos2);
	$stmt->bindParam(':PONTOS3', $qts_pontos3);
	$stmt->bindParam(':PONTOS4', $qts_pontos4);
	$stmt->bindParam(':PONTOS5', $qts_pontos5);
	$stmt->bindParam(':PONTOS6', $qts_pontos6);
	$stmt->bindParam(':PONTOS7', $qts_pontos7);
	$stmt->bindParam(':PONTOS8', $qts_pontos8);
	$stmt->bindParam(':PONTOS9', $qts_pontos9);
	$stmt->bindParam(':PONTOS10', $qts_pontos10);
	
	$stmt->bindParam(':QTS_ADPACKS1', $qts_adpacks1);
	$stmt->bindParam(':QTS_ADPACKS2', $qts_adpacks2);
	$stmt->bindParam(':QTS_ADPACKS3', $qts_adpacks3);
	$stmt->bindParam(':QTS_ADPACKS4', $qts_adpacks4);
	$stmt->bindParam(':QTS_ADPACKS5', $qts_adpacks5);
	$stmt->bindParam(':QTS_ADPACKS6', $qts_adpacks6);
	$stmt->bindParam(':QTS_ADPACKS7', $qts_adpacks7);
	$stmt->bindParam(':QTS_ADPACKS8', $qts_adpacks8);
	$stmt->bindParam(':QTS_ADPACKS9', $qts_adpacks9);
	$stmt->bindParam(':QTS_ADPACKS10', $qts_adpacks10);
	
	$stmt->bindParam(':BONUS_COMPRA_ADPACKS1', $qts_adpacks_comprar1);
	$stmt->bindParam(':BONUS_COMPRA_ADPACKS2', $qts_adpacks_comprar2);
	$stmt->bindParam(':BONUS_COMPRA_ADPACKS3', $qts_adpacks_comprar3);
	$stmt->bindParam(':BONUS_COMPRA_ADPACKS4', $qts_adpacks_comprar4);
	$stmt->bindParam(':BONUS_COMPRA_ADPACKS5', $qts_adpacks_comprar5);
	$stmt->bindParam(':BONUS_COMPRA_ADPACKS6', $qts_adpacks_comprar6);
	$stmt->bindParam(':BONUS_COMPRA_ADPACKS7', $qts_adpacks_comprar7);
	$stmt->bindParam(':BONUS_COMPRA_ADPACKS8', $qts_adpacks_comprar8);
	$stmt->bindParam(':BONUS_COMPRA_ADPACKS9', $qts_adpacks_comprar9);
	$stmt->bindParam(':BONUS_COMPRA_ADPACKS10', $qts_adpacks_comprar10);

	$stmt->bindParam(':BONUS_BRINDE_ADPACKS1', $qts_adpacks_brinde1);
	$stmt->bindParam(':BONUS_BRINDE_ADPACKS2', $qts_adpacks_brinde2);
	$stmt->bindParam(':BONUS_BRINDE_ADPACKS3', $qts_adpacks_brinde3);
	$stmt->bindParam(':BONUS_BRINDE_ADPACKS4', $qts_adpacks_brinde4);
	$stmt->bindParam(':BONUS_BRINDE_ADPACKS5', $qts_adpacks_brinde5);
	$stmt->bindParam(':BONUS_BRINDE_ADPACKS6', $qts_adpacks_brinde6);
	$stmt->bindParam(':BONUS_BRINDE_ADPACKS7', $qts_adpacks_brinde7);
	$stmt->bindParam(':BONUS_BRINDE_ADPACKS8', $qts_adpacks_brinde8);
	$stmt->bindParam(':BONUS_BRINDE_ADPACKS9', $qts_adpacks_brinde9);
	$stmt->bindParam(':BONUS_BRINDE_ADPACKS10', $qts_adpacks_brinde10);
	
	$stmt->bindParam(':LIBERADO_PONTOS', $liberado_pontos);
	$stmt->bindParam(':LIBERADO_BRINDES', $liberado_brindes);

$result = $stmt->execute();

if ( ! $result )

{

var_dump( $stmt->errorInfo() );

exit;

}

 

já tentei varias formas, mas nenhuma esta dando certo

[ESerra 744]

De cara já vi o seguinte:

WHERE ID = :ID";

Em nenhum lugar você setou o :ID no bindparam...

[11closed 0]

putss, brigadão amigo, tinha passado despercebido

funcionou certinho aqui.. vlww