SMF 2.1 RC2 Upgrade script fails on MySql 8 - idx_likes

Started by PhilGer, June 21, 2020, 09:53:17 AM

Previous topic - Next topic

PhilGer

Problem: Upgrade script fails on MySql 8 when creating idx_likes

Source: upgrade_2-1_mysql.sql

Step:
/******************************************************************************/
--- Create index for messages likes
/******************************************************************************/
---# Add Index for messages likes
CREATE INDEX idx_likes ON {$db_prefix}messages (likes DESC);
---#


-> Error: The storage engine for the table doesn't support descending indexes

As workaround I removed the DESC attribute of the index.

Illori

are you using SMF 2.1 from github or from our downloads page? if from the downloads page, please test from github as some of these bugs may be fixed already.

PhilGer

Yes, I was using the Large Update from the download page.

Quoteplease test from github as some of these bugs may be fixed already.
You are right. There is a similar issue on GitHub marked as Closed - HasFix.

It doesn't really belong in this thread, but anyways: Wouldn't it make sense to release a packaged Version 2.1 RC 2.1 to get all those bug fixes since the original RC2 on the download page?

Arantor

No, no it really, really wouldn't

We've been through the pain of 'partial improvement RCs' in the past (c.f. 2.0 RC1-1, 2.0 RC1.2), the package manager in particular has issues with having to do it and it raises more bugs trying to have it.

RC3 is meant to be 'soon' though.

Advertisement: