{"action":"created","issue":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/164","labels_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/164/labels{/name}","comments_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/164/comments","events_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/164/events","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/164","id":50254373,"number":164,"title":"Default sqlitebrowser version for current Ubuntu (14.04LTS) is VERY old","user":{"login":"rob-hills","id":5433032,"avatar_url":"https://avatars.githubusercontent.com/u/5433032?v=3","gravatar_id":"","url":"https://api.github.com/users/rob-hills","html_url":"https://github.com/rob-hills","followers_url":"https://api.github.com/users/rob-hills/followers","following_url":"https://api.github.com/users/rob-hills/following{/other_user}","gists_url":"https://api.github.com/users/rob-hills/gists{/gist_id}","starred_url":"https://api.github.com/users/rob-hills/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rob-hills/subscriptions","organizations_url":"https://api.github.com/users/rob-hills/orgs","repos_url":"https://api.github.com/users/rob-hills/repos","events_url":"https://api.github.com/users/rob-hills/events{/privacy}","received_events_url":"https://api.github.com/users/rob-hills/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":27,"created_at":"2014-11-27T04:59:30Z","updated_at":"2015-04-28T12:40:21Z","closed_at":null,"body":"I am trying to convert an existing MySQL DB to sqlite.  Being an optimist, I first tried an \"ansi-compatible\" export from the MySQL DB for one table, created (and saved) a new DB in sqlitebrowser and then tried running some of the Export file.  The result is that sqlitebrowser just hangs.\r\n\r\nI was hoping to see it report a syntax error or something like that so I could go about massaging the sql exported from MySQL so I could do my conversion.\r\n\r\nThe SQL I tried to run in sqlitebrowser was the following:\r\n```sql\r\nSET time_zone = \"+00:00\";\r\n\r\n/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;\r\n/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;\r\n/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;\r\n/*!40101 SET NAMES utf8 */;\r\n\r\n--\r\n-- Database: `acom_mforum`\r\n--\r\n\r\n-- --------------------------------------------------------\r\n\r\n--\r\n-- Table structure for table `posts`\r\n--\r\n\r\nCREATE TABLE IF NOT EXISTS \"posts\" (\r\n  \"post_id\" mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r\n  \"topic_id\" mediumint(8) unsigned NOT NULL DEFAULT '0',\r\n  \"forum_id\" mediumint(8) unsigned NOT NULL DEFAULT '0',\r\n  \"poster_id\" mediumint(8) unsigned NOT NULL DEFAULT '0',\r\n  \"icon_id\" mediumint(8) unsigned NOT NULL DEFAULT '0',\r\n  \"poster_ip\" varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  \"post_time\" int(11) unsigned NOT NULL DEFAULT '0',\r\n  \"post_reported\" tinyint(1) unsigned NOT NULL DEFAULT '0',\r\n  \"enable_bbcode\" tinyint(1) unsigned NOT NULL DEFAULT '1',\r\n  \"enable_smilies\" tinyint(1) unsigned NOT NULL DEFAULT '1',\r\n  \"enable_magic_url\" tinyint(1) unsigned NOT NULL DEFAULT '1',\r\n  \"enable_sig\" tinyint(1) unsigned NOT NULL DEFAULT '1',\r\n  \"post_username\" varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  \"post_subject\" varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',\r\n  \"post_text\" mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,\r\n  \"post_checksum\" varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  \"post_attachment\" tinyint(1) unsigned NOT NULL DEFAULT '0',\r\n  \"bbcode_bitfield\" varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  \"bbcode_uid\" varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  \"post_postcount\" tinyint(1) unsigned NOT NULL DEFAULT '1',\r\n  \"post_edit_time\" int(11) unsigned NOT NULL DEFAULT '0',\r\n  \"post_edit_reason\" varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  \"post_edit_user\" mediumint(8) unsigned NOT NULL DEFAULT '0',\r\n  \"post_edit_count\" smallint(4) unsigned NOT NULL DEFAULT '0',\r\n  \"post_edit_locked\" tinyint(1) unsigned NOT NULL DEFAULT '0',\r\n  \"post_visibility\" tinyint(3) NOT NULL DEFAULT '0',\r\n  \"post_delete_time\" int(11) unsigned NOT NULL DEFAULT '0',\r\n  \"post_delete_reason\" varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',\r\n  \"post_delete_user\" mediumint(8) unsigned NOT NULL DEFAULT '0',\r\n  PRIMARY KEY (\"post_id\"),\r\n  KEY \"forum_id\" (\"forum_id\"),\r\n  KEY \"topic_id\" (\"topic_id\"),\r\n  KEY \"poster_ip\" (\"poster_ip\"),\r\n  KEY \"poster_id\" (\"poster_id\"),\r\n  KEY \"post_username\" (\"post_username\"),\r\n  KEY \"tid_post_time\" (\"topic_id\",\"post_time\"),\r\n  KEY \"post_visibility\" (\"post_visibility\")\r\n) AUTO_INCREMENT=51587 ;\r\n```\r\n\r\nIdeally sqlitebrowser should report what the error(s) is/are rather than just hanging."},"comment":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/comments/97048283","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/164#issuecomment-97048283","issue_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/164","id":97048283,"user":{"login":"justinclift","id":406299,"avatar_url":"https://avatars.githubusercontent.com/u/406299?v=3","gravatar_id":"","url":"https://api.github.com/users/justinclift","html_url":"https://github.com/justinclift","followers_url":"https://api.github.com/users/justinclift/followers","following_url":"https://api.github.com/users/justinclift/following{/other_user}","gists_url":"https://api.github.com/users/justinclift/gists{/gist_id}","starred_url":"https://api.github.com/users/justinclift/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/justinclift/subscriptions","organizations_url":"https://api.github.com/users/justinclift/orgs","repos_url":"https://api.github.com/users/justinclift/repos","events_url":"https://api.github.com/users/justinclift/events{/privacy}","received_events_url":"https://api.github.com/users/justinclift/received_events","type":"User","site_admin":false},"created_at":"2015-04-28T12:40:21Z","updated_at":"2015-04-28T12:40:21Z","body":"@rob-hills @AndroidGecko @Jerome67000 Would you have a few minutes to try out the new PPA above (if it suits your Ubuntu version)? :wink:"}}