{"action":"created","issue":{"url":"https://api.github.com/repos/cheinle/NanoLIMS/issues/1","repository_url":"https://api.github.com/repos/cheinle/NanoLIMS","labels_url":"https://api.github.com/repos/cheinle/NanoLIMS/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/cheinle/NanoLIMS/issues/1/comments","events_url":"https://api.github.com/repos/cheinle/NanoLIMS/issues/1/events","html_url":"https://github.com/cheinle/NanoLIMS/issues/1","id":167714507,"number":1,"title":"Suggested changes for admin documentation","user":{"login":"morgantaschuk","id":1746206,"avatar_url":"https://avatars.githubusercontent.com/u/1746206?v=3","gravatar_id":"","url":"https://api.github.com/users/morgantaschuk","html_url":"https://github.com/morgantaschuk","followers_url":"https://api.github.com/users/morgantaschuk/followers","following_url":"https://api.github.com/users/morgantaschuk/following{/other_user}","gists_url":"https://api.github.com/users/morgantaschuk/gists{/gist_id}","starred_url":"https://api.github.com/users/morgantaschuk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/morgantaschuk/subscriptions","organizations_url":"https://api.github.com/users/morgantaschuk/orgs","repos_url":"https://api.github.com/users/morgantaschuk/repos","events_url":"https://api.github.com/users/morgantaschuk/events{/privacy}","received_events_url":"https://api.github.com/users/morgantaschuk/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2016-07-26T21:18:50Z","updated_at":"2016-07-29T05:00:12Z","closed_at":null,"body":"Hi,\r\n\r\nI'm trying to install NanoLIMS on my computer. I have some feedback for the Admin manual. I could edit the wiki directly but I feel uncomfortable doing so directly without contacting you first.\r\n\r\nI found a lot of the manual hard to follow because of missing line breaks. \r\n\r\ne.g.\r\n\r\n```\r\nMove ‘Important Accessories.zip’ out of webroot Contains four files: database_schema.pdf, nanolims_empty.sql, nanolims_demo.sql, and example_connection.txt\r\n\r\n    sudo mv Important Accessories.zip ../../ Or Ex: > mv Important Accessories.zip /var/www/\r\n```\r\n\r\n**Set paths for NanoLIMS by telling it where you put your nanolims folder**\r\n\r\nTwo different variable names are used here in the images \"$path_in_webroot\" and \"$logout_path\", they seem to be the same thing but not changed over. \r\n\r\nThe path for \"password_reset/forgot_passwordck.php\" is misspelled (couldn't find the file when following the documentation). What do you mean by \"domain\" here?\r\n\r\n**Ensure read and write access for the following files for user 'other'**\r\n\r\n \"query_sampleS\" directory is misspelled. Not sure what the \"*assumes\" note refers to.\r\n\r\n**Upload Database Structure:**\r\n\r\n- Missing semi-colon: CREATE USER 'nanolims'@'localhost' IDENTIFIED BY '[password]'\r\n\r\nThere's a mixture of smart quotes and single quotes in this line:\r\n```\r\nmysql> GRANT INSERT ON nanolims_demo.* TO ‘nanolims’@'localhost’; GRANT SELECT ON nanolims_demo.* TO ‘nanolims’@'localhost’; GRANT UPDATE ON nanolims_demo.* TO ‘nanolims’@'localhost’;\r\nERROR 1470 (HY000): String 'localhost’; GRANT SELECT ON nanolims_demo.* TO ‘nanolims’@' is too long for host name (should be no longer than 60)\r\n```\r\n\r\nI'm still working my way through the documentation for install but I thought you might be interested in this part.\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/cheinle/NanoLIMS/issues/comments/236094837","html_url":"https://github.com/cheinle/NanoLIMS/issues/1#issuecomment-236094837","issue_url":"https://api.github.com/repos/cheinle/NanoLIMS/issues/1","id":236094837,"user":{"login":"cheinle","id":10081573,"avatar_url":"https://avatars.githubusercontent.com/u/10081573?v=3","gravatar_id":"","url":"https://api.github.com/users/cheinle","html_url":"https://github.com/cheinle","followers_url":"https://api.github.com/users/cheinle/followers","following_url":"https://api.github.com/users/cheinle/following{/other_user}","gists_url":"https://api.github.com/users/cheinle/gists{/gist_id}","starred_url":"https://api.github.com/users/cheinle/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cheinle/subscriptions","organizations_url":"https://api.github.com/users/cheinle/orgs","repos_url":"https://api.github.com/users/cheinle/repos","events_url":"https://api.github.com/users/cheinle/events{/privacy}","received_events_url":"https://api.github.com/users/cheinle/received_events","type":"User","site_admin":false},"created_at":"2016-07-29T05:00:12Z","updated_at":"2016-07-29T05:00:12Z","body":"Hi Morgan,\r\n\r\nHrm, so the other thing I can think of other than the privileges issue mentioned above is that perhaps it is possibly a keyword/reserved word problem. I don't actually see any reserved words in the sql statements that are failing (checked against `SELECT * FROM mysql.help_keyword;`).  However, I have attached a new login.txt and registration.txt with all the column names escaped by backticks (can copy and paste to replace contents of login.php and registration.php) on the off chance that this could solve the problem (if the problem was not with permissions). \r\n\r\nI hope one of these is helpful. \r\n\r\nSincerely,\r\n\r\nCassie\r\n\r\n[login.txt](https://github.com/cheinle/NanoLIMS/files/389903/login.txt)\r\n[registration.txt](https://github.com/cheinle/NanoLIMS/files/389904/registration.txt)\r\n\r\n\r\n"}}
{"actor":{"display_login":"cheinle"}}