Login Error - Invalid object name 'Users2'

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
Magda
User
Posts: 1

Login Error - Invalid object name 'Users2'

Post by Magda »

Hi, I can't solve the Error I get when I am trying to log in with other users that I set up as a Super Admin. The ERROR message is:

...\vendor\doctrine\dbal\src\Driver\API\SQLSrv\ExceptionConverter.php(39): An exception occurred while executing a query: SQLSTATE [42S02, 208]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'Users2'. SQLSTATE [42000, 8180]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared.

In debug I get:

#0 ...\vendor\doctrine\dbal\src\Connection.php(1938): Doctrine\DBAL\Driver\API\SQLSrv\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\SQLSrv\Exception\Error), Object(Doctrine\DBAL\Query))
#1 ...\vendor\doctrine\dbal\src\Connection.php(1880): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\SQLSrv\Exception\Error), Object(Doctrine\DBAL\Query))
#2 ...\vendor\doctrine\dbal\src\Connection.php(1105): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\SQLSrv\Exception\Error), 'SELECT t0.Login...', Array, Array)

I have follwed the clues from: https://learn.microsoft.com/en-us/sql/r ... rver-ver16
but it doesn't seem to be a permission problem.

Please point me to where else to look for problems.


arbei
User
Posts: 9396

Post by arbei »

What is 'Users2'? Is it your users table of your project? Is it a real table or view in your database? If yes, is it with a different schema so the table is not found?


Post Reply