Why do I get :yp15 in query scope

Archives Yii 1.0.x Discussions
1 

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1366 Incorrect decimal value: '90,000.00' for column 'valor_compra' at row 1INSERT INTO `imovel` (`condominio`, `aluguel`, `valor_compra`, `rascunho`, `nome`, `descricao`, `qtd_quartos`, `precisa_reforma`, `rua`, `cep`, `complemento`, `bloco`, `referencia`, `localizacaoid`, `categoriaid`, `createdDate`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15)

I know that there is a problem with my query data however I get different kind of exception in other computer.

It`s it normal or I forgot some detail when configurating my files?

2

Your decimal value should not contain a ",".

3

Yeah, I wanted it to get wrong. but I need to know why INSERT statement is coming together with exception Message. It looks like it was placed there in wrong way. I want to know if I have a problem with some configuration or it’s normal :)

Thank you