Just upgraded from 2.2.8 to 4.1.0 and got a message to state I needed to re-encrypt forms from their current encryption to a new encryption... I did this... and now... the form data is all corrupt! Any idea how I can retrieve this data from the database? Anyone know where in the MODx DB where the stored formit forms data is and how I can un-encrypt it once located in the DB???
What a pain!
Did you use the migration page in the Manager to do the new encryption?
Do you know the encryption key?
Is it possibly that you refreshed the page or navigated to another page while it was still working on the conversion? That would probably mean some of the data is encrypted with the new method and some with the old, which would make it appear corrupted.
Without the encryption key (which might be in a snippet property somewhere, or identifiable in the source code), there's nothing to try other then restoring from a backup.
If you know which table is it, just export only that table in PhpMyAdmin from the backup, (or, if the backup is an .sql file you should be able to cut and paste the section for that table into another .sql file -- you may need the file header as well). Then in PhpMyAdmin, truncate the current table and import the backup .sql file for that table.