- Affected version
- 2.0.10
Caused by the effective following code;
PHP:
public function installStep1()
{
$this->schemaManager()->createTable('xf_tagess_blacklist', function (Create $table) {
$table->addColumn('blacklist_id', 'int')->autoIncrement()->primaryKey();
$table->addColumn('tag', 'varchar', 255);
$table->addColumn('regex', 'tinyint', 1)->setDefault(0);
$table->addColumn('user_id', 'int');
$table->addColumn('blacklisted_date', 'int')->nullable(true)->setDefault(null);
$table->addKey(['regex',['tag', 191]], 'tag');
});
$this->schemaManager()->alterTable('xf_tagess_blacklist', function (Alter $table) {
$table->addKey(['regex',['tag', 191]], 'tag');
});
}Normally this would update/change the index 'tag', but with a partial index the column definition is returned as
['regex',['tag', 191]] which causes the test if (isset($conflictRenames[$column])) to fail with "Illegal offset type in isset or empty".I require the partial index to support older version of MySQL which do not support index over columns longer than 255 bytes.
Last edited:
