Error 1406: Data too long for column 'payload_content' #19679
Labels
Comments
|
Similar to this one:
MySQL's TEXT can only hold 64K string. It should be altered to LONGTEXT if you have a lot of data. |
zeripath
pushed a commit
that referenced
this issue
Jun 19, 2022
Mysql TEXT has a limit of 64KB, change this to LONGTEXT in mysql only so we can have bigger hook payloads. Postgresql has unlimited TEXT - https://www.postgresql.org/docs/current/datatype-character.html Sqlite has unlimited TEXT - https://www.sqlitetutorial.net/sqlite-data-types/#:~:text=The%20maximum%20length%20of%20TEXT,SQLite%20supports%20various%20character%20encodings. Same issue as #16656 but for hook_task Fixes #10252, #19679, #3561
|
Fixed in #20038 |
vsysoev
pushed a commit
to IntegraSDL/gitea
that referenced
this issue
Aug 10, 2022
Mysql TEXT has a limit of 64KB, change this to LONGTEXT in mysql only so we can have bigger hook payloads. Postgresql has unlimited TEXT - https://www.postgresql.org/docs/current/datatype-character.html Sqlite has unlimited TEXT - https://www.sqlitetutorial.net/sqlite-data-types/#:~:text=The%20maximum%20length%20of%20TEXT,SQLite%20supports%20various%20character%20encodings. Same issue as go-gitea#16656 but for hook_task Fixes go-gitea#10252, go-gitea#19679, go-gitea#3561
AbdulrhmnGhanem
pushed a commit
to kitspace/gitea
that referenced
this issue
Aug 24, 2022
Mysql TEXT has a limit of 64KB, change this to LONGTEXT in mysql only so we can have bigger hook payloads. Postgresql has unlimited TEXT - https://www.postgresql.org/docs/current/datatype-character.html Sqlite has unlimited TEXT - https://www.sqlitetutorial.net/sqlite-data-types/#:~:text=The%20maximum%20length%20of%20TEXT,SQLite%20supports%20various%20character%20encodings. Same issue as go-gitea#16656 but for hook_task Fixes go-gitea#10252, go-gitea#19679, go-gitea#3561
Sign up for free
to subscribe to this conversation on GitHub.
Already have an account?
Sign in.
Description
Noticed one occurrence of error
in gitea log.
Gitea Version
1.16.3
Can you reproduce the bug on the Gitea demo site?
No
Log Gist
No response
Screenshots
No response
Git Version
2.30.2
Operating System
Debian
How are you running Gitea?
Gitea build from sources using go 1.17.9.
Database
MySQL
The text was updated successfully, but these errors were encountered: