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:inetpubwwwrootprojeqtormodelpersistenceSqlElement.php:664]
2014-10-07 16:01:40 ** ERROR ** #1 SqlElement->insertSqlElement called at [C:inetpubwwwrootprojeqtormodelpersistenceSqlElement.php:482]
2014-10-07 16:01:40 ** ERROR ** #2 SqlElement->saveSqlElement called at [C:inetpubwwwrootprojeqtormodelpersistenceSqlElement.php:371]
2014-10-07 16:01:40 ** ERROR ** #3 SqlElement->save called at [C:inetpubwwwrootprojeqtormodelAudit.php:146]
2014-10-07 16:01:40 ** ERROR ** #4 Audit->updateAudit called at [C:inetpubwwwrootprojeqtortoolloginCheck.php:246]
2014-10-07 16:01:40 ** ERROR ** #5 loginOk called at [C:inetpubwwwrootprojeqtortoolloginCheck.php:102]

Best regards,

Jigar.