Feeling Lucky
?
[#9249] - Duplicate Key Entry for idx_term in #__finder_terms after updating to 3.5b3 an running db fix again
- Closed
- 11 Mar 2016
- Medium
- Build: master
- # 9249
Steps to reproduce the issue
- Run Database Fix Tool after upgrading to 3.5b3 on an utf8mb4 capable site
Expected result
- Migrate Database to utf8mb4_general_ci
Actual result
- An error is shown for #__finder_terms (idx_term) duplicate entry
System information (as much as possible)
Additional comments
- Delete the Search index
- Run Database migrations
- Rebuild the search index
Fixes the Problem!
brianteeman
- | Labels |
Added:
?
|
||
swiffer
- comment
- 1 Mar 2016
sorry, i directly cleaned the index and rebuild it after running the migrations
wilsonge
- comment
- 1 Mar 2016
Do you not have a copy of the original site (you should never run betas on production sites!) - but if not then I'll have to close this as neither me nor Eli could find a way to replicate the issue
| Category | ⇒ | SQL Updating |
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2016-03-11 12:07:39 |
| Closed_By | ⇒ | wilsonge |
OK So I am super confused here - because this column is VARCHAR(75) length so we should never exceed it's length. I have tried several times and I'm unable to replicate this in anyway. Have you been able to identify the rows that are triggering this?