Error log

[karnyge]

At every maintenance the server crashes.
Replaced the servers themselves. But still it happens.
Its becoming very annoying to my players and myself, any ideas please?

Heres the error log thing, lol

=================================================================
04:30:04 Message: Jehad Server Stable V2.3721 C2.193  - name removed (Jul  6 2008 16:09:53)
04:30:04 Message: =================================================================
04:30:04 Message: SHELL: 0¡¢Init Database thread...
04:30:04 ERROR: CreateFieldDef - not support type account!
04:30:04 ERROR: CreateFieldDef - not support type account_old!
04:30:04 ERROR: CreateFieldDef - not support type ball_card!
04:30:04 ERROR: CreateFieldDef - not support type cardbalance!
04:30:04 ERROR: CreateFieldDef - not support type columns_priv!
04:30:04 ERROR: CreateFieldDef - not support type cq_mission!
04:30:04 ERROR: CreateFieldDef - not support type fee_end!
04:30:04 ERROR: CreateFieldDef - not support type forgotpass!
04:30:04 ERROR: CreateFieldDef - not support type serial_stat!
04:30:04 ERROR: CreateFieldDef - not support type ss_categories!
04:30:04 ERROR: CreateFieldDef - not support type ss_ordered_carts!
04:30:04 ERROR: CreateFieldDef - not support type ss_orders!
04:30:04 ERROR: CreateFieldDef - not support type ss_products!
04:30:04 ERROR: CreateFieldDef - not support type tables_priv!
04:30:04 ERROR: CreateFieldDef - not support type user_detail!
04:30:04 Message: SHELL: 1¡¢Init world thread...
04:30:04 Message: SHELL: 2¡¢Init map group thread...
04:30:41 ERROR: ¡ïIF_OK(pRes)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\IpAddressSet.cpp, 27
04:30:41 Message: ¼ÓÔصØͼÎļþ[100]...
04:30:41 ERROR: ÎÞ·¨´ò¿ªµØͼÎļþ[map/map/market.dmap]
04:30:41 ERROR: µØͼÎļþ[100]¼ÓÔØʧ°Ü£¡
04:30:41 ERROR: ¡ïASSERT(!"pMapManager->Create")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 570
04:30:41 Message: SHELL: Kernel logic closing...
04:31:01 Message: SHELL: Kernel logic close timeup.
04:31:01 Message: SHELL: Kernel closing...
04:31:01 Message: Total 0 account visit this server.
04:31:01 Message: SHELL: Close map group thread[0] OK¡£
04:31:01 Message: SHELL: #4: map group kernel thread running¡£
04:31:01 Message: SHELL: Close world thread OK¡£
04:31:01 Message: SHELL: #3: World kernel thread running.
04:31:21 Message: DbKernel release 0 timeout user recordset.
04:31:21 Message: SHELL: Close database thread OK¡£
04:31:21 Message: SHELL: #1: Database kernel thread running¡£
04:31:21 Message: SHELL: Flush all cache buffer to file.
04:31:21 Message: SHELL: Server is over, close all  after 3 second!
04:31:24 WARNING: CMyHeap::~CMyHeap() µÄ[CMapManager]ÓÐ[1]¸öÄÚ´æ¿éûÓÐÊÍ·Å
04:35:33 Message: 


=================================================================
04:35:33 Message: Jehad Server Stable V2.3721 C2.193  - name removed(Jul  6 2008 16:09:53)
04:35:33 Message: =================================================================
04:35:34 Message: SHELL: 0¡¢Init Database thread...
04:35:34 ERROR: CreateFieldDef - not support type account!
04:35:34 ERROR: CreateFieldDef - not support type account_old!
04:35:34 ERROR: CreateFieldDef - not support type ball_card!
04:35:34 ERROR: CreateFieldDef - not support type cardbalance!
04:35:34 ERROR: CreateFieldDef - not support type columns_priv!
04:35:34 ERROR: CreateFieldDef - not support type cq_mission!
04:35:34 ERROR: CreateFieldDef - not support type fee_end!
04:35:34 ERROR: CreateFieldDef - not support type forgotpass!
04:35:34 ERROR: CreateFieldDef - not support type serial_stat!
04:35:34 ERROR: CreateFieldDef - not support type ss_categories!
04:35:34 ERROR: CreateFieldDef - not support type ss_ordered_carts!
04:35:34 ERROR: CreateFieldDef - not support type ss_orders!
04:35:34 ERROR: CreateFieldDef - not support type ss_products!
04:35:34 ERROR: CreateFieldDef - not support type tables_priv!
04:35:34 ERROR: CreateFieldDef - not support type user_detail!
04:35:34 Message: SHELL: 1¡¢Init world thread...
04:35:34 Message: SHELL: 2¡¢Init map group thread...
04:36:10 ERROR: ¡ïIF_OK(pRes)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\IpAddressSet.cpp, 27
04:36:10 Message: ¼ÓÔصØͼÎļþ[100]...
04:36:10 ERROR: ÎÞ·¨´ò¿ªµØͼÎļþ[map/map/market.dmap]
04:36:10 ERROR: µØͼÎļþ[100]¼ÓÔØʧ°Ü£¡
04:36:10 ERROR: ¡ïASSERT(!"pMapManager->Create")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 570
04:36:10 Message: SHELL: Kernel logic closing...
04:36:29 Message: SHELL: Kernel logic close timeup.
04:36:30 Message: SHELL: Kernel closing...
04:36:30 Message: Total 0 account visit this server.
04:36:30 Message: SHELL: Close map group thread[0] OK¡£
04:36:30 Message: SHELL: #4: map group kernel thread running¡£
04:36:30 Message: SHELL: Close world thread OK¡£
04:36:30 Message: SHELL: #3: World kernel thread running.
04:36:50 Message: DbKernel release 0 timeout user recordset.
04:36:50 Message: SHELL: Close database thread OK¡£
04:36:50 Message: SHELL: #1: Database kernel thread running¡£
04:36:50 Message: SHELL: Flush all cache buffer to file.
04:36:50 Message: SHELL: Server is over, close all  after 3 second!
04:36:53 WARNING: CMyHeap::~CMyHeap() µÄ[CMapManager]ÓÐ[1]¸öÄÚ´æ¿éûÓÐÊÍ·Å

[Death[PM]]

it looks like to me that the data base that your are using dosent have the files that you server is running from. But i may be wrong

[karnyge]

Let me guess, you are trying to say new database required?

[PraDevil[ELITE]]

what i can say here maybe u are using old table file.here the list..or maybe you are using new one db table or u are using an old acc server..

04:30:04 ERROR: CreateFieldDef - not support type account!
04:30:04 ERROR: CreateFieldDef - not support type account_old!
04:30:04 ERROR: CreateFieldDef - not support type ball_card!
04:30:04 ERROR: CreateFieldDef - not support type cardbalance!
04:30:04 ERROR: CreateFieldDef - not support type columns_priv!
04:30:04 ERROR: CreateFieldDef - not support type cq_mission!
04:30:04 ERROR: CreateFieldDef - not support type fee_end!
04:30:04 ERROR: CreateFieldDef - not support type forgotpass!
04:30:04 ERROR: CreateFieldDef - not support type serial_stat!
04:30:04 ERROR: CreateFieldDef - not support type ss_categories!
04:30:04 ERROR: CreateFieldDef - not support type ss_ordered_carts!
04:30:04 ERROR: CreateFieldDef - not support type ss_orders!
04:30:04 ERROR: CreateFieldDef - not support type ss_products!
04:30:04 ERROR: CreateFieldDef - not support type tables_priv!
04:30:04 ERROR: CreateFieldDef - not support type user_detail!

[C0D3R4ID3R]

if those files files do exist and were working open navicat select those tables and right click and go down to the maintain tables tab and choose repair tables, also make sure all 3 files for each table are in your "my" folder eg:- account.frm , account.MYD , account.MYI

[karnyge]

Originally Posted by C0D3R4ID3R

if those files files do exist and were working open navicat select those tables and right click and go down to the maintain tables tab and choose repair tables, also make sure all 3 files for each table are in your "my" folder eg:- account.frm , account.MYD , account.MYI

Been there and tried that, but ty for the input.

Based on the responses so far, i have tried all these things.

So it looks like i need to replace my db, if anyone has a copy of the revolution db they would care to share, i would very much appreciate it.

UPDATE
All the servers replaced and still crashes.
Entire db replaced with a clean copy of the same database, and still the npc and msg servers crash.

So if anyone has any further ideas, i will listen. Msn on profile

This is the new error log

================================================================================
=== Jehad Server Stable V2.3721 C2.193  - ELMUERTEZONE (Jul  6 2008 16:09:53)
=== Start server time is 2010-08-28 01:47:51
================================================================================
=== Current time is 2010-08-28 01:47:51
=== Server takes 0 days  00:00:00
================================================================================


01:47:51 Message: 


=================================================================
01:47:51 Message: Jehad Server Stable V2.3721 C2.193  - ELMUERTEZONE (Jul  6 2008 16:09:53)
01:47:51 Message: =================================================================
01:47:51 Message: SHELL: 0¡¢Init Database thread...
01:47:51 Message: SHELL: 1¡¢Init world thread...
01:47:51 ERROR: ¡ïCHECKF(pRes)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\WorldKernel\MapList.cpp, 38
01:47:51 Message: SHELL: 2¡¢Init map group thread...
01:47:51 ERROR: ¡ïSAFE_RELEASE(m_pDynaMapDataDefault)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 897
01:47:51 ERROR: ¡ïSAFE_RELEASE(m_pDynaNpcDataDefault)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 898
01:47:51 ERROR: ¡ïSAFE_RELEASE(m_pPetDataDefault)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 899
01:47:51 ERROR: ¡ïSAFE_RELEASE(m_pSynAttrDataDefault)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 900
01:47:51 ERROR: ¡ïSAFE_RELEASE(m_pSynDataDefault)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 901
01:47:51 ERROR: ¡ïSAFE_RELEASE(m_pMagicDataDefault)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 902
01:47:51 ERROR: ¡ïSAFE_RELEASE(m_pUserWeaponSkillDefault)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 903
01:47:51 ERROR: ¡ïSAFE_RELEASE(m_pUserDataDefault)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 905
02:01:15 Message: 


=================================================================
02:01:15 Message: Jehad Server Stable V2.3721 C2.193  - ELMUERTEZONE (Jul  6 2008 16:09:53)
02:01:15 Message: =================================================================
02:01:15 Message: SHELL: 0¡¢Init Database thread...
02:01:15 Message: SHELL: 1¡¢Init world thread...
02:01:15 ERROR: ¡ïCHECKF(pRes)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\WorldKernel\MapList.cpp, 38
02:01:15 Message: SHELL: 2¡¢Init map group thread...
02:01:15 ERROR: ¡ïSAFE_RELEASE(m_pDynaMapDataDefault)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 897
02:01:15 ERROR: ¡ïSAFE_RELEASE(m_pDynaNpcDataDefault)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 898
02:01:15 ERROR: ¡ïSAFE_RELEASE(m_pPetDataDefault)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 899
02:01:15 ERROR: ¡ïSAFE_RELEASE(m_pSynAttrDataDefault)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 900
02:01:15 ERROR: ¡ïSAFE_RELEASE(m_pSynDataDefault)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 901
02:01:15 ERROR: ¡ïSAFE_RELEASE(m_pMagicDataDefault)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 902
02:01:15 ERROR: ¡ïSAFE_RELEASE(m_pUserWeaponSkillDefault)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 903
02:01:15 ERROR: ¡ïSAFE_RELEASE(m_pUserDataDefault)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 905

[funhacker]

Sorry but I did not bother to read all of the posts as people seem to be looking at the wrong thing

04:30:41 ERROR: ÎÞ·¨´ò¿ªµØͼÎļþ[map/map/market.dmap]
04:30:41 ERROR: µØͼÎļþ[100]¼ÓÔØʧ°Ü£¡

Is your problem, just like the client the server has a GameMap.ini here there are numbers that will say what map files are required to build a map. So the cq_map Id that is 100 is loading the the game map id (found in the ini file which will also very likely be 100) and is unable to locate the file "map\map\market.dmap" within your server folder. Easiest way to fix this is just get the map folder from your client or a very up to date private server client (not the TQ ones as map structures may be different) and copy and paste it into your server folder. It should fix this error

[karnyge]

Originally Posted by funhacker

Sorry but I did not bother to read all of the posts as people seem to be looking at the wrong thing



Is your problem, just like the client the server has a GameMap.ini here there are numbers that will say what map files are required to build a map. So the cq_map Id that is 100 is loading the the game map id (found in the ini file which will also very likely be 100) and is unable to locate the file "map\map\market.dmap" within your server folder. Easiest way to fix this is just get the map folder from your client or a very up to date private server client (not the TQ ones as map structures may be different) and copy and paste it into your server folder. It should fix this error

Thanks Funhacker, but that didnt work either.

=================================================================
12:52:17 Message: Jehad Server Stable V2.3721 C2.193  - ELMUERTEZONE (Jul  6 2008 16:09:53)
12:52:17 Message: =================================================================
12:52:17 Message: SHELL: 0¡¢Init Database thread...
12:52:17 ERROR: CreateFieldDef - not support type account_old!
12:52:17 ERROR: CreateFieldDef - not support type cardbalance!
12:52:17 ERROR: CreateFieldDef - not support type columns_priv!
12:52:18 ERROR: CreateFieldDef - not support type cq_mission!
12:52:19 ERROR: CreateFieldDef - not support type fee_end!
12:52:19 ERROR: CreateFieldDef - not support type forgotpass!
12:52:19 ERROR: CreateFieldDef - not support type gm_ban!
12:52:19 ERROR: CreateFieldDef - not support type gm_msgoutput!
12:52:19 ERROR: CreateFieldDef - not support type serial_stat!
12:52:19 ERROR: CreateFieldDef - not support type tables_priv!
12:52:19 ERROR: CreateFieldDef - not support type user_detail!
12:52:19 Message: SHELL: 1¡¢Init world thread...
12:52:19 Message: SHELL: 2¡¢Init map group thread...
12:52:22 ERROR: Dup obj id:1058.
12:52:22 ERROR: Dup obj id:1058.
12:52:22 ERROR: Dup obj id:1059.
12:52:22 ERROR: Dup obj id:1059.
12:52:22 ERROR: Dup obj id:1060.
12:52:22 ERROR: Dup obj id:1060.
12:52:22 ERROR: Dup obj id:1061.
12:52:22 ERROR: Dup obj id:1061.
12:52:22 ERROR: Dup obj id:1062.
12:52:22 ERROR: Dup obj id:1062.
12:52:22 ERROR: Dup obj id:1063.
12:52:22 ERROR: Dup obj id:1063.
12:52:22 ERROR: Dup obj id:1064.
12:52:22 ERROR: Dup obj id:1064.
12:52:22 ERROR: Dup obj id:1065.
12:52:22 ERROR: Dup obj id:1065.
12:52:22 ERROR: Dup obj id:1066.
12:52:22 ERROR: Dup obj id:1066.
12:52:22 ERROR: Dup obj id:1067.
12:52:22 ERROR: Dup obj id:1067.
12:52:22 ERROR: Dup obj id:1068.
12:52:22 ERROR: Dup obj id:1068.
12:52:22 ERROR: Dup obj id:1069.
12:52:22 ERROR: Dup obj id:1069.
12:52:22 ERROR: Dup obj id:1070.
12:52:22 ERROR: Dup obj id:1070.
12:52:22 ERROR: Dup obj id:1071.
12:52:22 ERROR: Dup obj id:1071.
12:52:22 ERROR: Dup obj id:1072.
12:52:22 ERROR: Dup obj id:1072.
12:52:22 ERROR: Dup obj id:1073.
12:52:22 ERROR: Dup obj id:1073.
12:52:22 ERROR: Dup obj id:1074.
12:52:22 ERROR: Dup obj id:1074.
12:52:22 ERROR: Dup obj id:1075.
12:52:22 ERROR: Dup obj id:1075.
12:52:22 ERROR: Dup obj id:1076.
12:52:22 ERROR: Dup obj id:1076.
12:52:22 ERROR: Dup obj id:1077.
12:52:22 ERROR: Dup obj id:1077.
12:52:22 ERROR: Dup obj id:1078.
12:52:22 ERROR: Dup obj id:1078.
12:52:22 ERROR: Dup obj id:1079.
12:52:22 ERROR: Dup obj id:1079.
12:52:22 ERROR: Dup obj id:1080.
12:52:22 ERROR: Dup obj id:1080.
12:52:22 ERROR: Dup obj id:1081.
12:52:22 ERROR: Dup obj id:1081.
12:52:22 ERROR: Dup obj id:1082.
12:52:22 ERROR: Dup obj id:1082.
12:52:22 ERROR: Dup obj id:1083.
12:52:22 ERROR: Dup obj id:1083.
12:52:22 ERROR: Dup obj id:1084.
12:52:22 ERROR: Dup obj id:1084.
12:52:22 ERROR: Dup obj id:1085.
12:52:22 ERROR: Dup obj id:1085.
12:52:22 ERROR: Dup obj id:1086.
12:52:22 ERROR: Dup obj id:1086.
12:52:22 ERROR: Dup obj id:1087.
12:52:22 ERROR: Dup obj id:1087.
12:52:22 ERROR: Dup obj id:1088.
12:52:22 ERROR: Dup obj id:1088.
12:52:22 ERROR: Dup obj id:1089.
12:52:22 ERROR: Dup obj id:1089.
12:52:22 ERROR: Dup obj id:1090.
12:52:22 ERROR: Dup obj id:1091.
12:52:22 ERROR: Dup obj id:1091.
12:52:22 ERROR: Dup obj id:1092.
12:52:22 ERROR: Dup obj id:1093.
12:52:22 ERROR: Dup obj id:1093.
12:52:22 ERROR: Dup obj id:1094.
12:52:22 ERROR: Dup obj id:1094.
12:52:22 ERROR: Dup obj id:1095.
12:52:22 ERROR: Dup obj id:1095.
12:52:22 ERROR: Dup obj id:1096.
12:52:22 ERROR: Dup obj id:1096.
12:52:22 ERROR: Dup obj id:1097.
12:52:22 ERROR: Dup obj id:1097.
12:52:22 ERROR: Dup obj id:1098.
12:52:22 ERROR: Dup obj id:1098.
12:52:22 ERROR: Dup obj id:1099.
12:52:22 ERROR: Dup obj id:1099.
12:52:22 ERROR: Dup obj id:1100.
12:52:22 ERROR: Dup obj id:1100.
12:52:22 ERROR: Dup obj id:1101.
12:52:22 ERROR: Dup obj id:1101.
12:52:22 ERROR: Dup obj id:1102.
12:52:22 ERROR: Dup obj id:1102.
12:52:22 ERROR: Dup obj id:1103.
12:52:22 ERROR: Dup obj id:1103.
12:52:22 ERROR: Dup obj id:1104.
12:52:22 ERROR: Dup obj id:1104.
12:52:22 ERROR: Dup obj id:1105.
12:52:22 ERROR: Dup obj id:1105.
12:52:22 ERROR: Dup obj id:1106.
12:52:22 ERROR: Dup obj id:1106.
12:52:22 ERROR: Dup obj id:1107.
12:52:22 ERROR: Dup obj id:1107.
12:52:22 ERROR: Dup obj id:1108.
12:52:22 ERROR: Dup obj id:1108.
12:52:22 ERROR: Dup obj id:1109.
12:52:22 ERROR: Dup obj id:1109.
12:52:22 ERROR: Dup obj id:1110.
12:52:22 ERROR: Dup obj id:1110.
12:52:22 ERROR: Dup obj id:1111.
12:52:22 ERROR: Dup obj id:1111.
12:52:22 ERROR: Dup obj id:1112.
12:52:22 ERROR: Dup obj id:1112.
12:52:22 ERROR: Dup obj id:1113.
12:52:22 ERROR: Dup obj id:1113.
12:52:22 ERROR: Dup obj id:1114.
12:52:22 ERROR: Dup obj id:1114.
12:52:22 ERROR: Dup obj id:1115.
12:52:22 ERROR: Dup obj id:1115.
12:52:22 ERROR: Dup obj id:1116.
12:52:22 ERROR: Dup obj id:1116.
12:52:22 ERROR: Dup obj id:1117.
12:52:22 ERROR: Dup obj id:1117.
12:52:22 ERROR: Dup obj id:1118.
12:52:22 ERROR: Dup obj id:1118.
12:52:23 ERROR: ¡ïIF_OK(pRes)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\IpAddressSet.cpp, 27
12:52:23 Message: ¼ÓÔصØͼÎļþ[100]...
12:52:23 ERROR: ±³¾°Îļþ[map\puzzle\market.pul]Êý¾Ý×°ÔØ´íÎó£¡
12:52:23 ERROR: µØͼÎļþ[100]¼ÓÔØʧ°Ü£¡
12:52:23 ERROR: ¡ïASSERT(!"pMapManager->Create")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroupKernel\MapGroup.cpp, 570
12:52:23 Message: SHELL: Kernel logic closing...
12:52:43 Message: SHELL: Kernel logic close timeup.
12:52:43 Message: SHELL: Kernel closing...
12:52:43 Message: Total 0 account visit this server.
12:52:43 Message: SHELL: Close map group thread[0] OK¡£
12:52:43 Message: SHELL: #4: map group kernel thread running¡£
12:52:43 Message: SHELL: Close world thread OK¡£
12:52:43 Message: SHELL: #3: World kernel thread running.

I will wait 24-48 hours, if there are no further ideas, or offers of assistance, i will have no choice but to start from scratch. I dont want to have to do this. So if there is a person out there who thinks they can get my server running again without losing all the accounts, player details, and the pets, feel free to msn me. Mention epvp in the invite please.

King Arthur, Dreferalis, Eurion- I plead for one of you to help sort out this problem. Perhaps plead is too mild a term, BEG, would be nearer the mark.

Either way, i could use the help.

Yes i know its double posting, but no-one seems to notice this plea!