Nurga

UPDATE: Created the columns that were missed in character_aura. It works now. Thank you

Server is patched and works. No wrong updates so far. But the character_aura table doesn't have all the columns that are listed at character_aura (getmangos.eu) But may this be the problem? I mean...why is this error not happening on the other classes? Mh.

I have a problem. Server-Version: 3.3.5a Every time I log out with a warrior-class-character the server crashes. This does not effect any other class, only warriors. Crash-Log: Revision: * * 11880 * Date 4:2:2012. Time 16:52 //===================================================== *** Hardware *** Processor: AMD Opteron(tm) Processor 6128 Number Of Processors: 1 Physical Memory: 1047184 KB (Available: 292540 KB) Commit Charge Limit: 2385804 KB *** Operation System *** Windows Vista or Windows Server 2008 Server 4.0 Service Pack 2 (Version 6.0, Build 6002) //===================================================== Exception code: C0000005 ACCESS_VIOLATION Fault address: 009D6B29 01:005D5B29 D:\\mangos\\mangosd.exe Registers: EAX:00000000 EBX:7FF8FF40 ECX:722FAB30 EDX:00000000 ESI:00000000 EDI:009E1030 CS:EIP:001B:009D6B29 SS:ESP:0023:03F5FE14 EBP:03F5FE20 DS:0023 ES:0023 FS:003B GS:0000 Flags:00010246 Call stack: Address Frame Function SourceFile 009D6B29 00000000 SqlConnection::ExecuteStmt+29 009E1C87 00000000 SqlPreparedRequest::Execute+57 009E1AA0 00000000 SqlTransaction::Execute+D0 009E6BBA 00000000 SqlDelayThread::ProcessRequests+3A 009E6B27 00000000 SqlDelayThread::run+57 009E1049 00000000 ACE_Based::Thread::ThreadTask+19 6D362E34 00000000 ?invoke@ACE_OS_Thread_Adapter@@UAEKXZ+74 6D283433 00000000 _endthreadex+44 6D2834C7 00000000 _endthreadex+D8 7641D309 00000000 BaseThreadInitThunk+12 77C01603 00000000 RtlInitializeExceptionChain+63 77C015D6 00000000 RtlInitializeExceptionChain+36 Call stack: Address Frame Function SourceFile 77C25CD4 00000000 KiFastSystemCallRet+0 76419A12 00000000 WaitForSingleObject+12 Call stack: Address Frame Function SourceFile 77C25CD4 00000000 KiFastSystemCallRet+0 763D1C6C 00000000 Sleep+F 009E1260 00000000 ACE_Based::Thread::Sleep+30 009E6B1C 00000000 SqlDelayThread::run+4C 009E1049 00000000 ACE_Based::Thread::ThreadTask+19 6D362E34 00000000 ?invoke@ACE_OS_Thread_Adapter@@UAEKXZ+74 6D283433 00000000 _endthreadex+44 6D2834C7 00000000 _endthreadex+D8 7641D309 00000000 BaseThreadInitThunk+12 77C01603 00000000 RtlInitializeExceptionChain+63 77C015D6 00000000 RtlInitializeExceptionChain+36 Call stack: Address Frame Function SourceFile 77C25CD4 00000000 KiFastSystemCallRet+0 03F5F020 00000000 0000:00000000 FF50D845 FFFFFFFF 0000:00000000 Call stack: Address Frame Function SourceFile 77C25CD4 00000000 KiFastSystemCallRet+0 763D1C6C 00000000 Sleep+F 009E1260 00000000 ACE_Based::Thread::Sleep+30 009E6B1C 00000000 SqlDelayThread::run+4C 009E1049 00000000 ACE_Based::Thread::ThreadTask+19 6D362E34 00000000 ?invoke@ACE_OS_Thread_Adapter@@UAEKXZ+74 6D283433 00000000 _endthreadex+44 6D2834C7 00000000 _endthreadex+D8 7641D309 00000000 BaseThreadInitThunk+12 77C01603 00000000 RtlInitializeExceptionChain+63 77C015D6 00000000 RtlInitializeExceptionChain+36 Call stack: Address Frame Function SourceFile 77C25CD4 00000000 KiFastSystemCallRet+0 763D1C6C 00000000 Sleep+F 009E1260 00000000 ACE_Based::Thread::Sleep+30 00468529 00000000 WorldRunnable::run+99 009E1049 00000000 ACE_Based::Thread::ThreadTask+19 6D362E34 00000000 ?invoke@ACE_OS_Thread_Adapter@@UAEKXZ+74 6D283433 00000000 _endthreadex+44 6D2834C7 00000000 _endthreadex+D8 7641D309 00000000 BaseThreadInitThunk+12 77C01603 00000000 RtlInitializeExceptionChain+63 77C015D6 00000000 RtlInitializeExceptionChain+36 Call stack: Address Frame Function SourceFile 77C25CD4 00000000 KiFastSystemCallRet+0 76477973 00000000 GetConsoleInputWaitHandle+1E2 76477AAD 00000000 ReadConsoleA+40 7642AD35 00000000 PulseEvent+3014 6D2C8EF2 00000000 _wsopen_s+228 6D2C9376 00000000 _read+C0 6D28EFD2 00000000 _filbuf+7D 6D28E671 00000000 fgets+109 00416398 00000000 CliRunnable::run+B8 009E1049 00000000 ACE_Based::Thread::ThreadTask+19 6D362E34 00000000 ?invoke@ACE_OS_Thread_Adapter@@UAEKXZ+74 6D283433 00000000 _endthreadex+44 6D2834C7 00000000 _endthreadex+D8 7641D309 00000000 BaseThreadInitThunk+12 77C01603 00000000 RtlInitializeExceptionChain+63 77C015D6 00000000 RtlInitializeExceptionChain+36 Call stack: Address Frame Function SourceFile 77C25CD4 00000000 KiFastSystemCallRet+0 758B179D 00000000 0001:0000079D C:\\Windows\\system32\\MSWSOCK.dll 77771693 00000000 select+9F 6D3256E5 00000000 ?wait_for_multiple_events@?$ACE_Select_Reactor_T@V?$ACE_Reactor_Token_T@VACE_Token@@@@@@MAEHAAVACE_Select_Reactor_Handle_Set@@PAVACE_Time_Value@@@Z+115 FFFFFFFF FFFFFFFF 0000:00000000 Call stack: Address Frame Function SourceFile 77C25CD4 00000000 KiFastSystemCallRet+0 758B179D 00000000 0001:0000079D C:\\Windows\\system32\\MSWSOCK.dll 77771693 00000000 select+9F 6D3256E5 00000000 ?wait_for_multiple_events@?$ACE_Select_Reactor_T@V?$ACE_Reactor_Token_T@VACE_Token@@@@@@MAEHAAVACE_Select_Reactor_Handle_Set@@PAVACE_Time_Value@@@Z+115 FFFFFFFF FFFFFFFF 0000:00000000 ======================== Local Variables And Parameters Call stack: Address Frame Function SourceFile 009D6B29 00000000 SqlConnection::ExecuteStmt+29 Local <user defined> 'this' punting on symbol nIndex Local <user defined> 'id' Local <user defined> 'pStmt' 009E1C87 00000000 SqlPreparedRequest::Execute+57 Local <user defined> 'this' Local <user defined> 'conn' Local <user defined> 'guard' 009E1AA0 00000000 SqlTransaction::Execute+D0 Local <user defined> 'pStmt' punting on symbol i Local <user defined> 'this' Local <user defined> 'conn' Local <user defined> 'nItems' Local <user defined> 'guard' 009E6BBA 00000000 SqlDelayThread::ProcessRequests+3A Local <user defined> 'this' Local <user defined> 's' 009E6B27 00000000 SqlDelayThread::run+57 Local <user defined> 'this' Local <user defined> 'loopSleepms' punting on symbol loopCounter Local <user defined> 'pingEveryLoop' 009E1049 00000000 ACE_Based::Thread::ThreadTask+19 punting on symbol param Local <user defined> '_task' 6D362E34 00000000 ?invoke@ACE_OS_Thread_Adapter@@UAEKXZ+74 6D283433 00000000 _endthreadex+44 6D2834C7 00000000 _endthreadex+D8 7641D309 00000000 BaseThreadInitThunk+12 77C01603 00000000 RtlInitializeExceptionChain+63 77C015D6 00000000 RtlInitializeExceptionChain+36 ======================== Global Variables And this is what the server-log shows last: Server.txt: 2012-02-04 17:43:33 ERROR:SQL: SELECT caster_guid,item_guid,spell,stackcount,remaincharges,basepoints0,basepoints1,basepoints2,periodictime0,periodictime1,periodictime2,maxduration,remaintime,effIndexMask FROM character_aura WHERE guid = '12' 2012-02-04 17:43:33 ERROR:query ERROR: Unknown column 'caster_guid' in 'field list' 2012-02-04 17:43:36 ERROR:SESSION: received not allowed opcode CMSG_LFG_GET_STATUS (0x0296) 2012-02-04 17:44:21 ERROR:SQL: mysql_stmt_prepare() failed for 'INSERT INTO character_aura (guid, caster_guid, item_guid, spell, stackcount, remaincharges, basepoints0, basepoints1, basepoints2, periodictime0, periodictime1, periodictime2, maxduration, remaintime, effIndexMask) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' 2012-02-04 17:44:21 ERROR:SQL ERROR: Unknown column 'caster_guid' in 'field list mangosd.exe: http://img99.imageshack.us/img99/1174/crasheu.jpg[/img]