{"action":"created","issue":{"url":"https://api.github.com/repos/IUMDPI/MediaSCORE/issues/1","labels_url":"https://api.github.com/repos/IUMDPI/MediaSCORE/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/IUMDPI/MediaSCORE/issues/1/comments","events_url":"https://api.github.com/repos/IUMDPI/MediaSCORE/issues/1/events","html_url":"https://github.com/IUMDPI/MediaSCORE/issues/1","id":128157364,"number":1,"title":"install schema fails with syntax error","user":{"login":"dongourley","id":282597,"avatar_url":"https://avatars.githubusercontent.com/u/282597?v=3","gravatar_id":"","url":"https://api.github.com/users/dongourley","html_url":"https://github.com/dongourley","followers_url":"https://api.github.com/users/dongourley/followers","following_url":"https://api.github.com/users/dongourley/following{/other_user}","gists_url":"https://api.github.com/users/dongourley/gists{/gist_id}","starred_url":"https://api.github.com/users/dongourley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dongourley/subscriptions","organizations_url":"https://api.github.com/users/dongourley/orgs","repos_url":"https://api.github.com/users/dongourley/repos","events_url":"https://api.github.com/users/dongourley/events{/privacy}","received_events_url":"https://api.github.com/users/dongourley/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-01-22T13:30:44Z","updated_at":"2016-01-22T14:25:37Z","closed_at":null,"body":"I am trying to install MediaSCORE on Ubuntu 14.04 with Mysql 5.5.46. When I get to the step in install.txt to connect to the database and <code>source data/sql/schema.sql</code> it fails with this message:\r\n\r\n    ERROR 1064 (42000) at line 11: You have an error in your SQL syntax;\r\n    check the manual that  corresponds to your MySQL server version for the\r\n    right syntax to use near '<<<<<<< HEAD\r\n    =======\r\n    CREATE TABLE `characteristics_format` (\r\n      `id` bigint(20) N' at line 1\r\n\r\nIt seems to be the <<<<<<<< and >>>>>>>>> lines it doesn't like -- I'm not sure what they are and where they come from...are they an artifact from git or symfony or ...? Also there are two CREATE stmts for characteristics_format and other tables with the <<<<<<< HEAD and >>>>>>> blocks, so I'm guessing that something is supposed to process schema.sql before I feed it to MySQL?\r\n\r\nThe previous install.txt step, <code>php symfony --model --forms --filters</code> did not work -- it just listed all the available tasks. So I ran these three commands instead:\r\n\r\n    php symfony doctrine:build-model\r\n    php symfony doctrine:build-forms\r\n    php symfony doctrine:build-filters\r\n\r\nDid that miss something that processes the schema file?"},"comment":{"url":"https://api.github.com/repos/IUMDPI/MediaSCORE/issues/comments/173933924","html_url":"https://github.com/IUMDPI/MediaSCORE/issues/1#issuecomment-173933924","issue_url":"https://api.github.com/repos/IUMDPI/MediaSCORE/issues/1","id":173933924,"user":{"login":"Fuqran","id":7449211,"avatar_url":"https://avatars.githubusercontent.com/u/7449211?v=3","gravatar_id":"","url":"https://api.github.com/users/Fuqran","html_url":"https://github.com/Fuqran","followers_url":"https://api.github.com/users/Fuqran/followers","following_url":"https://api.github.com/users/Fuqran/following{/other_user}","gists_url":"https://api.github.com/users/Fuqran/gists{/gist_id}","starred_url":"https://api.github.com/users/Fuqran/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Fuqran/subscriptions","organizations_url":"https://api.github.com/users/Fuqran/orgs","repos_url":"https://api.github.com/users/Fuqran/repos","events_url":"https://api.github.com/users/Fuqran/events{/privacy}","received_events_url":"https://api.github.com/users/Fuqran/received_events","type":"User","site_admin":false},"created_at":"2016-01-22T14:25:37Z","updated_at":"2016-01-22T14:25:37Z","body":"welcome, yes it is using doctrine , let me know if you need more help ​\n\nOn Fri, Jan 22, 2016 at 7:23 PM, Don <notifications@github.com> wrote:\n\n> Thanks. It seems this application is using doctrine ORM, not Propel:\n>\n> /var/www/MediaSCORE> php symfony propel:build-sql\n> There are no tasks defined in the \"propel\" namespace.\n>\n> When I re-generate the SQL with php symfony doctrine:build-sql I get some\n> other syntax errors, like:\n>\n> ERROR 1064 (42000): You have an error in your SQL syntax;\n> check the manual that corresponds to your MySQL server version for the right syntax to use near\n> 'datatime, score_subject_interest FLOAT(18, 2), notes_subject_interest text, scor' at line 1\n>\n> Full output is attached:\n> source.err.txt\n> <https://github.com/IUMDPI/MediaSCORE/files/100886/source.err.txt>\n>\n> Thanks for your help...\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/IUMDPI/MediaSCORE/issues/1#issuecomment-173933176>.\n>\n\n\n\n-- \n\nThanks!\nFurqan Wasi\nApplication Developer\n\noffice: 888-783-2442\n\n[image: https://twitter.com/geekschicago] <https://twitter.com/geekschicago>\n [image: https://www.facebook.com/geekschicago]\n<https://www.facebook.com/geekschicago> [image:\nhttps://www.youtube.com/channel/UCS76Te3JZO4bClkrYD3QVrA]\n<https://www.youtube.com/channel/UCS76Te3JZO4bClkrYD3QVrA> [image:\nhttps://www.linkedin.com/company/geekschicago-com]\n<https://www.linkedin.com/company/geekschicago-com>\n<https://geekschicago.com>\n"}}