I was able to recreate this error after installing Acquia Drupal from the Microsoft Web Platform installer and then directly installing the storage api module. The reason for this error comes from the platform installer setting the MySQL database to strict mode automatically which causes the 'user warning: storage api INSERT INTO etc etc.' This seems to occur only during Web Platform Installation on Windows Servers when MySQL is automatically installed.

How to Fix:
1. Go to Start > Programs > MySQL > Instance Installer Wizard
2. Reconfigure Instance
3. Detailed Configuration
4. Server Machine
5. Multifunctional Database
6. Next
7. Online Transaction Processing
8. UNCHECK 'Enable Strict Mode' <- *IMPORTANT*
9. Best Support for Multilingualism
10. Next
11. Set Password
12. Done