Uploaded image for project: 'Blesta Core'
  1. Blesta Core
  2. CORE-4131

Create Tools > Utilities page with database collation update

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.0.1
    • Component/s: None
    • Labels:
      None

      Description

      First, remove the database collation upgrade from the database.

      Add a new page in the admin interface under Tools > Utilites

      On this page there should be a button "Update to utf8mb4" with a short paragraph beside it. This paragraph should be different based on the state of the system:

      • If any tables or columns are utf8mb4 and mysql >= 5.7 or mariadb >= 10.2.2 "Update the character set and collation of your database, tables, and columns to utf8mb4 to support 4 byte characters such as emojis."
      • If any tables or columns are utf8mb4 and mysql < 5.7 or mariadb < 10.2.2 "Please upgrade to MySQL to 5.7+ or MariaDB to 10.2.2+ to support utf8mb4 characters such as emojis."
        • Disable the button under this condition
      • If all tables and columns are utf8mb4 "Database already supports utf8mb4"
        • Disable the button under this condition

      When the button is clicked we should do the same thing we are doing in the upgrade right now (Maybe put that code in a utility so we're not making database calls in the controller).

        Activity

          People

          • Assignee:
            jonathan Jonathan Reissmueller
            Reporter:
            jonathan Jonathan Reissmueller
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Fix Release Date:
              20/Jan/21

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 4 hours, 29 minutes
              4h 29m

                Agile