{"action":"created","issue":{"url":"https://api.github.com/repos/bolt/bolt/issues/5612","repository_url":"https://api.github.com/repos/bolt/bolt","labels_url":"https://api.github.com/repos/bolt/bolt/issues/5612/labels{/name}","comments_url":"https://api.github.com/repos/bolt/bolt/issues/5612/comments","events_url":"https://api.github.com/repos/bolt/bolt/issues/5612/events","html_url":"https://github.com/bolt/bolt/issues/5612","id":168676599,"number":5612,"title":"Bold 3.0.11 – Taxonomy from Bolt 2.X error – content may be created, but reopening for edit is not possible","user":{"login":"lexislav","id":7147349,"avatar_url":"https://avatars.githubusercontent.com/u/7147349?v=3","gravatar_id":"","url":"https://api.github.com/users/lexislav","html_url":"https://github.com/lexislav","followers_url":"https://api.github.com/users/lexislav/followers","following_url":"https://api.github.com/users/lexislav/following{/other_user}","gists_url":"https://api.github.com/users/lexislav/gists{/gist_id}","starred_url":"https://api.github.com/users/lexislav/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lexislav/subscriptions","organizations_url":"https://api.github.com/users/lexislav/orgs","repos_url":"https://api.github.com/users/lexislav/repos","events_url":"https://api.github.com/users/lexislav/events{/privacy}","received_events_url":"https://api.github.com/users/lexislav/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-08-01T15:40:18Z","updated_at":"2016-08-02T09:43:43Z","closed_at":null,"body":"I am updating older website from Bolt 2.X to Bolt 3.0.11.\r\nThe same taxonomy definition does'n work in bolt 3.0.11.\r\nThe issue can be easily replicated by adding taxonomy bellow to clean Bolt3 install, for exampel to Entries.\r\n\r\nWhen saving content, the Error message appears, but the content is saved.\r\nListed contetnt cann't be reopened for edit – error message again.\r\n\r\nAny ideas how to fix this is very wellcome.\r\nWorked like charm in 2.X…\r\n\r\n\r\nDetails\r\n-------\r\n\r\nBug „works“ on localhost (MAMP) and on production server as well.\r\n\r\n - Relevant Bolt Version: [ 3.0.11 | 2.X ]\r\n - Install type: [ Composer install ]\r\n - PHP version: [ 7.0.0 / 5.5 ]\r\n - Used webservers: [ MAMP/Apache + Apache on server ]\r\n\r\n\r\nCritical taxonomy definition in my taxonomy.yml:\r\n\r\n```\r\ndruhy-peciva:\r\n    name: Druhy pečiva\r\n    slug: druhy-peciva\r\n    singular_name: Druh pečiva\r\n    singular_slug: druh-peciva\r\n    behaves_like: categories\r\n    multiple: true\r\n    options: { chleby: \"Chleby\", bagety: \"Bagety\", bile-pecivo: \"Rohlíky, housky, hvězdičky\", banketni-pecivo: \"Banketní pečivo\", sladke-pecivo: \"Koláče, buchty a další sladkosti\", vicezrne-pecivo: \"Vícezrné pečivo\" }\r\n    has_sortorder: true\r\n```\r\n\r\nReproduction\r\n------------\r\n\r\nError message\r\n------------\r\n```\r\nSyntaxErrorException in AbstractMySQLDriver.php line 90:\r\nAn exception occurred while executing 'SELECT content.*, \r\nGROUP_CONCAT(incomingrelation.id) as _incomingrelation_id, \r\nGROUP_CONCAT(incomingrelation.from_id) as _incomingrelation_fromid, \r\nGROUP_CONCAT(incomingrelation.from_contenttype) as _incomingrelation_fromcontenttype, \r\nGROUP_CONCAT(druhy-peciva.sortorder ORDER BY druhy-peciva.sortorder ASC) as _druhy-peciva_sortorder, \r\nGROUP_CONCAT(druhy-peciva.id ORDER BY druhy-peciva.sortorder ASC) as _druhy-peciva_id, \r\nGROUP_CONCAT(druhy-peciva.slug ORDER BY druhy-peciva.sortorder ASC) as _druhy-peciva_slug, \r\nGROUP_CONCAT(druhy-peciva.name ORDER BY druhy-peciva.sortorder ASC) as _druhy-peciva_name, \r\nGROUP_CONCAT(druhy-peciva.taxonomytype ORDER BY druhy-peciva.sortorder ASC) as _druhy-peciva_taxonomytype, \r\nGROUP_CONCAT(DISTINCT CONCAT_WS('_', f_hmotnost.name, f_hmotnost.grouping, f_hmotnost.id)) as hmotnost \r\nFROM bolt_pecivo content \r\nLEFT JOIN bolt_relations incomingrelation ON content.id = incomingrelation.to_id AND incomingrelation.to_contenttype='pecivo' \r\nLEFT JOIN bolt_taxonomy druhy-peciva ON content.id = druhy-peciva.content_id AND druhy-peciva.contenttype='pecivo' AND druhy-peciva.taxonomytype='druhy-peciva' \r\nLEFT JOIN bolt_field_value f_hmotnost ON f_hmotnost.content_id = content.id AND f_hmotnost.contenttype='pecivo' AND f_hmotnost.name = 'hmotnost' \r\nWHERE content.id = ? GROUP BY content.id, content.id' with params [\"1\"]:\r\n\r\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; \r\ncheck the manual that corresponds to your MySQL server version for the right syntax to use near \r\n'-peciva_sortorder, GROUP_CONCAT(druhy-peciva.id ORDER BY druhy-peciva.sortorder ' at line 1\r\n```"},"comment":{"url":"https://api.github.com/repos/bolt/bolt/issues/comments/236855832","html_url":"https://github.com/bolt/bolt/issues/5612#issuecomment-236855832","issue_url":"https://api.github.com/repos/bolt/bolt/issues/5612","id":236855832,"user":{"login":"SahAssar","id":5096632,"avatar_url":"https://avatars.githubusercontent.com/u/5096632?v=3","gravatar_id":"","url":"https://api.github.com/users/SahAssar","html_url":"https://github.com/SahAssar","followers_url":"https://api.github.com/users/SahAssar/followers","following_url":"https://api.github.com/users/SahAssar/following{/other_user}","gists_url":"https://api.github.com/users/SahAssar/gists{/gist_id}","starred_url":"https://api.github.com/users/SahAssar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SahAssar/subscriptions","organizations_url":"https://api.github.com/users/SahAssar/orgs","repos_url":"https://api.github.com/users/SahAssar/repos","events_url":"https://api.github.com/users/SahAssar/events{/privacy}","received_events_url":"https://api.github.com/users/SahAssar/received_events","type":"User","site_admin":false},"created_at":"2016-08-02T09:43:43Z","updated_at":"2016-08-02T09:43:43Z","body":"@lexislav Yeah, we have some issues with dashes/hyphens and underscores in slugs/keys... If you change druhy_peciva to druhypeciva it should work for you, see #5490 and #5601"}}
{"actor":{"display_login":"SahAssar"}}