{"issue":{"state":"open","pull_request":{"diff_url":null,"html_url":null,"patch_url":null},"milestone":null,"user":{"avatar_url":"https://secure.gravatar.com/avatar/e1d496f18f1b6ac46ebd1e3c85b67673?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"e1d496f18f1b6ac46ebd1e3c85b67673","url":"https://api.github.com/users/georgesmart1","login":"georgesmart1","id":758615},"assignee":null,"labels":[],"updated_at":"2011-10-31T17:49:20Z","closed_at":null,"comments":0,"url":"https://api.github.com/repos/magicbug/HRD-Web-Frontend/issues/69","body":"Hi.\r\n\r\nI have downloaded the latest version from github and installed it. It all went okay, except for adding a user.  I get this error:\r\n\r\nError Number: 1054\r\nUnknown column 'user_timezone' in 'field list'\r\n[string removed]\r\nFilename: /var/www/logger/models/user_model.php\r\nLine Number: 103\r\n\r\nUpon investigation, the users table doesn't contain a field \"user_timezone\" hence the failing insert.\r\n\r\nmysql> show fields from users;\r\n+----------------+-------------+------+-----+---------+----------------+\r\n| Field          | Type        | Null | Key | Default | Extra          |\r\n+----------------+-------------+------+-----+---------+----------------+\r\n| user_id        | int(11)     | NO   | PRI | NULL    | auto_increment |\r\n| user_name      | varchar(32) | NO   | UNI | NULL    |                |\r\n| user_password  | varchar(64) | NO   |     | NULL    |                |\r\n| user_email     | varchar(64) | NO   | UNI | NULL    |                |\r\n| user_type      | varchar(8)  | NO   |     | NULL    |                |\r\n| user_callsign  | varchar(32) | NO   |     | NULL    |                |\r\n| user_locator   | varchar(16) | NO   |     | NULL    |                |\r\n| user_firstname | varchar(32) | NO   |     | NULL    |                |\r\n| user_lastname  | varchar(32) | NO   |     | NULL    |                |\r\n+----------------+-------------+------+-----+---------+----------------+\r\n9 rows in set (0.00 sec)\r\n\r\nmysql>\r\n\r\nAdding it manually resolved the issue, but it still exists by default.\r\n\r\n\r\nmysql> alter table users add user_timezone int;\r\n\r\nCheers all, \r\nGeorge, M1GEO.","html_url":"https://github.com/magicbug/HRD-Web-Frontend/issues/69","title":"User Table doesn't contain user_timezone.","number":69,"id":2099965,"created_at":"2011-10-31T17:49:20Z"},"action":"opened"}