MantisBT - Piwigo
View Issue Details
0002342Piwigoweb APIpublic2011.06.14 13:502011.06.14 14:03
plg 
plg 
normalmajoralways
closedfixed 
2.2.2 
2.2.42.2.4 
any
Apache 1.3.x
0002342: [pwg.images.setInfo] default value for privacy level fails with MySQL 5.5
The default value is $leve = 0, but $level != '' then return false, which generate a "UPDATE images SET level = NULL..." which is an error with MySQL 5.5 because images.level can't be null.
No tags attached.
Issue History
2011.06.14 13:50plgNew Issue
2011.06.14 13:50plgStatusnew => assigned
2011.06.14 13:50plgAssigned To => plg
2011.06.14 13:50plgbrowser => any
2011.06.14 13:50plgWeb server => Apache 1.3.x
2011.06.14 14:02svnCheckin
2011.06.14 14:02svnNote Added: 0005230
2011.06.14 14:03svnCheckin
2011.06.14 14:03svnNote Added: 0005231
2011.06.14 14:03plgStatusassigned => closed
2011.06.14 14:03plgResolutionopen => fixed
2011.06.14 14:03plgFixed in Version => 2.2.4

Notes
(0005230)
svn   
2011.06.14 14:02   
[Subversion] r11363 by plg on branch 2.2

-----[Subversion commit log]----------------------------------------------------
bug 2342 fixed: with MySQL 5.5, "set level = NULL" fails because images.level
is a NOT NULL field. The same test is performed in the same function
(mass_updates) but for array bigger than 10 rows.
(0005231)
svn   
2011.06.14 14:03   
[Subversion] r11364 by plg on trunk

-----[Subversion commit log]----------------------------------------------------
merge r11363 from branch 2.2 to trunk

bug 2342 fixed: with MySQL 5.5, "set level = NULL" fails because images.level
is a NOT NULL field. The same test is performed in the same function
(mass_updates) but for array bigger than 10 rows.