Error Whilst Rebuilding Database

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • beeline
    Junior Member
    • Jan 2023
    • 6
    #1

    Error Whilst Rebuilding Database

    Hi, I've recently encountered an error when rebuilding my database. It is preventing me creating / editing custom entities.

    My host interpreted the logs to suggest "Specified key was too long". My most recent log file is attached.

    I am running version 7.2.7 and am showing 'Success' against all System Requirements (Administration > System Requirements).

    Attached Files
    Tags: None
    • beeline
      Junior Member
      • Jan 2023
      • 6
      #2
      I've just tried to upgrade to 7.3.1 and the issue is preventing the upgrade too (I'd hoped it would fix it). I have just updated my PHP to 8.0.27 too.

        Comment

        • yuri
          Member
          • Mar 2014
          • 8454
          #3
          Hi,

          You are on MariaDB? What version?
          If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

            Comment

            • yuri
              Member
              • Mar 2014
              • 8454
              #4
              Your entity, which name begins with "sta". Do you have a custom index created there?
              If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                Comment

                • beeline
                  Junior Member
                  • Jan 2023
                  • 6
                  #5
                  Hi, thanks for your help. Drawing my attention to the entity beginning with STA helped me resolve the problem.

                    Comment

                    • shalmaxb
                      #5.1
                      shalmaxb commented
                      01-11-2023, 01:44 PM
                      Editing a comment
                      Hi, being a bit more specific in how you solved the problem could be helpful for others, when similar happens to them. Thank you.
                    • beeline
                      Junior Member
                      • Jan 2023
                      • 6
                      #6
                      Just wanted to post the outcome of this in case anyone comes across the same issue. The entity in question was used as a message board, and the issue came because I was using the default Name field for the messages. Some messages were too long and caused the issue. I have since restructures using a proper text field now for the messages.

                        Comment

                        Previous template Next
                        Working...