meeting-room-booking-system / mrbs-code

MRBS application code
Other
129 stars 64 forks source link

MRBS 1.5.0 - Adding New Areas Sets Invalid Timezone in DB #1831

Open jberanek opened 7 years ago

jberanek commented 7 years ago

MRBS 1.5.0 Database: MySQL 5.7.17-log System: Windows NT 6.2 build 9200 (Unknow Windows version Standard Edition) i586 <- Server 2016 Server time: 12/19/2016 3:44:14 PM PHP: 5.3.28

As the Ticket Title States, when you add in a New Area it creates it's entry within the SQL DB but the Timezone field is set to "timezone" which then throws up:

MRBS configuration error: invalid timezone 'timezone'

Only way I can fix it is to go into the "mrbs_area" table and modify the "timezone" field to a valid value such as america/chicago

Forgive me I'm not a PHP coder and know just enough SQL to be dangerous but it seems like during the creation routine when it creates the area in the SQL DB it's entering in the value of "timezone" for the TZ as opposed to grabbing the vaule set within config.inc.php

Not a php guy but I figure this could be fixed somewhere in the php files just not sure where.

This occus with a fresh clean installation of MRBS.

Not an earth shattering problem but would be nice to know how to fix this.

Thanks.

Reported by: crchicago-raul

Original Ticket: mrbs/support-requests/1110

jberanek commented 7 years ago

See https://sourceforge.net/p/mrbs/support-requests/1111/.

Original comment by: campbell-m