Forums / Suggestions / Bug in kernel/classes/datatypes/ezimage/ezimagefile.php

Bug in kernel/classes/datatypes/ezimage/ezimagefile.php

Next topic

Author	Message
Frank Miedreich	Friday 08 April 2011 5:24:07 am In version 4.4 (and earlier) on line 113 of file kernel/classes/datatypes/ezimage/ezimagefile.php is a bug in the sql statement: The query uses mysql specific syntax "LIMIT 1" on the query, this will break when you use oracle as your database. For oracle this should read "AND ROWNUM = 1" to achieve the same effect. I tried to find a place to file bug reports but failed. So I hope some developer with commit rights finds this here. cheers, Frank
Chen Xiongjie	Friday 08 April 2011 6:37:30 am It's fixed in 4.5. I'm sure the fix works on previous versions: https://github.com/ezsystems/ezpublish/commit/7679cbb18a46d7635be34a532029206ba42a489c Public issue: http://issues.ez.no/018040 eZ Comments: http://projects.ez.no/ezcomments twitter: http://twitter.com/xiongjie

Author

Message

Friday 08 April 2011 5:24:07 am

In version 4.4 (and earlier) on line 113 of file kernel/classes/datatypes/ezimage/ezimagefile.php is a bug in the sql statement:

The query uses mysql specific syntax "LIMIT 1" on the query, this will break when you use oracle as your database. For oracle this should read "AND ROWNUM = 1" to achieve the same effect.

I tried to find a place to file bug reports but failed. So I hope some developer with commit rights finds this here.

cheers, Frank

Chen Xiongjie

Friday 08 April 2011 6:37:30 am

It's fixed in 4.5.

I'm sure the fix works on previous versions: https://github.com/ezsystems/ezpublish/commit/7679cbb18a46d7635be34a532029206ba42a489c

Public issue: http://issues.ez.no/018040

eZ Comments: http://projects.ez.no/ezcomments
twitter: http://twitter.com/xiongjie