View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - 3.0.0 RC - Page 2 - ProjeQtOr
 
 

3.0.0 RC

More
16 Nov 2012 18:11 #7 by babynus
Replied by babynus on topic Re: 3.0.0 RC
It seems you upgraded database, and now try to use it with old version of code.
In V3.0.0, table "user" has been renamed to "resource".

The message you get is "table user not found".

When you deploy new version, you must overwrite old code with new one, so you need to unzip in the existing folder.

Babynus
Administrator of ProjeQtOr web site

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

More
18 Nov 2012 16:44 #8 by bersyl91
Replied by bersyl91 on topic Re: 3.0.0 RC
Mmmhhh... I can't understand how this may happen: I don't have any code that old.

I had done a tar.gz of the previous version (2.6.3). If I untar it in place, I get the same type of error!

tail projector_20121118.log
2012-11-18 16:40:37 ***** ERROR ***** Strack trace :
2012-11-18 16:40:37 ***** ERROR ***** #0 Sql->query called at [/opt/projectorria/model/persistence/SqlElement.php:1103]
2012-11-18 16:40:37 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [/opt/projectorria/tool/loginCheck.php:30]
2012-11-18 16:40:37 ===== TRACE ===== Login error for user 'bernard'
2012-11-18 16:40:37 ***** ERROR ***** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projectorria.user' doesn't exist
2012-11-18 16:40:37 ***** ERROR ***** For query : select * from user where user.name ='bernard' and user.isUser = '1'
2012-11-18 16:40:37 ***** ERROR ***** Strack trace :
2012-11-18 16:40:37 ***** ERROR ***** #0 Sql->query called at [/opt/projectorria/model/persistence/SqlElement.php:1103]
2012-11-18 16:40:37 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [/opt/projectorria/tool/loginCheck.php:30]
2012-11-18 16:40:37 ===== TRACE ===== Login error for user 'bernard'

What can I do?

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

More
18 Nov 2012 16:55 #9 by bersyl91
Replied by bersyl91 on topic Re: 3.0.0 RC
Well, I think I begin to understand: The upgrade of table must hav begun but never properly ended and I'm stucked with a new base structure and a code which 'think' it hasn't been done.
I _must_ tweak to find out where... Can you help me?

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

More
18 Nov 2012 16:56 #10 by babynus
Replied by babynus on topic Re: 3.0.0 RC
It really looks like you are using V3.0.0 code, with database migrated to V3.0.0 but version stored in database set to V2.6.3.
This can happen if you migrate to V3.0.0, and there use it again with old code : dbVersion will be reversed to old version, although the database is in V3.0.0 format.

Can you :
- set debug level to 3 (instead of 2) in parameters.php file and try again
- check paramerterValue in table parameter where parameterCode='dbVersion'
Thanks.

Babynus
Administrator of ProjeQtOr web site

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

More
18 Nov 2012 17:02 #11 by bersyl91
Replied by bersyl91 on topic Re: 3.0.0 RC
I finally found out a workaround but it does not satisfy me: I had to rename the resource table into user, then give a _full write access_ to the entire directory tree to have the migration done.

It's a *serious security hole* to have to do that. I wouldn't never have to do that. I admit the product has to write logs and reports but if he can't write to a specific file during the migration, I have to be notified and the migration has to be rollbacked or a new run must go straightforward.

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

More
18 Nov 2012 17:03 #12 by babynus
Replied by babynus on topic Re: 3.0.0 RC
Can you retrieve the log file including the migration step and post it here ?

Babynus
Administrator of ProjeQtOr web site

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

Moderators: babynusprotion
Time to create page: 0.047 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.