[RELEASE] ManGOS DB Handler

[feal87]

Posted Revision 196 on the UPDATER SYSTEM (there is no release, you must update) :

1 - Added a character search through accounts. (it was so requested that i decided to do it right now)
2 - Delete the game_addons handler according to revision 2680.

 

[destroya]

I got a problem, i configured DB handeler right but when i try to hit Save&exit it says:

Your configuration file is wrong, modigy your options...
#42S02Table 'mangos.item_loot_template' doesnt exist.

i cnat do anything there and i really want to.
how do i solve this problem?

 

[feal87]

This problem says that you have an old database, you must update your database in order to use the latest MDH version. Otherwise if you don't want to update you will have to use an OLDER version of MDH.

 

[Alamir]

Hmmm 1 thing..
Got same error, but i have last database ( sdb 0.5.3 - is it last? )

So whats wrong?
Or maybe i am instaled it not right....but all make and servers run well....

 

[Knodden]

Ok first of all thx so much for this crazy cool program u made
And now to my question...
I have installed the newest revision 294.
And your Database Handler want to find a row in the sql database named: game_addons which have been deleted in the newst rev versions.
The error looks like this:

Your configuration file is wrong, modify you options...
#42S02Table 'mangos.game_addons' dosen't exist

 

[BazookaJoe]

I fixed mine by inserting the game_addons table from an older DB. MDH now works fine, and haven't noticed any adverse affects from it. Can always delete the table if it causes problems, but so far so good.

Give it a try and see if it helps.

*note* Just updated MDH to 196 and it connects fine without needing the game_addons table. So I have removed it once again from the DB.

 

[Knodden]

Ok got it to work are a wile had to add the game_addon then drop it which made my character table crash...
Had to fix it and then i got DBH to work.. Any way now it seems to be working just fine

 

[feal87]

Yep guys, remember to update MDH to the latest revision cause i update the program as soon as the developers release updates.

P.S. Sorry for the waiting for the new revisions but my real life is getting occupied. Just a few more days and i'll be back for good.

 

[Alamir]

Thx, gret program!
All working now with latest update

 

[indianicrasta]

i have 189 rev.

can i just download the 193 revision??or i must download step by step from 192??

 

[feal87]

i have 189 rev.

can i just download the 193 revision??or i must download step by step from 192??

You can directly download the latest revision through the internal updater.

 

[feal87]

Posted Revision 197 on the UPDATER SYSTEM (there is no release, you must update) :

1 - Added an async update checker at the program start.
2 - Fixed a blocking bug that appeared when there was no results in a character search.
3 - Added the options connectonstartup,updatecheckatstartup.

 

[kuug]

Well when im trying to find something with the database handler I just get an error saying "connection must be valid and open":newbie:

 

[feal87]

As i said please be sure that your configuration is correctly configured.
If it is then be sure that the database in up-to-date to the latest available revision.
And check that mysql allow remote root connection.

 

[MrValle]

I have a problem with the latest DBH,

When i edit the Deathcharger mount or whatever its called, i change the required lvl to 1. But i still cannot use it in the game. It still has lvl 60 req.

I have restarted the server after i changed this.

Anybody know of any good place with alot of tutorials for mangos on how to edit different stuff. And how to add npc

 

[feal87]

you have to clear the WDB directory in the client.
It's not a problem with MDH.

 

[kuddster]

With any install of the database handler I get an error stating

MaNGOS Database Handler has encountered a problem and needs to close.  We are sorry for the inconvenience

containing an error report stating

EventType : clr20r3     P1 : mangos database handler.exe     P2 : 0.3.0.0     
P3 : 455ade2b     P4 : system.drawing     P5 : 2.0.0.0     P6 : 4333aeaf     
P7 : 7a8     P8 : 6c     P9 : system.argumentexception

Anyone with any information as to why this error occurs would be much appreciated.

 

[feal87]

do you have the .NET Framework 2.0?

Please try to uninstall COMPLETELY the .NET Framework and reinstall.

 

[feal87]

Posted Revision 198 on the UPDATER SYSTEM (there is no release, you must update) :

1 - Fast fix for the backpack changed properties in DB.

 

[feal87]

Posted Revision 199 on the UPDATER SYSTEM (there is no release, you must update) :

1 - Added the online field on the account handler.
2 - Fixed a bug in the character_kill handler edit button.