{"action":"created","issue":{"url":"https://api.github.com/repos/dotCMS/core/issues/9788","repository_url":"https://api.github.com/repos/dotCMS/core","labels_url":"https://api.github.com/repos/dotCMS/core/issues/9788/labels{/name}","comments_url":"https://api.github.com/repos/dotCMS/core/issues/9788/comments","events_url":"https://api.github.com/repos/dotCMS/core/issues/9788/events","html_url":"https://github.com/dotCMS/core/issues/9788","id":176837971,"number":9788,"title":"Database migration of dotCMS 3.6.0 fails on MySQL with case sensitive table names","user":{"login":"splotzky","id":11347836,"avatar_url":"https://avatars.githubusercontent.com/u/11347836?v=3","gravatar_id":"","url":"https://api.github.com/users/splotzky","html_url":"https://github.com/splotzky","followers_url":"https://api.github.com/users/splotzky/followers","following_url":"https://api.github.com/users/splotzky/following{/other_user}","gists_url":"https://api.github.com/users/splotzky/gists{/gist_id}","starred_url":"https://api.github.com/users/splotzky/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/splotzky/subscriptions","organizations_url":"https://api.github.com/users/splotzky/orgs","repos_url":"https://api.github.com/users/splotzky/repos","events_url":"https://api.github.com/users/splotzky/events{/privacy}","received_events_url":"https://api.github.com/users/splotzky/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/dotCMS/core/labels/Agile%20:%20Discuss%20for%20Release","name":"Agile : Discuss for Release","color":"009800"},{"url":"https://api.github.com/repos/dotCMS/core/labels/Severity%20:%20Support%20Requested","name":"Severity : Support Requested","color":"1d76db"}],"state":"open","locked":false,"assignee":{"login":"jcastro-dotcms","id":8779585,"avatar_url":"https://avatars.githubusercontent.com/u/8779585?v=3","gravatar_id":"","url":"https://api.github.com/users/jcastro-dotcms","html_url":"https://github.com/jcastro-dotcms","followers_url":"https://api.github.com/users/jcastro-dotcms/followers","following_url":"https://api.github.com/users/jcastro-dotcms/following{/other_user}","gists_url":"https://api.github.com/users/jcastro-dotcms/gists{/gist_id}","starred_url":"https://api.github.com/users/jcastro-dotcms/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jcastro-dotcms/subscriptions","organizations_url":"https://api.github.com/users/jcastro-dotcms/orgs","repos_url":"https://api.github.com/users/jcastro-dotcms/repos","events_url":"https://api.github.com/users/jcastro-dotcms/events{/privacy}","received_events_url":"https://api.github.com/users/jcastro-dotcms/received_events","type":"User","site_admin":false},"assignees":[{"login":"jcastro-dotcms","id":8779585,"avatar_url":"https://avatars.githubusercontent.com/u/8779585?v=3","gravatar_id":"","url":"https://api.github.com/users/jcastro-dotcms","html_url":"https://github.com/jcastro-dotcms","followers_url":"https://api.github.com/users/jcastro-dotcms/followers","following_url":"https://api.github.com/users/jcastro-dotcms/following{/other_user}","gists_url":"https://api.github.com/users/jcastro-dotcms/gists{/gist_id}","starred_url":"https://api.github.com/users/jcastro-dotcms/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jcastro-dotcms/subscriptions","organizations_url":"https://api.github.com/users/jcastro-dotcms/orgs","repos_url":"https://api.github.com/users/jcastro-dotcms/repos","events_url":"https://api.github.com/users/jcastro-dotcms/events{/privacy}","received_events_url":"https://api.github.com/users/jcastro-dotcms/received_events","type":"User","site_admin":false}],"milestone":null,"comments":2,"created_at":"2016-09-14T07:46:54Z","updated_at":"2016-09-30T20:40:16Z","closed_at":null,"body":"The database migration script of dotCMS 3.6.0 cannot find the table \"Folder\" (with capital \"F\"). Actually the table name in the database is \"folder\" (in lower case). This causes an exception in the migration process and the migration fails. Turns out that MySQL can have case sensitive table names depending on the configuration values at database creation.\r\n\r\n## Expected Behavior\r\nThe database migration should complete successfully.\r\n\r\n## Current Behavior\r\nAn exception occurs during migration:\r\nFATAL runonce.Task03545FixVarcharSizeInFolderOperations: Unable to execute SQL upgrade\r\ncom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'Folder' doesn't exist\r\n\r\n## Possible Solution\r\nChange the table name in the database migration script to \"folder\" (in lower case).\r\n\r\n## Known Workarounds\r\nCreate a new database in MySQL and set the variable \"lower_case_table_names\" to 1.\r\n\r\n## Steps to Reproduce (for bugs)\r\n1. Create a new database in MySQL and set the variable \"lower_case_table_names\" to 0.\r\n2. Import a starter.zip file with dotCMS 3.5.1.\r\n3. Execute the database migration with dotCMS 3.6.0.\r\n\r\n## Context\r\nUnable to upgrade from dotCMS 3.5.1 to dotCMS 3.6.0, because the database migration fails.\r\n\r\n## Your Environment\r\n* dotCMS version used: 3.5.1\r\n* Browser Name and version: not applicable\r\n* Operating System and version: Debian GNU/Linux 8.5 (jessie) \r\n* Application Server and version: Bundled Tomcat 8.0.18\r\n* Java Brand and version: Java 1.8.0_102\r\n* Database and version: MySQL 5.5.50\r\n* Application module (if apply):"},"comment":{"url":"https://api.github.com/repos/dotCMS/core/issues/comments/250846918","html_url":"https://github.com/dotCMS/core/issues/9788#issuecomment-250846918","issue_url":"https://api.github.com/repos/dotCMS/core/issues/9788","id":250846918,"user":{"login":"jcastro-dotcms","id":8779585,"avatar_url":"https://avatars.githubusercontent.com/u/8779585?v=3","gravatar_id":"","url":"https://api.github.com/users/jcastro-dotcms","html_url":"https://github.com/jcastro-dotcms","followers_url":"https://api.github.com/users/jcastro-dotcms/followers","following_url":"https://api.github.com/users/jcastro-dotcms/following{/other_user}","gists_url":"https://api.github.com/users/jcastro-dotcms/gists{/gist_id}","starred_url":"https://api.github.com/users/jcastro-dotcms/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jcastro-dotcms/subscriptions","organizations_url":"https://api.github.com/users/jcastro-dotcms/orgs","repos_url":"https://api.github.com/users/jcastro-dotcms/repos","events_url":"https://api.github.com/users/jcastro-dotcms/events{/privacy}","received_events_url":"https://api.github.com/users/jcastro-dotcms/received_events","type":"User","site_admin":false},"created_at":"2016-09-30T20:40:16Z","updated_at":"2016-09-30T20:40:16Z","body":"PR: https://github.com/dotCMS/core/pull/9858"}}
{"actor":{"display_login":"jcastro-dotcms"}}