Feeling Lucky
J3 Issue
?
[#24354] - URLs with utf8mb4 characters allowed
- Closed
- 20 Jun 2019
- Medium
- Build: staging
- # 24354
Steps to reproduce the issue
Try to copy/paste an utf8mb4 character such as
Expected result
The utf8mb4 character is stripped out and the link is working
Actual result
The utf8mb4 is still there and the link is broken causing a MySQL error:
1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
System information (as much as possible)
ALL Joomla versions
joomla-cms-bot
- | Labels |
Added:
?
|
||
franz-wohlkoenig
- | Status | New | ⇒ | Discussion |
| Category | ⇒ | Router / SEF |
| Labels |
Added:
J3 Issue
|
||
SharkyKZ
- comment
- 20 Jun 2019
@joeforjoomla please enable system debug in Global Configuration and post stack trace. Is this on a clean installation or updated? Do you have any extensions installed? Can you post a list of all your tables and their collations?
I can create the alias but I do not get the error. On a clean installation all tables should be utf8mb4.
| Status | Discussion | ⇒ | Information Required |
| Status | Information Required | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2019-06-20 08:20:15 |
| Closed_By | ⇒ | joeforjoomla |
I think you need to go to your PhpMyadmin and change the collation of the the tables from 'utf8_general_ci' to 'utf8mb4_unicode_ci'.
Here's an article I found that might help -https://www.joomlathat.com/support/music-collection/1267-illegal-mix-of-collations-utf8-general-ci-implicit-and-utf8mb4-general-ci-coercible-for-operation-like