DB Migration Bug
Author: toprakcagatayCreated Sep 12, 2026Updated Sep 12, 2026
Migrated from 4.0.2.3 to 4.1.0.4. Both code and db. Downloaded the code, then run the update script as I described on the versions above.
The changes on prior version I made on theme editor disappeared from the website.
Then I figured out, status field on the oc_theme table were "0" on all records. I manually changed them to "1" on phpmyadmin. All changes came back.
I'm not sure, but possibly the status field on oc_theme table is added later on the migration and default is 0. That is why all my theme changes disappeared.
Source: opencart/opencart