tendonsie

July 21, 2011

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

July 21, 2011

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

July 19, 2011

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!

July 19, 2011

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.

July 16, 2011

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.

July 16, 2011

Okay thinks. I will try!

July 15, 2011

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)

July 14, 2011

Possible to update the git patch file? Thanks

Or it there a new project to do it?

July 2, 2011

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

June 30, 2011

Its not the database. Have the clean default chars-realmd-mangos used to test.

So no UDB/YTDB or ... used.

June 29, 2011

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.

May 25, 2011

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.

January 13, 2011

Possible to update to 01/2011 ?

January 6, 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.

November 3, 2010

Thanks

November 2, 2010

I use more than one year mangos and compile works great.

I use Centos 5.4.

Now today, I want to update my MaNGOS and I compile I have next problem:

configure.ac:39: error: Autoconf version 2.61 or higher is requierd.
configure.ac:39: the top level
and then erorr error error and it stops.

Now I have autoconf 2.59 on my Centos 5.4.

I upgrade it:

yum update autoconf

Feedback: no packages marked for update. Nothing to update.

So i decedid to upgrade to Centos 5.5.

Now I got Centos 5.5 (Final)

Again try to compile MaNGOS, again it don't work.

With yum update the same like before.

Any idea what to do? Centos don't see i higher autoconf version then I have now, but for mangos I need higher one.

Thanks.

September 13, 2010

Possible fix for those who have troubles with browsing items, characters, etc. and have SQL-related errors in debug log (unable to connect or unable to select data from original MaNGOS/TrinityCore tables such as `item_template` or `characters` (and table structure in query is fine)) - change max_connections variable in MySQL config to more higher than current (default - 100).
Why you need this? I'll explain: currently, each class is inheriting from the "Armory" class (class.armory.php) and with new instance of any class script reconnects to the database which leads to these errors when the maximum allowable number of connections reaches the maximum. This is temporary hack. Until I fix this (only on next weekends or when I'll have free time (maybe earlier, maybe later)) you need to reconfigure your MySQL server.

My apologize for the inconvenience.

Thanks! Increasing mysql connections works!

September 11, 2010

Same problem like me I think.

September 10, 2010

** = Deleted in this post.

User and pass = 4x the same.

Database name is correct given in config.

User for database = have all access.

Do you have any idea what is wrong ?

**info deleted** **problem fixed**

September 9, 2010

Nope, can't be the problem.

User have all right thats are possible.

I can log in to armory and see the name list of chars, but can"t look at a specific char.

Search don't work: items, characters...

Arena teams: works.

Achievement Firsts: works!

Mysql user have all right, checked config all name of databases are correct and mysql user have all right of every database that is needed.

ERROR [09-09-2010 18:58:28]: Characters::BuildCharacter : unable to connect to MySQL server (error: none; realmId: 1). Check your configs.
DEBUG [09-09-2010 18:58:28]: ArmoryDatabaseHandler::_query : unable to execute SQL query (SELECT `id`, `version` FROM `armory_realm_data` WHERE `name`='loginpanel'). MySQL error: none

DEBUG [09-09-2010 18:58:28]: ArmoryDatabaseHandler::_query : unable to execute SQL query (SELECT 1 FROM `characters` WHERE `guid`=0 LIMIT 1). MySQL error: none

ERROR [09-09-2010 18:58:28]: Achievements::InitAchievements : player with guid 0 was not found in `characters` table!

DEBUG [09-09-2010 18:58:28]: Utils::GetBookmarks : bookmarks for account 32 not found

September 8, 2010

Log if I search "Wool Cloth" in database:

DEBUG [08-09-2010 22:14:27]: ArmoryDatabaseHandler::_query : unable to execute SQL query (SELECT `guid`, `level`, `account` FROM `characters` WHERE `name`='Wool cloth' AND `level` >= 10 LIMIT 200). MySQL error: none

DEBUG [08-09-2010 22:14:27]: ArmoryDatabaseHandler::_query : unable to execute SQL query (SELECT COUNT(`guildid`) FROM `guild` WHERE `name` LIKE '%Wool cloth%' LIMIT 200). MySQL error: none

DEBUG [08-09-2010 22:14:27]: ArmoryDatabaseHandler::_query : unable to execute SQL query (SELECT COUNT(`arenateamid`) FROM `arena_team` WHERE `name` LIKE '%Wool cloth%' LIMIT 200). MySQL error: none

DEBUG [08-09-2010 22:14:27]: ArmoryDatabaseHandler::_query : unable to execute SQL query (SELECT COUNT(`entry`) FROM `item_template` WHERE `name` LIKE '%Wool cloth%'). MySQL error: none

Log if I search a character:

ArmoryDatabaseHandler::_query : unable to execute SQL query (SELECT `guid`, `level`, `account` FROM `characters` WHERE `name`='Tendonsie' AND `level` >= 10 LIMIT 200). MySQL error: none

DEBUG [08-09-2010 22:15:52]: ArmoryDatabaseHandler::_query : unable to execute SQL query (SELECT COUNT(`guildid`) FROM `guild` WHERE `name` LIKE '%Tendonsie%' LIMIT 200). MySQL error: none

DEBUG [08-09-2010 22:15:52]: ArmoryDatabaseHandler::_query : unable to execute SQL query (SELECT COUNT(`arenateamid`) FROM `arena_team` WHERE `name` LIKE '%Tendonsie%' LIMIT 200). MySQL error: none

DEBUG [08-09-2010 22:15:52]: ArmoryDatabaseHandler::_query : unable to execute SQL query (SELECT COUNT(`entry`) FROM `item_template` WHERE `name` LIKE '%Tendonsie%'). MySQL error: none

What works:

Login to armory

See your characters in armory list. But! Not to see the details.

Can't search anything ??? <--

Arena teams works. <-

I have redone the armory db again and again all SQL and same problem.

I have the req for armory and .htaccess I have done.

Any idea what the problem is ?

Done this again today with mangos of today and armory git of today and applied the patch of armory in mangos core.

September 6, 2010

Same problem like me ivchoto. Items en char search don't work.

Debug mode, no logs of errors. In character database I see information in the new table.

September 6, 2010

Nope. Used the .htaccess file that was in a winrar file in the armory root.

September 5, 2010

Hey, I have read many times the installation file and the post on mangos forum but I can't find my problem.

*/armory/character-sheet.xml?r=Armory+Realm&cn=Phoenix

*/armory/search.xml?source=all&type=armor&subTp=cloth&searchType=items

Everything with search don't work, en you can't see a profile of a char of search it.

If you login I can see me charlist, but I can't go to a specific char.

Any idea ? I used the version of last week with MaNGOS and database is okay, he see my chars etc and all SQL done in SQL map for armory.

Thanks

August 24, 2010

Problem fixed.

Sign In

Profiles

Bug Tracker

Wiki

Release Notes

Forums

Downloads

Blogs

Events

Posts posted by tendonsie

Contact Us

Repositories

Important Information