[Mangos] 2.0.12-2.1.0 Silvermoon Database rev 5 Newest

Quote:

---

Originally Posted by baronkohinar

I don't believe I've seen anyone address it yet, but I seem to be having the same trouble as WildCard: Everything's working fine but, once I get a hunter to level 10, I'm having trouble taming beasts to use as pets. I made it through the mission that had you tame three creatures to test it out but not even that worked properly; I could tame the monster but it wouldn't do anything and, in fact, the only way I could 'release' the pet was to log out and in again, then it would be gone.

Once through the mission, I gained the supposed ability to tame monsters but, although the taming bar makes it all the way down on a given monster, when it reaches the bottom nothing happens. I've tried with several different monsters to the same end. In fact, I tried it on the same types of monsters the tutorial mission had me train with the same result (and obviously you're supposed to be able to tame them)...

Has anyone else run into this besides WildCard and I? More specifically, does anyone have any ideas on what to do to fix the issue? I'm running the server myself so I can make any necissary changes BTW.

Thanks in advance.

---

Ya I am still having the issue even downloading a petpatch that was available. It really didnt do anything. I know it works because other people seem to be using pets with no problem. If someone out there know of a fix please let me know. Also if you make a druid dont press the C key to look at your class window becasue it crashes the client. Not sure why it does this but it only does it on a druid. Also on shamans and some other classes you talents trees get reset and you haveto put it all back everytime you login. Well at least that is my issue for now. If anyone else is having these issues and know of a fix please let me know.

Thank you

dam cant get it to work... :sq_yellow

Unable to validate game version...

Quote:

---

Originally Posted by Stansoj

dam cant get it to work... :sq_yellow

Unable to validate game version...

---

There's a bloody guide I made just 2 posts above yours READ BEFORE SPAM!

so can you get a link to the source and a tut to compile? or can you post an updated binary for us :)
and for 2.1.1? rev #6739

Quote:

---

Originally Posted by Wildcard999

Ya I am still having the issue even downloading a petpatch that was available. It really didnt do anything. I know it works because other people seem to be using pets with no problem. If someone out there know of a fix please let me know. Also if you make a druid dont press the C key to look at your class window becasue it crashes the client. Not sure why it does this but it only does it on a druid. Also on shamans and some other classes you talents trees get reset and you haveto put it all back everytime you login. Well at least that is my issue for now. If anyone else is having these issues and know of a fix please let me know.

Thank you

---

Actually, I seem to have figured it out; I turned off GM privlages on my user account (the one with my hunter character) and it works (almost) fine. It seems to ocasionally generate an error when you're in the character screen for the pet but they've all be non-fatal so far (and only crop up if that screen's open). But, more importantly, you can tame them and name them and fight with them. Hope this helps.

So I am getting this stupid stupid error that has had me thrown off for a couple hours now. I have tried importing from sql dumps on 3 different mangos database versions. I always get this error:

Error occured at:2007-06-06 00:38:50
Line no.:58
Error Code: 1005 - Can't create table '.\mangos\arena_team.frm' (errno: 121)

and it crashes the import. This happens every single time I try to import and on every single download I get of revisions 4, 5, and 6 of the databases. Can someone please help me? Thanks!

Trance4ME, empty database, close program, open it again and Import fresh.

Deathtonoobs (or any other people)

http://i210.photobucket.com/albums/b...ngeversion.jpg

You go to...

C:\sources\mangos\win (assuming you correctly followed the tutorial and the sources\mangos folder is where you download the new files
Open up whatever version you will be using (2005 uses VC80, 2003 uses VC70)
This is basic compiling so if you don't understand, just get a binary
On your left you open shared, then common.h and then you change the row saying

#define EXPECTED_MANGOS_CLIENT_BUILD {6546, 0}

to

#define EXPECTED_MANGOS_CLIENT_BUILD {6080, 6299, 6546, 6692, 6729, 6739, 0}
That will allow every version from 2.0.0 to 2.1.1 to connect (probably LOADS of errors too)
After that you just add what build you want (Found in WoW next to your version number in the bottom left corner of the login screen) in order, and before the 0


THE TUTORIAL OF HOW TO COMPILE AND THE MANGOS SOURCE ARE IN THE SAME PLACE



here's a binary I made (you still need Maps, and Vmaps)

BINARY
Here's THIS (the post) database I converted for use with THIS binary
DATABSE

NOTE: to be able to import the database:

go to where you installed MySQL (for example C:\Program Files\MySQL\MySQL Server 5.0)
Open my.ini
Look for a line saying
max_allowed_packet =

If you find none, just add
max_allowed_packet = 150M
below [mysqld]

Quote:

---

Originally Posted by baronkohinar

Actually, I seem to have figured it out; I turned off GM privlages on my user account (the one with my hunter character) and it works (almost) fine. It seems to ocasionally generate an error when you're in the character screen for the pet but they've all be non-fatal so far (and only crop up if that screen's open). But, more importantly, you can tame them and name them and fight with them. Hope this helps.

---

Thank you I will have to give this a shot and see if it works.

right, i've put in DBC's, maps etc, populated the databases with the mangos and realmd spl files, ran the configuration thing, that was fine, when i sart mangos gui it just crashes instantly.
ran mangosd through cmd prompt and it says it cant find the cnofig file dispit the fact it's right there.
:(

any help is really appreciated thanks.

Wildcard and baronkohinar, just a suggestion, check your server.log file after trying to add a pet. I had similar issues taming pets (with the taming bar going down all the way and nothing happening) and after looking in the server log I saw sql errors trying to insert into one of the pet tables. The insert statement that mangos was trying to use was apparently tested with a different version of the database than I had and so the column count in the table was different. A simple sql statement to alter the table and add the missing columns fixed that problem. I was able to tame animals just fine after that.

One thing that people should start getting used to is the fact that even if the mangos server and db are "supposed" to be compatible that doesn't necessarily mean the table structure of the database you're using and what mangos is trying to use is the same. So always check those log files when something odd is going on. It can be mighty useful and that's pretty much what they're there for anyway.

Good luck to you guys.

SQL: DELETE FROM `ip_banned` WHERE `unbandate`<=UNIX_TIMESTAMP() AND `unbandate`
<>`bandate`
SQL ERROR: Unknown column 'unbandate' in 'where clause'
SQL: SELECT `bandate`,`unbandate` FROM `account_banned` WHERE `id` = 1 AND `acti
ve` = 1 AND (`bandate`=`unbandate` OR `unbandate`>UNIX_TIMESTAMP())
query ERROR: Table 'realmd.account_banned' doesn't exist
how i fix this?

Quote:

---

Originally Posted by atezeroate

yeah i got the same problem, when i hit c to see my stats, BAM, crashes...

ANYONE know why?

---

Found out that error is cause by haveing a charactor over level 70 for some reason it just dont calculate the stats correctly. Just dont open your charactor page while you have your level 255 and youll be fine.

alright got everything sorted, got mangos up, ran about had some fun but only i can connect?

how do i make it public so other people can join? My friend reported his game stuck at 'logging into game server' after selecting the realm.

my realmlist in realmd db has the address set to 192.168.0.4 and my realm list is set to my WAN ip address.

any idea?

Any help is really appreciated.

I checked the DBErrors.log and i found the following errors. If someone can help I'll apreciate it.

2007-06-07 08:09:34 Some items can't be succesfully looted: not exist or have in chance field value < 0.000001 with quest chance ==0 in `creature_loot_template` DB table . List:
loot entry = 18805 item = 29981 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29977 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29951 mincount = 1 maxcount = 1 (not exist)
loot entry = 18728 item = 0 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 30446 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29950 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 30449 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29976 mincount = 1 maxcount = 1 (not exist)

Thank u

mapeto: you can just ignore that error... on other hand you can remove it if you REALLY want, but this is nothing to be worried about, I think it's the items that are missing in the item_template table

Eroa: Go HERE

Deathtonoobs: you need a working database for your version, easiest if you figure out how to import mine, but if you don't want to do that,

you can EASILY fix it by getting the source and finding the mangos sql to import, and import table by table that you need...

you can fix it with more difficulty by observing the errors and directly editing your database (if you don't get it from what you posted, you can't really do this)

There's no other way to fix it.