primary key different than id

Hello, I have read pretty much everyhing everywhere, so the last resort is to ask..

I am doing very simple insert to the database:

$params = array(
		'my_pid' => 'abcde', // THIS IS PRIMARY KEY
		'name' => 'ppp'
		...
);

$this->db->table("my_table")->insert($params)

SQL command knows that my_pid is PRI.

SHOW FULL COLUMNS FROM sd_service;

Anyways, the problem is that, once I do the insert, Nette somehow tries to get a primary id, which is always expected to be called “id”.

This is what happens in the background after running insert.

INSERT INTO `my_table` (`my_pid`, `name`) VALUES (?, ?),
SELECT * FROM `my_table` WHERE (`my_table`.`id` = '0'), # this was being generated by Nette

throwing…

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'my_table.id' in 'where clause'

I am using
Apache/2.4.35 (Win64) PHP/5.6.38, Nette 2.3.10, Mysql 5.7.23

Either I don't want to execute those selects getting primary keys or tell Nette my PK is different than id.

PS: I have tried restarting Apache, clearing cache for far.
PS2: My PK could not be renamed to different name.

Thanks for any help.

Last edited by gfeep (2019-01-25 14:28)