Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Connection problem ...
 
Notifications
Clear all

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

6 Posts
2 Users
0 Reactions
5,343 Views
(@danielf)
Posts: 4
Active Member
Topic starter
 
[#1925]

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.


 
Posted : 29 Jul 2014 17H19
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

Did you refresh your browser cache ?
(there are some important js changes in login phase)


 
Posted : 29 Jul 2014 17H56
(@danielf)
Posts: 4
Active Member
Topic starter
 

Yes,
I'm doing again and I have same problem


 
Posted : 29 Jul 2014 17H59
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

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:wwwprojeqtormodelpersistenceSqlElement.php:801]
2014-07-29 16:14:08 ** ERROR **    #1 SqlElement->updateSqlElement called at [D:wwwprojeqtormodelpersistenceSqlElement.php:476]
2014-07-29 16:14:08 ** ERROR **    #2 SqlElement->saveSqlElement called at [D:wwwprojeqtormodelpersistenceSqlElement.php:371]
2014-07-29 16:14:08 ** ERROR **    #3 SqlElement->save called at [D:wwwprojeqtormodelUser.php:663]
2014-07-29 16:14:08 ** ERROR **    #4 User->save called at [D:wwwprojeqtortoolchangePassword.php:61]
2014-07-29 16:14:08 ** ERROR **    #5 changePassword called at [D:wwwprojeqtortoolchangePassword.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)


 
Posted : 29 Jul 2014 18H22
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

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:wwwprojeqtormodelpersistenceSqlElement.php:801]
2014-07-29 16:14:08 ** ERROR **    #1 SqlElement->updateSqlElement called at [D:wwwprojeqtormodelpersistenceSqlElement.php:476]
2014-07-29 16:14:08 ** ERROR **    #2 SqlElement->saveSqlElement called at [D:wwwprojeqtormodelpersistenceSqlElement.php:371]
2014-07-29 16:14:08 ** ERROR **    #3 SqlElement->save called at [D:wwwprojeqtormodelUser.php:663]
2014-07-29 16:14:08 ** ERROR **    #4 User->save called at [D:wwwprojeqtortoolchangePassword.php:61]
2014-07-29 16:14:08 ** ERROR **    #5 changePassword called at [D:wwwprojeqtortoolchangePassword.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)


 
Posted : 29 Jul 2014 18H22
(@danielf)
Posts: 4
Active Member
Topic starter
 

OK !

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

Thanks a lot.


 
Posted : 29 Jul 2014 19H07
Share:

Scroll to Top