Incorrect sorting in paging functionality #15033

New Issue

GiteaMirror · 2025-11-02T11:28:37-06:00

GiteaMirror commented

2025-11-02 11:28:37 -06:00

Originally created by @zeekling on GitHub (Oct 18, 2025).

Description

Incorrect sorting in paging functionality

page one, has project kerberosTest

click next page, and alse has project kerberosTest

Gitea Version

1.24.6

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

No response

Screenshots

No response

Git Version

1.24.6

Operating System

No response

How are you running Gitea?

No

Database

MySQL/MariaDB

Originally created by @zeekling on GitHub (Oct 18, 2025). ### Description Incorrect sorting in paging functionality page one, has project kerberosTest <img width="484" height="751" alt="Image" src="https://github.com/user-attachments/assets/a6d587db-c577-41b4-92bb-a2f42f67bc36" /> click next page, and alse has project kerberosTest <img width="544" height="761" alt="Image" src="https://github.com/user-attachments/assets/984f272c-c650-4ab0-b4e0-bab2fb7d2585" /> ### Gitea Version 1.24.6 ### Can you reproduce the bug on the Gitea demo site? No ### Log Gist _No response_ ### Screenshots _No response_ ### Git Version 1.24.6 ### Operating System _No response_ ### How are you running Gitea? No ### Database MySQL/MariaDB

GiteaMirror added the type/bug label 2025-11-02 11:28:37 -06:00

GiteaMirror commented

2025-11-02 11:28:38 -06:00

@mithileshgupta12 commented on GitHub (Oct 30, 2025):

I tried reproducing the issue but could not replicate it. Can you please provide more details like

Is it still happening on the latest gitea version?
How many repos do you have?

@mithileshgupta12 commented on GitHub (Oct 30, 2025): I tried reproducing the issue but could not replicate it. Can you please provide more details like - Is it still happening on the latest gitea version? - How many repos do you have?

GiteaMirror commented

2025-11-02 11:28:38 -06:00

@zeekling commented on GitHub (Oct 30, 2025):

I tried reproducing the issue but could not replicate it. Can you please provide more details like

Is it still happening on the latest gitea version?

How many repos do you have?

yes, on 1.24.6
35 repos

@zeekling commented on GitHub (Oct 30, 2025): > I tried reproducing the issue but could not replicate it. Can you please provide more details like > > * Is it still happening on the latest gitea version? > * How many repos do you have? 1. yes, on 1.24.6 2. 35 repos

GiteaMirror commented

2025-11-02 11:28:38 -06:00

@mithileshgupta12 commented on GitHub (Oct 31, 2025):

Ok so I tried replicating this issue with same number of repos with latest version of gitea and MySQL 8, and I was not able to replicate the issue. It would be great if you can tell me the exact version of database and database type. Also maybe try updating to latest version of gitea and see if issue still persists.

@mithileshgupta12 commented on GitHub (Oct 31, 2025): Ok so I tried replicating this issue with same number of repos with latest version of gitea and MySQL 8, and I was not able to replicate the issue. It would be great if you can tell me the exact version of database and database type. Also maybe try updating to latest version of gitea and see if issue still persists.

GiteaMirror commented

2025-11-02 11:28:39 -06:00

@zeekling commented on GitHub (Oct 31, 2025):

mysql info:


MySQL [gitea]> status
--------------
mysql  Ver 15.1 Distrib 10.3.38-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Connection id:          2778779
Current database:       gitea
Current user:           root@172.17.0.1
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server:                 MySQL
Server version:         8.4.6 MySQL Community Server - GPL
Protocol version:       10
Connection:             127.0.0.1 via TCP/IP
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    utf8mb4
Conn.  characterset:    utf8mb4
TCP port:               3306
Uptime:                 40 days 8 hours 12 min 56 sec

Threads: 7  Questions: 433651192  Slow queries: 71  Opens: 5709  Flush tables: 3  Open tables: 2643  Queries per second avg: 124.413

@zeekling commented on GitHub (Oct 31, 2025): mysql info: ``` MySQL [gitea]> status -------------- mysql Ver 15.1 Distrib 10.3.38-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Connection id: 2778779 Current database: gitea Current user: root@172.17.0.1 SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server: MySQL Server version: 8.4.6 MySQL Community Server - GPL Protocol version: 10 Connection: 127.0.0.1 via TCP/IP Server characterset: utf8mb4 Db characterset: utf8mb4 Client characterset: utf8mb4 Conn. characterset: utf8mb4 TCP port: 3306 Uptime: 40 days 8 hours 12 min 56 sec Threads: 7 Questions: 433651192 Slow queries: 71 Opens: 5709 Flush tables: 3 Open tables: 2643 Queries per second avg: 124.413 ```

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/gitea#15033