Mentionin you error

After #8201 i check mentionin you group on try.gitea.io. but response 500 status code

When i check same repo on local there is no error, works well 🤔

[guillep2k]

Can you give us the URL? Perhaps an admin can check the logs

[guillep2k]

Here's a link.
https://try.gitea.io/issues?type=mentioned&repo=0&sort=&state=open
I've just registered a new test user (no activity) and the server error shows up immediately.

[guillep2k]

The error is not showing on my dev server, neither with an old user or a new one.

[guillep2k]

@lunny is it possible to get the log from try.gitea.io?

[lunny]

@guillep2k It seems try.gitea.io's log is misconfiguration. I cannot find error stack information.

i created a user on gitea.com and there is no any error with that

[lunny]

@jaqra gitea.com hasn't been updated to a recent version since there are serval bugs. But I tested it locally and I cannot reproduce this.

ahh sorryy

[lunny]

@jaqra @guillep2k could you confirm your local instance could reproduce this?

[guillep2k]

@lunny No, I couldn't reproduce it locally. So far the only place the problem showed up is on try.gitea.io.

@lunny no. with sqlite db

[guillep2k]

In my case I use PostgreSQL

[guillep2k]

@jaqra with the help from @techknowlogick this is an excerpt of the log from the server with the error:

https://gist.github.com/techknowlogick/39b137e092c80c04212ff3c398ed4d86

SELECT count(*) FROM `issue`
INNER JOIN issue_user ON issue.id = issue_user.issue_id and issue_user.is_mentioned = ?
WHERE issue.is_pull=? AND (is_closed = ?) AND (issue_user.uid = ?)

{true, false, false, 4940}

routers/user/home.go:352:Issues() [E] GetUserIssueStats: ambiguous column name: is_closed

It looks like try.gitea.io has some extra columns in the database (in particular issue_user seems to have a is_closed column). It might be a leftover from some old migration.

@lunny is there anything that can be done about it?