When I copy the 3.1.4. version in my Apache folder (override the 3.2 version), it works and I can log in.

If you can log on V3.1.4 without being an admin, and without connecting as admin first, this means your database is still tagged as V3.1.4.

Maybe you did not upgrade the correct database.

When upgrading, after first admin connection, you can check for the new version in the database, in table parameter, line with parameterCode='dbVersion'.
Another way to check you database is in V3.2.0 : you shoud see 2 new tables : audit and auditsummary.

I have dbVersion parameter = V3.1.4. but it is with this value because after overriding the apache Folder of Project'Or RIA with a backup of 3.1.4. version, it changes this value the first time I log in.

I already have the audit and auditsummary tables.

I override the folder with the 3.2.0 version, again, the parameter changes to V3.2.0., and the upgrade of the database show several errors because some elements (tables, indexes and others) already exist.

And after that, I can't log in. I don`t know what to do...

Fortunately, with the backup of the 3.1.4. Apache folder, it runs...

Can you check for a Javascript error in the console ?

If you tell me how to... yes, it is our own server...

Javascript console is in the client browser.

For instance :
on Chrome and FireFox [Shift]+[CTRL]+J opens the console

Fortunately, with the backup of the 3.1.4. Apache folder, it runs...

As you get a backup of previous version, I imagine you didn't install new version over the previous releease.
How did you install the new version ?
Do you have a /tool/parametersLocation.php file ?
Is it pointing to the correct parameters.php file ?

I have upgraded again to v3.2.0 (overriding the Apache folder with 3.2.0 version).

After that it shows 17 errors during database update, but I have checked the log file and it is due to already existing items.

When I try to log in with Javascrypt console open (in the server), it shows the next errors:

POST http://localhost/proyectos/tool/loginCheck.php?destinationWidth=350 500 (Internal Server Error) dojo.js:15
Error en xhrPost el retorno para loadContent('../tool/loginCheck.php?destinationWidth=350', 'loginResultDiv', 'loginForm', 'undefined') :
RequestError: Unable to load ../tool/loginCheck.php?destinationWidth=350 status: 500 projector.js:628
_481 {stack: "Error: Unable to load ../tool/loginCheck.php?desti…calhost/proyectos/external/dojo/dojo.js:15:80293)", message: "Unable to load ../tool/loginCheck.php?destinationWidth=350 status: 500", response: Object, name: "RequestError", constructor: function}
dojo.js:15

Do you have a /tool/parametersLocation.php file ?

Yes, with the next text:

<?php
$parametersLocation = 'D:FicherosApacheProyectosConfigparameters.php';

Is it pointing to the correct parameters.php file ?

Yes, that file exits, with the next text:

?php
// =======================================================================================
// Automatically generated parameter file
// on 2013-01-19 00:11:55
// =======================================================================================
$paramDbType='mysql';
$paramDbHost='localhost';
$paramDbPort='3306';
$paramDbUser='xxxxx';
$paramDbPassword='zzzzz';
$paramDbName='IREProyectos';
$paramDbPrefix='';
$logFile='D:\FicherosApacheProyectos\Logs\projector_${date}.log';
$logLevel='3';
//======= END

Hi,

Your php server cannot render ../tool/loginCheck.php
I just checked : it is provided in the zip file.

Can you check access rights to this file, and to all other files in the application directory.
The PHP server must have at least read rights to these files.

The root directory of the App has full rights to these users/groups:

Administrators Group
Creator Owner
System
Everybody

So, I don't think is a problem of rights...

Another idea?

Please check Apache logs.

Error 500 should be reported, maybe with more explanation.

More information:

When I reach the login page, I get the next information in Apache Error.log:

[Mon Mar 11 20:33:54 2013] [error] [client 92.56.2.118] PHP Fatal error: Call to undefined function date_diff() in C:\AppServ\www\Proyectos\model\Audit.php on line 120, referer: http://XXXXXX/view/main.php

When I get a not succesful login, after that, each time I try to reach the login page I get "ERROR 500" error until I clean browser cache.

The problem is in date_diff function.

If I change the next code:

$audit->lastAccess=date('Y-m-d H:i:s');
$duration=date_diff(date_create($audit->connection), date_create($audit->lastAccess)) ;
$audit->duration=$duration->format('%H%I%S');

To:

$audit->lastAccess=date('Y-m-d H:i:s');
$duration='01:01:01';

It Works!!!

So, the problem is with date_diff function. And I have read that it is not implemented until PHP Version 5.3 and I have installed PHP Version 5.2.17

Could give a fix to this error or must I upgrade my PHP version? I prefer not to do that because I have more php applications on this server...

Hi,

I recorded the issue as Ticket #1018.
Will be deployed in next patch.

Thanks for reporting and analysis.