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 ?
Support us on Capterra
