4spacesdk / CI4OrmExtension

OrmExtension for CodeIgniter 4
MIT License
50 stars 9 forks source link

A select problem with existing old named tables #24

Closed etcware closed 1 year ago

etcware commented 2 years ago

My model is:

class CourseCardModel extends Model
{
    protected $table = 'ptv_course_card';
    protected $primaryKey = 'id';
    protected $allowedFields = [
        'id',
        'master_fk',
        'course_id',
        'manifesto_uid'
    ];
...

My query is:

            $courseCardModel = new CourseCardModel();
        try {
        $courseCard = $courseCardModel->where('master_fk',$master_id)->find();
        } catch(\mysqli_sql_exception $e) {
            dd($courseCardModel->getLastQuery());
        }

The executed query is:

SELECT * FROM `ptv_course_card` WHERE `course_cards`.`master_fk` = '93935'

And it is wrong. Is there a parameters work around?

Martin-4Spaces commented 2 years ago

@etcware Can it be caching? Check ../writable/cache/OrmExtension folder and delete everything.