[#8376] - Correcting order of queries in update sql + wrong alias char in joomla.sql
- Closed
- 11 Nov 2015
- Medium
- Build: staging
- # 8376
- Diff
- infograf768:sql350
- Success The Travis CI build passed Details
User tests: Successful: Unsuccessful:
See #8374
When updating, in 3.5.0-2015-07-01.sql, the alias collation to utf8mb4_bin has to be modified AFTER the table changes to utf8mb4_general_ci
To test: install a clean 3.4.5, then download https://github.com/joomla/joomla-cms/releases/download/3.5.0-beta/Joomla_3.5.0-beta-Beta-Update_Package.zip , unzip and replace ROOT/administrator/components/com_admin/sql/updates/mysql/3.5.0-2015-07-01.sql by the modified file. Zip again.
Then install the update via Extensions=>Update
There will be one issue to fix (related to user_profile) in Database Fix (see below)
Then in PHPMyadmin, export your database.
The alias definitions will now correctly be:
`alias` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
The PR also corrects some alias varchar when installing a clean full 3.5.0. They should be 191 and not 255.
This PR does NOT solve the other issue reported in #8374
i.e.
Table 'mytable_user_profiles' does not have column 'profile_value' with type 'TEXT'.
(From file 3.3.4-2014-08-03.sql.)
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Labels |
Added:
?
|
||
| Category | ⇒ | Installation Updating |
| Status | Pending | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2015-11-11 11:25:00 |
| Closed_By | ⇒ | Kubik-Rubik |
| Milestone |
Added: |
||
Tested successfully, thank you @infograf768! Merged on code review.