fishjerky / phalcon-mssql

phalcon mssql pdo db adapter
22 stars 17 forks source link

COUNT field incorrect or syntax error #7

Open EhsanJamshidi opened 5 years ago

EhsanJamshidi commented 5 years ago

hi when I try to use code like this $robot = Robot::findFirst();

this error will appear

SQLSTATE[07002]: [Microsoft][ODBC Driver 13 for SQL Server]COUNT field incorrect or syntax error

0 C:\wamp64\www\hotbookmakers\app\library\db\adapter\Mssql.php(503): PDOStatement->execute()

1 [internal function]: Twm\Db\Adapter\Pdo\Mssql->executePrepared(Object(PDOStatement), Array, Array)

2 C:\wamp64\www\hotbookmakers\app\library\db\adapter\Mssql.php(286): Phalcon\Db\Adapter\Pdo->query('SELECT TOP :APL...', Array, Array)

3 [internal function]: Twm\Db\Adapter\Pdo\Mssql->query('SELECT TOP :APL...', Array, Array)

4 [internal function]: Phalcon\Mvc\Model\Query->_executeSelect(Array, Array, Array)

5 [internal function]: Phalcon\Mvc\Model\Query->execute()

6 [internal function]: Phalcon\Mvc\Model::findFirst(Array)

7 [internal function]: Phalcon\Mvc\Model\Manager->getRelationRecords(Object(Phalcon\Mvc\Model\Relation), NULL, Object(Hotbookmakers\Models\Tblusers), NULL)

8 C:\wamp64\www\hotbookmakers\app\library\Auth\Auth.php(53): Phalcon\Mvc\Model->__get('profile')

9 C:\wamp64\www\hotbookmakers\app\controllers\SessionController.php(82): Hotbookmakers\Auth\Auth->check(Array)

10 [internal function]: Hotbookmakers\Controllers\SessionController->loginAction()

11 [internal function]: Phalcon\Dispatcher->callActionMethod(Object(Hotbookmakers\Controllers\SessionController), 'loginAction', Array)

12 [internal function]: Phalcon\Dispatcher->dispatch()

13 C:\wamp64\www\hotbookmakers\public\index.php(41): Phalcon\Mvc\Application->handle()

14 {main}