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?

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?

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

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.

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.

Good news and bad news.

The good news is that the error was avoided.

The bad news is that I still can't get past the spinner and the 'Upgrade in progress'. I turned logging to level 3 but the log only says:

2015-07-17 22:04:57 ===== TRACE ===== NEW CONNECTED USER 'admin'
2015-07-17 22:05:08 ===== TRACE ===== DISCONNECTED USER 'admin'

I also checked the database and the 'messages' table still only has 8 columns so it isn't being upgraded.

I decided to try another tack. I deleted projector. I also deleted the database and checked that it was gone using the psql interpreter. I did a clean install of V5.0.3 and set debugging to level 4. Still no success; this is the logfile:

2015-07-18 00:32:48.121 ..... SCRIPT .... 192.168.0.200 /view/index.php
2015-07-18 00:32:48.367 ..... SCRIPT .... 192.168.0.200 /view/main.php
2015-07-18 00:32:48.390 ..... SCRIPT .... 192.168.0.200 Page=main.php
2015-07-18 00:32:48.395 ..... SCRIPT .... 192.168.0.200 ->/view/login.php
2015-07-18 00:32:48.895 ..... SCRIPT .... 192.168.0.200 /tool/saveDataToSession.php
2015-07-18 00:32:48.913 ..... SCRIPT .... 192.168.0.200 Page=saveDataToSession.php
2015-07-18 00:32:48.947 ..... SCRIPT .... 192.168.0.200 /tool/saveDataToSession.php
2015-07-18 00:32:48.966 ..... SCRIPT .... 192.168.0.200 Page=saveDataToSession.php
2015-07-18 00:32:49.049 ..... SCRIPT .... 192.168.0.200 /tool/saveDataToSession.php
2015-07-18 00:32:49.066 ..... SCRIPT .... 192.168.0.200 Page=saveDataToSession.php
2015-07-18 00:32:49.100 ..... SCRIPT .... 192.168.0.200 /tool/saveDataToSession.php
2015-07-18 00:32:49.123 ..... SCRIPT .... 192.168.0.200 Page=saveDataToSession.php
2015-07-18 00:32:49.154 ..... SCRIPT .... 192.168.0.200 /tool/saveDataToSession.php
2015-07-18 00:32:49.173 ..... SCRIPT .... 192.168.0.200 Page=saveDataToSession.php
2015-07-18 00:32:49.204 ..... SCRIPT .... 192.168.0.200 /tool/saveDataToSession.php
2015-07-18 00:32:49.227 ..... SCRIPT .... 192.168.0.200 Page=saveDataToSession.php
2015-07-18 00:32:57.191 ..... SCRIPT .... 192.168.0.200 /tool/getHash.php
2015-07-18 00:32:57.207 ..... SCRIPT .... 192.168.0.200 Page=getHash.php

There have been no further log entries for 20 minutes so I have concluded that it has failed. Still can't log in.

Please could you tell me what /tool/getHash.php is supposed to do as this is the last file that it seems to access before dying.

On a forst install, you shoud not go to getHash.php as it is first step of authentication.
There is something weird about your config.
The first page you should get is config page.
Then login page should appear.
You login as admin/admin and database is populated.
You should then have all the logs of database updates....
Did you have this or not ? If yes, please post the log file.

I would agree with the word 'weird'!!

I should have been more explicit. I do get the config page and fill that in (that's how I set the debug to level 4). I then get the login page. I try to login as admin/admin and get the spinner going round indefinitely.

What do you mean by "...and the database is populated." What does it need to be populated with?

What "...logs of database updates..." do you mean? If you mean the logs in ../files/logs then I have posted the exact total of what is in the log file.

If you are saying I should not get to getHash.php on the first install, is there something I need to delete so that it knows it is a first install that I am missing? I assumed just to do the following:

delete /srv/www/projeqtor
delete ../files
delete database projeqtor
re-created database projeqtor

So now I understand.
You ran configuration well.
Then on login page you get blocked.
As far as I can see, you "must" have a javascript error.
Please check browser console.

Only other possibility is a browser plugin blocking js execution.
I once met issues with skype "click to call" with is a real mess : drastically slowing down javascript execution and blocking to executions by "translating" parts of response, giving unexpected results.
Try and disable all plugins to try.

And really, check for js error in browser console.

Also you can use "network" tab in dev tools to check response of getHash.php.
Post it here, it may give some hint.

i will try to do so but I'm not that conversant with browser technology.

However, I'm bound to say that I think it unlikely to be a client side issue. So far I have tried to access this from:

Chrome running on Windows 8.1
Internet Explorer running on Windows 8.1
Chrome running on Android
Puffin running on Android
Firefox running on Linux

It seems unlikely to me that 4 browsers running on 3 operating systems all have the same javascript error.

Hi,

Must understand what happens in browser.

1) open browser dev tools : [F12] key works on most browser (I would recommend Chrome or Firefox fir debugging)
2) You should have a network tab on the tools : select it
3) play test on Projector
4) go ot network tab ; you should see all requests send to the server
5) select the last request (getHash.php if your test case reproduces the same way)
6) you should have on the right part several tabs, select the response tab
7) paste response on the forum
Thanks

Unfortunately there was no response. Please see attached which have all the info that was available. i think perhaps the Error 500 Internal Server Error is as much info as we are going to find.

Sure, empty response of getHash is not normal.
Sure you must have an error logged on projeqtor log file or apache log files.

1) make sure mbstring is correctly installed on your PHP
2) Try to install attached patch : unzip and copy/pasted getHash.php in /tool folder (replacing existing one). Try again connection. Retrive projector log file and post it here.

Well, we finally got there! It was the lack of mbstring which was obviously an issue for V5 but not V4.5.7. Everything appears to be fine now.

Thanks very much for all your patience and assistance. Sorry that it appears to have been my fault.

For information, in V5.1 we'll add a systematic control of prerequisites.
=> on setup
=> on each upgrade (to take into account possible new prerequisites)

I think that's great news. For me I am running ProjeQtOr in a VM so I only install the minimum necessary packages to keep it light.