afterlogic/aurora-framework

aurora-framework's Issues

password reset adminpanel

Hi, we have lost our admin password, how do we recover it, we have full DB access.

v8->v9 migration issues; Was: Issue when au_min_hashes is empty

I get the error:

# php system/bin/console -vvv migrate:eav-to-sql
File /path_to_afterlogic_webmail/data/migration-eav-to-sql/migration-progress.txt is invalid. Do you wish migrate all entities? (Y/N)Y
 0/56 [>---------------------------]   0% < 1 sec/< 1 sec 6.0 MiB
In MySql.php line 536:

  [Aurora\System\Exceptions\DbException]
  21S01
  1136
  Column count doesn't match value count at row 1 [21S01]


Exception trace:
  at /path_to_afterlogic_webmail/system/Db/Pdo/MySql.php:536
 Aurora\System\Db\Pdo\MySql->_setSqlError() at /path_to_afterlogic_webmail/system/Db/Pdo/MySql.php:337
 Aurora\System\Db\Pdo\MySql->Execute() at /path_to_afterlogic_webmail/system/Db/Storage.php:189
 Aurora\System\Db\Storage->Execute() at /path_to_afterlogic_webmail/system/Console/Commands/Migrations/EavToSqlCommand.php:81
 Aurora\System\Console\Commands\Migrations\EavToSqlCommand->migrateMinHashes() at /path_to_afterlogic_webmail/system/Console/Commands/Migrations/EavToSqlCommand.php:255
 Aurora\System\Console\Commands\Migrations\EavToSqlCommand->execute() at /path_to_afterlogic_webmail/vendor/symfony/console/Command/Command.php:298
 Symfony\Component\Console\Command\Command->run() at /path_to_afterlogic_webmail/vendor/symfony/console/Application.php:1015
 Symfony\Component\Console\Application->doRunCommand() at /path_to_afterlogic_webmail/vendor/symfony/console/Application.php:299
 Symfony\Component\Console\Application->doRun() at /path_to_afterlogic_webmail/vendor/symfony/console/Application.php:171
 Symfony\Component\Console\Application->run() at /path_to_afterlogic_webmail/system/bin/console:6

migrate:eav-to-sql [-w|--wipe] [-f|--migrate-file]

My au_min_hashes schema is:

CREATE TABLE au_min_hashes
(
    hash_id varchar(32) DEFAULT '' NOT NULL,
    hash    varchar(20) DEFAULT '' NOT NULL,
    data    text                   NULL
)
    CHARSET = utf8mb3;

CREATE INDEX au_min_hash_index
    ON au_min_hashes (hash);

But there is no data in there. I think that causes the issue in Aurora\System\Console\Commands\Migrations\EavToSqlCommand::migrateMinHashes()

aurora-framework/Console/Commands/Migrations/EavToSqlCommand.php

Lines 67 to 83 in f5d3c2d

	protected function migrateMinHashes($oConnection)
	{
	if (!Capsule::schema()->hasTable('core_min_hashes')) {
	return false;
	}
	if (!Capsule::schema()->hasTable('min_hashes')) {
	return false;
	}
	$sql = "TRUNCATE `" . $this->oP8Settings->DBPrefix . "core_min_hashes`;";
	$oConnection->execute($sql);
	$sql = "INSERT INTO " . $this->oP8Settings->DBPrefix . "core_min_hashes (`HashId`, `UserId`,`Hash`, `Data`, `ExpireDate`)
	SELECT *
	FROM " . $this->oP8Settings->DBPrefix . "min_hashes;";
	$oConnection->execute($sql);
	return true;
	}

Bump support for higher version of Symfony

Installation request for afterlogic/aurora-framework ^0.9.119 -> satisfiable by afterlogic/aurora-framework[0.9.119].
    - Conclusion: remove symfony/symfony v4.2.12
    - Conclusion: don't install symfony/symfony v4.2.12
    - afterlogic/aurora-framework 0.9.119 requires symfony/filesystem ^2.8