Those debug asserts are meant to help developers find and fix mistakes in the code. For example if the sql parameter names or types or counts declared in code don't match the parameters in the actual stored procedure.
If you are encountering such errors in mojoPortal code please let me know where they are so I can fix them, ie post a stack trace. I would not expect you to be encountering lots of errors such as this but if you are encountering them I would like to get bug reports about the specific details.
When not in debug mode sql server is fairly forgiving and errors won't happen in production if the types and counts are correct and only the names are wrong, but still its best to track down any such mistakes and fix them.