{"action":"created","issue":{"url":"https://api.github.com/repos/steveswinsburg/student-engagement/issues/2","repository_url":"https://api.github.com/repos/steveswinsburg/student-engagement","labels_url":"https://api.github.com/repos/steveswinsburg/student-engagement/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/steveswinsburg/student-engagement/issues/2/comments","events_url":"https://api.github.com/repos/steveswinsburg/student-engagement/issues/2/events","html_url":"https://github.com/steveswinsburg/student-engagement/pull/2","id":162963466,"number":2,"title":"table names are case sensitive in mysql","user":{"login":"mgolden-noodle","id":8107248,"avatar_url":"https://avatars.githubusercontent.com/u/8107248?v=3","gravatar_id":"","url":"https://api.github.com/users/mgolden-noodle","html_url":"https://github.com/mgolden-noodle","followers_url":"https://api.github.com/users/mgolden-noodle/followers","following_url":"https://api.github.com/users/mgolden-noodle/following{/other_user}","gists_url":"https://api.github.com/users/mgolden-noodle/gists{/gist_id}","starred_url":"https://api.github.com/users/mgolden-noodle/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mgolden-noodle/subscriptions","organizations_url":"https://api.github.com/users/mgolden-noodle/orgs","repos_url":"https://api.github.com/users/mgolden-noodle/repos","events_url":"https://api.github.com/users/mgolden-noodle/events{/privacy}","received_events_url":"https://api.github.com/users/mgolden-noodle/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-06-29T15:58:45Z","updated_at":"2016-06-29T22:53:20Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/steveswinsburg/student-engagement/pulls/2","html_url":"https://github.com/steveswinsburg/student-engagement/pull/2","diff_url":"https://github.com/steveswinsburg/student-engagement/pull/2.diff","patch_url":"https://github.com/steveswinsburg/student-engagement/pull/2.patch"},"body":"I am seeing errors in my catalina.out.  This should fix them.\r\n"},"comment":{"url":"https://api.github.com/repos/steveswinsburg/student-engagement/issues/comments/229513462","html_url":"https://github.com/steveswinsburg/student-engagement/pull/2#issuecomment-229513462","issue_url":"https://api.github.com/repos/steveswinsburg/student-engagement/issues/2","id":229513462,"user":{"login":"mgolden-noodle","id":8107248,"avatar_url":"https://avatars.githubusercontent.com/u/8107248?v=3","gravatar_id":"","url":"https://api.github.com/users/mgolden-noodle","html_url":"https://github.com/mgolden-noodle","followers_url":"https://api.github.com/users/mgolden-noodle/followers","following_url":"https://api.github.com/users/mgolden-noodle/following{/other_user}","gists_url":"https://api.github.com/users/mgolden-noodle/gists{/gist_id}","starred_url":"https://api.github.com/users/mgolden-noodle/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mgolden-noodle/subscriptions","organizations_url":"https://api.github.com/users/mgolden-noodle/orgs","repos_url":"https://api.github.com/users/mgolden-noodle/repos","events_url":"https://api.github.com/users/mgolden-noodle/events{/privacy}","received_events_url":"https://api.github.com/users/mgolden-noodle/received_events","type":"User","site_admin":false},"created_at":"2016-06-29T22:53:20Z","updated_at":"2016-06-29T22:53:20Z","body":"It is there now, but it only works if it's there at the time the database\nis created.  Once the database is built, the table names are fixed.\n\nAside from that though, I would note that nowhere in sakai is the table\nreferred to in lower case, and I think it's to avoid the problem that I\nhave noticed.  You can see it by doing \"grep -rHn sakai_event\n[SAKAI_SOURCE_DIR]\". The one line (outside a comment) you'll find is line\n89\nof sitestats/sitestats-impl/src/java/org/sakaiproject/sitestats/impl/StatsAggregateJobImpl.java,\nbut that's a special case:\n\n 73    private String MYSQL_GET_EVENT                  = \"select \" +\nMYSQL_DEFAULT_COLUMNS + MYSQL_CONTEXT_COLUMN + \" \" +\n 74                                                         \"from\nSAKAI_EVENT e join SAKAI_SESSION s on e.SESSION_ID=s.SESSION_ID \" +\n 75                                                         \"where EVENT_ID\n>= ? and EVENT_ID < ? \" +\n 76                                                         \"order by\nEVENT_ID asc \";\n...\n\n 88     private String ORACLE_GET_EVENT = \"SELECT \" +\nORACLE_DEFAULT_COLUMNS + ORACLE_CONTEXT_COLUMN +\n 89                 \" FROM sakai_event e JOIN sakai_session s ON\ne.session_id = s.SESSION_ID\" +\n 90                 \" WHERE event_id >= ? AND event_id < ? ORDER BY\nevent_id ASC\";\n\nIt seems that an attempt is being made (for mysql) to refer to the table\nnames in upper case, so I think it's worth doing in the engagement code as\nwell.\n\nMitch Golden\nCTO\nNoodle Partners, Inc.\n59 Chelsea Piers, Suite 200, New York, NY, 10011\n+1 646 289 7834 | mgolden@noodle.com | noodle-partners.com\n\n\n\nOn Wed, Jun 29, 2016 at 6:10 PM, Steve Swinsburg <notifications@github.com>\nwrote:\n\n> This is to do with your MySQL config being case sensitive. You should have:\n> lower_case_table_names=1 in your MySQL config. Can you check that it is\n> there?\n>\n> —\n> You are receiving this because you authored the thread.\n> Reply to this email directly, view it on GitHub\n> <https://github.com/steveswinsburg/student-engagement/pull/2#issuecomment-229504493>,\n> or mute the thread\n> <https://github.com/notifications/unsubscribe/AHu08PaRUiReCoOTPtn5dsd9aHjnu_djks5qQu04gaJpZM4JBSzR>\n> .\n>\n"}}
{"actor":{"display_login":"mgolden-noodle"}}