[Help Thread] Please post your questions here.

[ThunderNikk]

Are you using the right server files with the right servers...

because no Herlock does not give me SQL column errors when I start it.

[mariathao]

doing the 6.2 with guide and thats what im getting when i launch herlock. does the SQL year matter?

[ThunderNikk]

Not really if you were able to restore all of the databases.

Never really restored or worked with the 6.2 myself

So you have at least all 3 databases restored and named Arcadia Auth and Telecaster

Started Princess aurora with no errors and start captain herlock with that error.

And you are not mixing 6.2 releases you got all the databases out of the same release you got the herlock?

[mariathao]

yea, everything is form the same folder. im using SQL 2014 enterprise and everything work right up till i launched herlock.

[ThunderNikk]

I will set 6.2 up later tonight and see if I can recreate the issue and try to find out what it is, unless someone else answers before that.

[SilentWisdom]

Could get better help if you provide us the last several lines of a SQL Server Profiler capture during the gs startup.

I'm willing to be it's stemming from an smp because the gs selects data like SELECT * FROM dbo.Item, it doesn't use strongly typed column names.

[mariathao]

Originally Posted by SilentWisdom

Could get better help if you provide us the last several lines of a SQL Server Profiler capture during the gs startup.

I'm willing to be it's stemming from an smp because the gs selects data like SELECT * FROM dbo.Item, it doesn't use strongly typed column names.

how do i do that?

[roller334]

1. open your SQL Management Studio
2. in the top menu "tools" -> "sql server profiler"
3. authenticate and run it
4. start your gameserver (wait till his done with initialising)
5. stop tracing
6. save as (select whatever you prefer)

[mariathao]

Cant seem to get it working

but i can provide this

 Spoiler

================================================== ============================

------------------------------------------------------------------------------
Thread Information
------------------------------------------------------------------------------

00 Thread name : IOCP 00
00 job info :
00 job id : 0
00 counter : 0
00 execute time : 0
01 Thread name : IOCP 02
01 job info :
01 job id : 0
01 counter : 0
01 execute time : 0
02 Thread name : IOCP 03
02 job info :
02 job id : 0
02 counter : 0
02 execute time : 0
03 Thread name : IOCP 01
03 job info :
03 job id : 0
03 counter : 0
03 execute time : 0
04 Thread name : Scheduler 00
04 job info :
04 job id : 0
04 counter : 0
04 execute time : 0
05 Thread name : Scheduler 01
05 job info :
05 job id : 0
05 counter : 0
05 execute time : 0
06 Thread name : Scheduler 02
06 job info :
06 job id : 0
06 counter : 0
06 execute time : 0
07 Thread name : Scheduler 03
07 job info :
07 job id : 0
07 counter : 0
07 execute time : 0


------------------------------------------------------------------------------
Basic Information
------------------------------------------------------------------------------

Program Name : Arcadia
EXE : C:\Users\Vaj\Desktop\game_bin\CaptainHerlockServer .exe
User : Vaj
Computer : DESKTOP-R0IVG2I

Program :
Exception : E06D7363 ()
Fault Address: 1748008B2 FF8B2:761838D0
Mem Usage : 1019236KB / 951664KB

------------------------------------------------------------------------------
Allocation Count Info(by _MEM_USAGE_DEBUG)
------------------------------------------------------------------------------

Type: StructSummon Allocated: [Current: 0]/[Peek Concurrent: 1]/[Total: 1]
Type: StructQuestManager Allocated: [Current: 0]/[Peek Concurrent: 1]/[Total: 1]
Type: StructPlayer Allocated: [Current: 0]/[Peek Concurrent: 1]/[Total: 1]
Type: AutoAuctionInfo Allocated: [Current: 38]/[Peek Concurrent: 38]/[Total: 38]


------------------------------------------------------------------------------
x86 Registers
------------------------------------------------------------------------------

EAX=3F80EF38 EBX=004E073E ECX=00000003 EDX=00000000
ESI=3F80F288 EDI=3F80F99C EBP=3F80EF90
DS =002B ES=002B FS=0053 GS:002B
CS:EIP=0023:748008B2
SS:ESP=002B:3F80EF38
Flags=00000212


------------------------------------------------------------------------------
Environment dump
------------------------------------------------------------------------------
app.checksum : 00A17223
app.cmdline : "C:\Users\Vaj\Desktop\game_bin\CaptainHerlockServe r.exe"
app.filesize : 2560000
app.filetime : 2011/07/04-02:16:32
app.name : Rappelz Server
auth.server_idx : 1
auth.server_name : Tester
db.c._password :
db.c.account : sa
db.c.name : Arcadia
db.c.server : 127.0.0.1
db.game.ip : 127.0.0.1
db.user._password :
db.user.account : sa
db.user.name : Telecaster
db.user.server : 127.0.0.1
db.user.thread_active : 0
db.user.thread_total : 0
db.user.work_active : 0
db.user.work_pending : 0
db.user.work_total : 1
engine.ar_time : 18976
engine.count_client : 0
engine.count_movable : 0
engine.count_static : 0
engine.lock : 0
engine.region_size : 180
engine.scheduler.0.instruction : 1290
engine.scheduler.0.object : 1
engine.scheduler.1.instruction : 1290
engine.scheduler.1.object : 1
engine.scheduler.2.instruction : 1290
engine.scheduler.2.object : 1
engine.scheduler.3.instruction : 1290
engine.scheduler.3.object : 0
engine.scheduler.destroy_cnt : 0
engine.scheduler.destroy_loop : 1290
engine.scheduler.destroy_pend : 0
engine.use_region_debug : 0
engine.wait : 0
game.AdultServer : 0
game.AutoOpenOnly : 0
game.PKServer : 0
game.allowed_special_char :
game.ally_pcbang_bonus_rate : 0.100000
game.ally_pcbang_chaos_bonus_rate : 0.100000
game.apply_stamina_bonus_in_premium_pcbang : 0
game.auction_process_request_min_interval : 100
game.auction_search_request_min_interval : 300
game.bUseLockDelayLogging : 0
game.broadcast_event_item_pickup : 0
game.cash_item_dropable : 0
game.cash_usable_server : 0
game.chaos_drop_rate : 100.000000
game.check_storage_security_always : 1
game.disable_dungeon_raid_siege : 0
game.disable_huntaholic : 0
game.disable_pk_on : 0
game.exp_rate : 2.000000
game.force_unregister_account_on_kick_fail : 0
game.gold_drop_rate : 1000.000000
game.ignore_random_damage : 0
game.item_count : 0
game.item_drop_rate : 200.000000
game.item_hold_time : 180000
game.item_loading : complete
game.limit_adv_chat_count : 1
game.limit_booth_openable_layer_to_zero : 0
game.limit_dungeon_enterable_level : 0
game.limit_field_logout : 0
game.limit_game_time : 0
game.local_flag : 1
game.logout_timer : 1000
game.map_height : 1000000
game.map_width : 700000
game.max_game_time_limited_age : 17
game.max_healthy_game_time : 1080000
game.max_layer : 256
game.max_level : 170
game.max_storage_item_count : 1000
game.max_tired_game_time : 1800000
game.min_booth_startable_level : 0
game.min_global_chat_usable_level : 0
game.mod : 0.000000
game.monster_drop_respawn : 0
game.monster_pathfinding : 0
game.monster_respawn_cnt : 0
game.monster_respawn_object_cnt : 0
game.monster_respawn_try_cnt : 0
game.monster_wandering : 1
game.no_collision_check : 1
game.no_skill_cooltime : 0
game.party_exp_rate : 1.000000
game.period_of_security_solution_check : 30000
game.play_point_accumulate_amount : 1
game.play_point_accumulate_term : 60
game.premium_pcbang_bonus_rate : 1.200000
game.premium_pcbang_chaos_bonus_drop_rate : 1.000000
game.premium_pcbang_chaos_bonus_rate : 0.100000
game.premium_pcbang_gold_bonus_drop_rate : 1.000000
game.premium_pcbang_item_bonus_drop_rate : 1.000000
game.premium_pcbang_play_point_bonus_rate : 2.000000
game.pvp_damage_rate_for_player : 0.200000
game.pvp_damage_rate_for_summon : 0.130000
game.restrict_banword_for_booth : 0
game.restrict_special_char : 1
game.security_solution_exceptional_ip :
game.security_solution_response_timeout : 3000
game.security_solution_type : 0
game.server_screenshot_url :
game.skip_loading_attribute : 0
game.speed_unit : 30
game.stamina_bonus_rate : 1.000000
game.tile_size : 42.000000
game.use_auto_jail : 1
game.use_auto_trap : 0
game.use_delete_security : 0
game.use_guild_donation_point : 0
game.use_login_logout_debug : 0
game.use_play_point : 0
game.use_security : 0
game.use_storage_security : 0
game.user_count : 0
io.connection : 0
io.ip_address : 127.0.0.1
io.port : 4514
io.recv_byte : 0
io.recv_count : 0
io.send_byte : 0
io.send_count : 0
io.use_message_statistics : 0
iocp.active : 0
iocp.dis_count : 0
iocp.instruction : 0
iocp.total : 4
log.chat.working : 0
log.server_name : Rappelz Server
log.working : 0
memory.item_heap_size : 189696
memory.monster_heap_size : 149800
memory.player_heap_size : 11952
memory.summon_heap_size : 43600
process.id : 5148
process.load : 162
process.load_kernel : 99
process.load_user : 0
process.memory : 1019236
process.memory_peak : 1019640
process.paged_memory : 951664
process.paged_memory_peak : 953436
process.start : 2018/01/11-17:49:20
process.uptime : 3 Minute 9 Second
stat.loading_guild_info : doing
thread.db.0.proc : DB_OnStartUp
thread.scheduler.0.proc : ItemCollector
thread.scheduler.1.proc : _ServerStatusReport
thread.scheduler.2.proc : WorldLocationManager


------------------------------------------------------------------------------
Application-specific log
------------------------------------------------------------------------------

PlayerHeapSize : 11952 kb
MonsterHeapSize : 149800 kb
ItemHeapSize : 189696 kb
SummonHeapSize : 43600 kb
PetHeapSize : 4200 kb
SkillHeapSize : 38400 kb
QuestHeapSize : 4800 kb
DBHeapSize : 13042 kb


------------------------------------------------------------------------------
Call Stack (Short)
------------------------------------------------------------------------------

Address Frame Function SourceFile
748008B2 3F80EF90 0001:000FF8B2 C:\WINDOWS\System32\KERNELBASE.dll
0056A84B 3F80EFC8 0001:0016984B C:\Users\Vaj\Desktop\game_bin\CaptainHerlockServer .exe f:\dd\vctools\crt_bld\self_x86\crt\prebuild\eh\thr ow.cpp line 161
004E0217 3F80FDC8 0001:000DF217 C:\Users\Vaj\Desktop\game_bin\CaptainHerlockServer .exe d:\alienbrainwork\source code\@rappelz\server\gameserver_for_update\090721_ gameserver\game\community\guildloader.cpp line 193
004E1290 3F80FDF0 0001:000E0290 C:\Users\Vaj\Desktop\game_bin\CaptainHerlockServer .exe d:\alienbrainwork\source code\@rappelz\server\gameserver_for_update\090721_ gameserver\game\community\guildmanager.cpp line 48
004DF5CC 3F80FDF4 0001:000DE5CC C:\Users\Vaj\Desktop\game_bin\CaptainHerlockServer .exe d:\alienbrainwork\source code\@rappelz\server\gameserver_for_update\090721_ gameserver\game\community\guildloader.cpp line 72
0041D3CA 3F80FF40 0001:0001C3CA C:\Users\Vaj\Desktop\game_bin\CaptainHerlockServer .exe d:\alienbrainwork\source code\@rappelz\server\gameserver_for_update\090721_ gameserver\xmodule\xbossworker.h line 276
0056AC6C 3F80FF78 0001:00169C6C C:\Users\Vaj\Desktop\game_bin\CaptainHerlockServer .exe f:\dd\vctools\crt_bld\self_x86\crt\src\threadex.c line 348
0056AD11 3F80FF80 0001:00169D11 C:\Users\Vaj\Desktop\game_bin\CaptainHerlockServer .exe f:\dd\vctools\crt_bld\self_x86\crt\src\threadex.c line 326
77128654 3F80FF94 0001:00008654 C:\WINDOWS\System32\KERNEL32.DLL
776A4A77 3F80FFDC 0001:00063A77 C:\WINDOWS\SYSTEM32\ntdll.dll
776A4A47 3F80FFEC 0001:00063A47 C:\WINDOWS\SYSTEM32\ntdll.dll


------------------------------------------------------------------------------
Call Stack (Detail)
------------------------------------------------------------------------------

Address Frame Function SourceFile
748008B2 3F80EF90 0001:000FF8B2 C:\WINDOWS\System32\KERNELBASE.dll

0056A84B 3F80EFC8 0001:0016984B C:\Users\Vaj\Desktop\game_bin\CaptainHerlockServer .exe f:\dd\vctools\crt_bld\self_x86\crt\prebuild\eh\thr ow.cpp line 161

004E0217 3F80FDC8 0001:000DF217 C:\Users\Vaj\Desktop\game_bin\CaptainHerlockServer .exe d:\alienbrainwork\source code\@rappelz\server\gameserver_for_update\090721_ gameserver\game\community\guildloader.cpp line 193

[roller334]

I managed to reproduce your error, thanks to your dump text file. Just add a additional column "guild_id" (type int, allow null) to your Telecaster.dbo.Character.

[mariathao]

amazing! wish i could do that! thank you sir

[roller334]

you are welcome dude

[mariathao]

i still cant do it, says that i cant save and unless i re create table

[roller334]

You have to check the checkbox "Allow Nulls" and set the Data Type to int, it should be possible.
Look at the attachment.

[mariathao]

Originally Posted by roller334

You have to check the checkbox "Allow Nulls" and set the Data Type to int, it should be possible.
Look at the attachment.

cant add guild_id or save when i allow null