1

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?

  • i think reindex problem try to reindex. it not reflect frontend right? – Magento 2 Feb 1 '16 at 9:34
  • its not there in the database itself ... I checked using phpmyadmin. Since its not there in db, the frontend also does not have it. I had re-indexed and tried but did not work. Can try again and will post back. – coderatlarge Feb 1 '16 at 9:36
  • That column is created or not ? – Magento 2 Feb 1 '16 at 9:38
  • yes the column is created and i can see it in phpmyadmin – coderatlarge Feb 1 '16 at 9:48
  • Did you flush the cache ? Magento maintains table definitions in cache even if it is not enabled via admin. – Prateek Feb 1 '16 at 9:50
1

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.