Crashing When Logging In
Any help or direction would be appreciated
Code:
[01-03-2016 :: 18:50:51] [Crash] EXCEPTION_ACCESS_VIOLATION |
Did you remove items (or change item ids) from your database?
|
I added new items for a task i was making, didnt remove any i think.
ceated a goallist if that helps |
Following the code in the crash trace:
Code:
01-03-2016 :: 18:50:54] [Crash] C:\Windows\system32\dbghelp.dll:dbghelp.dll (735A0000), size: 962560 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\dbghelp.dll', fileVersion: 6.1.7601.17514 My guess: https://github.com/EQEmu/Server/blob...m_struct.h#L75 (crash point) https://github.com/EQEmu/Server/blob...item.cpp#L1444 https://github.com/EQEmu/Server/blob...eddb.cpp#L1297 https://github.com/EQEmu/Server/blob...reddb.cpp#L668 https://github.com/EQEmu/Server/blob...rlddb.cpp#L221 The only thing I can see happening in that call line is that a non-null pointer is being passed for an item in which the original reference was deleted or never valid. Post the id's of the items that you created and ensure the shared_memory.exe was run after making the additions that caused this crash. |
Ok so,
I checked all of my items and they were all valid. i did run shared_memory with no errors. Only thing i can think of is when i added a goalid into the task, i entered an ID in that didn't exist, but i couldn't delete the entry through EoC (PEQ DBase editor) so i made a new goalid, with a list. Any idea if the goalid is the issue, with the incorrect ID? can't seem to find the table in the database. |
That crash is explicitly in the character select loading portion of the code. I don't think goals should be an issue that early..but, anything is possible.
I ask about item ids because there is a cap on what the ids can be and wondered if you exceeded that. Technically, you shouldn't be getting to '= new item_struct' unless the item id was in the hash..so, I'm not completely sure what the issue is atm. EDIT: You have successfully been in-game prior to this crash, correct? EDIT2: Someone mentioned the possibility of running out of memory as well.. |
Ok thanks, the last item id was 132485
Yes, i have been in before and i will check my memory usage when i crawl my ass out of bed :D |
Ok,
Checked the server and shes still purring unless you meant something else running out of memory. Step by step, i was in game at the time and was buidling the new task to do. Decided to reboot the server and that is when it happened. But, in saying that i did create a goalid with an item in it that was 1324085 by accident, but i went into the database and removed it from the goallist / activities |
Quote:
|
^ lawl, every morning zz
Ok, so i search zones crash log and got this, any help? Code:
[01-04-2016 :: 14:24:04] [Error] [TASKS]Activity for non-existent task (1, 0) while loading activities from database |
Run this query and see if it returns anything:
Code:
SELECT * FROM `inventory` WHERE `itemid` > (SELECT MAX(`id`) FROM `items`); |
You can try this one too..looks for inventory items not in the items table:
Code:
SELECT * FROM `inventory` WHERE `itemid` NOT IN (SELECT `id` FROM `items`); |
Quote:
But, i have narrowed it down. my account is unable to log in, i used different accounts and they get to char select screen, i didn't test further. Used my main account, the world crumbles. So possibly an account issue, will look further. Appreciate the help Uleat. |
Update
Fixed the issue by deleting everything in inventory, i will go through each Id i had in the inventory and will find the cause. Thanks for narrowing it down for me! |
Something, I've done in the past, when I need a custom item for a quest, etc., which one could call it
a quick easy "cheat" (smirk), I find an item in the db from an expansion thats not in use and, without changing the item ID, I edit everything else. |
If you do find the specific item(s) causing the issue, please post an export using:
[CMD Prompt] Code:
mysqldump -t -u MyUserName -pMyPassword MyDatabase items --where="id = n"-- or -- [HeidiSQL SQL Inserts Export] Code:
SELECT * FROM `items` WHERE `id` = n;..where Code:
nIt should look something like this: Quote:
Quote:
I can look at the column values and see if something is causing an issue. |
What has probably happened is that shared_memory isn't being properly reloaded.
If you ever ran the #hotfix command there is a variable called "hotfix" in the table "variables" that contains the hotfix prefix. That needs to get wiped out and all of the files in shared_memory need to be deleted before you rerun shared memory and your issue should go away. |
Quote:
is the #hotfix command ingame or through cmd? shared_memory is suppose to be re-run everytime you create a new item? or create, editing, even npcs? |
Uleat,
This is one item that is causing the crash; Code:
-- phpMyAdmin SQL Dump |
Thanks for posting that!
Does item id 41525 "Quill of the Fury" also cause the same crash, perchance? |
Will try now
|
Quote:
In total, i have create 6 items. which all 6 are used in a quest, but i am removing 3 of them edit: all 6 items i have created crash the player it is looted. I have ran #hotfix, and all appriopriate sequences (i hope) |
I'm looking for differences in field values between what you posted and existing items.
Here are a few so far: Code:
SELECT * FROM `items` WHERE `material` = '-1'Since that other item didn't fail for you, you may try looking at the `created` column. The insert query that you posted shows a malformed timestamp. Quote:
|
I'll give that a shot
|
Ok no luck there either, might it be best if i just edit current items instead of making new ones?
Tested by changing the timestamp and material, still does it. TBH im quite stuck now |
My post had the answer, just saying.
|
I did run shared_memory, several times and also hotfix but neither solve the problem. Can u shed some light on the proprer procedure? I have read the wiki maybe i missed a part.
|
Quote:
cleaned the hotfix_ prefix in hotfix_name (variables) deleted shared folder data, rerun shared_memory. Still crashes:( |
Make sure that when you do all that, that all world and zone processes are closed before running shared_memory and booting your server once again.
Anytime you crash on a shared load like that its related to shared memory referencing invalid id's |
So when it says Zone: current hotfix_ in use, what does that relate to?
I must be doing something wrong, deleted and created a brand new item, did this, and still crashes. I create the item through PEQ Editor |
Run this query:
UPDATE `variables` SET `value`='' WHERE (`varname`='hotfix_name') Make sure everything is shut off. Run shared_memory and make sure it runs items and everything else. Turn on server. Profit. |
Quote:
If the item is *not* in the player inventory, it's fine, but if it is no charm. Is PEQ Editor still the main use of item creation? Otherwise atm ill continue to edit out of era items. Thanks though:( |
| All times are GMT -4. The time now is 11:42 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.