[HowTo] Fix "ACCESS_VIOLATION"

[Xijezu]

Heyho,

First of all:

Whats that?!

Program Name : Arcadia
EXE : ********\CapitanHerlockServer.exe
User : Xijezu
Computer : *******

Program :
Exception : C0000005 (ACCESS_VIOLATION)
Fault Address: 100424184 23184:76D4AF26

This, my friend, is some part of your dump-files (.txt).

Usually ACCESS_VIOLATION is a database-issue, when Herlock isn't able to insert/update/delete rows.

Caused by...?
That's a part which I dont know.
But I have some therories:

• Your Comp/Root crashed, and your database got corrupted.
• some wrong insert corrupted the database
• general issue.

How to fix:
First of all, run this SQL-Query:

USE Telecaster
GO
DBCC CHECKDB

When this query printing red lines, then gz: Your Database is corrupted!

First of all: Read the errormessage!
Sometimes there is the fix for your problem, for example:

Table X, column X got a wrong insert. Update this column to fix that.
OR
Table Item, column update_time got a wrong insert. Update this column to fix that.
(in this case, just run: Update item set update_time = getdate())

If there is no understandable errormessage, use this query (Notice: Close all your programs which have access to this database, for example herlock, webserver, etc):

USE Telecaster
GO
ALTER DATABASE Telecaster SET single_user
GO
DBCC CHECKDB('Telecaster', repair_allow_data_loss)
GO
ALTER DATABASE Telecaster SET multi_user
GO

If your problem isn't solved yet, do this:

Download
Connect to your SQL Server
Create a new Database
Open both, the old and the new database
Copy'n'Paste your current table's & stored procedures into the new one

 Spoiler

Rename the old one into some stupid name, the new one in Telecaster
Start Herlock.

Usually your database is repaired yet. If not: Unlucky you. :P

NOTICE
Some things:
I know, I'm not a pro in SQL, because I prefer to MySQL.
If you think, Navicat is crap, then dont use it. I love it to work with Databases.
If you don't get this error messages, ignore it.

Hope, this therad can help you.

Xijezu.