magicbug/HRD-Web-Frontend — Issue #69: User Table doesn't contain user_timezone.
Author: georgesmart1
Created: 2011-10-31 17:49:20+00:00
State: open

Hi.

I have downloaded the latest version from github and installed it. It all went okay, except for adding a user. I get this error:

Error Number: 1054
Unknown column 'user_timezone' in 'field list'
[string removed]
Filename: /var/www/logger/models/user_model.php
Line Number: 103

Upon investigation, the users table doesn't contain a field "user_timezone" hence the failing insert.

mysql> show fields from users;
+----------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+----------------+
| user_id | int(11) | NO | PRI | NULL | auto_increment |
| user_name | varchar(32) | NO | UNI | NULL | |
| user_password | varchar(64) | NO | | NULL | |
| user_email | varchar(64) | NO | UNI | NULL | |
| user_type | varchar(8) | NO | | NULL | |
| user_callsign | varchar(32) | NO | | NULL | |
| user_locator | varchar(16) | NO | | NULL | |
| user_firstname | varchar(32) | NO | | NULL | |
| user_lastname | varchar(32) | NO | | NULL | |
+----------------+-------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)

mysql>

Adding it manually resolved the issue, but it still exists by default.

mysql> alter table users add user_timezone int;

Cheers all,
George, M1GEO.