luisdelavega / matchup Goto Github PK

For some reason doing an put for editing a review is giving me the following response:

Status: 404
Message: Cannot PUT /matchup/events/Event%2001/review/test02?date=2015-03-25T09:00:00.000Z&location=miradero

Information used at the time:
Username: "test02"
Event name: "Event 01"
Event date: "2015-03-25T09:00:00.000Z"
Event Location: "miradero"

http://matchup.neptunolabs.com/matchup/events/Event%2001/review/test02?date=2015-03-25T09:00:00.000Z&location=miradero

I tried to run the Create_Event3.sql in the VM but it didn't work. I remembered that I had changed the file a bit because in my local DB the timestamps for Events are all set for 'without time zone'. That should be part of the issue but the error it logs is kinda weird:
psql:Create_Event3.sql:1: ERROR: syntax error at or near "START"
LINE 1: START TRANSACTION;

Edwin, try and alter the tables so that the timestamps are set without time zone in the VM.
This is what I used to do my local:
http://www.postgresql.org/docs/9.1/static/sql-altertable.html

I would do it myself but I really have to go, you know. Love u boo!