SQL error when sending catches to the API

FrancisG-Massey / Capstone2016

4 stars 0 forks source link

SQL error when sending catches to the API #159

Closed FrancisG-Massey closed 8 years ago

FrancisG-Massey commented 8 years ago

When trying to send catches to the server (via POST /catch), a 500 error is returned and the following message appears in the server log:

Oct 12, 2016 9:19:27 AM org.nestnz.api.RequestServlet doRequest
INFO: IO/SQL error while executing queries:
ERROR: INSERT has more expressions than target columns
  Position: 378
org.apache.catalina.connector.ResponseFacade@4e5e8da3
Returning 500...

sam-hunt commented 8 years ago

catch_traptypeid was missing from the column list in catch.json

sam-hunt commented 8 years ago

fixed on test. will be in the next merge.