View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Connection problem update v3.3.x to v.4.3.3 - ProjeQtOr
 
 

Connection problem update v3.3.x to v.4.3.3

More
29 Jul 2014 15:19 #1 by DanielF
Hi,

I cant update my install of ProjeQtOr from 3.4.4 to 4.3.3.
When I trying to login for update database Error connection

Connection LDAP KO, connection user admin local KO.

I done many test 3.4.4 to 4.0.0 KO too

Help me please.

Please Log in or Create an account to join the conversation.

More
29 Jul 2014 15:56 #2 by babynus
Did you refresh your browser cache ?
(there are some important js changes in login phase)

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
29 Jul 2014 15:59 #3 by DanielF
Yes,
I'm doing again and I have same problem

Please Log in or Create an account to join the conversation.

More
29 Jul 2014 16:22 #4 by babynus
Hi,

I'm almost sure it is a cache issue.

I could reproduce :
setup V3.4.4, and install : OK
upgrade ot V4.3.3 => issue while login, with error logged in log file
2014-07-29 16:14:08 ***** ERROR ***** Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'salt' in 'field list'
2014-07-29 16:14:08 ***** ERROR *****    For query : update resource set password='cc0bde50b9b5cadfd0389e00bddf193e301704079c1ceabd2bd79a883e83dfcb' , salt='b62d903c0f924eae9822ca90ec9c1e87d3665da5803dbbca7d3c13ae37c66723' , crypto='sha256' , passwordChangeDate='2014-07-29'  where id=1
2014-07-29 16:14:08 ***** ERROR *****    Strack trace :
2014-07-29 16:14:08 ***** ERROR *****    #0 Sql->query called at [D:\www\projeqtor\model\persistence\SqlElement.php:801]
2014-07-29 16:14:08 ***** ERROR *****    #1 SqlElement->updateSqlElement called at [D:\www\projeqtor\model\persistence\SqlElement.php:476]
2014-07-29 16:14:08 ***** ERROR *****    #2 SqlElement->saveSqlElement called at [D:\www\projeqtor\model\persistence\SqlElement.php:371]
2014-07-29 16:14:08 ***** ERROR *****    #3 SqlElement->save called at [D:\www\projeqtor\model\User.php:663]
2014-07-29 16:14:08 ***** ERROR *****    #4 User->save called at [D:\www\projeqtor\tool\changePassword.php:61]
2014-07-29 16:14:08 ***** ERROR *****    #5 changePassword called at [D:\www\projeqtor\tool\changePassword.php:36]

Then refreshed browser cache : [Shift]+[F5] was enough on my chrome browser.
And connect again : all works fine, upgrade correct.

1) Try to clean browser cache, with [Shift]+[F5]
2) Try to clean browser cache, with parameters options of browser
3) Try to connect with another browser

If none works, have a look at your Apache and PHP cache.
(Zend server manages some cache it is possible to clean throught the Zend GUI)

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
29 Jul 2014 16:22 #5 by babynus
Hi,

I'm almost sure it is a cache issue.

I could reproduce :
setup V3.4.4, and install : OK
upgrade ot V4.3.3 => issue while login, with error logged in log file
2014-07-29 16:14:08 ***** ERROR ***** Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'salt' in 'field list'
2014-07-29 16:14:08 ***** ERROR *****    For query : update resource set password='cc0bde50b9b5cadfd0389e00bddf193e301704079c1ceabd2bd79a883e83dfcb' , salt='b62d903c0f924eae9822ca90ec9c1e87d3665da5803dbbca7d3c13ae37c66723' , crypto='sha256' , passwordChangeDate='2014-07-29'  where id=1
2014-07-29 16:14:08 ***** ERROR *****    Strack trace :
2014-07-29 16:14:08 ***** ERROR *****    #0 Sql->query called at [D:\www\projeqtor\model\persistence\SqlElement.php:801]
2014-07-29 16:14:08 ***** ERROR *****    #1 SqlElement->updateSqlElement called at [D:\www\projeqtor\model\persistence\SqlElement.php:476]
2014-07-29 16:14:08 ***** ERROR *****    #2 SqlElement->saveSqlElement called at [D:\www\projeqtor\model\persistence\SqlElement.php:371]
2014-07-29 16:14:08 ***** ERROR *****    #3 SqlElement->save called at [D:\www\projeqtor\model\User.php:663]
2014-07-29 16:14:08 ***** ERROR *****    #4 User->save called at [D:\www\projeqtor\tool\changePassword.php:61]
2014-07-29 16:14:08 ***** ERROR *****    #5 changePassword called at [D:\www\projeqtor\tool\changePassword.php:36]

Then refreshed browser cache : [Shift]+[F5] was enough on my chrome browser.
And connect again : all works fine, upgrade correct.

1) Try to clean browser cache, with [Shift]+[F5]
2) Try to clean browser cache, with parameters options of browser
3) Try to connect with another browser

If none works, have a look at your Apache and PHP cache.
(Zend server manages some cache it is possible to clean throught the Zend GUI)

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
29 Jul 2014 17:07 #6 by DanielF
OK !

I retryed with Internet Explorer 11, clean browser ..... KO
I tryed with Chrome > success first time.

Thanks a lot.

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.056 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.