The same error in Gogs v 0.8.0.1212

Thanks your feedback!

Can you dump the xorm.log here as well?

For this gogs.log record:

2015/12/14 01:34:13 [...routers/repo/view.go:260 renderItems()] [E] getter: pq: syntax error at or near "."

attached xorm.log.txt

Thanks!

Is this a valid SQL query in PostgreSQL?

SELECT * FROM "user" LEFT JOIN "watch" ON user.id=watch.user_id WHERE repo_id=1

If not, can you help debug which part is exactly wrong? The error from pg is so disappointing...

No, this is invalid SQL.
You should use this

SELECT * FROM "user"  LEFT JOIN "watch" ON "user".id=watch.user_id WHERE repo_id=1;

or even

SELECT * FROM "user" u LEFT JOIN "watch" ON u.id=watch.user_id WHERE repo_id=1;

Thanks, the user is the problem I'm thinking.

Does

SELECT * FROM "user"  LEFT JOIN "watch" ON `user`.id=watch.user_id WHERE repo_id=1;

would work?

Nope, only double quotes allowed. And user must be doublequoted - it is keyword

Hi, can you checkout develop branch and help test?

Yes I can)

Develop branch works fine. Thank you, Unknwon!

👏 Thanks your confirmation!

I have got the same error 500, and the same message in xorm.log. Thank you for the fix.