Fix Vanilla to run successfully in Mysql strict mode

I found a very simple way to fix Vanilla to run well with Mysql in strict mode and also support IIS Rewrite Rules

Please review and approve this pull request.

Thanks for your consideration.