it's not a bug related to my program.
This is a bug that occur when you had a BETA version of the .NET Framework on your computer.
To solve uninstall all the .NET framework, and reinstall the LATEST version.
Printable View
it's not a bug related to my program.
This is a bug that occur when you had a BETA version of the .NET Framework on your computer.
To solve uninstall all the .NET framework, and reinstall the LATEST version.
my .net version laste version
datebase handler is not run my computer
mangos 2547
and sdb 5.2/269
.net 2.0
sql 5.0
web sever
why
NOT
Run?
:vegeta: :2gunsfiring_v1: :2gunsfiring_v1: :juggle: :technolog my .net version laste version
datebase handler is not run my computer
mangos 2547
and sdb 5.2/269
.net 2.0
sql 5.0
web sever
why
NOT
Run?
:ala:
Posted Revision 183 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added the fully featured areatrigger_template and areatrigger_tavern handler. (sorry for the waiting, university is killing me :D)
2 - Fixed some negative cooldown on items. (Thanks to Jkipp82 for the report)
As is said UNINSTALL FULLY the .NET Framework and reinstall it. Its because you installed a BETA version some time ago. :)
Posted Revision 184 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added a first version of the Add function for the creature handler. You can now create brand new creature with this software. :)
2 - Fixed something related to the areatrigger handlers
Posted Revision 185 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added the button for a spell lookup in the Enchantment field of the character_inventory handler (suggested by jbaker)
Posted Revision 186 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Updated the MDH code to be working with MaNGOS Revision 2572+.
2 - Fixed a bug in the creature_involvedrelation handling.
It would be cool if one day you could build in an extension to view the models of the monsters with the scale and size, maybe even items for characters directly from your app with the specifications set within the program.
hi..
mangoes database handler!!..this tool only update this tool..and or does it update my server too??
if .. tell me how??:juggle:
1) Yes, in the future there will be a model previewer in the program. It's a planned feature. ;)
2) The updater ONLY UPDATE the program itself. IT DON'T update ManGOS or anything else.
From Revision 186 and further i'm going to support MaNGOS Revision 2580+. No previous support is available.
any idea can do *DL new REV from mangos ??
tool for DL* rev and copy new in it?? ..maybe
..i need special NPC /vendor (for gm..Players )????:juggle: :juggle:
you need MaNGOS Revision 2580+, any version less and it will not work.
Go to MaNGOS project discussion forums (Powered by Invision Power Board)
for finding the newest binaries.
I am getting an error, with DB Handler, cant get it to run, getting a popup screen with a number like .0000035 (or something) and it stops there. Any ideas what I am doing wrong, I am trying to get it working so I can back up all accounts and characters before patching mangos again. dont want to lose them on my kids hehehe, version at time is 171msi and I do believe am running mangos 25xx and SDB .51 with .52 updates
1) Do you have .NET Framework 2.0 installed on your computer?
2) Have you tried to uninstall e reinstall the .NET Framework 2.0?
Keep up the excellent work feral87, you rock!
Installshield Revision 187 OUT
Download from the official website
Important changes from the last Installshield Release :
1 - Support for MaNGOS Revision 2580+
2 - Separate configuration for both mangos and realmd database
3 - Hide and show toolbar functionality
4 - Newly created creature_questrelation and creature_involvedrelation handler.
5 - Newly created areatrigger_template and areatrigger_tavern handler.
6 - Add function for the creature_template handler.
7 - Newly created item_loot_template handler.
8 - Fixed infinite number of bugs.
This is the second polished Installshield Version with enough functionality and stability to be considered a milestone (even if not official) for this project.
Thanks to ALL the guy who helped along the way with your beta-testing, suggestion and everything you have maked. I really appreciated your help.
I hope to continue to make a good work for the MaNGOS community.
Thanks,
feal87
forget I posted this, i figured out the reason its not working.
Posted Revision 188 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Better error handling for letting know users what is not right with their DB.
2 - Fixed a little typo in the interface
Posted Revision 189 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added logout_time, is_logout_resting, rest_bonus fields to the character handler. :)
Any chance of a quest editor being added? Would be nice to have an easier way to add custom quests/ repair gltiched quests.
How would you go about using the MaNGOS DB Handler to add "advanced" items (ex: Mounts) to the game?
You can already do that in the item handler.
Just put the correct flag/spell to the item and it will become a mount.
Posted Revision 190 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Posted the first part of the global wide optimization of the code i'm working on. :)
Posted Revision 191 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Posted the second part of the global wide optimization of the code i'm working on.
Installshield Revision 192 OUT
Download from the official website
Important changes from the last Installshield Release :
1 - This revision support ONLY MaNGOS Revision 2642+
2 - Added logout_time, is_logout_resting, rest_bonus fields to the character handler.
3 - Better error handling for letting know users what is not right with their DB.
4 - Fixed a little typo in the interface
5 - Posted the first part of the global wide optimization of the code i'm working on.
6 - Posted the second part of the global wide optimization of the code i'm working on.
7 - Updated MDH to support ONLY MaNGOS 2642+. No other revision will work.
8 - Fully completed the character_spell_cooldown handler.
9 - Done some update to the updater.
This is the third polished Installshield Version with enough functionality and stability to be considered a milestone (even if not official) for this project.
Thanks to ALL the guy who helped along the way with your beta-testing, suggestion and everything you have maked. I really appreciated your help.
I hope to continue to make a good work for the MaNGOS community.
Thanks,
feal87
good job bro
Posted Revision 193 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fixed a SERIOUS bug in the generalistic LoadTable function.
2 - Added the Go To Home function in the character_homebind handler.
3 - Added the CurrentXP/NextLevelXP fields in the character handler.
once again i must express my appreciation for your mdbh makes my work with db a whole lot easier
Anyone else getting this error whenever you click on Char to view the characters in any account?
http://img86.imageshack.us/img86/135...ererrorpy5.jpg
Just keep getting it even when you try to restore accounts that you use MDBH to backup. Any advise would be appreciated.
Do you have some strange values to some chars health, mana etc..?
Because THIS is the reason of these errors.
If not contact me through MSN and we'll see how to resolve this matter.
Posted Revision 195 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fixed a bug with various Userlevel different than normal
2 - Updated the import/export function to the latest MaNGOS. ;)
Nope, it is just a few new accounts. I was testing to see if i have the same problem with Clean database. So i put in the database clean and registered a few accounts with a few new characters to try. And the error is still there. :(
[quote=LiquidNexxus
Feal I sent you an email a few days ago, can you take a look when you get a chance please?
Thanks,
Frub
I generally answer to e-mail within 12 hours. If i don't reply in this time then the mail hasn't arrived.
Try to send the e-mail again (maybe Yahoo Mail treated your mail as spam.).
Thanks,
feal87
P.S. (or if you want you can contact me through MSN in the evening ;))
Hey i ned help
i got a problem starting mangosdb.
when starting it says:
confuguration file is wrong modify your option
value cannot be null
parameter name: item
mangosdb stops configuration while loading areatrigger......
I am using Navicat to alter the DB but i cant find the error.
hope to get help
This is a corrupt DB message.
If the DB have some corrupt or incorrect data the program will react this way.
Try with a correct database, it should work. :)
I dont learn anything that way ??
It most be posible to find the primary key that trigger the null error.
mangosdb load to fast to se where it stops.
cant mangosdb make an error log
contact me through MSN at the address stated in the MDH homepage (where you downloaded) and i'll debug the program online with your server. :)
I'll wait for your contact. :)
Lots of search features are underway for the next version.
You'll have to wait a little cause i'm a little busy in the real life. :D
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.
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?
:eek:
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.
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....
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:
Code:
Your configuration file is wrong, modify you options...
#42S02Table 'mangos.game_addons' dosen't exist
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.
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;)
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. ;)
Thx, gret program!
All working now with latest update:)
i have 189 rev.
can i just download the 193 revision??or i must download step by step from 192??
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.
Well when im trying to find something with the database handler I just get an error saying "connection must be valid and open":newbie:
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. :)
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
you have to clear the WDB directory in the client.
It's not a problem with MDH. :)
With any install of the database handler I get an error stating
containing an error report statingCode:MaNGOS Database Handler has encountered a problem and needs to close. We are sorry for the inconvenience
Anyone with any information as to why this error occurs would be much appreciated.Code: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
do you have the .NET Framework 2.0?
Please try to uninstall COMPLETELY the .NET Framework and reinstall.
Posted Revision 198 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fast fix for the backpack changed properties in DB.
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.
Posted Revision 200 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added the fully completed character_queststatus handler.
2 - Fixed a bug in the character handler.
Posted Revision 201 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added the status field to the character_queststatus handler.
2 - Added the mob/item count to the character_queststatus handler.
Posted Revision 202 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Simplified the Status field on the character_queststatus handler.
2 - Added a special check to enable/disable the exploration checkbox in the character_queststatus handler related to the quest you are pointing (it check if the quest is an exploration one).
Why is MDH hanging at "Inserting Skill DB" and not doing anything further, once i try to do something it crashes ...
The inserting Skill DB remaining on the screen is a known problem, but it's not related to any crash that i know. Can you be more precise?
Posted Revision 203 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fixed an hard bug on the generalistic loadtable function that can block the reading in some situation.
2 - Added a basical restarter (with basic functionality :))
Posted Revision 204 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added an SQL logging system to the program to better keep track of the problems that may arise. ;)
Posted Revision 204 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added an SQL logging system to the program to better keep track of the problems that may arise. ;)
Installshield Revision 205 OUT
Download from the official website
Important changes from the last Installshield Release :
1 - This revision support ONLY MaNGOS Revision 2748+
2 - Updated the import/export function to the latest MaNGOS. ;)
3 - Fixed some SERIOUS bugs in the generalistic LoadTable function.
4 - Added the Go To Home function in the character_homebind handler.
5 - Added the CurrentXP/NextLevelXP fields in the character handler.
6 - Hopefully fixed the "reader not opened" problem reported by Teto.
7 - Fixed a bug with various Userlevel different than normal
8 - Added a character search through accounts. (it was so requested that i decided to do it right now)
9 - Delete the game_addons handler according to revision 2680.
10 - Added an async update checker at the program start.
11 - Fixed a blocking bug that appeared when there was no results in a character search.
12 - Added the options connectonstartup,updatecheckatstartup.
13 - Added the online field on the account handler.
14 - Fixed a bug in the character_kill handler edit button.
15 - Added the fully completed character_queststatus handler.
16 - Fixed some bugs in the character handler.
17 - Added a basical restarter (with basic functionality :))
18 - Added an SQL logging system to the program to better keep track of the problems that may arise. ;)
19 - Added a restarter logging system for the newly created restarter.
This is the fourth polished Installshield Version with enough functionality and stability to be considered a milestone (even if not official) for this project.
Thanks to ALL the guy who helped along the way with your beta-testing, suggestion and everything you have maked. I really appreciated your help.
I hope to continue to make a good work for the MaNGOS community.
Thanks,
feal87
Posted Revision 206 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fixed the Clear Log functionality for the 2 part of the program
2 - Added a FREEZE system detection and restart into the restarter!!! (Unique in the world i think :D)
3 - Some other bug fixing.
Posted Revision 207 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added an option to minimize to tray on X button pressed.
2 - Added an option to minimize to taskbar instead of always minimizing to tray.
3 - Fixed some typo in the language file.
4 - Added a check to prevent unhandled exception at starting servers with an incorrect path.
Posted Revision 208 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Disabled the character_spellcooldown time field until i find out what's wrong with it.
Posted Revision 209 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fixed some typos in the interfaces
2 - Added a combobox for quickly select configurations without opening the configuration window. :)
3 - Reactivated the time field in the character_spell_cooldown table. (Thanks to Vladimir for the swift and fast Core Fix)
Posted Revision 210 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fixed the SpellDB button in the character_spell_cooldown handler.
2 - Maked sure that the DB Management page is accessible only if the connection is active. (even if database content is corrupt)
3 - Some other interface fixes
4 - Fixed a bug related to the double showing of the connection error message.
5 - Maked sure that import/export procedures are allowed only on database in line. :)
Posted Revision 211 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Finally FIXED inventory after that SQL Update.
I don't know if you guys are aware of this but after that update on the inventory, my MDH is acting strange....
the Inventory sections are all mixed up!
Example:
BuyBack items....it's actually my main Bank items
BackPack bags...is actually the Bank slots Bags....
And I cannot SEE the Normal Bags ....although they are there...I'm sure of it
I hope there is a fix to this soon....because I personally use MDH ONLY for the Inventory fonctionality :(
Pls let me know if it's a work in progress.....or I should just give up
Thanks
Posted Revision 212 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added a background configuration option.
2 - Added the fields spell1,spell2,spell3,spell4 to the creature_template handler.
3 - Added a SpellDB lookup button at the npc_trainer handler.
4 - Done some optimization to the code.
5 - Added licence to files where was missing.
6 - Fixed the problem of the splashscreen that was remaining active in the background.
7 - Fixed a problem that was arising when you tried to update with multiple instance of MDH running.
8 - Added an option to select what kind of SQL istructions you wanna log (SELECT,UPDATE,INSERT,DELETE).
Sorry for the waiting. My ADSL line is down and i'm posting this update through dial-up. I hope the problems will resolve soon.
For the problem you are encountering try updating your MDH TO THE LATEST REVISION. (cause your problem maybe resolved in latest revision)
this thread should be stickied!
Question:
Which tables are actually backed up when you EXPORT with MDH?
I need to know asap. Thanks! :)
I am pretty sure i can speak for all of us mangos users when I say "Keep up the good work, we all apreciate the work you are doing"
MDH has made my life as a GM much easier, lol
Was wondering if you were planning on implimenting the "equip" section for mobs, anytime in the near future. To equip mobs with weapons and stuff. The Spells 1-4 in your latest release have come in very handy for those of us trying to make the mobs cast instead of just melee, I myself have many mobs casting spells now, thanks to MDH.
Thanks again for all your efforts and hard work.
:D
account,character, character_action, character_aura,character_homebind,Quote:
Question:
Which tables are actually backed up when you EXPORT with MDH?
I need to know asap. Thanks! :)
character_inventory,character_kill,character_pet,character_queststatus,character_reputation,
character_social,character_spell,character_spell_cooldown,character_ticket",
character_tutorial,item_instance,auctionhouse,mail,guild,guild_member,guild_rank",
guild_charter,guild_charter_sign,character_stable
These are the tables actually exported.
Hi Bazooka,
The equip section for NPCs will be added very soon even thought it's still not correctly managed by MaNGOS core. :)
Thanks to you for your feedback. ;)
(I'm doing a BIG rehaul of the code to make it more manageable, i hope to finish soon. ;))
Posted Revision 213 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fixed the Inventory according to MaNGOS Revision 2787 (this is basically adding the support for 28-slot bags). NO PREVIOUS MANGOS VERSION ARE SUPPORTED.
2 - Fixed Item inserting in Normal/Bank Bags and i hope all the problems with the inventory. Please report any bugs you found.
3 - Done the first part of a WHOLE code optimization and clearing. Very long and hard work. :D (actually 15% of the work is done)
Please everybody test the inventory system. It must work COMPLETELY correctly, i hope :D
Now i'll return optimizing the code, a lot of work awaits me. :D
(I'm still from dial-up, so if my answer to your question aren't swift is because i cannot connect all the time. :D)
there is an issue with the import of the auctionhouse table from the post auctionhouse update of version 2777 to the newest revisions.....any ideas?
mdh is really great.no doubt about it...i only have one problem.if i lvlup a char inside the game,the mdh cannot handle it anymore...
it says:
Invalid attempt to access a field before calling Read().
i click continue and it opens the char,but everyting's empty.the only data is in general and extra tabs.is it me or is it mdh?:(
You must BEFORE exporting data execute all SQLs Updates otherwise it won't work. As i said countless times, the starting and the ending structure must collide, MUST BE IDENTICAL.
Mhn...That error is generally related to some strange or VERY BIG value inside the data field...Quote:
mdh is really great.no doubt about it...i only have one problem.if i lvlup a char inside the game,the mdh cannot handle it anymore...
it says:
Invalid attempt to access a field before calling Read().
i click continue and it opens the char,but everyting's empty.the only data is in general and extra tabs.is it me or is it mdh?:(
What level you lvlupped?
It's not certainly a MDH problem related to lvlup cause i use it costantly to test new features. ;)
Posted Revision 214 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added 4 new DBs for Item Class, Item Subclass, Character Class, Character Race. This way all should be localized and optimized for every update that could occur. :)
2 - Done the first part of a WHOLE code optimization and clearing. Very long and hard work. :D (actually 20% of the work is done)
Posted Revision 215 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added an integrity checker with base functionality of detection NON-LINKED records into the DB. (In next revision i'll add the Edit config... and Show Records functionality)
2 - Done the first part of a WHOLE code optimization and clearing. Very long and hard work. :D (actually 25% of the work is done)
3 - Fixed some bugs in the new class and races DB features. (thanks to fee for the time and patience to debug with me on his DB :D)
Just Curious how you're supposed to set up an ADmin account using MDH as im using Revision 215 of it and revision 2800 of MaNGOS and i cant seem to get it to work by adding it thru MDH it wont save keeps going back to Unnamed when i hit close since there is no save button for it.
Edit = Save
I don't know why lots of people don't understand this :D
LOL that's too complex for some :)
Is it posibly to config MDH to read the data from multiple realms at once? I am currently running 3 realms and was just wondering if their was an easier way than running 3 seprate instances of MDH.
Keep up the good work MDH is a great tool.
at the same time no, you can create multiple configuration yes.
This way you can change them by simply changing the combobox in the right panel. ;)
Easy no? :)
I am having some difficulties updating to version 216 from version 215, I update it and it is not updating at all it stays at version 215.
Posted Revision 217 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added the fully completed Creature_loot_template handler.
ok im getting an error trying to connect to the page where u update svn mdh..or its kinda like a security warning..it says "there is a problem with this websites security certificate." the security certificate presented by this website was not issued by a trusted certificate." Security certificate problems may indicate an attempt to fool you or intercept any data you send to the server. "
i dunno if its safe to go on that website soo..
Little bug maybe? I am using version 217. The problem is not really that big of a deal i can get around it, but in the Configuration/server tab when browsing for the mangosd path it is not selecting the path, so I just manually copy/paste the path and it works fine, the realmd path is working...i dunno if anyone else is having this issue but again its not that big of a problem. And if this problem has already been stated then I apologize.
Phantom710 to update MDH you have just to press Tools->Updater on your MDH, no site is required. The site you are talking contained sources but for now it's offline.
Kiasta thanks for the report, it will be fixed in the next revision. :)
well when i open mdh it says..your configuration file is wrong modify your options..then it says #42S02Table 'mangos.item_loot _template' doesnt exsist..
my configuration files are right i dunno whats wrong..?
That error is simple :
You have an outdated database. The item_loot_template table was added in revision 2495 and we are currently at 2826.
Update your DB and MDH will work just fine.
Remember that MDH only support newer MaNGOS Revision. :)