{"action":"created","issue":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/9534","repository_url":"https://api.github.com/repos/joomla/joomla-cms","labels_url":"https://api.github.com/repos/joomla/joomla-cms/issues/9534/labels{/name}","comments_url":"https://api.github.com/repos/joomla/joomla-cms/issues/9534/comments","events_url":"https://api.github.com/repos/joomla/joomla-cms/issues/9534/events","html_url":"https://github.com/joomla/joomla-cms/issues/9534","id":142811490,"number":9534,"title":"Error when saving file after updating to Joomla 3.5","user":{"login":"ggeorgg","id":13244552,"avatar_url":"https://avatars.githubusercontent.com/u/13244552?v=3","gravatar_id":"","url":"https://api.github.com/users/ggeorgg","html_url":"https://github.com/ggeorgg","followers_url":"https://api.github.com/users/ggeorgg/followers","following_url":"https://api.github.com/users/ggeorgg/following{/other_user}","gists_url":"https://api.github.com/users/ggeorgg/gists{/gist_id}","starred_url":"https://api.github.com/users/ggeorgg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ggeorgg/subscriptions","organizations_url":"https://api.github.com/users/ggeorgg/orgs","repos_url":"https://api.github.com/users/ggeorgg/repos","events_url":"https://api.github.com/users/ggeorgg/events{/privacy}","received_events_url":"https://api.github.com/users/ggeorgg/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":19,"created_at":"2016-03-22T23:36:11Z","updated_at":"2016-03-23T00:46:55Z","closed_at":null,"body":"#### Steps to reproduce the issue\r\nUpdate Joomla 3.4 with Joomla-Updater\r\nOpen an article and save it.\r\n\r\n#### Expected result\r\nNo error messages.\r\n\r\n#### Actual result\r\ngetting the following error:\r\n\r\n`Fehler\r\nSpeichern fehlgeschlagen! Fehler: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-11' for key 'PRIMARY'`\r\n\r\n#### System information (as much as possible)\r\nPHP 7.0 as CGI\r\nMySQL 5.5.46\r\n\r\n#### Additional comments\r\nThe good thing is: The article is saved to the database even if I get this error. \r\n\r\nHow can I figure out where I have duplicate entries? How did this happen? Has it something to do with my recent update of Joomla to 3.5?\r\nHow can I solve this problem or should I just use a backup and try again?\r\n"},"comment":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/comments/200096581","html_url":"https://github.com/joomla/joomla-cms/issues/9534#issuecomment-200096581","issue_url":"https://api.github.com/repos/joomla/joomla-cms/issues/9534","id":200096581,"user":{"login":"chrisdavenport","id":305153,"avatar_url":"https://avatars.githubusercontent.com/u/305153?v=3","gravatar_id":"","url":"https://api.github.com/users/chrisdavenport","html_url":"https://github.com/chrisdavenport","followers_url":"https://api.github.com/users/chrisdavenport/followers","following_url":"https://api.github.com/users/chrisdavenport/following{/other_user}","gists_url":"https://api.github.com/users/chrisdavenport/gists{/gist_id}","starred_url":"https://api.github.com/users/chrisdavenport/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chrisdavenport/subscriptions","organizations_url":"https://api.github.com/users/chrisdavenport/orgs","repos_url":"https://api.github.com/users/chrisdavenport/repos","events_url":"https://api.github.com/users/chrisdavenport/events{/privacy}","received_events_url":"https://api.github.com/users/chrisdavenport/received_events","type":"User","site_admin":false},"created_at":"2016-03-23T00:46:55Z","updated_at":"2016-03-23T00:46:55Z","body":"Yes, the problem is definitely the Smart Search tables.  I think you have a couple of words which used to have separate index entries but which are now causing a collision.  It could be something like one uses ß but the other uses ss (although I thought we'd resolved that one; that's why the finder tables are utf8mb4_general_ci but the other tables are utf8mb4_unicode_ci)."}}