Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 21:24

  • Please register to post and access all features, it's quick, easy and FREE!

 

[HowTo] Fix "ACCESS_VIOLATION"

Reply
 
Old   #1


 
elite*gold: 30
Join Date: May 2011
Posts: 4,801
Received Thanks: 3,181
[HowTo] Fix "ACCESS_VIOLATION"

Heyho,

First of all:

Whats that?!
Quote:
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:
Code:
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:
Quote:
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):
Code:
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

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.



Xijezu is offline  
Thanks
2 Users
Reply



« Previous Thread | Next Thread »



All times are GMT +2. The time now is 21:24.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.