Province/State Missing

Ask your questions regarding TimeTrex installation here.
Locked
lsanchez_gutierrez
Posts: 36
Joined: Fri Jan 05, 2007 5:26 pm
Location: San Jose, Costa Rica
Contact:

Province/State Missing

Post by lsanchez_gutierrez »

I installed TimeTrex and had some problems because the Province/State was missing when I entered the Company Information, during Setup. If I switched between Canada, USA or any other country no Province/State would show up (Other PC's had info for Canada and USA). The Province/State filed is requried. so if I was unable to setup the company information nothing else worked, no users, nothing.

Temporary solution, dumped Postgre database from another computer, but still I cannot choose a Province/State. I was working with the debug buffer, http headers, etc. No other PC can change my locale information for the company information in TimeTrex, no one can see a Province/State list. Also tried other version of TimeTrex.

Firefox JavaScript Console shows 2 errors:
- Error: [Exception... "'Error: HTTP Error Making Request: [406] Not Acceptable' when calling method: [nsIOnReadyStateChangeHandler::handleEvent]" nsresult: "0x8057001c (NS_ERROR_XPC_JS_THREW_JS_OBJECT)" location: "<unknown>" data: no]

-Error: Error in parsing value for property 'font'. Declaration dropped.
Source File: http://l1:5009/interface/company/EditCompany.php?id=1
Line: 0

This is the http headers for my machine:
http://luis1:5009/interface/ajax_server ... nceOptions

POST /interface/ajax_server.php?&c=AJAX_Server&m=getProvinceOptions HTTP/1.1
Host: luis1:5009
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.8) Gecko/20061109 CentOS/1.5.0.8-0.1.el4.centos4 Firefox/1.5.0.8 pango-text
Accept: text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
Accept-Language: en-us,es-cr;q=0.8,ja;q=0.5,en;q=0.3
Accept-Encoding: gzip,deflate
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive: 300
Connection: keep-alive
Content-Type: application/json; charset=utf-8; charset=utf-8
Content-Length: 6
Cookie: SessionID=86f08d317b49af1c791dc8d7dd15b59b; StationID=65ba09ccd8e51e9910287c98ac643bed
Pragma: no-cache
Cache-Control: no-cache
["US"]
HTTP/1.x 406 Not Acceptable
Date: Wed, 17 Jan 2007 21:58:31 GMT
Server: Apache/2.2.0 (Fedora)
Content-Length: 343
Connection: close
Content-Type: text/html; charset=iso-8859-1

This is the http header for a pc where the Province/State works fine:
http://localhost:5003/interface/ajax_se ... nceOptions

POST /interface/ajax_server.php?&c=AJAX_Server&m=getProvinceOptions HTTP/1.1
Host: localhost:5003
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.8) Gecko/20061109 CentOS/1.5.0.8-0.1.el4.centos4 Firefox/1.5.0.8 pango-text
Accept: text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
Accept-Language: en-us,es-cr;q=0.8,ja;q=0.5,en;q=0.3
Accept-Encoding: gzip,deflate
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive: 300
Connection: keep-alive
Content-Type: application/json; charset=utf-8; charset=utf-8
Content-Length: 6
Cookie: SessionID=24e2262ff48b5b5b93d1d1e61539dc42; StationID=bcc352b44a503e3a2ab19c786b4d0499; testing=1; sid=6699e75a64a502a304756a37b2a84c21
Pragma: no-cache
Cache-Control: no-cache
["CA"]
HTTP/1.x 200 OK
Date: Wed, 17 Jan 2007 23:05:24 GMT
Server: Apache/2.0.52 (CentOS)
X-Powered-By: PHP/5.1.6
Expires: Mon, 26 Jul 1997 05:00:00 GMT
Last-Modified: Wed, 17 Jan 2007 23:05:24GMT
Cache-Control: no-cache, must-revalidate
Pragma: no-cache
Content-Length: 250
Connection: close
Content-Type: application/json; charset=utf-8

TimeTrex debug buffer shows no errors. Could it be some configuration on my machine? Apache Server? My Locale Setup in my machine? The Ajax Server Post?

Thanks for your help
___________________
Luis Sanchez
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

Firefox JavaScript Console shows 2 errors:
- Error: [Exception... "'Error: HTTP Error Making Request: [406] Not Acceptable' when calling method: [nsIOnReadyStateChangeHandler::handleEvent]" nsresult: "0x8057001c (NS_ERROR_XPC_JS_THREW_JS_OBJECT)" location: "<unknown>" data: no]
I think error 406 it something Apache is sending, not TimeTrex, see this page for more information on what error 406 is
http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html

Can you login to our online demo and see if you can select a province on there?
http://demo.timetrex.com/interface/Logi ... sword=demo
lsanchez_gutierrez
Posts: 36
Joined: Fri Jan 05, 2007 5:26 pm
Location: San Jose, Costa Rica
Contact:

Post by lsanchez_gutierrez »

I could login to the online version and change the Locale info (Province/State and Country). No problem there. What else do you recommend?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

Everything I can find points to issues with your Apache. Maybe this will help?
http://209.85.165.104/search?q=cache:5h ... =firefox-a
jtbryant
Posts: 7
Joined: Thu Jan 18, 2007 3:37 pm

Post by jtbryant »

Same problem here, running on IIS 6.0, PHP 5.1.2 etc.

The province does not show up, I am getting the following:

PHP Notice: Undefined index: province in C:\DotNetNuke\timetrex\interface\install\Company.php on line 78

Thanks,
Tim Bryant
jtbryant
Posts: 7
Joined: Thu Jan 18, 2007 3:37 pm

Post by jtbryant »

Managed to restart the install and it didn't asked me that the second time, but now I can't get login.php to open.

Any ideas?

Thanks,
Tim Bryant
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

jtbryant wrote:Managed to restart the install and it didn't asked me that the second time, but now I can't get login.php to open.

Any ideas?

Thanks,
Tim Bryant
Hi Tim, please read this
http://forums.timetrex.com/viewtopic.php?t=89
lsanchez_gutierrez
Posts: 36
Joined: Fri Jan 05, 2007 5:26 pm
Location: San Jose, Costa Rica
Contact:

Post by lsanchez_gutierrez »

Shaun,

Thanks, link to UrbanGiraffe worked, now I can get the Province/State working and change my locale. It seem the ModSecurity was messing with the POST.

To Tim Bryant

It seems you had the same problem I did, installed TimeTrex but could not choose a Province/State, since it is a required field, you could not continue and setup users (administrator). That is why you cannot use the login.php, because there is no database with any users for you to login with. My solution was to dump the database, import one and the use the UrbanGiraffe link to edit the ModSecurity settings in Apache. Since you are using IIS, I think there is no ModSecurity. Will think about you problem and look for solution.
jtbryant
Posts: 7
Joined: Thu Jan 18, 2007 3:37 pm

Post by jtbryant »

Couldn't I change the code in some way to just set the province to MS? I'm looking right now for some way to set that as the default in the company.php file.

Thanks,
Tim Bryant
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Post by shaunw »

jtbryant wrote:Couldn't I change the code in some way to just set the province to MS? I'm looking right now for some way to set that as the default in the company.php file.

Thanks,
Tim Bryant
This will just mask the problem and cause you huge headaches in the future. We need to fix the root problem instead. Please see my last post in the topic you created.
Locked