Column not getting updated in production but works fine in Test

Question

I have a magento site and a MYSQL table where sellerprofile is saved. I manually added a column to this table

ALTER TABLE `XYZ` ADD COLUMN `ABC` AFTER `CDE`

Now when I am trying to update a value to this column using my magento code then it is not saving this value. If I try to do a SQL update then it works just fine.

The Magento update

$collection->save() 

does not return any error either. All other columns get updated except this particular column. I did a Mage::log on this and till the save point, the variable does carry the correct value. It just does not show up in the database.

Strangely this works perfectly in my TEST env which is not very different from PROD.

What am I missing here?

Answer 1

Did you flush the cache ? Magento maintains table definitions in cache even if it is not enabled via admin.