Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create issue with multiple labels throws an error 500 with sqlite3 #2700

Closed
neolit123 opened this issue Feb 25, 2016 · 5 comments
Closed

Create issue with multiple labels throws an error 500 with sqlite3 #2700

neolit123 opened this issue Feb 25, 2016 · 5 comments
Labels
💊 bug Something isn't working
Milestone

Comments

@neolit123
Copy link
Contributor

- Gogs version (or commit ref):
 0.8.43.0223
- Git version:
git version 1.7.9.5
- Operating system:
Ubuntu 12.04.1 LTS
- Database:
SQLite

seems to happen only for sqlite3!

steps:

- create a new repository via the Web UI
- push something
- create a couple of labels for the issue tracker
- create issue
- write some text for the title and message of the issue
- add both labels on the right
- done
- error 500
repo/issue.go:427 NewIssuePost()] [E] NewIssue: newIssue: label does not exist [id: XXXXX]
# where XXXX seems to be an index out of the whole range of user labels

if you select only a single or no labels out of the list when creating the issue it does work.

original thread:
#1701

@unknwon unknwon changed the title creating issues with multiple labels throws a Error 500 with sqlite3 Create issue with multiple labels throws an error 500 with sqlite3 Feb 26, 2016
@unknwon unknwon added the 💊 bug Something isn't working label Feb 26, 2016
@unknwon unknwon added this to the 0.9.0 milestone Feb 26, 2016
@sapk
Copy link
Contributor

sapk commented Feb 27, 2016

I have the same problem with sqlite (Gogs Version: 0.8.43.0223) (docker container)
Log : 2016/02/27 15:00:41 [...outers/repo/issue.go:478 NewIssuePost()] [E] NewIssue: newIssue: label does not exist [id: 4]

@unknwon
Copy link
Member

unknwon commented Feb 29, 2016

Hi, I just pushed a fix to develop branch, please help test again.

@neolit123
Copy link
Contributor Author

hello @unknwon, thanks for looking into this.
i need to find the time to prepare the Gogs build setup to test it, unless you can provide some sort of a daily build (which is a good idea to have on a regular basis at least for Linux-64bit and if automated properly).

in the meantime pinging @kpande, who reported the original issue to see if he has the build setup to quickly test the develop branch.

@neolit123
Copy link
Contributor Author

@unknwon, i was able to build Gogs (0.8.49.0229) and test it with sqlite3.
the issue seems to be fixed!

@unknwon
Copy link
Member

unknwon commented Mar 1, 2016

@neolit123 thanks your confirmation!

@unknwon unknwon closed this as completed Mar 1, 2016
@unknwon unknwon removed the status: needs feedback Tell me more about it label Mar 1, 2016
ausbin added a commit to ausbin/gogs that referenced this issue Jul 20, 2016
Wait until we're done adding a new issue to the database to attempt to
search the `repository' table for the issue's repository id. Otherwise,
on SQLite, retrieving the repository will fail, probably for the same
reason as gogs#2700 (and ea80274) -- the SQLite driver for xorm can't
retrieve objects after something was updated.

Fixes gogs#3291.
ausbin added a commit to ausbin/gogs that referenced this issue Jul 21, 2016
Wait until we're done adding a new issue to the database to attempt to
search the `repository' table for the issue's repository id. Otherwise,
on SQLite, retrieving the repository will fail, probably for the same
reason as gogs#2700 (and ea80274) -- the SQLite driver for xorm can't
retrieve objects after something was updated.

Fixes gogs#3291.
ethantkoenig referenced this issue in unfoldingWord/dcs Oct 18, 2017
* provide both possible authentication solutions

Signed-off-by: David Schneiderbauer <dschneiderbauer@gmail.com>
ethantkoenig pushed a commit to ethantkoenig/gogs that referenced this issue Nov 10, 2017
* provide both possible authentication solutions

Signed-off-by: David Schneiderbauer <dschneiderbauer@gmail.com>
@github-actions github-actions bot locked as resolved and limited conversation to collaborators May 3, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
💊 bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants