[eluser]boltsabre[/eluser]
Hi guys,
I'm getting this error when trying to insert some data into a new table I've just created:
Quote:A Database Error Occurred
Error Number: 1146
Table 'workandtravdatabase.travel_insurance_reviews_pending' doesn't exist
INSERT INTO `travel_insurance_reviews_pending` .....
And the model doing the inserting is:
Code:
public function insertNewPendingReview($data){
$query = $this->db->insert('travel_insurance_reviews_pending', $this->db->escape($data));
if ($query){
return true;
}else{
return false;
}
}
I am really at a loss as to why I'm getting this message (mind you it's late here, that could be the problem!). I know the table exists, I just created it, and I copied it's name straight from my phpmyadmin screen into my model. I've double, triple checked it - it does exist! And it's also the correct DB name (I'm only using one DB in this application, and all my other inserts are working and inserting into tables...
Any thoughts would be greatly appreciated. Thanks in advance.