Crash when trying to log character in

[phantomghost]

I have tried to resolve this when I get time for a couple of weeks, but have had no luck.

I cannot find anything on the forums, I have very limited experience with servers, I made a server about a year ago (I do not have it any more), and I was able to play on the server, but I am uncertain of what I am missing this time around. (Only difference would be previously I did it on Windows 7 and I am now doing it on Windows 10).

I can make a character on the server, but I cannot log in on the character without it crashing. I have tried all different race/class combinations and I get the same result.

Looking at my queryserv window I initially thought this might have been the issue.

I have tried on UF, ROF and ROF2 client. UF I get an error message almost immediately (attached). ROF and ROF2 just never loads.







I included my eqemu_config.xml thinking that I may have an issue here, as I have tried changing bits and pieces due to several posted not always following the same format (one listed on the wiki does not have anything on the qsdatabase so queryserv does not even run)

I have tried switching between 127.0.0.1 and localhost but neither worked.

Any help is appreciated. Let me know if I need to post any other files up. I am able to log on other servers, so I can only assume it the issue is due to something wrong in my server files.

<?xml version="1.0"?>
<server>
	<world>
		<shortname>Phantom</shortname>
		<longname>Phantom's Server</longname>

		<!-- Only specify these two if you really think you need to.  (read: You don't) -->
		<address>127.0.0.1</address>
		<!-- <localaddress>192.168.0.10</localaddress> -->

		<!-- Loginserver information.  Defaults shown -->
		<loginserver>
			<host>login.eqemulator.net</host>
			<port>5998</port>
			<account></account>
			<password></password>
		</loginserver>

		<!-- Server status.  Default is unlocked -->
		<!--<locked/>-->
		<!-- <unlocked/> -->

		<!-- Sets the ip/port for the tcp connections.  Both zones and console (if enabled).  Defaults are shown -->
		<tcp ip="127.0.0.1" port="9000" telnet="disable"/>

		<!-- Sets the shared key used by zone/launcher to connect to world -->
		<key>somerandomstring1234567890</key>

		<!-- Enable and set the port for the HTTP service.  Defaults are shown -->
		<http port="9080" enabled="false" mimefile="mime.types" />
	</world>

	<!-- Chatserver (channels) information.  Defaults shown -->
	<chatserver>
		<host>127.0.0.1</host>
		<port>7778</port>
	</chatserver>

	<!-- Mailserver (in-game mail) information.  Defaults shown -->
	<mailserver>
		<host>127.0.0.1</host>
		<port>7778</port>
	</mailserver>

	<zones>
		<defaultstatus>0</defaultstatus>

		<!-- Sets port range for world to use to auto configure zones -->
		<ports low="7000" high="7500"/>
	</zones>

	<!-- Database configuration, replaces db.ini.  Defaults shown -->
	<database>
		<host>127.0.0.1</host>
		<port>3306</port>
		<username>root</username>
		<password>password</password>
		<db>peq</db>
	</database>

	<qsdatabase>
		<host>127.0.0.1</host>
		<port>3306</port>
		<username>root</username>
		<password>password</password>
		<db>peq</db>
	</qsdatabase>

	<!-- Launcher Configuration -->
	<launcher>
		<!-- <logprefix>logs/zone-</logprefix> -->
		<!-- <logsuffix>.log</logsuffix> -->
		<!-- <exe>zone.exe or ./zone</exe> -->
		<!-- <timers restart="10000" reterminate="10000"> -->
	</launcher>

	<!-- File locations.  Defaults shown -->
	<files>
		<!-- <spells>spells_us.txt</spells> -->
		<!-- <opcodes>opcodes.conf</opcodes> -->
		<!-- <logsettings>log.ini</logsettings> -->
		<!-- <eqtime>eqtime.cfg</eqtime> -->
	</files>
	<!-- Directory locations.  Defaults shown -->
	<directories>
		<!-- <maps>maps</maps> -->
		<!-- <quests>quests</quests> -->
		<!-- <plugins>plugins</plugins> -->
	</directories>
</server>

[Uleat]

A lot of missing information...

Is this a new server or did you recently update it?

Have you tried any other clients or re-installed this one?

[phantomghost]

It is new. I have tried Uf, RoF and Rof2. I only reinstalled UF. I am able to log on other servers which makes me believe it is not the client, but more something I have done wrong on the server.

[Uleat]

Client issues are really hard to track down..

That said, one of the more common causes for client crashes is item-related changes.

Sometimes information is changed to something that the client doesn't like and it throws an exception of some sort.

If your server code and database versioning are up-to-date, have you run shared_memory since the initial install?


EDIT: I think FVNODROP causes a lot of issues..iirc...

[phantomghost]

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

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.

[Uleat]

A bag with >10 slots wouldn't hurt the client..but, you would have some client-server issues when trying to access those slots.

There is code in-place to limit all bags to 10-slot upon server start-up..so, any changes there are overridden.


You have to be careful with manually applying updates. It could be possible to apply an update that will be out-of-date and have another applied that will
cause the proper update not to trigger.

I was pretty sure that all of the merc info was in the peq database..but, iirc, there is something that needs to be applied.

Lemme look and see if I can find the thread on that - it was fairly recent..


EDIT: I didn't see it..but, I'll keep an eye out for it. Check your logs for any [Error] entries.

[phantomghost]

I backed up everything so I can revert it, but after manually sourcing the queryserv window finally loaded. Internet is out so I cannot login to test, but I did get several errors, which I am hoping doing the automated update fixes, but if not I'll just revert back and try individual files to source in.

I believe on my first server a year ago I had a similar issue, and the logsys files stood out, but not sure if those two files would have anything to do with queryserv not loading or if those were just the files I had to start sourcing from a year ago.

If my Internet ever comes up I will update if it works or if I find out what specifically fixes the issue.

[phantomghost]

The specific file that needs to be sourced in order for the queryserv window to fully load is:
2015_01_15_logsys_categories_table

However, in order to be able to log on a character I need to source everything from this and newer:

2014_12_26_merc_weaponinfo_table_update

There were 3 or 4 that were already sourced.

Once this all gets sourced in there are several errors and basically there are no items on the server.

I rolled the server back and copied all the update info and changed the error codes to red. Not sure if these are files that needed to be sourced in or if they should be sourced in with option 3.

Retrieving latest database manifest...
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/db_update_manifest.txt
        [Saved] :: db_update/db_update_manifest.txt
Reading manifest...

Missing DB Update 9096 '2016_03_05_secondary_recall.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2016_03_05_secondary_recall.sql
        [Saved] :: db_update/2016_03_05_secondary_recall.sql
ERROR 1146 (42S02) at line 1: Table 'peq.command_settings' doesn't exist
Missing DB Update 9095 '2016_01_08_command_find_aliases.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2016_01_08_command_find_aliases.sql
        [Saved] :: db_update/2016_01_08_command_find_aliases.sql
ERROR 1146 (42S02) at line 1: Table 'peq.perl_event_export_settings' doesn't exist
Missing DB Update 9094 '2015_12_29_quest_zone_events.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_12_29_quest_zone_events.sql
        [Saved] :: db_update/2015_12_29_quest_zone_events.sql
Missing DB Update 9093 '2015_12_21_items_updates_evoitem.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_12_21_items_updates_evoitem.sql
        [Saved] :: db_update/2015_12_21_items_updates_evoitem.sql
Missing DB Update 9092 '2015_12_17_eqtime.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_12_17_eqtime.sql
        [Saved] :: db_update/2015_12_17_eqtime.sql
Missing DB Update 9091 '2015_12_07_command_settings.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_12_07_command_settings.sql
        [Saved] :: db_update/2015_12_07_command_settings.sql
Missing DB Update 9090 '2015_12_01_spell_scribe_restriction_rule.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_12_01_spell_scribe_restriction_rule.sql
        [Saved] :: db_update/2015_12_01_spell_scribe_restriction_rule.sql
DB up to date with: 9089 - '2015_11_02_ai_idle_no_spell_recast_default_changes.sql'
Missing DB Update 9088 '2015_11_01_perl_event_export_settings.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_11_01_perl_event_export_settings.sql
        [Saved] :: db_update/2015_11_01_perl_event_export_settings.sql
Missing DB Update 9087 '2015_09_25_inventory_snapshots.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_09_25_inventory_snapshots.sql
        [Saved] :: db_update/2015_09_25_inventory_snapshots.sql
DB up to date with: 9086 - '2015_07_02_aa_rework.sql'
Missing DB Update 9085 '2015_07_01_Marquee_Rule.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_07_01_Marquee_Rule.sql
        [Saved] :: db_update/2015_07_01_Marquee_Rule.sql
Missing DB Update 9084 '2015_06_30_runspeed_adjustments.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_06_30_runspeed_adjustments.sql
        [Saved] :: db_update/2015_06_30_runspeed_adjustments.sql
DB up to date with: 9083 - '2015_06_07_aa_update.sql'
DB up to date with: 9082 - '2015_05_25_npc_types_texture_fields.sql'
Missing DB Update 9081 '2015_05_23_dbstr_us.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_05_23_dbstr_us.sql
        [Saved] :: db_update/2015_05_23_dbstr_us.sql
DB up to date with: 9080 - '2015_05_23_PetBuffInstrumentMod.sql'
DB up to date with: 9079 - '2015_05_23_BuffDurations.sql'
DB up to date with: 9078 - '2015_05_20_BuffInstrumentMod.sql'
DB up to date with: 9077 - '2015_02_12_zone_gravity.sql'
DB up to date with: 9076 - '2015_02_04_average_coin.sql'
ERROR 1146 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist
Missing DB Update 9075 '2015_02_02_logsys_packet_logs_with_dump.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_02_02_logsys_packet_logs_with_dump.sql
        [Saved] :: db_update/2015_02_02_logsys_packet_logs_with_dump.sql
ERROR 1146 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist
Missing DB Update 9074 '2015_02_01_logsys_packet_logs.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_02_01_logsys_packet_logs.sql
        [Saved] :: db_update/2015_02_01_logsys_packet_logs.sql
Missing DB Update 9073 '2015_01_31_character_item_recast.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_01_31_character_item_recast.sql
        [Saved] :: db_update/2015_01_31_character_item_recast.sql
DB up to date with: 9072 - '2015_01_30_merc_attack_delay.sql'
DB up to date with: 9071 - '2015_01_29_merc_stats_table_update.sql'
ERROR 1146 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist
Missing DB Update 9070 '2015_01_28_quest_debug_log_category.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_01_28_quest_debug_log_category.sql
        [Saved] :: db_update/2015_01_28_quest_debug_log_category.sql
ERROR 1146 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist
Missing DB Update 9069 '2015_01_25_logsys_Mercenaries_category.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_01_25_logsys_Mercenaries_category.sql
        [Saved] :: db_update/2015_01_25_logsys_Mercenaries_category.sql
Missing DB Update 9068 '2015_01_15_logsys_categories_table.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_01_15_logsys_categories_table.sql
        [Saved] :: db_update/2015_01_15_logsys_categories_table.sql
DB up to date with: 9067 - '2015_01_21_npc_types_update.sql'
DB up to date with: 9066 - '2014_12_31_npc_types_default_values_update.sql'
ERROR 1146 (42S02) at line 1: Table 'peq.vwmercnpctypes' doesn't exist
Missing DB Update 9065 '2014_12_26_merc_weaponinfo_table_update.sql'
 [URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_12_26_merc_weaponinfo_table_update.sql
        [Saved] :: db_update/2014_12_26_merc_weaponinfo_table_update.sql
DB up to date with: 9064 - '2014_12_24_npc_types_table_update.sql'
DB up to date with: 9063 - '2014_12_24_npc_types_update.sql'
DB up to date with: 9062 - '2014_12_15_multiple_table_updates.sql'
DB up to date with: 9061 - '2014_12_13_inventory_table_update.sql'
DB up to date with: 9060 - '2014_12_09_items_table_update.sql'
DB up to date with: 9059 - '2014_12_01_mercs_table_update.sql'
DB up to date with: 9058 - '2014_11_26_InventoryTableUpdate.sql'
DB up to date with: 9057 - '2014_11_13_spells_new_updates.sql'
DB up to date with: 9056 - '2014_11_08_RaidMembers.sql'
DB up to date with: 9055 - '2014_10_30_special_abilities_null.sql'
DB up to date with: 9054 - '2014_10_19_raid_group_mentor.sql'
DB up to date with: 9053 - '2014_10_18_group_mentor.sql'
DB up to date with: 9052 - '2014_10_13_RaidLeadership.sql'
DB up to date with: 9051 - '2014_10_11_RaidMOTD.sql'
DB up to date with: 9050 - '2014_09_20_ban_messages.sql'
DB up to date with: 9048 - '2014_09_09_attack_delay.sql'
DB up to date with: 9046 - '2014_08_23_player_events_and_player_aa_rate_hourly.sql'
DB up to date with: 9045 - '2014_08_23_Complete_QueryServ_Table_Structures.sql'
DB up to date with: 9044 - '2014_08_20_merchantlist_probability.sql'
DB up to date with: 9043 - '2014_08_18_spells_new_update.sql'
DB up to date with: 9042 - '2014_08_12_NPC_raid_targets.sql'
DB up to date with: 9041 - '2014_08_02_spells_new.sql'
DB up to date with: 9040 - '2014_07_10_npc_spells.sql'
DB up to date with: 9036 - '2014_05_04_SlowMitigationFix.sql'
DB up to date with: 9035 - '2014_04_27_AISpellEffects.sql'
DB up to date with: 9034 - '2014_04_25_spawn_events.sql'
DB up to date with: 9032 - '2014_04_12_SlowMitigation.sql'
DB up to date with: 9031 - '2014_04_10_No_Target_With_Hotkey.sql'
DB up to date with: 9030 - '2014_04_04_PhysicalResist.sql'
DB up to date with: 9028 - '2014_02_26_roambox_update.sql'
DB up to date with: 9027 - '2014_02_20_buff_update.sql'
DB up to date with: 9026 - '2014_02_13_spells_new_update.sql'
DB up to date with: 9025 - '2014_02_13_Rename_instance_lockout_tables.sql'
DB up to date with: 9022 - '2014_01_20_Weather.sql'
DB up to date with: 9020 - '2014_01_20_Not_Extendable.sql'
DB up to date with: 9018 - '2014_01_09_PreservePetSize.sql'
DB up to date with: 9017 - '2014_01_08_SpellsNewAdditions.sql'
DB up to date with: 9015 - '2013_12_26_MerchantList_Class_Required.sql'
DB up to date with: 9014 - '2013_11_18_AssistRadius.sql'
DB up to date with: 9012 - '2013_11_07_BaseData.sql'
DB up to date with: 9011 - '2013_10_31_Recipe_disabling.sql'
DB up to date with: 9009 - '2013_10_12_Merc_Special_Abilities.sql'
DB up to date with: 9008 - '2013_07_11_NPC_Special_Abilities.sql'
DB up to date with: 9007 - '2013_05_05_Item_Tick.sql'
DB up to date with: 9006 - '2013_05_05_Account_Flags.sql'
DB up to date with: 9005 - '2013_04_08_Salvage.sql'
DB up to date with: 9002 - '2013_03_1_Merc_Rules_and_Equipment.sql'
DB up to date with: 9001 - '2013_02_25_Impr_HT_LT.sql'

EDIT: Here is what comes up if I try to source the first error (the oldest dated sql file:

ERROR 1054 (42S22) at line 2 in file: '2013_10_12_Merc_vwMercNpcTypes.sql': Unknown column 'mwi.d_meele_texture1' in 'field list'

[DanCanDo]

Just curious, when you first create a fresh server with a fresh unedited database,
do you get that problem with your client crashing when logging in to a brand new
server ? I am only asking, because I have never had to source in any old sql's or
tables. I've never used Akka's installer script, but I'm confident that DB comes a
lot more complete than your experiencing. I source the db in myself, but I never
get that kind of grief. I just source the db, source player_tables, source load_login,
and then run updates. Few glitches to work out after that, but the only time I have
had my client crash, is when I screwed up trying to login to a GM account with a
different client IP than I had in the GM IP table.

[Maze_EQ]

Update your binaries to the latest binaries if you haven't after installing db updates.

[Maze_EQ]

http://www.eqemulator.org/forums/showthread.php?t=40777


Directly below this thread. or a few down.

[phantomghost]

Originally Posted by DanCanDo

Just curious, when you first create a fresh server with a fresh unedited database,
do you get that problem with your client crashing when logging in to a brand new
server ? I am only asking, because I have never had to source in any old sql's or
tables. I've never used Akka's installer script, but I'm confident that DB comes a
lot more complete than your experiencing. I source the db in myself, but I never
get that kind of grief. I just source the db, source player_tables, source load_login,
and then run updates. Few glitches to work out after that, but the only time I have
had my client crash, is when I screwed up trying to login to a GM account with a
different client IP than I had in the GM IP table.

Using the somewhat outdated guide here:
http://wiki.eqemulator.org/p?Complet...er_Setup_Guide

The server does not work. Regardless, it comes down to the same errors when trying to update.

I also source the db, source player_tables. (I am not doing the login). Then I skip the quest and map part because those SVN checkout links are old and do not work. (I do not use the link provided for the eq_emu.config because it does not work, I use google to get one that does work and make the few changes needed).

Then I run world.exe. Back it up... even though there is nothing special there. (Now at this point I have tried both orders) I can download quests and maps, then update or the other way around. In the end I get the same errors listed in red in my previous post). I also run shared.exe after but not sure it makes a difference since the updates I need fail anyway.

No info regarding libmysql.dll or zlib1.dll (so you have to google those errors that pop up to find those files).

Binaries are updated (just re-did everything) and it is the same result, several error codes trying to update the database.

[phantomghost]

Tried using option 3 then 3 again. But it is the same result, so I am not sure if I am missing something a step or what I am doing wrong.

[Uleat]

There is an option in the updater to download the necessary 'dll' files.