An error occurred during execution; please try again later.
Additional information:
Doctrine\DBAL\DBALException
C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ dbal\lib\Doctrine\DBAL\DBALException.php:172
An exception occurred while executing 'SELECT t0_.JID AS JID_0, t0_.StrUserID AS StrUserID_1, t0_.password AS password_2, t0_.Status AS Status_3, t0_.GMrank AS GMrank_4, t0_.Name AS Name_5, t0_.Email AS Email_6, t0_.sex AS sex_7, t0_.phone AS phone_8, t0_.regtime AS regtime_9, t0_.reg_ip AS reg_ip_10, t0_.sec_primary AS sec_primary_11, t0_.sec_content AS sec_content_12, t0_.AccPlayTime AS AccPlayTime_13, t0_.LatestUpdateTime_ToPlayTime AS LatestUpdateTime_ToPlayTime_14 FROM TB_User t0_ WHERE t0_.StrUserID = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY' with params ["heaven"]:
SQLSTATE[42S22]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'AccPlayTime'.
#0 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ dbal\lib\Doctrine\DBAL\DBALException.php(145): Doctrine\DBAL\DBALException::wrapException(Object( GameBackend\DBAL\Driver\PDOSqlsrv\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'An exception oc...')
#1 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ dbal\lib\Doctrine\DBAL\Connection.php(911): Doctrine\DBAL\DBALException::driverExceptionDuring Query(Object(GameBackend\DBAL\Driver\PDOSqlsrv\Dri ver), Object(Doctrine\DBAL\Driver\PDOException), 'SELECT t0_.JID ...', Array)
#2 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ orm\lib\Doctrine\ORM\Query\Exec\SingleSelectExecut or.php(50): Doctrine\DBAL\Connection->executeQuery('SELECT t0_.JID ...', Array, Array, NULL)
#3 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ orm\lib\Doctrine\ORM\Query.php(334): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#4 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ orm\lib\Doctrine\ORM\AbstractQuery.php(967): Doctrine\ORM\Query->_doExecute()
#5 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ orm\lib\Doctrine\ORM\AbstractQuery.php(922): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, NULL)
#6 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ orm\lib\Doctrine\ORM\AbstractQuery.php(765): Doctrine\ORM\AbstractQuery->execute(NULL, NULL)
#7 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\game-backend\src\Entity\SRO\Account\Repository\TbUser.p hp(57): Doctrine\ORM\AbstractQuery->getOneOrNullResult()
#8 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\game-backend\src\DataService\SRO.php(100): GameBackend\Entity\SRO\Account\Repository\TbUser->isUserNameExists(Object(PServerCore\Entity\User ))
#9 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\p-server-core\src\Validator\UserNameBackendNotExists.php(73 ): GameBackend\DataService\SRO->isUserNameExists(Object(PServerCore\Entity\User ))
#10 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\p-server-core\src\Validator\UserNameBackendNotExists.php(52 ): PServerCore\Validator\UserNameBackendNotExists->query('heaven')
#11 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-validator\src\ValidatorChain.php(246): PServerCore\Validator\UserNameBackendNotExists->isValid('heaven', Array)
#12 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-inputfilter\src\Input.php(434): Zend\Validator\ValidatorChain->isValid('heaven', Array)
#13 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-inputfilter\src\BaseInputFilter.php(275): Zend\InputFilter\Input->isValid(Array)
#14 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-inputfilter\src\BaseInputFilter.php(229): Zend\InputFilter\BaseInputFilter->validateInputs(Array, Array, NULL)
#15 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-form\src\Form.php(515): Zend\InputFilter\BaseInputFilter->isValid()
#16 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\p-server-core\src\Service\User.php(91): Zend\Form\Form->isValid()
#17 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\p-server-core\src\Controller\AuthController.php(54): PServerCore\Service\User->register(Array)
#18 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-mvc\src\Controller\AbstractActionController.php(78 ): PServerCore\Controller\AuthController->registerAction()
#19 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-eventmanager\src\EventManager.php(322): Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#20 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-eventmanager\src\EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))
#21 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-mvc\src\Controller\AbstractController.php(106): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#22 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-mvc\src\DispatchListener.php(138): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request) , Object(Zend\Http\PhpEnvironment\Response))
#23 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-eventmanager\src\EventManager.php(322): Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#24 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-eventmanager\src\EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))
#25 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-mvc\src\Application.php(332): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#26 C:\Apache24\htdocs\pserverCMSFull\public\index.php (18): Zend\Mvc\Application->run()
#27 {main}
Previous exceptions:
Doctrine\DBAL\Driver\PDOException
C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:119
SQLSTATE[42S22]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'AccPlayTime'.
#0 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ dbal\lib\Doctrine\DBAL\Connection.php(903): Doctrine\DBAL\Driver\PDOStatement->execute()
#1 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ orm\lib\Doctrine\ORM\Query\Exec\SingleSelectExecut or.php(50): Doctrine\DBAL\Connection->executeQuery('SELECT t0_.JID ...', Array, Array, NULL)
#2 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ orm\lib\Doctrine\ORM\Query.php(334): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#3 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ orm\lib\Doctrine\ORM\AbstractQuery.php(967): Doctrine\ORM\Query->_doExecute()
#4 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ orm\lib\Doctrine\ORM\AbstractQuery.php(922): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, NULL)
#5 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ orm\lib\Doctrine\ORM\AbstractQuery.php(765): Doctrine\ORM\AbstractQuery->execute(NULL, NULL)
#6 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\game-backend\src\Entity\SRO\Account\Repository\TbUser.p hp(57): Doctrine\ORM\AbstractQuery->getOneOrNullResult()
#7 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\game-backend\src\DataService\SRO.php(100): GameBackend\Entity\SRO\Account\Repository\TbUser->isUserNameExists(Object(PServerCore\Entity\User ))
#8 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\p-server-core\src\Validator\UserNameBackendNotExists.php(73 ): GameBackend\DataService\SRO->isUserNameExists(Object(PServerCore\Entity\User ))
#9 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\p-server-core\src\Validator\UserNameBackendNotExists.php(52 ): PServerCore\Validator\UserNameBackendNotExists->query('heaven')
#10 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-validator\src\ValidatorChain.php(246): PServerCore\Validator\UserNameBackendNotExists->isValid('heaven', Array)
#11 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-inputfilter\src\Input.php(434): Zend\Validator\ValidatorChain->isValid('heaven', Array)
#12 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-inputfilter\src\BaseInputFilter.php(275): Zend\InputFilter\Input->isValid(Array)
#13 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-inputfilter\src\BaseInputFilter.php(229): Zend\InputFilter\BaseInputFilter->validateInputs(Array, Array, NULL)
#14 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-form\src\Form.php(515): Zend\InputFilter\BaseInputFilter->isValid()
#15 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\p-server-core\src\Service\User.php(91): Zend\Form\Form->isValid()
#16 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\p-server-core\src\Controller\AuthController.php(54): PServerCore\Service\User->register(Array)
#17 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-mvc\src\Controller\AbstractActionController.php(78 ): PServerCore\Controller\AuthController->registerAction()
#18 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-eventmanager\src\EventManager.php(322): Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#19 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-eventmanager\src\EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))
#20 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-mvc\src\Controller\AbstractController.php(106): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#21 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-mvc\src\DispatchListener.php(138): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request) , Object(Zend\Http\PhpEnvironment\Response))
#22 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-eventmanager\src\EventManager.php(322): Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#23 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-eventmanager\src\EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))
#24 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-mvc\src\Application.php(332): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#25 C:\Apache24\htdocs\pserverCMSFull\public\index.php (18): Zend\Mvc\Application->run()
#26 {main}
C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:117
SQLSTATE[42S22]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'AccPlayTime'.
#0 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php(117 ): PDOStatement->execute(NULL)
#1 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ dbal\lib\Doctrine\DBAL\Connection.php(903): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ orm\lib\Doctrine\ORM\Query\Exec\SingleSelectExecut or.php(50): Doctrine\DBAL\Connection->executeQuery('SELECT t0_.JID ...', Array, Array, NULL)
#3 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ orm\lib\Doctrine\ORM\Query.php(334): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#4 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ orm\lib\Doctrine\ORM\AbstractQuery.php(967): Doctrine\ORM\Query->_doExecute()
#5 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ orm\lib\Doctrine\ORM\AbstractQuery.php(922): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, NULL)
#6 C:\Apache24\htdocs\pserverCMSFull\vendor\doctrine\ orm\lib\Doctrine\ORM\AbstractQuery.php(765): Doctrine\ORM\AbstractQuery->execute(NULL, NULL)
#7 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\game-backend\src\Entity\SRO\Account\Repository\TbUser.p hp(57): Doctrine\ORM\AbstractQuery->getOneOrNullResult()
#8 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\game-backend\src\DataService\SRO.php(100): GameBackend\Entity\SRO\Account\Repository\TbUser->isUserNameExists(Object(PServerCore\Entity\User ))
#9 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\p-server-core\src\Validator\UserNameBackendNotExists.php(73 ): GameBackend\DataService\SRO->isUserNameExists(Object(PServerCore\Entity\User ))
#10 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\p-server-core\src\Validator\UserNameBackendNotExists.php(52 ): PServerCore\Validator\UserNameBackendNotExists->query('heaven')
#11 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-validator\src\ValidatorChain.php(246): PServerCore\Validator\UserNameBackendNotExists->isValid('heaven', Array)
#12 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-inputfilter\src\Input.php(434): Zend\Validator\ValidatorChain->isValid('heaven', Array)
#13 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-inputfilter\src\BaseInputFilter.php(275): Zend\InputFilter\Input->isValid(Array)
#14 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-inputfilter\src\BaseInputFilter.php(229): Zend\InputFilter\BaseInputFilter->validateInputs(Array, Array, NULL)
#15 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-form\src\Form.php(515): Zend\InputFilter\BaseInputFilter->isValid()
#16 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\p-server-core\src\Service\User.php(91): Zend\Form\Form->isValid()
#17 C:\Apache24\htdocs\pserverCMSFull\vendor\kokspflan ze\p-server-core\src\Controller\AuthController.php(54): PServerCore\Service\User->register(Array)
#18 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-mvc\src\Controller\AbstractActionController.php(78 ): PServerCore\Controller\AuthController->registerAction()
#19 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-eventmanager\src\EventManager.php(322): Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#20 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-eventmanager\src\EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))
#21 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-mvc\src\Controller\AbstractController.php(106): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#22 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-mvc\src\DispatchListener.php(138): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request) , Object(Zend\Http\PhpEnvironment\Response))
#23 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-eventmanager\src\EventManager.php(322): Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#24 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-eventmanager\src\EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))
#25 C:\Apache24\htdocs\pserverCMSFull\vendor\zendframe work\zend-mvc\src\Application.php(332): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#26 C:\Apache24\htdocs\pserverCMSFull\public\index.php (18): Zend\Mvc\Application->run()
#27 {main}