About use in user search
Permalink Browser Info Environment
A client asked us to search and sort based on the two_step_auth_data attribute.
The client wants to find who haven't set-up MFA.
When I try to run it, I get the following error:
1.filter by twp_step_auth_data attribute
2.sort by twp_step_auth_data attribute
I would like to be able to use these functions, what should I do?
I also tried to check the two_step_auth_data attribute in the CSV output, but this attribute was not output.
What should I do to output?
Thank you.
The client wants to find who haven't set-up MFA.
When I try to run it, I get the following error:
1.filter by twp_step_auth_data attribute
Uncaught Error: Call to undefined method Concrete\Package\TwoStepAuthentication\Attribute\TwoStepAuthData\Controller::load() in /var/www/vhosts/example.com/releases/24/packages/two_step_authentication/attributes/two_step_auth_data/controller.php:52 Stack trace: #0 [internal function]: Concrete\Package\TwoStepAuthentication\Attribute\TwoStepAuthData\Controller->search() #1 /var/www/vhosts/example.com/c5/8.5.12/concrete/src/Controller/AbstractController.php(315): call_user_func_array(Array, Array) #2 /var/www/vhosts/example.com/c5/8.5.12/concrete/src/Attribute/View.php(156): Concrete\Core\Controller\AbstractController->runAction('search') #3 /var/www/vhosts/example.com/c5/8.5.12/concrete/src/Attribute/View.php(134): Concrete\Core\Attribute\View->runControllerTask() #4 /var/www/vhosts/example.com/c5/8.5.12/concrete/src/View/AbstractView.php(161): Concrete\Core\Attribute\View->setupRender() #5 /var/www/vhosts/example.com/c5/8.5.12/concrete/src/Search/Field/AttributeKeyField.php(75): Concrete\Core\View Details /var/www/vhosts/example.com/releases/24/packages/two_step_authentication/attributes/two_step_auth_data/controller.php(52): Whoops\Exception\ErrorException->null /var/www/vhosts/example.com/c5/8.5.12/concrete/vendor/filp/whoops/src/Whoops/Run.php(486): Whoops\Run->handleError [internal](0): Whoops\Run->handleShutdown
2.sort by twp_step_auth_data attribute
An exception occurred while executing 'SELECT u.uID, u.uDateAdded, ak_two_step_auth_data FROM Users u LEFT JOIN UserSearchIndexAttributes ua ON u.uID = ua.uID WHERE (u.uIsActive = ?) AND (u.uIsValidated != 0) GROUP BY u.uID ORDER BY ak_two_step_auth_data asc, u.uID asc LIMIT 10 OFFSET 0' with params [true]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ak_two_step_auth_data' in 'field list' 詳細 /var/www/vhosts/example.com/c5/8.5.12/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php(71): Doctrine\DBAL\Exception\InvalidFieldNameException->null /var/www/vhosts/example.com/c5/8.5.12/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException /var/www/vhosts/example.com/c5/8.5.12/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException->driverExceptionDuringQuery /var/www/vhosts/example.com/c5/8.5.12/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(107): Doctrine\DBAL\Driver\PDOException->null /var/www/vhosts/example.com/c5/8.5.12/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(105): PDOException->null /var/www/vhosts/example.com/c5/8.5.12/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(105): PDOStatement->execute /var/www/vhosts/example.com/c5/8.5.12/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(847): Doctrine\DBAL\Driver\PDOStatement->execute /var/www/vhosts/example.com/c5/8.5.12/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery /var/www/vhosts/example.com/c5/8.5.12/concrete/vendor/pagerfanta/pagerfanta/src/Pagerfanta/Adapter/DoctrineDbalAdapter.php(73): Doctrine\DBAL\Query\QueryBuilder->execute /var/www/vhosts/example.com/c5/8.5.12/concrete/vendor/pagerfanta/pagerfanta/src/Pagerfanta/Pagerfanta.php(319): Pagerfanta\Adapter\DoctrineDbalAdapter->getSlice /var/www/vhosts/example.com/c5/8.5.12/concrete/vendor/pagerfanta/pagerfanta/src/Pagerfanta/Pagerfanta.php(303): Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter /var/www/vhosts/example.com/c5/8.5.12/concrete/src/Search/Pagination/Pagination.php(111): Pagerfanta\Pagerfanta->getCurrentPageResults
Viewing 15 lines of 43 lines. View entire code block.
I would like to be able to use these functions, what should I do?
I also tried to check the two_step_auth_data attribute in the CSV output, but this attribute was not output.
What should I do to output?
Thank you.
Type: | Ticket |
---|---|
Status: | In Progress |
Hello,
Please update to version 1.8.4 and it should be working fine now.
Let me know if there's any other issue
Please update to version 1.8.4 and it should be working fine now.
Let me know if there's any other issue
I updated to v1.8.4 and now I can search. thank you.
I have a question.
1. Sorting shows the above SQL error (SQLSTATE[42S22]). Is it not possible to sort the "two_step_auth_data" attribute?
2. Any plans to export the "two_step_auth_data" attribute to CSV?
I would appreciate your answer.
Thank you.
I have a question.
1. Sorting shows the above SQL error (SQLSTATE[42S22]). Is it not possible to sort the "two_step_auth_data" attribute?
2. Any plans to export the "two_step_auth_data" attribute to CSV?
I would appreciate your answer.
Thank you.
I didn't have a look into ordering so I'll check and will see what i can do.
I have no plan for csv export.
I have no plan for csv export.
I checked and there seems to be a problem in Concrete with attributes that have multiple fields of value.
For instance, if you have an Address attribute and try to order by it, you'll get the same error as with 2FA.
So at this point, there isn't much I can do I'm afraid.
For instance, if you have an Address attribute and try to order by it, you'll get the same error as with 2FA.
So at this point, there isn't much I can do I'm afraid.
I understand that order is not possible due to Concrete issues.
What about question 2, the CSV output?
Is this also not possible due to Concrete issues?
Thank you.
What about question 2, the CSV output?
Is this also not possible due to Concrete issues?
Thank you.
Hello.
I just uploaded version 2.1.3 which fixes the CSV export. You should be good to go now.
I just uploaded version 2.1.3 which fixes the CSV export. You should be good to go now.
Hi,
It was a great help!
Thank you.
It was a great help!
Thank you.
I'm going to have to look into it, I will let you know ASAP.