Login by Cookie Error when using MongoDB

kakalos12 · January 4, 2015, 2:13am

Hi all,

I’m having the problem with yii2 login by cookie when using mongodb. I logged in the web in the evening and accessed the website the next morning. But it throws error

Next exception ‘yii\mongodb\Exception’ with message ‘localhost:27017: Can’t canonicalize query: BadValue unknown operator: $id’ in /usr/local/var/www/marketing/vendor/yiisoft/yii2-mongodb/Query.php:136

Stack trace:

#0 /usr/local/var/www/marketing/vendor/yiisoft/yii2-mongodb/Query.php(198): yii\mongodb\Query->fetchRows(Object(MongoCursor), false)

#1 /usr/local/var/www/marketing/vendor/yiisoft/yii2-mongodb/ActiveQuery.php(152): yii\mongodb\Query->one(NULL)

#2 /usr/local/var/www/marketing/vendor/yiisoft/yii2/db/BaseActiveRecord.php(136): yii\mongodb\ActiveQuery->one()

#3 /usr/local/var/www/marketing/vendor/yiisoft/yii2/db/BaseActiveRecord.php(101): yii\db\BaseActiveRecord::findByCondition(Array, true)

#4 /usr/local/var/www/marketing/models/db/User.php(84): yii\db\BaseActiveRecord::findOne(Array)

#5 /usr/local/var/www/marketing/vendor/yiisoft/yii2/web/User.php(295): app\models\db\User::findIdentity(Array)

#6 /usr/local/var/www/marketing/vendor/yiisoft/yii2/web/User.php(631): yii\web\User->loginByCookie()

#7 /usr/local/var/www/marketing/vendor/yiisoft/yii2/web/User.php(176): yii\web\User->renewAuthStatus()

#8 /usr/local/var/www/marketing/vendor/yiisoft/yii2/web/User.php(346): yii\web\User->getIdentity()

#9 /usr/local/var/www/marketing/vendor/yiisoft/yii2/filters/AccessRule.php(149): yii\web\User->getIsGuest()

#10 /usr/local/var/www/marketing/vendor/yiisoft/yii2/filters/AccessRule.php(104): yii\filters\AccessRule->matchRole(Object(yii\web\User))

#11 /usr/local/var/www/marketing/vendor/yiisoft/yii2/filters/AccessControl.php(117): yii\filters\AccessRule->allows(Object(yii\base\InlineAction), Object(yii\web\User), Object(yii\web\Request))

#12 /usr/local/var/www/marketing/vendor/yiisoft/yii2/base/ActionFilter.php(71): yii\filters\AccessControl->beforeAction(Object(yii\base\InlineAction))

#13 [internal function]: yii\base\ActionFilter->beforeFilter(Object(yii\base\ActionEvent))

#14 /usr/local/var/www/marketing/vendor/yiisoft/yii2/base/Component.php(538): call_user_func(Array, Object(yii\base\ActionEvent))

#15 /usr/local/var/www/marketing/vendor/yiisoft/yii2/base/Controller.php(259): yii\base\Component->trigger(‘beforeAction’, Object(yii\base\ActionEvent))

#16 /usr/local/var/www/marketing/vendor/yiisoft/yii2/web/Controller.php(108): yii\base\Controller->beforeAction(Object(yii\base\InlineAction))

#17 /usr/local/var/www/marketing/vendor/yiisoft/yii2/base/Controller.php(149): yii\web\Controller->beforeAction(Object(yii\base\InlineAction))

#18 /usr/local/var/www/marketing/vendor/yiisoft/yii2/base/Module.php(455): yii\base\Controller->runAction(’’, Array)

#19 /usr/local/var/www/marketing/vendor/yiisoft/yii2/web/Application.php(83): yii\base\Module->runAction(‘admin’, Array)

#20 /usr/local/var/www/marketing/vendor/yiisoft/yii2/base/Application.php(375): yii\web\Application->handleRequest(Object(yii\web\Request))

#21 /usr/local/var/www/marketing/web/index.php(12): yii\base\Application->run()

#22 {main}

2015-01-05 02:01:49 [127.0.0.1][-][-][info][application] $_COOKIE = [
'_csrf' =&gt; '4451110c314a32c789b88e39caa4f66bdee5d8ae50e3e0871be29d867cfc383ds:32:&#092;&quot;shPQQJ2LH3V7JjRN5s5vokDWl67z6k42&#092;&quot;;'


'PHPSESSID' =&gt; '9sm5er116l4e02s54it5tv5t54'


'_identity' =&gt; '8aad7e97dcfd37c3db2e241f907e35e23077802d53bffce07afc68ac78b30b42s:79:&#092;&quot;[{&#092;&quot;&#036;id&#092;&quot;:&#092;&quot;54a814193c021e72010041a7&#092;&quot;},&#092;&quot;hWo1fnt2wcSeg-VuIc1UqBaYEufeYdqx&#092;&quot;,2592000]&#092;&quot;;'
]

$_SESSION = [
'__flash' =&gt; []
]

$_SERVER = [
'USER' =&gt; 'summernguyen'


'HOME' =&gt; '/Users/summernguyen'


'FCGI_ROLE' =&gt; 'RESPONDER'


'SCRIPT_FILENAME' =&gt; '/usr/local/var/www/marketing/web/index.php'


'QUERY_STRING' =&gt; ''


'REQUEST_METHOD' =&gt; 'GET'


'CONTENT_TYPE' =&gt; ''


'CONTENT_LENGTH' =&gt; ''


'SCRIPT_NAME' =&gt; '/index.php'


'REQUEST_URI' =&gt; '/admin'


'DOCUMENT_URI' =&gt; '/index.php'


'DOCUMENT_ROOT' =&gt; '/usr/local/var/www/marketing/web'


'SERVER_PROTOCOL' =&gt; 'HTTP/1.1'


'GATEWAY_INTERFACE' =&gt; 'CGI/1.1'


'SERVER_SOFTWARE' =&gt; 'nginx/1.6.2'


'REMOTE_ADDR' =&gt; '127.0.0.1'


'REMOTE_PORT' =&gt; '50172'


'SERVER_ADDR' =&gt; '127.0.0.1'


'SERVER_PORT' =&gt; '80'


'SERVER_NAME' =&gt; 'emarketing.com'


'REDIRECT_STATUS' =&gt; '200'


'HTTP_HOST' =&gt; 'emarketing.com'


'HTTP_CONNECTION' =&gt; 'keep-alive'


'HTTP_CACHE_CONTROL' =&gt; 'max-age=0'


'HTTP_ACCEPT' =&gt; 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8'


'HTTP_USER_AGENT' =&gt; 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36'


'HTTP_ACCEPT_ENCODING' =&gt; 'gzip, deflate, sdch'


'HTTP_ACCEPT_LANGUAGE' =&gt; 'en-US,en;q=0.8,ja;q=0.6,vi;q=0.4'


'HTTP_COOKIE' =&gt; '_csrf=4451110c314a32c789b88e39caa4f66bdee5d8ae50e3e0871be29d867cfc383ds%3A32%3A%22shPQQJ2LH3V7JjRN5s5vokDWl67z6k42%22%3B; PHPSESSID=9sm5er116l4e02s54it5tv5t54; _identity=8aad7e97dcfd37c3db2e241f907e35e23077802d53bffce07afc68ac78b30b42s%3A79%3A%22%5B%7B%22%24id%22%3A%2254a814193c021e72010041a7%22%7D%2C%22hWo1fnt2wcSeg-VuIc1UqBaYEufeYdqx%22%2C2592000%5D%22%3B'


'PHP_SELF' =&gt; '/index.php'


'REQUEST_TIME_FLOAT' =&gt; 1420423309.0738


'REQUEST_TIME' =&gt; 1420423309
]

Do you have any solutions for this error ?

Thanks so much

kakalos12 · January 4, 2015, 2:37am

Here is my User findIdentity method




    /**

     * @inheritdoc

     */

    public static function findIdentity($id)

    {

        return static::findOne([

            '_id' => $id,

            'status' => self::STATUS_ACTIVE

        ]);

    }