XenForo query error [1178]: The storage engine for the table doesn't support descending indexes

Asphyxia

Owner
Administrator
Apr 25, 2015
1,845
2
2,199
327
1607410355002.png

Code:
XF\Db\InvalidQueryException: xf_post: MySQL query error [1178]: The storage engine for the table doesn't support descending indexes in src/XF/Db/AbstractStatement.php at line 228
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 77
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Db/Schema/AbstractDdl.php at line 151
XF\Db\Schema\AbstractDdl->apply() in src/XF/Db/SchemaManager.php at line 149
XF\Db\SchemaManager->alterTable() in src/XF/Install/InstallHelperTrait.php at line 675
XF\Install\Upgrade\AbstractUpgrade->alterTable() in src/XF/Install/Upgrade/2020010-220a.php at line 282
XF\Install\Upgrade\Version2020010->step10() in src/XF/Install/Controller/Upgrade.php at line 175
XF\Install\Controller\Upgrade->actionRun() in src/XF/Mvc/Dispatcher.php at line 350
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
XF\App->run() in src/XF.php at line 488
XF::runApp() in install/index.php at line 14

Code:
ALTER TABLE `xf_post`
ADD `type_data` MEDIUMBLOB NOT NULL AFTER `position`,
ADD `vote_score` INT NOT NULL,
ADD `vote_count` INT UNSIGNED NOT NULL DEFAULT '0',
ADD KEY `thread_id_score_date` (`thread_id`, `vote_score` DESC, `post_date`)

... so what did I end up doing since the 'DESC' piece kept effing up? (I failed in trying to switch from innodb to myisam engine)

I tried installing MariaDB alongside MySQL, that was a quick fiasco. I then blew away everything regarding mysql and mariadb (completely purged it all):
Code:
apt-get remove --purge mysql*
apt-get remove --purge mysql
apt-get remove --purge mariadb
apt-get remove --purge mariadb*
apt-get --purge remove mariadb-server
apt-get --purge remove python-software-properties

Keep in mind, I for sure kept a backup of my database for later access to import this all into MariaDB.

Anyway.. the solution was simply installing the MariaDB service, adding a user, importing the database in.

Yep.. that's all folks. No more silly database stuff, just running MariaDB from now on. Cool
 
Top