{"action":"created","issue":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12243","repository_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin","labels_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12243/labels{/name}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12243/comments","events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12243/events","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/12243","id":154071026,"number":12243,"title":"Invalid sql with export import","user":{"login":"bazzaxiv","id":8702037,"avatar_url":"https://avatars.githubusercontent.com/u/8702037?v=3","gravatar_id":"","url":"https://api.github.com/users/bazzaxiv","html_url":"https://github.com/bazzaxiv","followers_url":"https://api.github.com/users/bazzaxiv/followers","following_url":"https://api.github.com/users/bazzaxiv/following{/other_user}","gists_url":"https://api.github.com/users/bazzaxiv/gists{/gist_id}","starred_url":"https://api.github.com/users/bazzaxiv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bazzaxiv/subscriptions","organizations_url":"https://api.github.com/users/bazzaxiv/orgs","repos_url":"https://api.github.com/users/bazzaxiv/repos","events_url":"https://api.github.com/users/bazzaxiv/events{/privacy}","received_events_url":"https://api.github.com/users/bazzaxiv/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":{"login":"nijel","id":212189,"avatar_url":"https://avatars.githubusercontent.com/u/212189?v=3","gravatar_id":"","url":"https://api.github.com/users/nijel","html_url":"https://github.com/nijel","followers_url":"https://api.github.com/users/nijel/followers","following_url":"https://api.github.com/users/nijel/following{/other_user}","gists_url":"https://api.github.com/users/nijel/gists{/gist_id}","starred_url":"https://api.github.com/users/nijel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nijel/subscriptions","organizations_url":"https://api.github.com/users/nijel/orgs","repos_url":"https://api.github.com/users/nijel/repos","events_url":"https://api.github.com/users/nijel/events{/privacy}","received_events_url":"https://api.github.com/users/nijel/received_events","type":"User","site_admin":false},"milestone":null,"comments":9,"created_at":"2016-05-10T18:10:13Z","updated_at":"2016-05-23T06:41:01Z","closed_at":null,"body":"### Steps to reproduce\r\n1.Export database\r\n2.Import database\r\n3.\r\n\r\n### Expected behaviour\r\nThe exported .sql should be imported without error\r\n\r\n### Actual behaviour\r\nErrors are generated during import. The errors occur because the exported data is incorrect. See here - \r\n\r\n```\r\nCREATE TABLE `a3gj6_categories` (\r\n  `id` int(11) NOT NULL,\r\n  `asset_id` int(10) UNSIGNED NOT NULL DEFAULT '0'COMMENT\r\n) ;\r\n```\r\n\r\n. The problem is there is no space between the '0' and COMMENT and the rest of the table is not exported. Not all commented rows were affected and I could see no connection between the ones that were. By a trial and test method I removed all offending comments from the database until it exported the DB with all CREATE TABLE entries complete.\r\nWhen I imported this DB it errored again when filling a table.\r\nThe data was\r\n(7, 1, 15, 20, 1, 'com_contact', 'com_contact', '{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),\r\nbut the error message says it is\r\n(7, 1, 15, 20, 1, 'com_contact', 'com_contact', '{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":[],\"core.delete\":[...]\r\n\r\n\r\n### Server configuration\r\n**Operating system**:\r\nFedora 22\r\n**Web server:**\r\nApache 2.4.18\r\n**Database:**\r\nMariaDB 10.0.23\r\n**PHP version:**\r\n5.6.20\r\n**phpMyAdmin version:**\r\n4.6.1\r\n### Client configuration\r\n**Browser:**\r\nFirefox 46.0.1\r\n**Operating system:**\r\nFedora 23"},"comment":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/comments/220898696","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/12243#issuecomment-220898696","issue_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/12243","id":220898696,"user":{"login":"nijel","id":212189,"avatar_url":"https://avatars.githubusercontent.com/u/212189?v=3","gravatar_id":"","url":"https://api.github.com/users/nijel","html_url":"https://github.com/nijel","followers_url":"https://api.github.com/users/nijel/followers","following_url":"https://api.github.com/users/nijel/following{/other_user}","gists_url":"https://api.github.com/users/nijel/gists{/gist_id}","starred_url":"https://api.github.com/users/nijel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nijel/subscriptions","organizations_url":"https://api.github.com/users/nijel/orgs","repos_url":"https://api.github.com/users/nijel/repos","events_url":"https://api.github.com/users/nijel/events{/privacy}","received_events_url":"https://api.github.com/users/nijel/received_events","type":"User","site_admin":false},"created_at":"2016-05-23T06:41:01Z","updated_at":"2016-05-23T06:41:01Z","body":"Thanks, the query is also great reproducer for #12219 :-)."}}
{"actor":{"display_login":"nijel"}}