Database error mangos three

[Nagilum]

Hello there,

I guess i'm a big c++ Noob, know abit about sql but that's it.

Recently started the Mangos three server and installed it step by step, as clearly told in the installation guide.

Server is running oke, but on starting up there a lot of errors, so i wonder what i did wrong.

The main errors seems to be from scripts, and it looks like i still have a Wotlk database structure instead of a Cataclysm one.

Here a little summery:

Table creature_movement for id 57947, point 1 have script_id 1954602 that does not exist in `dbscripts_on_creature_movement`, ignoring

and this goes on till,

Table creature_movement_template for entry 23682, point 15 have script_id 2368215 that does not exist in `dbscripts_on_creature_movement`, ignoring

also:

Table gossip_menu_option for menu 21, id 1 have action_script_id 21 that does not exist in `dbscripts_on_gossip`, ignoring

and this goes on till,

Table gossip_menu_option for menu 50413, id 0 have action_script_id 2208 that does not exist in `dbscripts_on_gossip`, ignoring

Also:

Table `db_script_string` has unused string id 2000000000

and this goes on till,

Table `db_script_string` has unused string id 2000009995

And:

BattleGroundEvent: gameobject with guid 150383 is registered, for a nonexistent event: map:30, event1:0, event2:0

till,

BattleGroundEvent: creature with guid 150143 is registered, for a nonexistent event: map:30, event1:62, event2:0

I know this is work in progress, but wonder if there is something wrong in my database

Any help would be great,

Nagilum

[Corsol]

Hi, i can tell you that is not only your database...

i think that in last db configuration some things were not figured out as they are.

For major part of this error i think that a simple "look and fix" approach can solve the situation...

[Nagilum]

Hi, i can tell you that is not only your database...

i think that in last db configuration some things were not figured out as they are.

For major part of this error i think that a simple "look and fix" approach can solve the situation...

Yeah, you're right about that ;-)

I have added some additional tables in the mangos database, mostly for the scripting part of it.

Now i am debugging live in the game, finding a lot of errors a.i floating gameobjects, double or tripple npc's and mobs with wrong stats.

I don't mind, it takes a lot of time, but i'm trying to learn as much as possible so this is a great way to do that.

Only regret so far is that i cannot figure out how to dismount vehicle's, i think it is a mangos core thing because of the errors i see when mounting a vehicle and push de "leave vehicle" button.

The same goes for the "special quests" like the fire exthinger in human start area.

But for now i'm happy, mangos core is much more stable and working better then the trinity core i tried.

Nagilum

[Corsol]

Wow!

You are doing a huge work!!!

i'm also trying to fix worgen start area, and also here i've founded lots of quest broken, npc not scripted, etc etc...

i've made a theread about my current problem with quest progression... can you look and see if you have an idea to solve it?

Thread is here

[bels]

This was discussed over in this https://www.getmangos.eu/database/10108-server-fine-db-errors.html#post73440 thread. The following sql should clear up a bunch of the errors but not all. I haven't gotten around to fixing them all yet. If anyone has any patches that resolve any of the startup errors please make a pull request and I will happily merge them in. But yes the errors came from the last YTDB import.

update creature as c JOIN creature_template as ct on c.id = ct.entry set c.curhealth = ct.minhealth where c.curhealth < ct.minhealth;

I was waiting for some people to test this patch out to see if their errors about the curhealth being to low went away as well. If someone lets me know if this works for them, I'll get it in the main repo.

Thanks and happy holidays.

[bels]

Yeah, you're right about that ;-)

I have added some additional tables in the mangos database, mostly for the scripting part of it.

Now i am debugging live in the game, finding a lot of errors a.i floating gameobjects, double or tripple npc's and mobs with wrong stats.

I don't mind, it takes a lot of time, but i'm trying to learn as much as possible so this is a great way to do that.

Only regret so far is that i cannot figure out how to dismount vehicle's, i think it is a mangos core thing because of the errors i see when mounting a vehicle and push de "leave vehicle" button.

The same goes for the "special quests" like the fire exthinger in human start area.

But for now i'm happy, mangos core is much more stable and working better then the trinity core i tried.

Nagilum

Thank you for your work. I am also doing some clean up right now with the database because it really is a Frankenstein that has been brought along. Please submit pull requests so everyone can benefit and so we aren't duplicating each others work. The main problem with Three in my opinion is the database and if that gets cleaned up and fixed Three will be quite playable.

And yes, I think the dismount issue is a mangos core thing but I haven't had time to look into it.

[Nagilum]

Thank you for your work. I am also doing some clean up right now with the database because it really is a Frankenstein that has been brought along. Please submit pull requests so everyone can benefit and so we aren't duplicating each others work. The main problem with Three in my opinion is the database and if that gets cleaned up and fixed Three will be quite playable.

And yes, I think the dismount issue is a mangos core thing but I haven't had time to look into it.

I Agree, the database is pretty mixed up, if you could find a solution for the vehicle mount issusue and the "bunny credits" it would be great.

Otherwise it's stil good playing.

Because i'm not so hightech, i can't make any update sql scripts/ don't know how to myself.

Please let me explain,

A number of my friends and myself are playing wow from the first moment it came to europe (hence my bad english) ;-)

we played online through zero,tbc,Wotlk and Cataclysm and then most of us just had enough of it.

Gameplay became more and more boring (fighting pets?), massive attack from other players with there bots, and the never ending invites to party's guilds and so on.

2 years ago i came across the mangos server, fiddled a bit with it, and asked my friends if they wanted to play on my private server.

Some did, so now i have a steady group of people that is playing on my server, server two.

We all are "old dudes and duddets", around 35 to 55 so we like things to get a bit slower ;-)

But we all love rpg playing and wow is great playing for that, so i've learned a lot from sql db on server two.

Making char, quest and events and we are still enjoying.

But recently i found there was a server Three, so asked some friends...and here we go again.

2 of my friends are physical disabled, and play about 8 hours a day, and now are sending me everything not working, odd or missing by mail. (this means about 25 e-mails a day).

So the're now testing the allied side, and play without any tools.

When i have time to adress these errors, i go from human to dwarf to nightelf and so on, so i'm debugging everwhere.

Today finished the starting erea of the worgen, and already recieved e-mail about a bug in Duskhaven.

Darkshore is debugged ,now working in Ashenvale/ elwynn forest is debugged working in westfall/ Worgen start debugged/ working in duskhaven.

To make a long story short,

I know a lot of working in the mangos sql database, but don't know how to alter, edit the mangos core i just don't.

For now i just work around the quests with vehicle, and bunny credits hoping some hightech guy or girl finds a way to get these working.

Uploading my updated mangos sql database won't be any help, because it still will be full of errors.

So much to do.... we love it...

Nagilum

[bels]

When you say "Darkshore is debugged" what do you mean by that?

[Nagilum]

When you say "Darkshore is debugged" what do you mean by that?

What i mean with that, is that all npc's, all quest quest, all game objects are checked on:

working quest, right amount of npc/mobs right places right stats of the mobs

and as mentioned earlier, some quest that require a vehicle or bunny credit drops are modified

and all weird things like the large amount of flying gameobjects (herbs and veins) are adjusted too.

So maybe "debugged" is the wrong word for it, for me and my friends it means that it's a playable area.

Nagilum

[Corsol]

[...]

Today finished the starting erea of the worgen, and already recieved e-mail about a bug in Duskhaven.

[...]

Nagilum

I'm working on worgen area too... can you shere your script? i would like to learn about scripting!

I've made a Pull Request to fix first quest chain (still not completed) of worgen area.

Why you don't wont to make a PR?

Thanks

[Nagilum]

Dear Corsul, here comes the NOOB part of me..lol

What is a pull request?, and on the topic maybe you can help me out?

i use a dedicated sql server and use sqlyog as an editor, i can import sql scripts on my databases but not on a table in that database.

so for example, to make the second quest for worgen area working i had to change some lines in the quest and characters table.

But i have no clue how to make a script of this change, so how do you do that?

if i want to import an sql file on a table, i get a message that states i have to buy the pro version of sqlyog, but even then, i don't want to dump the hole table just the changes.

So how do you do that ?

Nagilum (feeling very dumb)

[Corsol]

Don't warry, i'm noob too and i'm learnig everything.

Pull request is an action that you can do when basically: fork the official repo to your own user (on GitHub), clone it locally (Making sure you select the correct branch), Then make your changes to it.

Commit and push you changes to your repos on gitHub, then from the page on your Repo in gitHub, select 'New Pull Request' and submit that!

I don't know how much customizations far away from Mangos develop style you had done on your local copy so i don't know if do a PR is a good idea or not..

Anyway to make working the phase change of second gileas quest i've edited few line in mangos table.. you can see it here

To have NPC and mob working as described on wowWiki or wowHead i've build some c++ code inside ScriptDev2 project (recently someone sayed me that i don't need to write c++ code to make thinks working.... ) and i'm planning to post it on forum

Ffor your sql, if you are using MSSql Server, SQLServer Management Studio (on windows) is a good interface to manage tables and data (and it's free), if you use MySQL i've used MySql Workbench (for both Win a Unix) that made everyting with no problem and is totally free!

Currently i'm locked on "Evaquate the Merchant Square" quest... i can't do quest progression when the door was opened... (here my post about it) How do you done it?

Thanks!!!

[Corsol]

This was discussed over in this https://www.getmangos.eu/database/10108-server-fine-db-errors.html#post73440 thread. The following sql should clear up a bunch of the errors but not all. I haven't gotten around to fixing them all yet. If anyone has any patches that resolve any of the startup errors please make a pull request and I will happily merge them in. But yes the errors came from the last YTDB import.

update creature as c JOIN creature_template as ct on c.id = ct.entry set c.curhealth = ct.minhealth where c.curhealth < ct.minhealth;

I was waiting for some people to test this patch out to see if their errors about the curhealth being to low went away as well. If someone lets me know if this works for them, I'll get it in the main repo.

Thanks and happy holidays.

I confirm to you that on my database the query worked fine!

All errors about creature current healt was fixed!

[bels]

I confirm to you that on my database the query worked fine!

All errors about creature current healt was fixed!

Then I'll get this in my next update. I've got a few more quests that I'd like to fix in the Dwarf start area so that it is close to 100% before I push my changes to the repo. I'm glad you guys are working on the Three database. I think it'll move along quite quickly with your efforts.

[bels]

Dear Corsul, here comes the NOOB part of me..lol

What is a pull request?, and on the topic maybe you can help me out?

i use a dedicated sql server and use sqlyog as an editor, i can import sql scripts on my databases but not on a table in that database.

so for example, to make the second quest for worgen area working i had to change some lines in the quest and characters table.

But i have no clue how to make a script of this change, so how do you do that?

if i want to import an sql file on a table, i get a message that states i have to buy the pro version of sqlyog, but even then, i don't want to dump the hole table just the changes.

So how do you do that ?

Nagilum (feeling very dumb)

If you don't know how to make an SQL "script", I would be more than happy to help you with that if you still have the lines of SQL that you used to modify. (ie. 'insert into creature_template (etc...,etc...) values (etc..., etc...))

[Nagilum]

Hi guys, i am still busy with the three server.

Although i can fix a lot of things in the database, make a workaround or whatever some things i just can't solve so a few questions from me:

1) leave vehicle button, must be a spell id because gettin in one also uses a spell. (but what id do i need?)

2) "jack all trade" the profession trainer (id 50247) only speaks about the professions but can't teach them, the gossip script en gossip menu id are all valid, but still it doesn't work.

3) worgen and dranei are ending there start area in Rut'heran village, but can not go to Lor'danel with a hippograph, only Nightelfs can get that ride by default. i've created a work around but by default worgen and dranei only can travel to stormwind by ship.

4) not really important just curious, some quest use a start and complete script, functions ok, but the cinematics are missing, (Worgen and Goblin) is there anyway to get them in to the game?

I hope someone has some answers, would be great fun if the vehicle issue is solved.

Nagilum