Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

BLOBS save incorrectly in phalcon 3.4 and php 7.2 #13423

Closed
jymboche opened this Issue Jul 2, 2018 · 1 comment

Comments

Projects
None yet
2 participants
@jymboche
Copy link
Contributor

jymboche commented Jul 2, 2018

Expected and Actual Behavior

Saving data to a BLOB column using the Mysql adapter in phalcon 3.4 and php 7.2 results in the blob incorrectly being saved as "1".

Mysql.zep here shows the bind type for TinyBlob being set to BOOL, even though TinyBlobs should support up to 255 chars of course

} elseif memstr(columnType, "tinyblob") {
/**
* Tinyblob
*/
let definition["type"] = Column::TYPE_TINYBLOB,
definition["bindType"] = Column::BIND_PARAM_BOOL;
} elseif memstr(columnType, "mediumblob") {
/**
* Mediumblob
*/
let definition["type"] = Column::TYPE_MEDIUMBLOB;
} elseif memstr(columnType, "longblob") {

I'm unsure why I dont experience this in 7.1.x php releases....

Details

  • Phalcon version: 3.4.0
  • PHP Version: 7.2.7
  • Operating System: docker php:7.2.7-fpm
  • Installation type: Compiled from source
  • Other related info (Database, table schema):

@jymboche jymboche referenced this issue Jul 2, 2018

Merged

removes incorrect mysql tinyblob bindtype #13424

2 of 3 tasks complete

@sergeyklay sergeyklay added the Bug - Low label Jul 2, 2018

@sergeyklay sergeyklay added this to the 3.4.1 milestone Jul 2, 2018

@sergeyklay

This comment has been minimized.

Copy link
Member

sergeyklay commented Jul 3, 2018

Fixed in the 3.4.x branch. Feel free to open a new issue if the problem appears again. Thank you for contributing.

@sergeyklay sergeyklay closed this Jul 3, 2018

@sergeyklay sergeyklay self-assigned this Jul 3, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.