Hi,
I have discovered that I am getting a mass of "Audit" errors in the log-files - I don't know when they have started, or what has triggered them.
I have gone through all the forum post's on similar instances - I have checked the database (shows V5.0.2, but that had to be "forced" during install because the software would not start up - login failures) upgraded from Version V5.0.2, to V5.0.3 - still the same.
I have checked that php-mbstring is loaded and functioning.
All looks OK, but the DB refuses to upgrade.to the version 5.
This is REALLY frustrating, and have been chasing it for two days now, without a hint of success.
I have also tried totally de-installing and re-installing direct to 5.0.3, that opens another "can of worms", i.e. it will not even build the database, despite pre-creating the DB "projeqtor", and the username "projeqtor" - in this case it tells me it cannot create the parametersLocation.php file, then sits them dumbly, doing NOTHING.
HOW do I go about getting the DB to run in the Version 5.0.x mode, and get rid of these AUDIT errors?
Regards,
VERNCon.
System is Fedora22, (Kernel 4.0), with Apache 2.4 and php-5.6.
[/ol]015-07-30 20:08:32.230 ***** ERROR ***** For query : insert into audit ( sessionId , auditDay , idUser , userName , platform , browser , browserVersion , userAgent , connectionDateTime , lastAccessDateTime , duration , idle , requestRefreshParam , requestRefreshProject , requestDisconnection ) values ('nhffsg63plrd4k8idhc3b7n4n3', '20150730', '1', 'admin', 'Windows', 'Mozilla Firefox', '39.0', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:39.0) Gecko/20100101 Firefox/39.0', '2015-07-30 20:08:32', '2015-07-30 20:08:32', '00:00:00', '0', '0', '0', '0')
2015-07-30 20:08:32.230 ***** ERROR ***** Strack trace :
2015-07-30 20:08:32.230 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:750]
2015-07-30 20:08:32.230 ***** ERROR ***** #1 SqlElement->insertSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:563]
2015-07-30 20:08:32.230 ***** ERROR ***** #2 SqlElement->saveSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:452]
2015-07-30 20:08:32.231 ***** ERROR ***** #3 SqlElement->save called at [/var/www/html/projeqtor/model/Audit.php:188]
2015-07-30 20:08:32.231 ***** ERROR ***** #4 Audit->updateAudit called at [/var/www/html/projeqtor/tool/projeqtor.php:231]
2015-07-30 20:08:32.231 ***** ERROR ***** #5 require_once called at [/var/www/html/projeqtor/tool/saveCollapsed.php:30]
2015-07-30 20:08:48.540 ***** ERROR ***** Exception-[42703] SQLSTATE[42703]: Undefined column: 7 ERROR: column "connectiondatetime" of relation "audit" does not exist
LINE 1: ...platform , browser , browserVersion , userAgent , connection...
^
2015-07-30 20:08:48.540 ***** ERROR ***** For query : insert into audit ( sessionId , auditDay , idUser , userName , platform , browser , browserVersion , userAgent , connectionDateTime , lastAccessDateTime , duration , idle , requestRefreshParam , requestRefreshProject , requestDisconnection ) values ('nhffsg63plrd4k8idhc3b7n4n3', '20150730', '1', 'admin', 'Windows', 'Mozilla Firefox', '39.0', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:39.0) Gecko/20100101 Firefox/39.0', '2015-07-30 20:08:48', '2015-07-30 20:08:48', '00:00:00', '0', '0', '0', '0')
2015-07-30 20:08:48.540 ***** ERROR ***** Strack trace :
2015-07-30 20:08:48.540 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:750]
2015-07-30 20:08:48.540 ***** ERROR ***** #1 SqlElement->insertSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:563]
2015-07-30 20:08:48.541 ***** ERROR ***** #2 SqlElement->saveSqlElement called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:452]
2015-07-30 20:08:48.541 ***** ERROR ***** #3 SqlElement->save called at [/var/www/html/projeqtor/model/Audit.php:188]
2015-07-30 20:08:48.541 ***** ERROR ***** #4 Audit->updateAudit called at [/var/www/html/projeqtor/tool/projeqtor.php:231]
2015-07-30 20:08:48.541 ***** ERROR ***** #5 require_once called at [/var/www/html/projeqtor/tool/saveDataToSession.php:30]
2015-07-30 20:08:48.802 ===== TRACE ===== DISCONNECTED USER 'admin'
2015-07-30 20:08:49.025 ***** 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...