Sirmadsen's post in Original Badge Icons was marked as the answer
Solved it. For anyone else who might screw up their badges:
Download the 4.6 IPS installation from your Client Area and unpack it. Go to your badges menu in your ACP. Click on Import and then import the badges.xml found in "yourfolder\applications\core\data\achievements". Make sure that "Remove existing unassigned badges" is set to Yes. Voila, badges restored and keep all other information like users earned etc.
Sirmadsen's post in Database compact mode how to change for this on cPanel ? was marked as the answer
That's not a very helpful answer. I'm having the same error @Marco Junior Compact mode is basically a less efficient format and can't store as much information as Dynamic. You can change this in your database settings (phpadmin for example) if your database supports it and depending if you are hosting the server yourself or if you are using a web-host which might not support it or only support in a higher tier payment (as in my case) . However since it's not a critical issue you don't have to worry about it unless you have a really big community.