Hi,

Could you please post print screen showing error, and possibly log file.
(I cannot reproduce and status exists in Meeting form)

Here is the print screen !

Hi,

Very strange...
The screen is not complete : you should have "treatment" section on the right, with "status" field.
(you can have a look at demo)

Could you please check log file and post here any error logged ?
Could you also check for browser issue (check browser console).
Thanks.

At the log file I only have this error

2015-01-07 11:45:17 ** ERROR **    For query : insert into audit ( sessionId , auditDay , idUser , userName , platform , browser , browserVersion , userAgent , connectionDateTime , lastAccessDateTime , duration , idle , requestRefreshParam , requestRefreshProject , requestDisconnection ) values ('mtk25rki44n67n9sp5cnenjvd6', '20150107', '7', 'smeunier', 'Windows', 'Mozilla Firefox', '21.0', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:21.0) Gecko/20100101 Firefox/21.0', '2015-01-07 11:45:17', '2015-01-07 11:45:17', '00:00:00', '0', '0', '0', '0')
2015-01-07 11:45:17 ** ERROR **    Strack trace :
2015-01-07 11:45:17 ** ERROR **    #0 Sql->query called at [/opt/projeqtor/model/persistence/SqlElement.php:691]
2015-01-07 11:45:17 ** ERROR **    #1 SqlElement->insertSqlElement called at [/opt/projeqtor/model/persistence/SqlElement.php:509]
2015-01-07 11:45:17 ** ERROR **    #2 SqlElement->saveSqlElement called at [/opt/projeqtor/model/persistence/SqlElement.php:398]
2015-01-07 11:45:17 ** ERROR **    #3 SqlElement->save called at [/opt/projeqtor/model/Audit.php:187]
2015-01-07 11:45:17 ** ERROR **    #4 Audit->updateAudit called at [/opt/projeqtor/tool/projeqtor.php:212]
2015-01-07 11:45:17 ** ERROR **    #5 require_once called at [/opt/projeqtor/tool/checkAlertToDisplay.php:29]
2015-01-07 11:45:27 ** ERROR ** Exception-[42703] SQLSTATE[42703]: Undefined column: 7 ERREUR:  la colonne « lastaccessdatetime » de la relation « audit » n'existe pas
LINE 1: ...browserVersion , userAgent , connectionDateTime , lastAccess...

I don't know if this error has a link with own problem.

Il the console browser I don't see error !

A+

Denis

Error you get has no link with meeting...
But it's not normal. I'll have a look at it.

Could you test what you're trying on the demo ( http://demo.projeqtor.org, user manager/manager).
Do you get same issue or not ?

Hello,
It's ok on demo !
I have an other server with projeqtor 4.3.2 and it works well !

Regards

Denis

Hi,

It seems the migration to V4.5 was not complete.
Check audit table, some columns have changed :
- lastAccessDateTime (V4.5) replacing lastAccess (V4.4)
- connectionDateTime(V4.5) replacing connection(V4.4)
- disconnectionDateTime (V4.5) replacing disconnection (V4.4)
Check assignment table, new column
- notPlannedWork is new column
Check planningelement table, new column
- notPlannedWork is new column

If these changes are not taken into account, the behavior would be exactly what you describe :
- assignment not completely displayed and rest of forml not displayed
- error logged on audit table every 10 second

Bonsoir,

The install wasn't issue from migration but from a fresh install!

I check the columns tomorrow

Regards

Denis

For information, I never has such issue on fresh installs (and I run some quite often).

On which OS do you Host ProjeQtOr ?

Salut,
Here are the tables

-- Table: audit
-- DROP TABLE audit;
CREATE TABLE audit
(
  id serial NOT NULL,
  sessionid character varying(100),
  auditday character varying(8),
  connectiondatetime timestamp without time zone,
  disconnection timestamp without time zone,
  lastaccess timestamp without time zone,
  duration time without time zone,
  iduser numeric(12,0),
  username character varying(100),
  useragent character varying(400),
  platform character varying(100),
  browser character varying(100),
  browserversion character varying(100),
  requestrefreshparam numeric(1,0) DEFAULT 0,
  requestdisconnection numeric(1,0) DEFAULT 0,
  idle numeric(1,0) DEFAULT 0::numeric,
  requestrefreshproject numeric(1,0) DEFAULT 0::numeric,
  CONSTRAINT audit_pkey PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);

it-s OK for assignment and planningelement tables

Regards

Denis

Hi,

The description of your audit table is very strange.

In V4.5, 3 columns were renamed :
connection to connectionDateTime
disconnection to disconnectionDateTime
disconnection to lastAccessDateTime

Here is what creation script should look like :

CREATE TABLE IF NOT EXISTS `audit` (
`id` int(12) unsigned NOT NULL,
  `sessionId` varchar(100) DEFAULT NULL,
  `auditDay` varchar(8) DEFAULT NULL,
  `connectionDateTime` datetime DEFAULT NULL,
  `disconnectionDateTime` datetime DEFAULT NULL,
  `lastAccessDateTime` datetime DEFAULT NULL,
  `duration` time DEFAULT NULL,
  `idUser` int(12) unsigned DEFAULT NULL,
  `userName` varchar(100) DEFAULT NULL,
  `userAgent` varchar(400) DEFAULT NULL,
  `platform` varchar(100) DEFAULT NULL,
  `browser` varchar(100) DEFAULT NULL,
  `browserVersion` varchar(100) DEFAULT NULL,
  `requestRefreshParam` int(1) DEFAULT '0',
  `requestDisconnection` int(1) DEFAULT '0',
  `idle` int(1) unsigned DEFAULT '0',
  `requestRefreshProject` int(1) unsigned DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=9001 DEFAULT CHARSET=utf8;

What is the most weird, is that the renaming of the 3 columns is done in ProjeQtOr with one only query :

ALTER TABLE `${prefix}audit` CHANGE `connection` connectionDateTime datetime,
CHANGE `disconnection` disconnectionDateTime datetime,
CHANGE `lastAccess` lastAccessDateTime datetime;

So I cannot explain that your database is updated on only 1 of the 3 columns. It should be all or none (if error occured).

How did you install ? Really using default scripts ?
On which OS does the issue happen ?
Is you Database MySql or PostgreSql ? Which version ?

Hello,
Sorry for the late.

I installed again the tool and I have the same problem.

The version is now 4.5.4. The OS is centos 6.6 and the database is posgresql 9.3.5

regards

Denis

Hi,

It is possible that there is some database upgrade with PostgreSql database (some case sensibility issue).
Could you post the log file corresponding to your set-up ?

Where is it ?
I found it