View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Issue upgrading to V5 - ProjeQtOr
 

Issue upgrading to V5

More
16 Jul 2015 12:05 #1 by briandlees
I have been running successfully V4.5.7 on a SUSE V13.2 VM with postgresql and tried to upgrade to V5.0.3 but could not get past the 'Upgrade in progress' screen. I decided to start from scratch so I deleted the projeqtor database, deleted the installation (all below /srv/www) and tried again, but with the same issue.

I followed the same procedure but this time installed V4.5.7 which worked OK; I logged in, created a user and created a project. I then tried upgrading to V5.0.0 but again got stuck at the 'Upgrade in progress' screen. Everything looked good in the log files until the message:

2015-07-15 23:12:02.671 ***** ERROR ***** Exception-[42703] SQLSTATE[42703]: Undefined column: 7 ERROR: column message.showonlogin does not exist
LINE 1: select * from message where message.showOnLogin='1' and mess...
^
2015-07-15 23:12:02.677 ***** ERROR ***** For query : select * from message where message.showOnLogin='1' and message.idle=0
2015-07-15 23:12:02.738 ***** ERROR ***** Strack trace :
2015-07-15 23:12:02.859 ***** ERROR ***** #0 Sql->query called at [/srv/www/projeqtor/model/persistence/SqlElement.php:1578]
2015-07-15 23:12:02.940 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [/srv/www/projeqtor/view/login.php:38]
2015-07-15 23:12:02.971 ***** ERROR ***** #2 include called at [/srv/www/projeqtor/tool/projeqtor.php:170]
2015-07-15 23:12:02.000 ***** ERROR ***** #3 require_once called at [/srv/www/projeqtor/view/main.php:37]

Please could you point me in the correct direction to fix this?

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

More
16 Jul 2015 22:07 #2 by briandlees
Replied by briandlees on topic Issue upgrading to V5
I have some more information. I have a test environment on my laptop using EasyPHP which includes mysql database. In the attachment messages_mysql.png you can see the structure of the table messages (using PhpMyAdmin) and there are 9 columns.



However, in the attachment messages_pgsql.png (using pgAdmin III) you can see the structure of the table messages in the production server which uses postgres. There are only 8 columns and the showOnLogin column is missing.



Obviously I can easily add the column but my questions are:

1. Why the difference?
2. How do I know that there are no other issues as the database upgrade obviously didn't work properly?

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

More
16 Jul 2015 22:18 #3 by briandlees
Replied by briandlees on topic Issue upgrading to V5
I have some more information. I have a test environment on my laptop using EasyPHP which includes mysql database. In the attachment messages_mysql.png you can see the structure of the table messages (using PhpMyAdmin) and there are 9 columns.



However, in the attachment messages_pgsql.png (using pgAdmin III) you can see the structure of the table messages in the production server which uses postgres. There are only 8 columns and the showOnLogin column is missing.



Obviously I can easily add the column but my questions are:

1. Why the difference?
2. How do I know that there are no other issues as the database upgrade obviously didn't work properly?
Attachments:

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

More
16 Jul 2015 23:18 #4 by babynus
Replied by babynus on topic Issue upgrading to V5
Hi,

I think that your MySql database is in V5.0, and your postgres still in V4.7.
You can check this in table parameter, line with parameterCode='dbVersion'.

Column showOnLogin is added on V5.0.
Logged error for ongoing deployment should not be blocking, but it is strange as it should not be displayed.
Maybe you should try with a clean session (clering cache and cookies, or using different broser for setup)

Please decribe your config : server OS, PHP version, postgres version, ...

NB : I recently upgraded a postgres install from V4.4 to V5.0 without issue

Babynus
Administrator of ProjeQtOr web site

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

More
17 Jul 2015 11:09 #5 by briandlees
Replied by briandlees on topic Issue upgrading to V5
You are correct; the dbVersion is 4.5.6.
openSUSE 13.2 (Harlequin) (x86_64)
psql (9.3.6)
PHP 5.6.1

I have already tried clearing browser cookies etc.

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

More
17 Jul 2015 19:55 #6 by babynus
Replied by babynus on topic Issue upgrading to V5
Try and change line 34 /view/login.php to
if (1 or getSessionValue('setup', null, true)) {
This should be an workaround, that you should remove after correct upgrade.

Babynus
Administrator of ProjeQtOr web site

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

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