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
| Field | Original Value | New Value |
|---|---|---|
| Story Points | 3 |
| Sprint | 5.1.0 Sprint 1 [ 125 ] |
| Rank | Ranked higher |
| Assignee | Jonathan Reissmueller [ jonathan ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
Paul Phillips
made changes -
| 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 not 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 not 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). |
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 not 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 not utf8mb4 and mysql < 5.7 or mariadb < 10.2.2 "Please upgrade 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). |
| 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 not 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 not utf8mb4 and mysql < 5.7 or mariadb < 10.2.2 "Please upgrade 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). |
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 not utf8mb4 and mysql >= 5.7 or mariadb >= 10.2.2 "Update the character set and collation of your database, tables, and columns to utf8mb4to support 4 byte characters such as emojis." * If any tables or columns are not 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 utf8mb4characters 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). |
| 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 not utf8mb4 and mysql >= 5.7 or mariadb >= 10.2.2 "Update the character set and collation of your database, tables, and columns to utf8mb4to support 4 byte characters such as emojis." * If any tables or columns are not 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 utf8mb4characters 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). |
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 not 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 not 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). |
| 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 not 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 not 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). |
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). |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 50 minutes [ 3000 ] | |
| Worklog Id | 14682 [ 14682 ] |
| Time Spent | 50 minutes [ 3000 ] | 3 hours, 26 minutes [ 12360 ] |
| Worklog Id | 14684 [ 14684 ] |
| Time Spent | 3 hours, 26 minutes [ 12360 ] | 3 hours, 49 minutes [ 13740 ] |
| Worklog Id | 14686 [ 14686 ] |
| Status | In Progress [ 3 ] | In Review [ 5 ] |
| Resolution | Fixed [ 1 ] |
| Time Spent | 3 hours, 49 minutes [ 13740 ] | 4 hours, 29 minutes [ 16140 ] |
| Worklog Id | 14694 [ 14694 ] |
| Status | In Review [ 5 ] | Closed [ 6 ] |
