View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Ongoing "Audit" issues - ProjeQtOr
 

Ongoing "Audit" issues

More
31 Jul 2015 14:13 - 31 Jul 2015 14:18 #1 by VERNCon
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...
Last edit: 31 Jul 2015 14:18 by VERNCon.

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

More
31 Jul 2015 15:42 #2 by babynus
Replied by babynus on topic Ongoing "Audit" issues

cannot create the parametersLocation.php file

This means that directory /tool is read only.
PHP user must have write rights during setup.

HOW do I go about getting the DB to run in the Version 5.0.x mode, and get rid of these AUDIT errors?

Have a clean install, with all prerequisites and folders in 755 access rights.

Babynus
Administrator of ProjeQtOr web site

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

More
31 Jul 2015 15:56 #3 by babynus
Replied by babynus on topic Ongoing "Audit" issues
Other hint.
Try this hack : in /view/login.php, replace line 34 from
if (getSessionValue('setup', null, true) ) {
to
if (getSessionValue('setup', null, true) or version_compare(ltrim(Sql::getDbVersion(),'V'), '5.0.0',"<") ) {

Tell me if this fixes your issue.

Babynus
Administrator of ProjeQtOr web site

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

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