OC 5.0.0 RC3 - Problem with mimetype for MSI

[kwiatek6324]

Hi, If in my repo is .msi file there is exception for this:

Fatal error: Uncaught exception 'DatabaseException' with message 'MDB2 Error: unknown error' in /home/spool/cloud/owncloud/lib/db.php:376 Stack trace: #0 /home/spool/cloud/owncloud/lib/db.php(409): OC_DB::prepare('SELECT lastval(...') #1 /home/spool/cloud/owncloud/lib/files/cache/cache.php(85): OC_DB::insertid('_PREFIX_mimetyp...') #2 /home/spool/cloud/owncloud/lib/files/cache/cache.php(243): OC\Files\Cache\Cache->getMimetypeId('') #3 /home/spool/cloud/owncloud/lib/files/cache/cache.php(199): OC\Files\Cache\Cache->buildParts(Array) #4 /home/spool/cloud/owncloud/lib/files/cache/scanner.php(85): OC\Files\Cache\Cache->put('files/Pobrane/o...', Array) #5 /home/spool/cloud/owncloud/lib/files/cache/scanner.php(111): OC\Files\Cache\Scanner->scanFile('files/Pobrane/o...', true) #6 /home/spool/cloud/owncloud/lib/files/view.php(754): OC\Files\Cache\Scanner->scan('files/Pobrane', false) #7 /home/spool/cloud/owncloud/lib/files/filesystem.php(621): OC\Files\View->getDirectoryContent('//Pobrane') #8 /home/spool/cloud/owncloud/apps/file in /home/spool/cloud/owncloud/lib/db.php on line 376

Below is SQL log:

statement: EXECUTE mdb2_statement_pgsql_15302e8ea67dc53822987db49043796ef717b291a2 (NULL)
DETAIL: prepare: SELECT "id" FROM "oc_mimetypes" WHERE "mimetype" = $1
LOG: duration: 0.104 ms
LOG: statement: EXECUTE mdb2_statement_pgsql_1756866fdc274c3dc69f9fe244f808a8a76266bab0 (NULL)
DETAIL: prepare: INSERT INTO "oc_mimetypes"("mimetype") VALUES($1)
ERROR: null value in column "mimetype" violates not-null constraint
STATEMENT: EXECUTE mdb2_statement_pgsql_1756866fdc274c3dc69f9fe244f808a8a76266bab0 (NULL)
LOG: statement: EXECUTE mdb2_statement_pgsql_186c0e3a1143a249d421909b0483a347a063086e7d
DETAIL: prepare: SELECT lastval() AS id
ERROR: current transaction is aborted, commands ignored until end of transaction block

And this is file result for this msi;

file -b --mime-type officesip-messenger-2.2.msi 2>/dev/null
application/msword

full output:

officesip-messenger-2.2.msi: Composite Document File V2 Document, Little Endian, Os: Windows, Version 6.0, Create Time/Date: Mon Jun 21 08:00:00 1999, Name of Creating Application: Windows Installer, Security: 1, Code page: 1252, Template: Intel;1033, Number of Pages: 200, Revision Number: {F8D45010-9940-48C2-B1EC-25618EA33C27}, Title: OfficeSIP Messenger, Author: OfficeSIP Communications, Keywords: SIP,Communicator,Messenger,Chat, Number of Words: 2, Last Saved Time/Date: Wed Apr 25 22:07:59 2012, Last Printed: Wed Apr 25 22:07:59 2012

There is also info on page:

Fatal error: Call to undefined method MDB2_Error::fetchRow() in /home/spool/cloud/owncloud/lib/db.php on line 410

Regards
AK

[BernhardPosselt]

@DeepDiver1975 @bartv2 @icewind1991

[DeepDiver1975]

This is again empty string as null value issue.

[tanghus]

This is again empty string as null value issue.

Fixed by #2371 ?

But then again if we switch to doctrine mdb2 would be out of the game

[BernhardPosselt]

@kwiatek6324 can you test it again with #2389

[kwiatek6324]

Hi. Now i'm using 5.0. In this version problem doesn't exists.

Regards
AK