findOne with dbprefix

[legionir]

Hello,

seems there is a bug with codeigniter "dbprefix" while using findOne and other WHERE methods. for example: $this->Products_model->findOne($id)

cause the following error:

Unknown column 'pl_`products.id' in 'where clause'

SELECT * FROM pl_products WHERE pl_``products.id = '1' LIMIT 1

I made a quick fix this change:

protected function _field($columnName)
{
    if ($this->alias)
    {
        return "`{$this->alias}`.`{$columnName}`";
    }

    if (!$this->_db->dbprefix)
    {
        return "`{$this->table}`.`{$columnName}`";
    }

    return "{$this->table}`.`{$columnName}`";
}

[yidas]

Hi @legionir ,

You could try the version 2.19.3 to see whether the problem is solved smoothly with dbprefix setting.

Thank you for your support!