We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.

Phalcon 2.0, Error:[Column type does not support scale parameter], column type is double(14,2)

As title, same code works very well in 1.3.4. When use 2.0, phalcon will throw this message [Column type does not support scale parameter]!

use float in filter before update or create



5.4k

Float is differenet from double in [accuracy]. I think this might be a bug of 2.0.



5.4k

Is this a bug?

same issue was solved in 1.3.0 https://github.com/phalcon/cphalcon/issues/1482

seems to be an old bug

I have same problem.



5.4k
Accepted
answer

This is a bug and it will be fixed in 2.0.x.

In 2.0.1, this bug still happen.

The same issue :(. How can I fixed it.



5.4k

Currently, you can change your column type to [decimal].

@megaxman: This is my problem I use project on Window (add dll file) -> It work. I develop project on Linux -> "Column type does not support......" Now, I will change the column type to decimal :) Thank you so much.

If this bug still happend in 2.0.3, my boss force me to change framework.

Bug fixes have been submitted here:

But collaborators didn't add unit tests so those weren't merged

I ever try this before but this fix still didn't work for me. My environment is 64 bits Ubuntu 14.04. Apache/2.4.12 and PHP 5.6.9.

Bug fixes have been submitted here:

But collaborators didn't add unit tests so those weren't merged

edited May '15

I had same errors with you. But I change the column type double -> decimal. It's fixed now.

I researched an other way to fix it. add some line into source phalcon (phalcon/db/adapter/pdo/mysql.zep). You can try at https://github.com/phalcon/cphalcon/issues/1482.

I ever try this before but this fix still didn't work for me. My environment is 64 bits Ubuntu 14.04. Apache/2.4.12 and PHP 5.6.9.

Bug fixes have been submitted here:

But collaborators didn't add unit tests so those weren't merged

I can't change it and with this code, my problem is still.

I had same errors with you. But I change the column type double -> decimal. It's fixed now.

I researched an other way to fix it. add some line into source phalcon (phalcon/db/adapter/pdo/mysql.zep). You can try at https://github.com/phalcon/cphalcon/issues/1482.

I ever try this before but this fix still didn't work for me. My environment is 64 bits Ubuntu 14.04. Apache/2.4.12 and PHP 5.6.9.

Bug fixes have been submitted here:

But collaborators didn't add unit tests so those weren't merged

It's fixed in master and 2.0.x branch.