DB Insert Problem: Unknown Column - Column never referenced in code

[eluser]mddd[/eluser]
I don't see how another table name could come in there, except if you were creating a db query somewhere else in your code that isn't finished.
The database class will remember parts of queries you are building, until you give a command like get() or update().

So it would go wrong if your controller contained code like this:

Code:

// here you are doing something about a delivery
$this->db->select('id');
$this->db->from('delivery_detail');

// now you are calling convert to stock
$this->convertToStock();   // but the 'from' information is still in the database library!

// and now you are finishing the query about delivery
$this->db->get();