During SG-Rewritten's development, we primarily tested via SQLite (while trying to make an effort to make sure that all used syntax was also valid in MySQL).

Unfortunately, upon preliminary testing, some of the newer database code is slightly incompatible with MySQL.

Additionally, there appear to be some problems with modern inter-server portals.

This issue will be used to keep track of all current SQL debugging, the issues found as a result of those efforts, and our work towards correcting them.

Known Problems:

• nullable MySQL incompatibility.
• Multiple issues with foreign keys
• A stack trace caused by interserver portals (found by Thorin -- TBP)

Most of these issues stems from invalid use of the foreign key. I'm not good at sql, but sqlite allows for behaviors that might cause bugs, whil mysql throws an stacktrace instead.

I've fixed some bugs in cf0c0f4, 56aca59 and c8353d0, but I'm not sure if it fixes any of the mentioned bugs.

This is a somewhat general issue, but:

• All unit tests work fine now
• No stacktraces are run when creating a interserver portal