{"action":"created","issue":{"url":"https://api.github.com/repos/sjarvela/mollify/issues/26","labels_url":"https://api.github.com/repos/sjarvela/mollify/issues/26/labels{/name}","comments_url":"https://api.github.com/repos/sjarvela/mollify/issues/26/comments","events_url":"https://api.github.com/repos/sjarvela/mollify/issues/26/events","html_url":"https://github.com/sjarvela/mollify/issues/26","id":119662817,"number":26,"title":"Searchfunction Request Failed","user":{"login":"basetrick","id":15939906,"avatar_url":"https://avatars.githubusercontent.com/u/15939906?v=3","gravatar_id":"","url":"https://api.github.com/users/basetrick","html_url":"https://github.com/basetrick","followers_url":"https://api.github.com/users/basetrick/followers","following_url":"https://api.github.com/users/basetrick/following{/other_user}","gists_url":"https://api.github.com/users/basetrick/gists{/gist_id}","starred_url":"https://api.github.com/users/basetrick/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/basetrick/subscriptions","organizations_url":"https://api.github.com/users/basetrick/orgs","repos_url":"https://api.github.com/users/basetrick/repos","events_url":"https://api.github.com/users/basetrick/events{/privacy}","received_events_url":"https://api.github.com/users/basetrick/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-12-01T07:59:16Z","updated_at":"2015-12-02T07:58:08Z","closed_at":null,"body":"Hello I've a Problem with the Searchfunction, i think the problem appear in the Database.\r\nThe Error will always appear, doesn't matter what i'm looking for.\r\n\r\nThank your for your Support \r\n\r\nPHP Error Log File:\r\n[01-Dec-2015 09:39:14 Europe/Helsinki] MOLLIFY ERROR: ServiceException: INVALID_CONFIGURATION=Error executing query (INSERT INTO mollify_item_id (id, path) VALUES ('565d4ea24ed1f','1:/Filialen/DE/01_Schule/02_Einschulung/08_Gespraechsbausteine/Datum Fazit.pdf')): Duplicate entry '1:/Vorort/DE/01_Schule/02_Einschulung/08_Gespraechsbausteine/Datum Fazit.pdf' for key 'path'\r\n\r\n[01-Dec-2015 09:39:14 Europe/Helsinki] MOLLIFY ERROR: {0:{file:C:\\xampp\\htdocs\\mollify\\backend\\db\\mysql\\MySQLIDatabase.class.php, line:165, function:query, class:MySQLIDatabase, type:->, args:{0:INSERT INTO mollify_item_id (id, path) VALUES ('565d4ea24ed1f','1:/Filialen/DE/01_Schule/02_Einschulung/08_Gespraechsbausteine/Datum Fazit.pdf')}}, 1:{file:C:\\xampp\\htdocs\\mollify\\backend\\include\\filesystem\\ItemIdProvider.class.php, line:97, function:update, class:MySQLIDatabase, type:->, args:{0:INSERT INTO mollify_item_id (id, path) VALUES ('565d4ea24ed1f','1:/Filialen/DE/01_Schule/02_Einschulung/08_Gespraechsbausteine/Datum Fazit.pdf}}, 2:{file:C:\\xampp\\htdocs\\mollify\\backend\\include\\filesystem\\ItemIdProvider.class.php, line:26, function:getOrCreateItemId, class:ItemIdProvider, type:->, args:{0:1:\\Filialen\\DE\\01_Personal\\02_Einarbeitung\\08_Gespraechsbausteine\\FL Filialführung Fazit.pdf}}, 3:{file:C:\\xampp\\htdocs\\mollify\\backend\\include\\filesystem\\MollifyFilesystem.class.php, line:72, function:getItemId, class:ItemIdProvider, type:->, args:{0:1:\\Filialen\\DE\\01_Personal\\02_Einarbeitung\\08_Gespraechsbausteine\\FL Filialführung Fazit.pdf}}, 4:{file:C:\\xampp\\htdocs\\mollify\\backend\\include\\filesystem\\LocalFilesystem.class.php, line:145, function:itemId, class:MollifyFilesystem, type:->, args:{0:Filialen\\DE\\01_Personal\\02_Einarbeitung\\08_Gespraechsbausteine\\FL Filialführung Fazit.pdf}}, 5:{file:C:\\xampp\\htdocs\\mollify\\backend\\include\\filesystem\\FilesystemItem.class.php, line:165, function:items, class:LocalFilesystem, type:->, args:{0:FILESYSTEMITEM Folder (LocalFilesystem): [565c6502b0600] = '08_Gespraechsbausteine' (Filialen\\DE\\01_Personal\\02_Einarbeitung\\08_Gespraechsbausteine\\)}}, 6:{file:C:\\xampp\\htdocs\\mollify\\backend\\include\\filesystem\\FilesystemController.class.php, line:1320, function:items, class:Folder, type:->, args:{}}, 7:{file:C:\\xampp\\htdocs\\mollify\\backend\\include\\filesystem\\FilesystemController.class.php, line:1336, function:searchRecursive, class:FilesystemController, type:->, args:{0:{FilesystemSearcher:{}}, 1:FILESYSTEMITEM Folder (LocalFilesystem): [565c6502b0600] = '08_Gespraechsbausteine' (Filialen\\DE\\01_Personal\\02_Einarbeitung\\08_Gespraechsbausteine\\), 2:brot}}, 8:{file:C:\\xampp\\htdocs\\mollify\\backend\\include\\filesystem\\FilesystemController.class.php, line:1336, function:searchRecursive, class:FilesystemController, type:->, args:{0:{FilesystemSearcher:{}}, 1:FILESYSTEMITEM Folder (LocalFilesystem): [565c6502a8b9c] = '02_Einarbeitung' (Filialen\\DE\\01_Personal\\02_Einarbeitung\\), 2:brot}}, 9:{file:C:\\xampp\\htdocs\\mollify\\backend\\include\\filesystem\\FilesystemController.class.php, line:1336, function:searchRecursive, class:FilesystemController, type:->, args:{0:{FilesystemSearcher:{}}, 1:FILESYSTEMITEM Folder (LocalFilesystem): [565c6502a54e3] = '01_Personal' (Filialen\\DE\\01_Personal\\), 2:brot}}, 10:{file:C:\\xampp\\htdocs\\mollify\\backend\\include\\filesystem\\FilesystemController.class.php, line:1336, function:searchRecursive, class:FilesystemController, type:->, args:{0:{FilesystemSearcher:{}}, 1:FILESYSTEMITEM Folder (LocalFilesystem): [565c6502a0d1f] = 'DE' (Filialen\\DE\\), 2:brot}}, 11:{file:C:\\xampp\\htdocs\\mollify\\backend\\include\\filesystem\\FilesystemController.class.php, line:1336, function:searchRecursive, class:FilesystemController, type:->, args:{0:{FilesystemSearcher:{}}, 1:FILESYSTEMITEM Folder (LocalFilesystem): [565c64e8aadb5] = 'Filialen' (Filialen\\), 2:brot}}, 12:{file:C:\\xampp\\htdocs\\mollify\\backend\\include\\filesystem\\FilesystemController.class.php, line:1297, function:searchRecursive, class:FilesystemController, type:->, args:{0:{FilesystemSearcher:{}}, 1:FILESYSTEMITEM Folder (LocalFilesystem): [565c64d985d26] = 'Filialportal' (), 2:brot}}, 13:{file:C:\\xampp\\htdocs\\mollify\\backend\\include\\services\\FilesystemServices.class.php, line:54, function:search, class:FilesystemController, type:->, args:{0:, 1:brot, 2:{parent-metadata:{}, core-file-modified:{}}}}, 14:{file:C:\\xampp\\htdocs\\mollify\\backend\\include\\services\\ServicesBase.class.php, line:59, function:processPost, class:FilesystemServices, type:->, args:{}}, 15:{file:C:\\xampp\\htdocs\\mollify\\backend\\include\\MollifyBackend.class.php, line:85, function:processRequest, class:ServicesBase, type:->, args:{}}, 16:{file:C:\\xampp\\htdocs\\mollify\\backend\\r.php, line:81, function:processRequest, class:MollifyBackend, type:->, args:{0:Request}}}\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/sjarvela/mollify/issues/comments/161213344","html_url":"https://github.com/sjarvela/mollify/issues/26#issuecomment-161213344","issue_url":"https://api.github.com/repos/sjarvela/mollify/issues/26","id":161213344,"user":{"login":"sjarvela","id":200035,"avatar_url":"https://avatars.githubusercontent.com/u/200035?v=3","gravatar_id":"","url":"https://api.github.com/users/sjarvela","html_url":"https://github.com/sjarvela","followers_url":"https://api.github.com/users/sjarvela/followers","following_url":"https://api.github.com/users/sjarvela/following{/other_user}","gists_url":"https://api.github.com/users/sjarvela/gists{/gist_id}","starred_url":"https://api.github.com/users/sjarvela/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sjarvela/subscriptions","organizations_url":"https://api.github.com/users/sjarvela/orgs","repos_url":"https://api.github.com/users/sjarvela/repos","events_url":"https://api.github.com/users/sjarvela/events{/privacy}","received_events_url":"https://api.github.com/users/sjarvela/received_events","type":"User","site_admin":false},"created_at":"2015-12-02T07:58:08Z","updated_at":"2015-12-02T07:58:08Z","body":"I've seen this only on Windows hosts, ultimately the reason is that system tries to create new item id with path that already exists. This really should not happen, because it creates only if one does not exist (so if it does end up creating new, why would database claim it does).\r\n\r\nAnd the error is also bit confusing, the query made is this:\r\n\r\n    INSERT INTO mollify_item_id (id, path) VALUES ('565d4ea24ed1f','1:/Filialen/DE/01_Schule/02_Einschulung/08_Gespraechsbausteine/Datum Fazit.pdf')): \r\n\r\nbut error is \r\n\r\n    Duplicate entry '1:/Vorort/DE/01_Schule/02_Einschulung/08_Gespraechsbausteine/Datum Fazit.pdf' for key 'path'\r\n\r\nThe path is different in error and in query, it makes no sense...are both paths valid (\"Vorort/...\" and \"Filialen/...\")?\r\n\r\nSounds like database would use primary key check only with n chars from the right, which would then seem like matching...\r\n\r\n"}}