Bug #85315
closed
8.7.16 - Install Tool - Database Analyzer endless loop of already apllied changes detected after upgrading from 8.7.15
0%
Description
After upgrading from 8.7.15 to 8.7.16, Database Analyzer show a lot of similar to-be-upgraded entries like the following:
[ ] ALTER TABLE `be_groups` CHANGE `title` `title` VARCHAR DEFAULT '' NOT NULL
Current value: title VARCHAR DEFAULT '''' NOT NULL COLLATE utf8_general_ci
When "selecting all" and "execute" all, next run of Database Analyzer shows all of these changes again. I guess it's maybe because of the "COLLATE utf8_general_ci" setting, which might trigger Database Analyzer to detect this as change.
Updated by
Updated by Susanne Moog over 5 years ago
- Status changed from New to Needs Feedback
Hey,
thanks for the report. To clarify things, can you provide the following additional info:
- What charset is your database / database connection / client using?
- What collation/charset is the table mentioned using?
- What charset is default?
Try setting all of these to UTF-8 and run the analyser again - is the issue still persistent? What happens if you manually remove the collation?
Updated by Riccardo De Contardi over 5 years ago
- Status changed from Needs Feedback to Closed
No feedback since the last 90 days => closing this issue.
If you think that this is the wrong decision or experience the issue again and have more information about how to reproduce your problem, please reopen it or open a new issue with a reference to this one.
Thank you and best regards