Scanner: Unknown opcode 58

[tarikogut]

what is this ?

[andresgutierrez]

https://github.com/phalcon/cphalcon/blob/2.0.x/CONTRIBUTING.md#bug-report-checklist

[andresgutierrez]

@tarikogut ping

[tarikogut]

old code

$phql = 'SELECT total_credits - (SELECT SUM(remaining_credits) FROM
Frontend\Models\Sites WHERE users_id = :id) FROM Frontend\Models\Users
WHERE id = :id';

$available_credits = $this->modelManager->executeQuery($phql, array(
    'id' => $this->user->id
));

new code

$phql = 'SELECT total_credits - (SELECT SUM(remaining_credits) FROM
Frontend\Models\Sites WHERE users_id = :id:) FROM
Frontend\Models\Users WHERE id = :id:';
$available_credits = $this->modelManager->executeQuery($phql, array(
    'id' => $this->user->id
));

chang :id to :id:.

2015-09-18 11:23 GMT+03:00 Nguyen Tien Manh notifications@github.com:

I also encountered this error. This is code in a action

$phql = 'SELECT total_credits - (SELECT SUM(remaining_credits) FROM Frontend\Models\Sites WHERE users_id = :id) FROM Frontend\Models\Users WHERE id = :id';$available_credits = $this->modelManager->executeQuery($phql, array( 'id' => $this->user->id));

And, this is trace

Scanner: Unknown opcode 58

#0 [internal function]: Phalcon\Mvc\Model\Query->parse()
#1 https://github.com/phalcon/cphalcon/issues/1 [internal function]:
Phalcon\Mvc\Model\Query->execute()
#2 https://github.com/phalcon/cphalcon/issues/2 /srv/
shareview.libtools.org/apps/frontend/controllers/SitesController.php(128):
Phalcon\Mvc\Model\Manager->executeQuery('SELECT total_cr...', Array)
#3 https://github.com/phalcon/cphalcon/issues/3 [internal function]:
Frontend\Controllers\SitesController->distributionAction()
#4 https://github.com/phalcon/cphalcon/issues/4 [internal function]:
Phalcon\Dispatcher->dispatch()
#5 https://github.com/phalcon/cphalcon/issues/5 /srv/
shareview.libtools.org/public/index.php(186):
Phalcon\Mvc\Application->handle()
#6 https://github.com/phalcon/cphalcon/issues/6 {main}

—
Reply to this email directly or view it on GitHub
#10821 (comment).

[strayobject]

In case someone comes here with the same error, when you are naming your params you need TWO colons not one.
Good: WHERE id = :id:
Bad: WHERE id = :id