JDBCAdaptorException problem

Hi, I installed webcat on a AWS server but I'm having this problem. It seem to me that there is some incompatibility with the version of mysql that the server uses. I haven't manage to find more documentation about the project to see what are the requirements. Thank you for the help and really good project.

 

Exception:
----------
com.webobjects.jdbcadaptor.JDBCAdaptorException:
EvaluateExpression failed: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "SELECT DISTINCT t0.CDISCARDED, t0.OID, t0.CPAUSED, t0.processor, t0.CQUEUETIME, t0.CREGRADING, t0.CSUBMISSIONID FROM TENQUEUEDJOB t0, TSUBMISSION T1 WHERE (t0.CPAUSED = ? AND t0.CREGRADING = ?) AND t0.CSUBMISSIONID = T1.OID ORDER BY T1.CSUBMITTIME ASC" withBindings: 1:false(paused), 2:false(regrading)>:
    Next exception:SQL State:HY000 -- error code: 3065 -- msg: Expression #1 of ORDER BY clause is not in SELECT list, references column 'WebCAT.T1.CSUBMITTIME' which is not in SELECT list; this is incompatible with DISTINCT

Stack trace:
-----------------
at _jdbcErrorWithChannel(JDBCContext.java:170)
at _evaluateExpression(JDBCChannel.java:344)
at evaluateExpression(JDBCChannel.java:296)
at selectAttributes(JDBCChannel.java:220)
at _selectWithFetchSpecificationEditingContext(EODatabaseChannel.java:897)
at selectObjectsWithFetchSpecification(EODatabaseChannel.java:234)
at _objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3055)
at objectsWithFetchSpecification(EODatabaseContext.java:3204)
at objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488)
at objectsWithFetchSpecification(EOEditingContext.java:4069)
at objectsWithFetchSpecification(ERXEC.java:1114)
at objectsWithFetchSpecification(EOEditingContext.java:4444)
at objectsWithFetchSpecification(_EnqueuedJob.java:584)
at objectsMatchingQualifier(_EnqueuedJob.java:639)
at run(GraderQueueProcessor.java:167)

Groups:

Comments

Alejandro Bulnes

POSSIBLE SOLUTION

I found that, downgrading mysql to 5.6 fixed the issue.