I have used the auto-update (1-20) used option 3-15 and 20 (used both option 1 and 2 for backups) and never used option 19.
It looks like from merc_weaponinfo_table_update and (newer) comes up with errors on the auto-update. (A few run successful but the majority come up with an error), So I will see if I can source them in manually and see if that changes anything.
I could not manually update merc_weaponinfo_table_update.sql but I could update the next one, 2014_12_31_npc_types_default_values_update.sql
Code:
MariaDB [peq]> source 2014_12_26_merc_weaponinfo_table_update.sql
ERROR 1051 (42S02) at line 2 in file: '2014_12_26_merc_weaponinfo_table_update.sql': Unknown table 'peq.vwmercnpctypes'
ERROR 1054 (42S22) at line 5 in file: '2014_12_26_merc_weaponinfo_table_update.sql': Unknown column 'd_meele_texture1' in 'merc_weaponinfo'
ERROR 1054 (42S22) at line 6 in file: '2014_12_26_merc_weaponinfo_table_update.sql': Unknown column 'd_meele_texture2' in 'merc_weaponinfo'
Query OK, 0 rows affected (0.01 sec)
Once I get these all updated (or find out why they won't update properly with option 3, I will see if I have any different results, but I do appreciate your responses.
One issue I saw that might have caused issue in relation to items, was bag slots. Which I did change every bag over 10 slots to be 10 slots which did not work either. (Since then I reinstalled the server on a different computer but got the same end result of a crash trying to log on any character).
I have not changed any of the data under FVNODROP though.