{"action":"created","issue":{"url":"https://api.github.com/repos/concrete5/concrete5/issues/2939","labels_url":"https://api.github.com/repos/concrete5/concrete5/issues/2939/labels{/name}","comments_url":"https://api.github.com/repos/concrete5/concrete5/issues/2939/comments","events_url":"https://api.github.com/repos/concrete5/concrete5/issues/2939/events","html_url":"https://github.com/concrete5/concrete5/issues/2939","id":102723862,"number":2939,"title":"Minimum system requirements - MySQL and PHP.","user":{"login":"JohntheFish","id":1260106,"avatar_url":"https://avatars.githubusercontent.com/u/1260106?v=3","gravatar_id":"","url":"https://api.github.com/users/JohntheFish","html_url":"https://github.com/JohntheFish","followers_url":"https://api.github.com/users/JohntheFish/followers","following_url":"https://api.github.com/users/JohntheFish/following{/other_user}","gists_url":"https://api.github.com/users/JohntheFish/gists{/gist_id}","starred_url":"https://api.github.com/users/JohntheFish/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JohntheFish/subscriptions","organizations_url":"https://api.github.com/users/JohntheFish/orgs","repos_url":"https://api.github.com/users/JohntheFish/repos","events_url":"https://api.github.com/users/JohntheFish/events{/privacy}","received_events_url":"https://api.github.com/users/JohntheFish/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/concrete5/concrete5/labels/status:under%20discussion","name":"status:under discussion","color":"c7def8"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-08-24T07:06:28Z","updated_at":"2015-08-24T16:02:20Z","closed_at":null,"body":"In the PRB I have recently run into issues with the minimum MySQL version needed to support doctrine data definitions. When doctrine sees a definition that includes a join on two tables it implies and tries to create a foreign key on the joined column. This was causing a MySQL error.\r\n\r\nhttp://www.concrete5.org/marketplace/review_pending/-/view_detail/2135/\r\n\r\nUpgrading to MySQL 5.6.26 resolved the problem, allowing the doctrine model to install.\r\n\r\nAs c5.7 is now dependant on doctrine and the use of doctrine data models is likely to increase, it seems the core requirement    http://www.concrete5.org/documentation/developers/5.7/installation/system-requirements/    \"MySQL 5.1.5 or Higher\" is outdated and should be revised to 5.6.xx (I don't know just which minor version this needs to be).\r\n\r\nWhile on the subject of minimum system requirements, I would estimate that 50% of all recent PRB submissions fail to install because they use php5.4 syntax that is not supported in php5.3. These submissions do not come from beginners. They come from experienced developers including many core contributors on github. We also have a fair number of marketplace submissions that pull in 3rd party libraries that depend on php5.4.\r\n\r\nIt would be easier for all concerned and cause considerably less friction if the minimum system requirements for the marketplace were php5.4 (and not the current php5.3).\r\n\r\nIssue https://github.com/concrete5/concrete5/issues/375 needs to be reopened.\r\n"},"comment":{"url":"https://api.github.com/repos/concrete5/concrete5/issues/comments/134264197","html_url":"https://github.com/concrete5/concrete5/issues/2939#issuecomment-134264197","issue_url":"https://api.github.com/repos/concrete5/concrete5/issues/2939","id":134264197,"user":{"login":"JohntheFish","id":1260106,"avatar_url":"https://avatars.githubusercontent.com/u/1260106?v=3","gravatar_id":"","url":"https://api.github.com/users/JohntheFish","html_url":"https://github.com/JohntheFish","followers_url":"https://api.github.com/users/JohntheFish/followers","following_url":"https://api.github.com/users/JohntheFish/following{/other_user}","gists_url":"https://api.github.com/users/JohntheFish/gists{/gist_id}","starred_url":"https://api.github.com/users/JohntheFish/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JohntheFish/subscriptions","organizations_url":"https://api.github.com/users/JohntheFish/orgs","repos_url":"https://api.github.com/users/JohntheFish/repos","events_url":"https://api.github.com/users/JohntheFish/events{/privacy}","received_events_url":"https://api.github.com/users/JohntheFish/received_events","type":"User","site_admin":false},"created_at":"2015-08-24T16:02:20Z","updated_at":"2015-08-24T16:02:20Z","body":"I don't think its a doctrine issue, just that doctrine creates foreign keys, and that that some MySQL versions (for windows?) before MySQL 5.6 had glitches with foreign keys."}}