github-starred/gitea
2
0
Fork 0
mirror of https://github.com/go-gitea/gitea.git synced 2026-03-26 08:41:08 -05:00
Code Issues 2.6k Packages Projects Releases 100 Wiki Activity

UpdatePublicKey: near "WHERE": syntax error #633

New Issue
Closed
opened 2025-11-02 03:31:01 -06:00 by GiteaMirror · 2 comments
GiteaMirror commented 2025-11-02 03:31:01 -06:00
Owner
Copy Link

Originally created by @ncwgf on GitHub (Apr 10, 2017).

  • Gitea version (or commit ref): Gitea Version: 1.1.0+115-g54f0293f (Docker image)
  • Git version: git version 1.8.3.1
  • Operating system: CentOS Linux release 7.3.1611 (Core)
  • Database (use [x]):
    • PostgreSQL
    • MySQL
    • MSSQL
    • SQLite
  • Can you reproduce the bug at https://try.gitea.io:
    • Yes (provide example URL)
    • No
    • Not relevant
  • Log gist:

Description

When using git the pull/push the repo via ssh://git@<host>/<repo>, below error message will display
It do not affect the usage of git (data will update), just show the error from Gitea
When I need to git pull, I need to pull twice because worktree will only update at the second pull

git message

$git pull
remote: Counting objects: 4, done.
remote: Compressing objects: 100% (4/4), done.
remote: Total 4 (delta 3), reused 0 (delta 0)
Unpacking objects: 100% (4/4), done.
Gitea: Internal error
UpdatePublicKey: near "WHERE": syntax error
$ git pull
From ssh://<host>/<repo>
   da19297..b471986  master     -> origin/master
Gitea: Internal error
UpdatePublicKey: near "WHERE": syntax error
Updating da19297..b471986
Fast-forward
 libs/<file>.js | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

xorm.log

# pull with deploy key
2017/04/10 01:47:13 [I] [SQL] SELECT `id`, `owner_id`, `name`, `fingerprint`, `content`, `mode`, `type`, `created_unix`, `updated_unix` FROM `public_key` WHERE content like ? LIMIT 1 [<xxx>]
2017/04/10 01:47:13 [I] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `passwd`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `description`, `num_teams`, `num_members`, `diff_view_style` FROM `user` WHERE `lower_name`=? LIMIT 1 [<name>]
2017/04/10 01:47:13 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_bare`, `is_mirror`, `is_fork`, `fork_id`, `created_unix`, `updated_unix` FROM `repository` WHERE `owner_id`=? AND `lower_name`=? LIMIT 1 [3 <repo_name>]
2017/04/10 01:47:13 [I] [SQL] SELECT `id`, `owner_id`, `name`, `fingerprint`, `content`, `mode`, `type`, `created_unix`, `updated_unix` FROM `public_key` WHERE `id`=? LIMIT 1 [3]
2017/04/10 01:47:13 [I] [SQL] SELECT `id`, `key_id`, `repo_id`, `name`, `fingerprint`, `created_unix`, `updated_unix` FROM `deploy_key` WHERE key_id = ? AND repo_id = ? LIMIT 1 [3 1]
2017/04/10 01:47:13 [I] [SQL] SELECT `id`, `key_id`, `repo_id`, `name`, `fingerprint`, `created_unix`, `updated_unix` FROM `deploy_key` WHERE `key_id`=? AND `repo_id`=? LIMIT 1 [3 1]
2017/04/10 01:47:13 [I] [SQL] UPDATE `deploy_key` SET `key_id` = ?, `repo_id` = ?, `name` = ?, `fingerprint` = ?, `created_unix` = ?, `updated_unix` = ? WHERE `id`=? [3 1 <name> <fingerprint> 1491210652 1491788833 4]
2017/04/10 01:47:13 [I] [SQL] UPDATE `public_key` SET  WHERE `id`=? [3]

#fetch with public_key (SSH keys)
2017/04/10 01:52:36 [I] [SQL] SELECT `id`, `owner_id`, `name`, `fingerprint`, `content`, `mode`, `type`, `created_unix`, `updated_unix` FROM `public_key` WHERE content like ? LIMIT 1 [<xxx>]
2017/04/10 01:52:36 [I] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `passwd`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `description`, `num_teams`, `num_members`, `diff_view_style` FROM `user` WHERE `lower_name`=? LIMIT 1 [<name>]
2017/04/10 01:52:36 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_bare`, `is_mirror`, `is_fork`, `fork_id`, `created_unix`, `updated_unix` FROM `repository` WHERE `owner_id`=? AND `lower_name`=? LIMIT 1 [3 <repo>]
2017/04/10 01:52:36 [I] [SQL] SELECT `id`, `owner_id`, `name`, `fingerprint`, `content`, `mode`, `type`, `created_unix`, `updated_unix` FROM `public_key` WHERE `id`=? LIMIT 1 [1]
2017/04/10 01:52:36 [I] [SQL] SELECT * FROM `user` INNER JOIN `public_key` ON `public_key`.owner_id = `user`.id WHERE `public_key`.id=? LIMIT 1 [1]
2017/04/10 01:52:36 [I] [SQL] SELECT `id`, `user_id`, `repo_id`, `mode` FROM `access` WHERE `user_id`=? AND `repo_id`=? LIMIT 1 [1 3]
2017/04/10 01:52:36 [I] [SQL] UPDATE `public_key` SET  WHERE `id`=? [1]

#pull with public_key
2017/04/10 02:12:57 [I] [SQL] SELECT `id`, `owner_id`, `name`, `fingerprint`, `content`, `mode`, `type`, `created_unix`, `updated_unix` FROM `public_key` WHERE content like ? LIMIT 1 [<xxx>]
2017/04/10 02:12:57 [I] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `passwd`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `description`, `num_teams`, `num_members`, `diff_view_style` FROM `user` WHERE `lower_name`=? LIMIT 1 [<name>]
2017/04/10 02:12:57 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_bare`, `is_mirror`, `is_fork`, `fork_id`, `created_unix`, `updated_unix` FROM `repository` WHERE `owner_id`=? AND `lower_name`=? LIMIT 1 [3 <repo>]
2017/04/10 02:12:57 [I] [SQL] SELECT `id`, `owner_id`, `name`, `fingerprint`, `content`, `mode`, `type`, `created_unix`, `updated_unix` FROM `public_key` WHERE `id`=? LIMIT 1 [1]
2017/04/10 02:12:57 [I] [SQL] SELECT * FROM `user` INNER JOIN `public_key` ON `public_key`.owner_id = `user`.id WHERE `public_key`.id=? LIMIT 1 [1]
2017/04/10 02:12:57 [I] [SQL] SELECT `id`, `user_id`, `repo_id`, `mode` FROM `access` WHERE `user_id`=? AND `repo_id`=? LIMIT 1 [1 11]
2017/04/10 02:12:58 [I] [SQL] UPDATE `public_key` SET  WHERE `id`=? [1]

may be the relative commit 5c0bee9b20

Originally created by @ncwgf on GitHub (Apr 10, 2017). - Gitea version (or commit ref): Gitea Version: 1.1.0+115-g54f0293f (Docker image) - Git version: git version 1.8.3.1 - Operating system: CentOS Linux release 7.3.1611 (Core) - Database (use `[x]`): - [ ] PostgreSQL - [ ] MySQL - [ ] MSSQL - [x] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [ ] No - [x] Not relevant - Log gist: ## Description When using git the pull/push the repo via `ssh://git@<host>/<repo>`, below error message will display ~~It do not affect the usage of git (data will update), just~~ show the error from Gitea When I need to `git pull`, I need to pull twice because worktree will only update at the second pull git message ``` $git pull remote: Counting objects: 4, done. remote: Compressing objects: 100% (4/4), done. remote: Total 4 (delta 3), reused 0 (delta 0) Unpacking objects: 100% (4/4), done. Gitea: Internal error UpdatePublicKey: near "WHERE": syntax error $ git pull From ssh://<host>/<repo> da19297..b471986 master -> origin/master Gitea: Internal error UpdatePublicKey: near "WHERE": syntax error Updating da19297..b471986 Fast-forward libs/<file>.js | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) ``` xorm.log ``` # pull with deploy key 2017/04/10 01:47:13 [I] [SQL] SELECT `id`, `owner_id`, `name`, `fingerprint`, `content`, `mode`, `type`, `created_unix`, `updated_unix` FROM `public_key` WHERE content like ? LIMIT 1 [<xxx>] 2017/04/10 01:47:13 [I] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `passwd`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `description`, `num_teams`, `num_members`, `diff_view_style` FROM `user` WHERE `lower_name`=? LIMIT 1 [<name>] 2017/04/10 01:47:13 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_bare`, `is_mirror`, `is_fork`, `fork_id`, `created_unix`, `updated_unix` FROM `repository` WHERE `owner_id`=? AND `lower_name`=? LIMIT 1 [3 <repo_name>] 2017/04/10 01:47:13 [I] [SQL] SELECT `id`, `owner_id`, `name`, `fingerprint`, `content`, `mode`, `type`, `created_unix`, `updated_unix` FROM `public_key` WHERE `id`=? LIMIT 1 [3] 2017/04/10 01:47:13 [I] [SQL] SELECT `id`, `key_id`, `repo_id`, `name`, `fingerprint`, `created_unix`, `updated_unix` FROM `deploy_key` WHERE key_id = ? AND repo_id = ? LIMIT 1 [3 1] 2017/04/10 01:47:13 [I] [SQL] SELECT `id`, `key_id`, `repo_id`, `name`, `fingerprint`, `created_unix`, `updated_unix` FROM `deploy_key` WHERE `key_id`=? AND `repo_id`=? LIMIT 1 [3 1] 2017/04/10 01:47:13 [I] [SQL] UPDATE `deploy_key` SET `key_id` = ?, `repo_id` = ?, `name` = ?, `fingerprint` = ?, `created_unix` = ?, `updated_unix` = ? WHERE `id`=? [3 1 <name> <fingerprint> 1491210652 1491788833 4] 2017/04/10 01:47:13 [I] [SQL] UPDATE `public_key` SET WHERE `id`=? [3] #fetch with public_key (SSH keys) 2017/04/10 01:52:36 [I] [SQL] SELECT `id`, `owner_id`, `name`, `fingerprint`, `content`, `mode`, `type`, `created_unix`, `updated_unix` FROM `public_key` WHERE content like ? LIMIT 1 [<xxx>] 2017/04/10 01:52:36 [I] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `passwd`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `description`, `num_teams`, `num_members`, `diff_view_style` FROM `user` WHERE `lower_name`=? LIMIT 1 [<name>] 2017/04/10 01:52:36 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_bare`, `is_mirror`, `is_fork`, `fork_id`, `created_unix`, `updated_unix` FROM `repository` WHERE `owner_id`=? AND `lower_name`=? LIMIT 1 [3 <repo>] 2017/04/10 01:52:36 [I] [SQL] SELECT `id`, `owner_id`, `name`, `fingerprint`, `content`, `mode`, `type`, `created_unix`, `updated_unix` FROM `public_key` WHERE `id`=? LIMIT 1 [1] 2017/04/10 01:52:36 [I] [SQL] SELECT * FROM `user` INNER JOIN `public_key` ON `public_key`.owner_id = `user`.id WHERE `public_key`.id=? LIMIT 1 [1] 2017/04/10 01:52:36 [I] [SQL] SELECT `id`, `user_id`, `repo_id`, `mode` FROM `access` WHERE `user_id`=? AND `repo_id`=? LIMIT 1 [1 3] 2017/04/10 01:52:36 [I] [SQL] UPDATE `public_key` SET WHERE `id`=? [1] #pull with public_key 2017/04/10 02:12:57 [I] [SQL] SELECT `id`, `owner_id`, `name`, `fingerprint`, `content`, `mode`, `type`, `created_unix`, `updated_unix` FROM `public_key` WHERE content like ? LIMIT 1 [<xxx>] 2017/04/10 02:12:57 [I] [SQL] SELECT `id`, `lower_name`, `name`, `full_name`, `email`, `keep_email_private`, `passwd`, `login_type`, `login_source`, `login_name`, `type`, `location`, `website`, `rands`, `salt`, `created_unix`, `updated_unix`, `last_login_unix`, `last_repo_visibility`, `max_repo_creation`, `is_active`, `is_admin`, `allow_git_hook`, `allow_import_local`, `allow_create_organization`, `prohibit_login`, `avatar`, `avatar_email`, `use_custom_avatar`, `num_followers`, `num_following`, `num_stars`, `num_repos`, `description`, `num_teams`, `num_members`, `diff_view_style` FROM `user` WHERE `lower_name`=? LIMIT 1 [<name>] 2017/04/10 02:12:57 [I] [SQL] SELECT `id`, `owner_id`, `lower_name`, `name`, `description`, `website`, `default_branch`, `num_watches`, `num_stars`, `num_forks`, `num_issues`, `num_closed_issues`, `num_pulls`, `num_closed_pulls`, `num_milestones`, `num_closed_milestones`, `is_private`, `is_bare`, `is_mirror`, `is_fork`, `fork_id`, `created_unix`, `updated_unix` FROM `repository` WHERE `owner_id`=? AND `lower_name`=? LIMIT 1 [3 <repo>] 2017/04/10 02:12:57 [I] [SQL] SELECT `id`, `owner_id`, `name`, `fingerprint`, `content`, `mode`, `type`, `created_unix`, `updated_unix` FROM `public_key` WHERE `id`=? LIMIT 1 [1] 2017/04/10 02:12:57 [I] [SQL] SELECT * FROM `user` INNER JOIN `public_key` ON `public_key`.owner_id = `user`.id WHERE `public_key`.id=? LIMIT 1 [1] 2017/04/10 02:12:57 [I] [SQL] SELECT `id`, `user_id`, `repo_id`, `mode` FROM `access` WHERE `user_id`=? AND `repo_id`=? LIMIT 1 [1 11] 2017/04/10 02:12:58 [I] [SQL] UPDATE `public_key` SET WHERE `id`=? [1] ``` may be the relative commit 5c0bee9b20f50a26c7ac3fa90d1db2b8329d358b
GiteaMirror added the type/bug label 2025-11-02 03:31:01 -06:00
GiteaMirror commented 2025-11-02 03:31:02 -06:00
Author
Owner
Copy Link

@lunny commented on GitHub (Apr 10, 2017):

This will be resolved by #1471

@lunny commented on GitHub (Apr 10, 2017): This will be resolved by #1471
GiteaMirror commented 2025-11-02 03:31:02 -06:00
Author
Owner
Copy Link

@lunny commented on GitHub (Apr 19, 2017):

resolved by #1471

@lunny commented on GitHub (Apr 19, 2017): resolved by #1471
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
$20
$250
$50
$500
backport/done
💎 Bounty
docs-update-needed
good first issue
hacktoberfest
issue/bounty
issue/confirmed
issue/critical
issue/duplicate
issue/needs-feedback
issue/not-a-bug
issue/regression
issue/stale
issue/workaround
lgtm/need 2
modifies/api
modifies/translation
outdated/backport/v1.18
outdated/theme/markdown
outdated/theme/timetracker
performance/bigrepo
performance/cpu
performance/memory
performance/speed
pr/breaking
proposal/accepted
proposal/rejected
pr/wip
pull-request
Mirrored from GitHub Pull Request
 reviewed/wontfix
💰 Rewarded
skip-changelog
status/blocked
topic/accessibility
topic/api
topic/authentication
topic/build
topic/code-linting
topic/commit-signing
topic/content-rendering
topic/deployment
topic/distribution
topic/federation
topic/gitea-actions
topic/issues
topic/lfs
topic/mobile
topic/moderation
topic/packages
topic/pr
topic/projects
topic/repo
topic/repo-migration
topic/security
topic/theme
topic/ui
topic/ui-interaction
topic/ux
topic/webhooks
topic/wiki
type/bug
type/deprecation
type/docs
type/enhancement
type/feature
type/miscellaneous
type/proposal
type/question
type/refactoring
type/summary
type/testing
type/upstream
No Label type/bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#633
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?