Database query in model fails silently

[oslabkyy]

I am in progress of upgrading from Phalcon 3.4.2 to 4.0.1. I went through Upgrade Guideline and made changes accordingly to it. Application itself is running, I can see that all services are running and controller is called but when I'm trying to get something from the database, application fails and doesn't send any response. It fails absolutely silently, there are no errors in apache logs.

When I build the query in my model it works but it stops working right after calling execute() method:

class Users extends Model
{
    public static function getById($id) {
        return self::query()
            ->where('users_id = :users_id:')
            ->bind(
                [
                    'users_id' => $id,
                ])
            ->execute()
            ->getFirst();
    }
}

Decomposing the code above I can see that it crashes on execution. It also crashes on calling Users::find() from controller and these queries do not raise any exceptions.

I checked my DB connection by creating a simple connection in controller and realized that it works fine and returns a resultset.

Here you can see how I initialize DB connection to be used by models around the application:

$di->set('db', function() use ($config) {
    try {
        $dbclass = 'Phalcon\Db\Adapter\Pdo\\' . $config->database->adapter;
        return new $dbclass(array(
            'host' => $config->database->host,
            'username' => $config->database->username,
            'password' => $config->database->password,
            'dbname' => $config->database->name,
            'charset' => $config->database->charset,
        ));
    } catch (Exception $e) {
        die(sprintf("<b>Error when initializing database connection:</b> %s", $e->getMessage()));
    }
});

This code does not raise any exceptions too.

var_dump(Phalcon\Di::getDefault()->get('db')); exit(); right before running query returns connection info.

I spent 2 days debugging this stuff but it's very hard when Phalcon does not provide any logs or exceptions. Does anyone have an idea what can be wrong or how can I make Phalcon speak?

[quasipickle]

Phalcon's View layer suppresses all output not through the View, so if any error messages get output, they don't get displayed. You could try exit()-ing in your method to see if any problems are being hidden:

public static function getById($id) {
    $result = self::query()
        ->where('users_id = :users_id:')
        ->bind(
            [
                'users_id' => $id,
            ])
        ->execute()
        ->getFirst();
    exit();
}

If that doesn't provide any results, you could maybe try logging directly in the database? With that said - database issues rarely cause silent script halting.

Also, your method can be rewritten more simply with findFirst()

public static function getById($id) {
    return self::findFirst(['users_id = :users_id:','bind'=>['users_id'=>$id]]);
}

[oslabkyy]

Ahh, sorry, it's just a typo, I use 4.1.0

[quasipickle]

Double dang.

If I were in your position I would create a new project as bare bones as possible to try to replicate the problem - it should be possible to do this all in one file - then file a bug report. If you can't replicate the problem, copy the working code in from your replication one chunk at a time until the problem goes away.

Or maybe wait until someone else chimes in with a more professional answer ;)

Good luck.

[oslabkyy]

Yeah, looks like a new clean project is the last resort in this situation that I should try.

Thank you very much for your responses and your time!

[oslabkyy]

@quasipickle btw, do you use 4.1.0 version?

[quasipickle]

No, I'm still running on 3.something. Otherwise I'd have given your setup a try to see if I could replicate it.

[DrJLT]

Try

public static function getById($id) {
return Di::getDefault()->getShared('db')->fetchOne('SELECT what_you_need FROM your_user_table WHERE user_id = ? LIMIT 1',\Pdo::FETCH_ASSOC,[$id]);
}

This should work.

[oslabkyy]

As I wrote above, this approach works fine, but this is a workaround. I need to use my models which is the correct way of using ORM.

[DrJLT]

why use orm? especially with a static method?

[oslabkyy]

Because it's nice, more clear, less verbose, and easily maintainable. But this topic is for another thread, I'm trying to figure out why Model does not use 'db' service in 4.1.0 which worked perfectly in 3.4.2?

[oslabkyy]

This problem is not resolved yet. Does anyone have any ideas? Please, help!

[quasipickle]

Have you tried replicating the problem with a fresh, minimal project?

[oslabkyy]

Yes, I tried and still have the same problem. My application now is as minimal as possible.

public/index.php

<?php
use Phalcon\Mvc\Application;
use Phalcon\Mvc\View;
use Phalcon\Di\FactoryDefault;
use Phalcon\Mvc\View\Engine\Volt as VoltEngine;
use Phalcon\Loader;

define('APP_PATH', realpath('..') . '/');

$loader = new Loader();

$loader->registerDirs(
    array(
        APP_PATH . 'app/controllers/',
        APP_PATH . 'app/models/',
        APP_PATH . 'app/forms/',
        APP_PATH . 'app/views/',
    )
);

$loader->register();

$di = new FactoryDefault();

$di->set('view', function() {

    $view = new View();

    $view->setViewsDir(APP_PATH . 'app/views/');

    $view->registerEngines(array(
        '.volt' => function ($view, $di) {

            $volt = new VoltEngine($view, $di);
            $volt->setOptions(array(
                'compiledPath' => APP_PATH . "cache/volt/",
                'compiledSeparator' => '_',
                'compileAlways' => true
            ));

            return $volt;
        }
    ));

    return $view;
}, true);


$di->set('db', function() {
    return new Phalcon\Db\Adapter\Pdo\Mysql(array(
        'host' => 'localhost',
        'username' => 'username',
        'password' => 'password',
        'dbname' => 'dbname',
        'charset' => 'utf8'
    ));
}, true);

$application = new Application($di);
echo $application->handle($_SERVER['REQUEST_URI'])->getContent();

app/controllers/IndexController.php

<?php

use Phalcon\Mvc\Controller;

class IndexController extends Controller
{
    public function indexAction()
    {
        //var_dump($this->getDi()->getShared('db')->query('SELECT * FROM users')->fetchAll()); exit();
        $users = Users::find();
        var_dump($users); exit();
    }
}

app/models/Users.php

<?php

use Phalcon\Mvc\Model;

class Users extends Model {}

And again, that commented var_dump in controller works fine but call to find method of model fails silently.

[Jeckerson]

Your errors might be disabled in your environment. Try to wrap with try catch inside getById():

<?php

class Users extends Model
{
    public static function getById($id) {
        try {
            return self::query()
                ->where('users_id = :users_id:')
                ->bind(
                    [
                        'users_id' => $id,
                    ])
                ->execute()
                ->getFirst();
        } catch (\Throwable $exception) {
            echo $exception->getMessage();
            exit;
        }
    }
}

[oslabkyy]

Unfortunately catch does not catch any exceptions. The application fails silently.

[Jeckerson]

Please show output of php -v

[oslabkyy]

PHP 7.4.3 (cli) (built: Oct 6 2020 15:47:56) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
with Zend OPcache v7.4.3, Copyright (c), by Zend Technologies

[oslabkyy]

@Jeckerson Do you have any ideas?

[Jeckerson]

@oslabkyy I noticed that you are using 4.0.1, try to use Phalcon v4.0.6 or v4.1.0.

[oslabkyy]

I use 4.1.0

[oslabkyy]

@Jeckerson magic! 4.0.6 works fine.

[oslabkyy]

I compiled 4.1.0 from the source code and the problem was resolved. Seems like the problem was with debian package for Ubuntu.

[Jeckerson]

Could you tell with what Zephir version you did compilation?

[oslabkyy]

0.12.19-4345593

[Jeckerson]

How did you installed Phalcon before re-compilation?

[oslabkyy]

It was installed via apt-get install

[zicare]

Had the same issue as oslaskyy when using Phalcon ORM with Ubuntu 20.04, PHP 7.4 and Phalcon 4.1.x. This discussion helped figure it out what the problem was. Downgrading to Phalcon 4.0.6 worked fine.

Anybody with Ubuntu 20.04 and PHP 7.4 installing Phalcon 4 following the official installation guide will likely be stuck with this problem. The workaround below can help solve it without resorting to compile the sources.

Phalcon 4.0.6 for Ubuntu 20.04 (focal) is not available at https://packagecloud.io/phalcon/stable/ubuntu/ but it is there for Ubuntu 18.04 (bionic). Manually edit file /etc/apt/sources.list.d/phalcon_stable.list

change these lines:

deb https://packagecloud.io/phalcon/stable/ubuntu/ focal main
deb-src https://packagecloud.io/phalcon/stable/ubuntu/ focal main

to:

deb https://packagecloud.io/phalcon/stable/ubuntu/ bionic main
deb-src https://packagecloud.io/phalcon/stable/ubuntu/ bionic main

Then install 4.0.6 with:

apt-get install php7.4-phalcon=4.0.6-975+php7.4

[malsksoa]

facing few issues could you please help us to fix it? i need your honest recommendations please?