Koiecks wrote:So I figured out the hard way that when running your server thru Bluefang that you should not place a /DELIMITER (sp) command in the patch.sql
It will cause too many errors on start up that it crashes. Once removed and updated it ran again with no problems.
I can see that as a problem with some providers.
MariaDB, which this was written for is a drop-in replacement for MySQL.
The programmer that started MySQL named it after his first daughter (My) then after it was sold, forked it and opened it back up and named it after his second daughter (Maria).
That said, while it is a drop in replacement, there are some things required in Maria (that most server admins run) that are not required or are unknown to My. The Delimiter aspect appears to be one, so Bluefang most likely runs a MySQL DB for the game instead of Maria.
For those that don't work after the patch, you may check and make sure that the trigger or a similar trigger does not exist already, if it does, you need to drop it and re-create it.
If you look through some of the patch.sql, you'll notice that it has a lot of CREATE PROCEDURE, etc. with a DROP PROCEDURE a few lines above it. This effectively refreshes the procedures and such that they patch in game.
So far they have not used any triggers in the patch or game code (TRIGGER can replace PROCEDURE for drops/creates)
Another thing to watch out for with triggers is that My and Maria does not have the capacity to handle multiple triggers of the same type on the same table.
For example, if you want to do a BEFORE INSERT on the character table to add skills upon creation, you cannot create a second BEFORE INSERT on the character table for adding items to their inventory for something like a newbie pack. Those 2 must be added to the same BEFORE INSERT trigger.