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.

Sign up for GitHub

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

Jump to bottom

quanda table lngfile key too long #6163

Closed
MissAllSunday opened this issue Jun 22, 2020 · 0 comments · Fixed by #6868
Closed

quanda table lngfile key too long #6163

MissAllSunday opened this issue Jun 22, 2020 · 0 comments · Fixed by #6868
Labels
Installer Upgrader
Milestone
2.1.0

Comments

@MissAllSunday
Copy link
Contributor

Description

for MySQL in utf8mb4, the lngfile column is set to 255 which causes issues on saving due to the way utf8mb4 requires more storage than utf8 or latin

Steps to reproduce

  1. use a MySQL utf8mb4 db
  2. use the quanda feature

Environment (complete as necessary)

  • Version/Git revision:
  • Database Type: MySQL
  • Database Version: > 5.7
  • PHP Version:

Additional information/references

Not every install can use inno to enable innodb_large_prefix so the only feasible solution is to limit the lngfile column to 250 length

Ref: https://www.simplemachines.org/community/index.php?topic=573832.msg4061249#msg4061249
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Installer Upgrader
Projects
None yet
Milestone
2.1.0
2 participants
@live627 @MissAllSunday