Ok, I have read the FAQ from here in regards to the timezone import, and have done those steps, checked inside phpMyAdmin and the zimezone tables appear and are now populated with data. http://forums.timetrex.com/viewtopic.php?t=40
However, im still getting an error as soon as I log in, and it goes to EditUser.php (freshly installed timetrex)
matthewk wrote:Ok, I have read the FAQ from here in regards to the timezone import, and have done those steps, checked inside phpMyAdmin and the zimezone tables appear and are now populated with data. http://forums.timetrex.com/viewtopic.php?t=40
However, im still getting an error as soon as I log in, and it goes to EditUser.php (freshly installed timetrex)
//Since MySQL can't store timezones in timestamp columns,
//We need to set the timezone for this MySQL session.
if ( $db->dataProvider == 'mysql' ) {
$db->Execute('SET SESSION time_zone=\''. $current_user_prefs->getTimeZone() .'\'');
}
//Since MySQL can't store timezones in timestamp columns,
//We need to set the timezone for this MySQL session.
$db_time_zone_error = FALSE;
if ( $db->dataProvider == 'mysql' AND $current_user_prefs->getTimeZone() != '' ) {
//Instead of using timezone names, we could set time_zone = "-08:00";
//This might get around the fact that MySQL doesn't always have timezone data imported.
if ( @$db->Execute('SET SESSION time_zone=\''. $current_user_prefs->getTimeZone() .'\'') ==
FALSE ) {
//Setting timezone failed, alert user to this fact.
$db_time_zone_error = TRUE;
}
}
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!