{"action":"created","issue":{"url":"https://api.github.com/repos/isotope/core/issues/1916","repository_url":"https://api.github.com/repos/isotope/core","labels_url":"https://api.github.com/repos/isotope/core/issues/1916/labels{/name}","comments_url":"https://api.github.com/repos/isotope/core/issues/1916/comments","events_url":"https://api.github.com/repos/isotope/core/issues/1916/events","html_url":"https://github.com/isotope/core/issues/1916","id":294388103,"number":1916,"title":"Isotope Update Fehler: Duplicate entry uniqid in Tabelle tl_iso_product_collection","user":{"login":"steve-smart","id":36159466,"avatar_url":"https://avatars3.githubusercontent.com/u/36159466?v=4","gravatar_id":"","url":"https://api.github.com/users/steve-smart","html_url":"https://github.com/steve-smart","followers_url":"https://api.github.com/users/steve-smart/followers","following_url":"https://api.github.com/users/steve-smart/following{/other_user}","gists_url":"https://api.github.com/users/steve-smart/gists{/gist_id}","starred_url":"https://api.github.com/users/steve-smart/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/steve-smart/subscriptions","organizations_url":"https://api.github.com/users/steve-smart/orgs","repos_url":"https://api.github.com/users/steve-smart/repos","events_url":"https://api.github.com/users/steve-smart/events{/privacy}","received_events_url":"https://api.github.com/users/steve-smart/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-02-05T13:13:05Z","updated_at":"2018-02-06T13:50:33Z","closed_at":null,"author_association":"NONE","body":"Fehlermeldung bei Update von Contao 3.2.16 mit Isotope 2.1.9 auf Contao 3.5.33 mit Isotope 2.4.5:\r\n\r\nFatal error: Uncaught exception Exception with message Query error: Duplicate entry '' for key 'uniqid' (ALTER TABLE `tl_iso_product_collection` ADD UNIQUE KEY `uniqid` (`uniqid`);) thrown in system/modules/core/library/Contao/Database/Statement.php on line 295\r\n\r\nDas Feld uniqid enthält für alle Bestellungen (type = oder) jeweils unterschiedliche Einträge.\r\nEs gibt jedoch auch Zeilen mit type = cart statt type = order - das sind wohl Warenkörbe, die befüllt wurden, aber die Bestellung nicht abgeschlosssen wurde. Dort ist das Feld uniqid leer.\r\nDas führt wohl dazu, dass der obige ALTER TABLE Befehl nicht ausgeführt werden kann (Duplicate entry).\r\n\r\nSiehe auch:\r\nhttps://community.contao.org/de/showthread.php?69661-Isotope-Update-Fehler-Duplicate-entry-uniqid-in-Tabelle-tl_iso_product_collection"},"comment":{"url":"https://api.github.com/repos/isotope/core/issues/comments/363427645","html_url":"https://github.com/isotope/core/issues/1916#issuecomment-363427645","issue_url":"https://api.github.com/repos/isotope/core/issues/1916","id":363427645,"user":{"login":"steve-smart","id":36159466,"avatar_url":"https://avatars3.githubusercontent.com/u/36159466?v=4","gravatar_id":"","url":"https://api.github.com/users/steve-smart","html_url":"https://github.com/steve-smart","followers_url":"https://api.github.com/users/steve-smart/followers","following_url":"https://api.github.com/users/steve-smart/following{/other_user}","gists_url":"https://api.github.com/users/steve-smart/gists{/gist_id}","starred_url":"https://api.github.com/users/steve-smart/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/steve-smart/subscriptions","organizations_url":"https://api.github.com/users/steve-smart/orgs","repos_url":"https://api.github.com/users/steve-smart/repos","events_url":"https://api.github.com/users/steve-smart/events{/privacy}","received_events_url":"https://api.github.com/users/steve-smart/received_events","type":"User","site_admin":false},"created_at":"2018-02-06T13:50:33Z","updated_at":"2018-02-06T13:50:33Z","author_association":"NONE","body":"Habe heute das obige Update noch einmal auf andere Wesie durchgeführt. Wieder kam es zur obigen Fehlermeldung. Ein manuelles Ausführen von\r\nUPDATE tl_iso_product_collection SET uniqid = NULL WHERE uniqid = \"\";\r\nführt dazu, dass die DB danach korrekt aktualisiert werden kann.\r\n\r\nEs scheint also ein Bug zu sein, dass die runonce.php nicht ausgeführt wird.\r\n\r\nWenn die runonce.php nicht ausgeführt wird: Ist der obige UPDATE Befehl das einzige, was darüber angestoßen wird oder könnte das Update auch im Bezug auf andere Dinge unvollständig/defekt sein?\r\n"}}
{"actor":{"display_login":"steve-smart"}}