[eluser]deczo[/eluser]
Hi there,
There is a problem when doing INSERT on a MySQL table with trigger set up.
The query works just fine without the trigger, but whenever I use the trigger it returns this error:
Code:
A Database Error Occurred
Error Number: 1146
Table 'DB_NAME_HERE.t' doesn't exist
INSERT INTO serwis_sales SET status_id=1...
the query is invoked like this (and it is OK):
Code:
$this->db->query(sprintf('INSERT INTO serwis_sales SET status_id=1 ...
I have no idea why CI renames/aliases the table.
BTW the trigger works fine when inserting data in phpmyadmin and mysql cli.
Any suggestion appreciated!