On Windows 7x64, PHP 5.3.5, MySQL 5.5.9 x64, updating a pdf report with emailMe=0 fails and gives :
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'email_me' at row 1
The problem seems to be located at plugins/PDFReports/API.php#L105.
In the API call, when
When using the PDFReport UI and unticking the email me checkbox, the request to the API is made with emailMe=0 and displays the SQL error. Same is true for plugins/PDFReports/tests/PDFReports.test.php#L131
It seems to be related to http://framework.zend.com/issues/browse/ZF-1457
isn't the first case also a problem?
Does Snover's July '09 patch work? (We won't be upgrading to ZF2 because it requires php 5.3 features.)
(In [4549]) refs #2360
The patch for Zend Framework does work but not in all cases.
When an insert statement is cached core/Db/Adapter/Pdo/Mysql.php#L182, it does not go through core/Db/Adapter/Pdo/Mysql.php#L193, hence, doesn't go through libs/Zend/Db/Adapter/Pdo/Abstract.php#L228 where the patch is applied.
(In [4551]) Refs #2360 does this fix it Julien? on my box it works before so I cant tell
This patch works. Shouldn't this be done in a more generic way ?
Also, (int)'true' equals 0, but I guess it's ok.
It should, but if the bug is in Zend there is not much we can do appart from submitting them the patch ;-)