Country and State drop-down lists missing on EditUser.php

mklell · Post by **mklell** » Thu Nov 01, 2007 9:41 am

I successfully installed version 2.1 on a Windows 2003 server using IIS, MySQL and PHP 5.2.4. The first time I login, I get the screen for first time login and I must complete the following information. On this screen, the country and province/state drop-down lists are completely missing. There is nothing showing in the php logs. The timetrex logs are below.

---------------[ Thu, 01 Nov 2007 17:11:16 +0000 (PID: 2616) ]---------------
DEBUG [249]: [Function](): URI: /interface/users/EditUser.php?id=1&incomplete=1 
DEBUG [251]: [Function](): Production: 1 
DEBUG [100]: TTDate::setTimeZone(): Setting TimeZone: GMT 
DEBUG [497]: Authentication::Check(): Session Name: SessionID 
DEBUG [503]: Authentication::Check(): Session ID: b49fe24355189d3444e4b4084bb2433c 
DEBUG [399]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:b49fe24355189d3444e4b4084bb2433c 
DEBUG [78]: Authentication::getIdle(): Idle Seconds Allowed: 14400 
DEBUG [399]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:b49fe24355189d3444e4b4084bb2433c 
DEBUG [69]: [Function](): User Authenticated: admin Created Date: 1193937074 
DEBUG [1903]: UserFactory::isInformationComplete(): User Information is NOT Complete: 
DEBUG [100]: TTDate::setTimeZone(): Setting TimeZone: GMT 
DEBUG [129]: TTDate::setDateFormat(): Setting Default Date Format: 
DEBUG [143]: TTDate::setTimeFormat(): Setting Default Time Format: 
DEBUG [157]: TTDate::setTimeUnitFormat(): Setting Default Time Unit Format: 
DEBUG [100]: [Function](): Locale Cookie: en_US 
DEBUG [235]: TTi18n::getLanguageFromLocale(): Locale: en_US 
DEBUG [102]: [Function](): Changing User Preference Language to match cookie... 
DEBUG [235]: TTi18n::getLanguageFromLocale(): Locale: en_US 
DEBUG [94]: Validator::inArrayKey(): Key: en 
DEBUG [739]: Factory::isValid(): Calling Validate() 
DEBUG [503]: Validator::Error(): Validation Error: Label: date_format Msg: Incorrect date format 
DEBUG [482] Array: Validator::isValid(): Errors
<pre>
Array
(
[date_format] => Array
(
[0] => Incorrect date format
)

)
</pre> 
DEBUG [270]: TTi18n::setLocale(): Attempting to set Locale to: en_US Category: 0 Current Locale: 
DEBUG [273]: TTi18n::setLocale(): Attempting to set Locale to: en_US 
DEBUG [275]: TTi18n::setLocale(): Failed setting i18n locale: en_US 
DEBUG [279]: TTi18n::setLocale(): Failed setting normalized i18n locale: en_US 
DEBUG [291]: TTi18n::setLocale(): Setting translator normalized locale to: en_US 
DEBUG [309]: TTi18n::setLocale(): Set Locale To: en_US 
DEBUG [1903]: UserFactory::isInformationComplete(): User Information is NOT Complete: 
DEBUG [136]: [Function](): Station ID Cookie found! 30fa3e5a44fceddcd4a68ba2f49decba 
DEBUG [243]: [Function](): UnRead Messages: 0 
DEBUG [83]: [Function](): aCompany ID: 
DEBUG [390]: [Function](): bCompany ID: 
DEBUG [394]: [Function](): cCompany ID: 1 
DEBUG [397]: [Function](): ID IS set 
DEBUG [48]: BreadCrumb::setCrumb(): Dropping Bread Crumb: Edit Employee URL: /interface/users/EditUser.php?id=1&incomplete=1 
DEBUG [420]: [Function](): Title: 
DEBUG [342]: FastTree::getAllChildren(): Getting Root ID: 0 
---------------[ Thu, 01 Nov 2007 17:11:16 +0000 (PID: 2616) ]---------------
---------------[ Thu, 01 Nov 2007 17:11:17 +0000 (PID: 2616) ]---------------
DEBUG [249]: [Function](): URI: /interface/ajax_server.php?client=all&stub=AJAX_Server 
DEBUG [251]: [Function](): Production: 1 
DEBUG [100]: TTDate::setTimeZone(): Setting TimeZone: GMT 
DEBUG [497]: Authentication::Check(): Session Name: SessionID 
DEBUG [503]: Authentication::Check(): Session ID: b49fe24355189d3444e4b4084bb2433c 
DEBUG [399]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:b49fe24355189d3444e4b4084bb2433c 
DEBUG [78]: Authentication::getIdle(): Idle Seconds Allowed: 14400 
DEBUG [399]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:b49fe24355189d3444e4b4084bb2433c 
DEBUG [69]: [Function](): User Authenticated: admin Created Date: 1193937074 
DEBUG [1903]: UserFactory::isInformationComplete(): User Information is NOT Complete: 
DEBUG [100]: TTDate::setTimeZone(): Setting TimeZone: GMT 
DEBUG [129]: TTDate::setDateFormat(): Setting Default Date Format: 
DEBUG [143]: TTDate::setTimeFormat(): Setting Default Time Format: 
DEBUG [157]: TTDate::setTimeUnitFormat(): Setting Default Time Unit Format: 
DEBUG [100]: [Function](): Locale Cookie: en_US 
DEBUG [235]: TTi18n::getLanguageFromLocale(): Locale: en_US 
DEBUG [102]: [Function](): Changing User Preference Language to match cookie... 
DEBUG [235]: TTi18n::getLanguageFromLocale(): Locale: en_US 
DEBUG [94]: Validator::inArrayKey(): Key: en 
DEBUG [739]: Factory::isValid(): Calling Validate() 
DEBUG [503]: Validator::Error(): Validation Error: Label: date_format Msg: Incorrect date format 
DEBUG [482] Array: Validator::isValid(): Errors
<pre>
Array
(
[date_format] => Array
(
[0] => Incorrect date format
)

)
</pre> 
DEBUG [270]: TTi18n::setLocale(): Attempting to set Locale to: en_US Category: 0 Current Locale: 
DEBUG [273]: TTi18n::setLocale(): Attempting to set Locale to: en_US 
DEBUG [275]: TTi18n::setLocale(): Failed setting i18n locale: en_US 
DEBUG [279]: TTi18n::setLocale(): Failed setting normalized i18n locale: en_US 
DEBUG [291]: TTi18n::setLocale(): Setting translator normalized locale to: en_US 
DEBUG [309]: TTi18n::setLocale(): Set Locale To: en_US 
DEBUG [1903]: UserFactory::isInformationComplete(): User Information is NOT Complete: 
DEBUG [136]: [Function](): Station ID Cookie found! 30fa3e5a44fceddcd4a68ba2f49decba 
DEBUG [55]: [Function](): AJAX Server called... 
---------------[ Thu, 01 Nov 2007 17:11:17 +0000 (PID: 2616) ]---------------

Post by **shaunw** » Thu Nov 01, 2007 11:16 am

The country options should never be blank. It sounds like something is seriously wrong with your installation if thats the case.

During the installation process, was the country/province options blank when you entered the company information?

mklell · Post by **mklell** » Thu Nov 01, 2007 11:23 am

At first during the installation I had the problem where none of the province/state options were visible, but the country had options. Then after looking through the forums I discovered my timetrex.ini.php base url was incorrect. I modified this and then I had the province/state options. I was then able to finish my installation. With this problem I am having the drop-down boxes do not even appear on the page for country or province/state.

Post by **shaunw** » Thu Nov 01, 2007 11:36 am

Province/State not showing up is relatively common because it uses AJAX to load, so its much more complex then just the country options.

The country options are just a straight dropdown box though, so them not showing up is very strange. Can you try a different web browser? Also try viewing the source of the page and see if any countries or errors appear there.

mklell · Post by **mklell** » Thu Nov 01, 2007 3:35 pm

I will post the source code showing country below. There were no errors present. Also this source code came from viewing the page in Firefox which produced the same results.

<script language=JavaScript>

var loading = false;
var hwCallback = {
getProvinceOptions: function(result) {
if ( result != false ) {
province_obj = document.getElementById('province');
selected_province = document.getElementById('selected_province').value;

populateSelectBox( province_obj, result, selected_province);
}
loading = false;
}
}

var remoteHW = new AJAX_Server(hwCallback);

function showProvince() {
country = document.getElementById('country').value;
remoteHW.getProvinceOptions( country );
}

</script>

HTML piece of code

<tr onClick="showHelpEntry('country')">
<td class="cellLeftEditTable">

Country: </td>
<td class="cellRightEditTable">

<input type="hidden" name="user_data[country]" value="">
</td>
</tr>

<tr onClick="showHelpEntry('province')">
<td class="cellLeftEditTable">
Province / State: </td>

<td class="cellRightEditTable">

<input type="hidden" name="user_data[province]" value="">
<input type="hidden" id="selected_province" value="">
</td>
</tr>

Post by **shaunw** » Thu Nov 01, 2007 5:12 pm

<input type="hidden" name="user_data[country]" value="">
</td>
</tr>

What happened to the rest of the <input> tag there? Are you sure you didn't miss something? Perhaps if you scroll to the right of the "View Source" page?

If not, then something is definitely wrong as you are missing random bits of HTML code.

Have you checked your PHP error log?

As a test, I would try our Windows installer to see if it works any better. It will create a completely separate instance of TimeTrex so you can run both at the same time to compare.

mklell · Post by **mklell** » Thu Nov 01, 2007 5:32 pm

Thanks for your help. We are implementing all of our new systems on MySQL 5.1.21 since the production release is right around the corner. I decided to try and eliminate that as the problem. We have a production environment running 5.0.37. I changed the database to connect to that server and everything worked correctly. We were hoping to decommission MySQL 5.0 soon and utilize the new features of 5.1. For now I will keep it running until I hear further support details. Also on a side note about the EditUser page, the entire left column of Employee Identification was hidden and I was only seeing the Contact Information column, very strange.

TimeTrex Time and Attendance

Country and State drop-down lists missing on EditUser.php

Country and State drop-down lists missing on EditUser.php

Time and Attendance