First of all:
Whats that?!
This, my friend, is some part of your dump-files (.txt).Quote:
Program Name : Arcadia
EXE : ********\CapitanHerlockServer.exe
User : Xijezu
Computer : *******
Program :
Exception : C0000005 (ACCESS_VIOLATION)
Fault Address: 100424184 23184:76D4AF26
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
First of all: Read the errormessage!
Sometimes there is the fix for your problem, for example:
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):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())
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
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.