tendonsie

MaNGOS Core: Latest version of yesterday. 11748 Linux Centos 5.6 Final 32bit. Using YTDB with ScriptDev2. Server Uptime: the full day, until someone went to Eatsern Plagelands. (City under Strattholme) Coodinates: 32.18, 32.24, 32.34, 35.30 and 37.18 DC's on our public server: 12 times in oné minute. Before uptime 1 week No DC if you delete the creature template. Debug Mode Server ERROR at the end: Sending SMSG_SPELL_START id=16592 Sending SMSG_SPELL_GO id=16592 Spell 16592 Effect0 : 6 Targets: Creature (Entry: 8553 Guid: 53477), -, - Spell: Aura is: 126 Aura: construct Spellid : 16592, Aura : 126 Target : 1 Damage : -20 Spell 16592 Effect1 : 6 Targets: Creature (Entry: 8553 Guid: 53477), -, - Spell: Aura is: 79 Aura: construct Spellid : 16592, Aura : 79 Target : 1 Damage : 20 AURA MOD DAMAGE type:32 negative:0 Holder of spell 16592 now is in use WORLD: Recvd MSG_MOVE_SET_FACING (218, 0xDA) opcode STORAGE_SIZE: 37 03 92 31 00 00 00 03 00 | 00 D9 97 1D 02 58 24 39 45 E8 D4 61 C5 5B 31 1F | 43 15 24 56 40 EB 97 D9 BE 00 00 00 00 WORLD: Recvd MSG_MOVE_SET_PITCH (219, 0xDB) opcode STORAGE_SIZE: 37 03 92 31 00 00 00 03 00 | 00 D9 97 1D 02 58 24 39 45 E8 D4 61 C5 5B 31 1F | 43 15 24 56 40 30 46 47 BE 00 00 00 00 WORLD: Recvd MSG_MOVE_START_FORWARD (181, 0xB5) opcode STORAGE_SIZE: 37 03 92 31 01 00 00 03 00 | 00 D9 97 1D 02 58 24 39 45 E8 D4 61 C5 5B 31 1F | 43 15 24 56 40 30 46 47 BE 00 00 00 00 WORLD: Recvd MSG_MOVE_HEARTBEAT (238, 0xEE) opcode STORAGE_SIZE: 37 03 92 31 01 00 00 03 00 | 00 CD 99 1D 02 59 0A 37 45 68 44 62 C5 B1 6C 18 | 43 15 24 56 40 30 46 47 BE 00 00 00 00 Player Ginta relocation grid[37,25]cell[4,1]->grid[37,25]cell[3,1] WORLD: Recvd MSG_MOVE_STOP (183, 0xB7) opcode STORAGE_SIZE: 37 03 92 31 00 00 00 03 00 | 00 D3 99 1D 02 E4 03 37 45 BF 45 62 C5 E6 57 18 | 43 15 24 56 40 30 46 47 BE 00 00 00 00 WORLD: Recvd MSG_MOVE_SET_FACING (218, 0xDA) opcode STORAGE_SIZE: 37 03 92 31 00 00 00 03 00 | 00 DF 9E 1D 02 E4 03 37 45 BF 45 62 C5 E6 57 18 | 43 33 FD 8A 40 30 46 47 BE 00 00 00 00 WORLD: Recvd MSG_MOVE_START_FORWARD (181, 0xB5) opcode STORAGE_SIZE: 37 03 92 31 01 00 00 03 00 | 00 DF 9E 1D 02 E4 03 37 45 BF 45 62 C5 E6 57 18 | 43 33 FD 8A 40 9E 30 8D BE 00 00 00 00 Sending SMSG_SPELL_START id=12420 WORLD: Recvd MSG_MOVE_STOP (183, 0xB7) opcode STORAGE_SIZE: 37 03 92 31 00 00 00 03 00 | 00 7C A0 1D 02 5D 63 36 45 E0 E4 63 C5 C4 78 10 | 43 33 FD 8A 40 9E 30 8D BE 00 00 00 00 Sending SMSG_SPELL_GO id=12420 Spell 12420 Effect0 : 56 Targets: Creature (Entry: 8553 Guid: 53477), -, - Loading map ./maps/0006031.map VMapManager2: loading file './vmaps/Pirateship_Plank.wmo'. VMAP loaded name:Eastern Kingdoms, id:0, x:60, y:31 (vmap rep.: x:60, y:31) Creature 1 used AI is EventAI. Pet (Petnumber: 920953 Guid: 1) enters grid[37,25] New Pet has guid 1 HandlePetNameQuery. CMSG_PET_NAME_QUERY WORLD: Recvd MSG_MOVE_START_FORWARD (181, 0xB5) opcode STORAGE_SIZE: 37 03 92 31 01 00 00 03 00 | 00 35 A6 1D 02 5D 63 36 45 E0 E4 63 C5 C4 78 10 | 43 33 FD 8A 40 9E 30 8D BE 00 00 00 00 WORLD: Recvd MSG_MOVE_SET_FACING (218, 0xDA) opcode STORAGE_SIZE: 37 03 92 31 01 00 00 03 00 | 00 36 A6 1D 02 F9 62 36 45 E1 E5 63 C5 E3 73 10 | 43 58 B3 83 40 9E 30 8D BE 00 00 00 00 WORLD: Recvd MSG_MOVE_SET_PITCH (219, 0xDB) opcode STORAGE_SIZE: 37 03 92 31 01 00 00 03 00 | 00 36 A6 1D 02 F9 62 36 45 E1 E5 63 C5 E3 73 10 | 43 58 B3 83 40 00 98 44 BF 00 00 00 00 WORLD: Recvd MSG_MOVE_START_ASCEND (857, 0x359) opcode STORAGE_SIZE: 37 03 92 31 01 00 40 03 00 | 00 50 A6 1D 02 34 57 36 45 35 F7 63 C5 3B 30 0F | 43 58 B3 83 40 00 98 44 BF 00 00 00 00 WORLD: Recvd MSG_MOVE_HEARTBEAT (238, 0xEE) opcode STORAGE_SIZE: 37 03 92 31 01 00 40 03 00 | 00 44 A8 1D 02 DC 7B 35 45 E2 40 65 C5 E8 EF 27 | 43 DA 13 84 40 00 98 44 BF 00 00 00 00 Player Ginta relocation grid[37,25]cell[3,1]->grid[37,25]cell[3,0] WORLD: Recvd MSG_MOVE_HEARTBEAT (238, 0xEE) opcode STORAGE_SIZE: 37 03 92 31 01 00 40 03 00 | 00 38 AA 1D 02 BD A2 34 45 05 8C 66 C5 95 AF 40 | 43 88 94 84 40 6D EC 43 BF 00 00 00 00 WORLD: Recvd MSG_MOVE_STOP_ASCEND (858, 0x35A) opcode STORAGE_SIZE: 37 03 92 31 01 00 00 03 00 | 00 F6 AA 1D 02 20 52 34 45 13 0B 67 C5 24 17 4A | 43 B3 B4 84 40 6D EC 43 BF 00 00 00 00 WORLD: Recvd MSG_MOVE_STOP (183, 0xB7) opcode STORAGE_SIZE: 37 03 92 31 00 00 00 03 00 | 00 5B AC 1D 02 C6 B5 33 45 58 FD 67 C5 2C C7 38 | 43 06 34 84 40 6D EC 43 BF 00 00 00 00 WORLD: Recvd MSG_MOVE_SET_FACING (218, 0xDA) opcode STORAGE_SIZE: 37 03 92 31 00 00 00 03 00 | 00 F1 B0 1D 02 C6 B5 33 45 58 FD 67 C5 2C C7 38 | 43 D4 DE A3 40 6D EC 43 BF 00 00 00 00 WORLD: Recvd MSG_MOVE_SET_PITCH (219, 0xDB) opcode STORAGE_SIZE: 37 03 92 31 00 00 00 03 00 | 00 F1 B0 1D 02 C6 B5 33 45 58 FD 67 C5 2C C7 38 | 43 D4 DE A3 40 EC C0 23 BF 00 00 00 00 WORLD: Recvd MSG_MOVE_START_FORWARD (181, 0xB5) opcode STORAGE_SIZE: 37 03 92 31 01 00 00 03 00 | 00 F1 B0 1D 02 C6 B5 33 45 58 FD 67 C5 2C C7 38 | 43 D4 DE A3 40 EC C0 23 BF 00 00 00 00 WORLD: Recvd MSG_MOVE_SET_PITCH (219, 0xDB) opcode STORAGE_SIZE: 37 03 92 31 01 00 00 03 00 | 00 44 B2 1D 02 58 32 34 45 3F 16 69 C5 53 DC 2A | 43 65 82 A6 40 22 E7 00 BF 00 00 00 00 WORLD: Recvd MSG_MOVE_SET_PITCH (219, 0xDB) opcode STORAGE_SIZE: 37 03 92 31 01 00 00 03 00 | 00 AC B2 1D 02 54 64 34 45 03 72 69 C5 C2 A7 27 | 43 EC A3 A7 40 00 2B C8 BE 00 00 00 00 Player Ginta relocation grid[37,25]cell[3,0]->grid[37,24]cell[3,7] CMSG_TIME_SYNC_RESP Time sync received: counter 6, client ticks 35500753, time since last sync 10056 Our ticks: 35500803, diff 50, latency 26 WORLD: Recvd MSG_MOVE_SET_FACING (218, 0xDA) opcode STORAGE_SIZE: 37 03 92 31 01 00 00 03 00 | 00 F1 B2 1D 02 B0 89 34 45 6C AF 69 C5 BD E2 25 | 43 6A EC AD 40 1B BE B6 BE 00 00 00 00 WORLD: Recvd MSG_MOVE_START_ASCEND (857, 0x359) opcode STORAGE_SIZE: 37 03 92 31 01 00 40 03 00 | 00 F1 B2 1D 02 B0 89 34 45 6C AF 69 C5 BD E2 25 | 43 6A EC AD 40 C6 4B A1 BE 00 00 00 00 WORLD: Recvd MSG_MOVE_SET_FACING (218, 0xDA) opcode STORAGE_SIZE: 37 03 92 31 01 00 40 03 00 | 00 14 B3 1D 02 05 9C 34 45 36 C4 69 C5 3C 9E 27 | 43 AE D1 B1 40 C6 4B A1 BE 00 00 00 00 WORLD: Recvd MSG_MOVE_SET_FACING (218, 0xDA) opcode STORAGE_SIZE: 37 03 92 31 01 00 40 03 00 | 00 5D B3 1D 02 86 C8 34 45 0E E9 69 C5 3E 3B 2B | 43 9B 76 B5 40 9C 92 96 BE 00 00 00 00 WORLD: Recvd MSG_MOVE_SET_FACING (218, 0xDA) opcode STORAGE_SIZE: 37 03 92 31 01 00 40 03 00 | 00 C7 B3 1D 02 C6 0E 35 45 F5 16 6A C5 67 7A 30 | 43 C2 7E BB 40 C7 4B A1 BE 00 00 00 00 WORLD: Recvd MSG_MOVE_SET_FACING (218, 0xDA) opcode STORAGE_SIZE: 37 03 92 31 01 00 40 03 00 | 00 EA B3 1D 02 0A 28 35 45 5C 22 6A C5 E6 35 32 | 43 DB 43 BF 40 61 0A B0 BE 00 00 00 00 mangosd: /root/core32/mangos/src/game/MotionMaster.cpp:118: void MotionMaster::DirectClean(bool, bool): Assertion `"!empty()" && 0' failed. /root/core32/mangos/src/game/MotionMaster.cpp:118: Error: Assertion in DirectClean failed: !empty()./r2: line 22: 22695 Aborted ./$mangosd Mangos-worldd crashed, restarting in 10 seconds.. file Motion Master Git: https://github.com/mangos/mangos/blob/master/src/game/MotionMaster.cpp

Your maps and vmaps are not in the correct folder or it aren't 3.3.5a maps and vmaps.

Problem FIXED! Solution: Mysql Version 5.0.x with yum update = doesn't work. (Centos 5.6 32bit) Mysql Version 5.0.x with directadmin script = does work, and is a little bit older then the 4.0.x of Centos Yum. No errors and no crashes. 4.x also doesn't work. Thanks for the help of VladirMaNGOS and Patman128!

Alsof if I logout I get this: Remove player Tendonsie from grid[62,62] Player: channels cleaned up! SESSION: Sent SMSG_LOGOUT_COMPLETE Message SQL: START TRANSACTION SQL ERROR: mysql_stmt_bind_param() failed SQL ERROR: Using unsupported buffer type: -1670337708 (parameter: 5) SQL: cannot execute 'INSERT INTO characters (guid,account,name,race,class,gender,level,xp,money,playerBytes,playerBytes2,playerFlags,map, dungeon_difficulty, position_x, position_y, position_z, orientation, taximask, online, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, trans_x, trans_y, trans_z, trans_o, transguid, extra_flags, stable_slots, at_login, zone, death_expire_time, taxi_path, arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, todayKills, yesterdayKills, chosenTitle, knownCurrencies, watchedFaction, drunk, health, power1, power2, power3, power4, power5, power6, power7, specCount, activeSpec, exploredZones, equipmentCache, ammoId, knownTitles, actionBars) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ' SQL ERROR: No data supplied for parameters in prepared statement SQL: ROLLBACK WORLD: Received CMSG_UPDATE_ACCOUNT_DATA UAD: type 1, time 1311092589, decompressedSize 453 SQL: START TRANSACTION SQL ERROR: mysql_stmt_bind_param() failed SQL ERROR: Using unsupported buffer type: -437918235 (parameter: 4) SQL: cannot execute 'INSERT INTO character_account_data VALUES (?,?,?,?)' SQL ERROR: No data supplied for parameters in prepared statement SQL: ROLLBACK WORLD: CMSG_READY_FOR_ACCOUNT_DATA_TIMES CMSG_REALM_SPLIT [0 ms] SQL: SELECT characters.guid, characters.name, characters.race, characters.class, characters.gender, characters.playerBytes, characters.playerBytes2, characters.level, characters.zone, characters.map, characters.position_x, characters.position_y, characters.position_z, guild_member.guildid, characters.playerFlags, characters.at_login, character_pet.entry, character_pet.modelid, character_pet.level, characters.equipmentCache FROM characters LEFT JOIN character_pet ON characters.guid=character_pet.owner AND character_pet.slot='0' LEFT JOIN guild_member ON characters.guid = guild_member.guid WHERE characters.account = '32' ORDER BY characters.guid If I run the server in this "debug" mode for players, it that good? Because in debug mode he doesn't crash. If we don't find any solution.

Updated mysql and tryed new build/compile. mysql-devel-5.0.77-4.el5_6.6.i386.rpm mysql-5.0.77.4-el5_6.6.i386.rpm mysql-server-5.0.77-4.el5_6_6.i386.rpm Problem not fixed. Same error in the debug mode.

Okay thinks. I will try!

I'm using Centos 5.6 32bit with all newest updates. MaNGOS Core: [11739] Tryed with, and without ScriptDev2. Normal Mode: If you log in as administrator: crash of server with "segmentation fault" After that compiled the server in debug mode. Mysql account have all rights, mysql version 5.0.77 How do I solve this? Thanks. The following information I have in debug mode: 2011-07-15 18:11:09 SERVER STARTUP TIME: 0 minutes 28 seconds 2011-07-15 18:11:09 Starting up anti-freeze thread (50 seconds max stuck time)... 2011-07-15 18:11:09 2011-07-15 18:14:08 ERROR:SQL ERROR: mysql_stmt_bind_param() failed 2011-07-15 18:14:08 ERROR:SQL ERROR: Using unsupported buffer type: -437918235 (parameter: 4) 2011-07-15 18:14:08 ERROR:SQL: cannot execute 'INSERT INTO account_data VALUES (?,?,?,?)' 2011-07-15 18:14:08 ERROR:SQL ERROR: No data supplied for parameters in prepared statement 2011-07-15 18:14:08 ERROR:SQL ERROR: mysql_stmt_bind_param() failed 2011-07-15 18:14:08 ERROR:SQL ERROR: Using unsupported buffer type: -437918235 (parameter: 4) 2011-07-15 18:14:08 ERROR:SQL: cannot execute 'INSERT INTO account_data VALUES (?,?,?,?)' 2011-07-15 18:14:08 ERROR:SQL ERROR: No data supplied for parameters in prepared statement 2011-07-15 18:14:08 ERROR:SQL ERROR: mysql_stmt_bind_param() failed 2011-07-15 18:14:08 ERROR:SQL ERROR: Using unsupported buffer type: -437918235 (parameter: 4) 2011-07-15 18:14:08 ERROR:SQL: cannot execute 'INSERT INTO account_data VALUES (?,?,?,?)' 2011-07-15 18:14:08 ERROR:SQL ERROR: No data supplied for parameters in prepared statement 2011-07-15 18:14:20 ERROR:SQL ERROR: mysql_stmt_bind_param() failed 2011-07-15 18:14:20 ERROR:SQL ERROR: Using unsupported buffer type: -437918235 (parameter: 3) 2011-07-15 18:14:20 ERROR:SQL: cannot execute 'UPDATE item_instance SET data = ?, owner_guid = ? WHERE guid = ?' 2011-07-15 18:14:20 ERROR:SQL ERROR: No data supplied for parameters in prepared statement 2011-07-15 18:14:21 ERROR:SQL ERROR: mysql_stmt_bind_param() failed 2011-07-15 18:14:21 ERROR:SQL ERROR: Using unsupported buffer type: -437918235 (parameter: 4) 2011-07-15 18:14:21 ERROR:SQL: cannot execute 'INSERT INTO character_account_data VALUES (?,?,?,?)' 2011-07-15 18:14:21 ERROR:SQL ERROR: No data supplied for parameters in prepared statement 2011-07-15 18:14:21 ERROR:SESSION: received not allowed opcode CMSG_LFG_GET_STATUS (0x0296) 2011-07-15 18:15:01 GameEvent 43 "Hammerfall Under Attack" started. 2011-07-15 18:15:55 ERROR:SQL ERROR: mysql_stmt_bind_param() failed 2011-07-15 18:15:55 ERROR:SQL ERROR: Using unsupported buffer type: -1657095852 (parameter: 5) 2011-07-15 18:15:55 ERROR:SQL: cannot execute 'INSERT INTO characters (guid,account,name,race,class,gender,level,xp,money,playerBytes,playerBytes2,playerFlags,map, dungeon_difficulty, position_x, position_y, position_z, orientation, taximask, online, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, trans_x, trans_y, trans_z, trans_o, transguid, extra_flags, stable_slots, at_login, zone, death_expire_time, taxi_path, arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, todayKills, yesterdayKills, chosenTitle, knownCurrencies, watchedFaction, drunk, health, power1, power2, power3, power4, power5, power6, power7, specCount, activeSpec, exploredZones, equipmentCache, ammoId, knownTitles, actionBars) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ' 2011-07-15 18:15:55 ERROR:SQL ERROR: No data supplied for parameters in prepared statement 2011-07-15 18:15:56 ERROR:SQL ERROR: mysql_stmt_bind_param() failed 2011-07-15 18:15:56 ERROR:SQL ERROR: Using unsupported buffer type: -437918235 (parameter: 4) 2011-07-15 18:15:56 ERROR:SQL: cannot execute 'INSERT INTO character_account_data VALUES (?,?,?,?)' 2011-07-15 18:15:56 ERROR:SQL ERROR: No data supplied for parameters in prepared statement If we search on the error type: http://dev.mysql.com/doc/refman/5.0/en/mysql-stmt-bind-param.html Error: 2036 (CR_UNSUPPORTED_PARAM_TYPE) Message: Using unsupported buffer type: %d (parameter: %d)

Possible to update the git patch file? Thanks Or it there a new project to do it?

There are many guides that are out of date. One is de person that make it banned. Another its of 2010 with "make" but now its "cmake". On the wiki you have 1 guide for linux with cmake: http://getmangos.eu/wiki/Compile_MaNGOS_On_Linux So first I have tryed with Centos 5.6 64bit. Full updated. First problem. Cmake 2.8 you don't have. So manuel cmake 2.8 installed with help of search google. After that you get this error: CMake Error at CMakeLists.txt:162 (message): This project requires ACE installed when ACE_USE_EXTERNAL is set. Please download the ACE Micro Release Kit from http://download.dre.vanderbilt.edu/ and install it. If this script didn't find ACE and it was correctly installed please set ACE_ROOT to the correct path. So then I go to install that. Trying again and again but don't work. don't understand the "installed please set ACE_ROOT to the correct path" ? So don't find that solution. Then tryed on Debian with the Debian guide. Again cmake 2.6 default, zo installed cmake 2.8, afther that again the ACE problem? In the past all software for mangos was easy to install. Now everywere you use version that are nog default with yum of apt-get to find. And the guides for install that software manuel are not to find on this forum. Is there a possility that someone make a A tot Z guide for the current mangos version. And that the old guides become deleted from the forum or updated? Thanks

Its not the database. Have the clean default chars-realmd-mangos used to test. So no UDB/YTDB or ... used.

I'm moving my Centos 32bit server to a new Centos 64bit server. Because of that, I'm trying to get my Centos 64bit (5.6 final) server working. What does I have: A clean centos 64bit working, with all yum install and yum update that the guides say. Alsof I have transfered my working MaNGOS source map to the new server. Then I compile mangos. -> Works After that I started Realmd -> Works Afther that I started Worldd -> Everything works, but the last second of starting up I get: Segmentation fault Before I see this result I have thing seeing: Game Event .... started Game Event system Initliazed Player::DeleteOldChars: ........ .... .... SQL: Select guid, deleteInfos_Account from characters. 6 times such a SQL. Segmentation fault What I don't have see is Worldd Initialized How can I fix this. Search on forum with search option and found one topic, that see update system and compile again. Done that, don't work. I also doesn't have any error during A to Z. Only this two words. Thanks.

I got an answer that I couldn't find on the wiki or on the search. How can I disable spells? I see a table called, spell_disabled, but if I add spells to idd and configure the table and restart the server, it doesn't have any effect. Also the information of this table, isn't on the wiki. Is there any idea how to disable a spell? I have also searched in the character_spell table, but it seems that nobody has the spell, so disable at the point isn't possible. Thanks.

Possible to update to 01/2011 ?

Possible to update it ot newest core of MaNGOS? Al the gits in this posts are november or older... my patch file is outdated.

Thanks