-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Medium
-
Affects Version/s: 3.6.2
-
Component/s: Import / Export [Deprecated]
-
Environment:
environment doesn't matter
-
3.06
Newer Bugzilla versions support PostgreSQL as bug database. The 'attachments' table has a field 'thedata' of
type 'bytea'.
Now PostgreSQL has two ways of storing BLOBs, see:
http://jdbc.postgresql.org/documentation/80/binary-data.html
The code in 'BugzillaImportBean.java' assumes the wrong one. So the code:
final Blob fileData = resultsSet.getBlob('thedata');
failes with the exception:
"Bad value for type int: <binary data>"
I provide a fast patch for 'BugzillaImportBean.java' for those few out there which happen to have run Bugzilla with PostgreSQL. ![]()