Hi there,
I have recently installed projeqtor successfully. I am able to login as well.. However I do see "audit" table insert into query error in logs as below. I believe the issue is with "CONNECTION" field.
Please help me to resolve this issue.
Exception-[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'connection , lastAccess , duration , idle , requestRefreshParam , requestRefresh' at line 1
2014-10-07 16:01:40 ***** ERROR ***** For query : insert into audit ( sessionId , auditDay , idUser , userName , platform , browser , browserVersion , userAgent , connection , lastAccess , duration , idle , requestRefreshParam , requestRefreshProject , requestDisconnection ) values ('qr3uv056aim71243dhvajsjro7', '20141007', '1', 'admin', 'Windows', 'Google Chrome', '37.0.2062.124', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.124 Safari/537.36', '2014-10-07 16:01:40', '2014-10-07 16:01:40', '04:30:00', '0', '0', '0', '0')
2014-10-07 16:01:40 ***** ERROR ***** Strack trace :
2014-10-07 16:01:40 ***** ERROR ***** #0 Sql->query called at [C:\inetpub\wwwroot\projeqtor\model\persistence\SqlElement.php:664]
2014-10-07 16:01:40 ***** ERROR ***** #1 SqlElement->insertSqlElement called at [C:\inetpub\wwwroot\projeqtor\model\persistence\SqlElement.php:482]
2014-10-07 16:01:40 ***** ERROR ***** #2 SqlElement->saveSqlElement called at [C:\inetpub\wwwroot\projeqtor\model\persistence\SqlElement.php:371]
2014-10-07 16:01:40 ***** ERROR ***** #3 SqlElement->save called at [C:\inetpub\wwwroot\projeqtor\model\Audit.php:146]
2014-10-07 16:01:40 ***** ERROR ***** #4 Audit->updateAudit called at [C:\inetpub\wwwroot\projeqtor\tool\loginCheck.php:246]
2014-10-07 16:01:40 ***** ERROR ***** #5 loginOk called at [C:\inetpub\wwwroot\projeqtor\tool\loginCheck.php:102]
Best regards,
Jigar.