Jump to content

[MANGOSTWO] Strange DB Behavior

5even

By 5even
in Archived Help and support

Recommended Posts

5even Advanced Member

5even

Posted
Posted 

`creature_movement` Id 6885, point 27 has textid1 has value 2000015009 out of range. Must be in 2001000000-2000009999

I have a ton of these errors, including many in the the db_scripts_on_gossip

The range requirement is in revers big->small (example above: 2001000000-2000009999

that not withstanding, i changed one of the errors from 2000005009 to 2000015009 which would have put it in range, but it did not.

So I am back to the range requirement.

Can someone clear this up. Looks like an easy DB fix by simply adding 10,000 or even 1000,000 to the existing, but that doesn't seem to work, as shown above 2000015009 IS IN BETWEEN 2001000000-2000009999

any suggestions?

5even Advanced Member

5even

Posted
  • Author
Posted 
`creature_movement` Id 6885, point 27 has textid1 has value 2000015009 out of range. Must be in 2001000000-2000009999

I have a ton of these errors, including many in the the db_scripts_on_gossip

The range requirement is in revers big->small (example above: 2001000000-2000009999

that not withstanding, i changed one of the errors from 2000005009 to 2000015009 which would have put it in range, but it did not.

So I am back to the range requirement.

Can someone clear this up. Looks like an easy DB fix by simply adding 10,000 or even 1000,000 to the existing, but that doesn't seem to work, as shown above 2000015009 IS IN BETWEEN 2001000000-2000009999

any suggestions?

oops, this is all from server log, below are a few snippets:

2014-08-01 10:51:11 ERROR:Table `creature_movement` Id 6885, point 27 has textid1 has value 2000015009 out of range. Must be in 2001000000-2000009999
2014-08-01 10:51:11 ERROR:Table creature_movement for id 44958, point 5 have script_id 150201 that does not exist in `dbscripts_on_creature_movement`, ignoring
2014-08-01 10:51:11 ERROR:Table creature_movement for id 44965, point 8 have script_id 150201 that does not exist in `dbscripts_on_creature_movement`, ignoring
2014-08-01 10:51:11 ERROR:Table `creature_movement` Id 30649, point 2 has textid1 has value 2000015019 out of range. Must be in 2001000000-2000009999
2014-08-01 10:51:11 ERROR:Table `creature_movement` Id 4567, point 10 has textid1 has value 2000015008 out of range. Must be in 2001000000-2000009999
2014-08-01 10:51:11 ERROR:Table `creature_movement` Id 4567, point 8 has textid1 has value 2000015007 out of range. Must be in 2001000000-2000009999
2014-08-01 10:51:11 ERROR:Table `creature_movement` Id 4567, point 7 has textid1 has value 2000015006 out of range. Must be in 2001000000-2000009999
2014-08-01 10:51:11 ERROR:Table `creature_movement` Id 4567, point 6 has textid1 has value 2000015005 out of range. Must be in 2001000000-2000009999
2014-08-01 10:51:11 ERROR:Table `creature_movement` Id 4567, point 5 has textid1 has value 2000015004 out of range. Must be in 2001000000-2000009999
2014-08-01 10:51:11 ERROR:Table `creature_movement` Id 4567, point 4 has textid1 has value 2000015003 out of range. Must be in 2001000000-2000009999
2014-08-01 10:51:11 ERROR:Table `creature_movement` Id 4567, point 3 has textid1 has value 2000015002 out of range. Must be in 2001000000-2000009999
2014-08-01 10:51:11 ERROR:Table `creature_movement` Id 4567, point 2 has textid1 has value 2000015001 out of range. Must be in 2001000000-2000009999
2014-08-01 10:51:11 ERROR:Table creature_movement for id 88696, point 44 have script_id 1 that does not exist in `dbscripts_on_creature_movement`, ignoring
2014-08-01 10:51:11 ERROR:Table creature_movement for id 125627, point 20 have script_id 1 that does not exist in `dbscripts_on_creature_movement`, ignoring
2014-08-01 10:51:11 ERROR:Table `creature_movement` Id 66937, point 1 has textid2 has value 2000015220 out of range. Must be in 2001000000-2000009999
2014-08-01 10:51:11 ERROR:Table `creature_movement` Id 66937, point 1 has textid4 has value 2000015235 out of range. Must be in 2001000000-2000009999
2014-08-01 10:51:11 ERROR:Table `creature_movement` Id 66937, point 2 has textid1 has value 2000015043 out of range. Must be in 2001000000-2000009999
2014-08-01 10:51:11 ERROR:Table `creature_movement` Id 66937, point 2 has textid3 has value 2000015230 out of range. Must be in 2001000000-2000009999
2014-08-01 10:51:11 ERROR:Table `creature_movement` Id 66937, point 2 has textid5 has value 2000005236 out of range. Must be in 2001000000-2000009999
etc...

the following is HUGE!! this is just another snipped (I haven't started working on this one yet, prob a typo, given the massive amounts of errors)

2014-08-01 10:50:57 ERROR:Creature (Entry: 1840) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 1860) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 1896) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 2160) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 2283) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 2453) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 2605) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 2638) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 2755) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 2887) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 3569) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 3672) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 3773) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 3799) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 3899) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 3900) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 4842) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 4978) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 5893) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 5894) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 5916) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 6047) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 6070) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 6228) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 6490) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 6550) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 7411) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 7734) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 7735) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 8075) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 8202) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 8217) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 8394) does not have proper `UnitClass(0)` in creature_template
2014-08-01 10:50:57 ERROR:Creature (Entry: 8578) does not have proper `UnitClass(0)` in creature_template

... etc..

..and finally another huge one.. (this one I already changed the textid(x) (btw that is a typo text_id(x) but since it is for display, i ignored it - I already checked the source)

2014-08-01 10:51:10 ERROR:Table `dbscripts_on_gossip` has out of range text_id2 (dataint = 2000010281 expected 2001000000-2000010000) in SCRIPT_COMMAND_TALK for script id 9865
2014-08-01 10:51:10 ERROR:Table `dbscripts_on_gossip` has out of range text_id3 (dataint = 2000010282 expected 2001000000-2000010000) in SCRIPT_COMMAND_TALK for script id 9865
2014-08-01 10:51:10 ERROR:Table `dbscripts_on_gossip` has out of range text_id4 (dataint = 2000010283 expected 2001000000-2000010000) in SCRIPT_COMMAND_TALK for script id 9865
2014-08-01 10:51:10 ERROR:Table `dbscripts_on_gossip` has out of range text_id2 (dataint = 2000010315 expected 2001000000-2000010000) in SCRIPT_COMMAND_TALK for script id 8762
2014-08-01 10:51:10 ERROR:Table `dbscripts_on_gossip` has out of range text_id3 (dataint = 2000010316 expected 2001000000-2000010000) in SCRIPT_COMMAND_TALK for script id 8762
2014-08-01 10:51:10 ERROR:Table `dbscripts_on_gossip` has out of range text_id2 (dataint = 2000015512 expected 2001000000-2000010000) in SCRIPT_COMMAND_TALK for script id 8851
2014-08-01 10:51:10 ERROR:Table `dbscripts_on_gossip` has out of range text_id3 (dataint = 2000015519 expected 2001000000-2000010000) in SCRIPT_COMMAND_TALK for script id 8851
2014-08-01 10:51:10 ERROR:Table `dbscripts_on_gossip` has out of range text_id4 (dataint = 2000015514 expected 2001000000-2000010000) in SCRIPT_COMMAND_TALK for script id 8851
2014-08-01 10:51:10 ERROR:Table `dbscripts_on_gossip` has out of range text_id2 (dataint = 2000015516 expected 2001000000-2000010000) in SCRIPT_COMMAND_TALK for script id 8851
2014-08-01 10:51:10 ERROR:Table `dbscripts_on_gossip` has out of range text_id3 (dataint = 2000015513 expected 2001000000-2000010000) in SCRIPT_COMMAND_TALK for script id 8851
2014-08-01 10:51:10 ERROR:Table `dbscripts_on_gossip` has out of range text_id4 (dataint = 2000015520 expected 2001000000-2000010000) in SCRIPT_COMMAND_TALK for script id 8851
etc....

5even Advanced Member

5even

Posted
  • Author
Posted

i'll repull it, but I am pretty sure i used that - Only say "pretty sure" as I've spend years on mine :-) but if you think that might be the issue, i'll try again and post ..

-- UPDATE

same errors if not more

they are all out of range errors

i have twice as manay now than I had with my old db

5even Advanced Member

5even

Posted
  • Author
Posted

everything I get is all from here 100% (mangostwo).

I did some research, as form here(getmangos.eu) apparently the unitclass issue is a tbc thing left over and to ignore those, but th emovement and dbscrips one, don't make sense as they fall in range of the displayed limit.

Unkle Nuke Advanced Member

Unkle Nuke

Posted
Posted

This is partly an educated guess, since I've yet to catch up on all the changes made to the database tables, but it looks to me as though the SQL patches for ACID or ScriptDev were either applied in the wrong order or missing entirely.

I'm not saying you did that 5even. It might have been a badly merged update on the developer's end.

5even Advanced Member

5even

Posted
  • Author
Posted
This is partly an educated guess, since I've yet to catch up on all the changes made to the database tables, but it looks to me as though the SQL patches for ACID or ScriptDev were either applied in the wrong order or missing entirely.

I'm not saying you did that 5even. It might have been a badly merged update on the developer's end.

well followig this guide:

https://github.com/mangoswiki/Wiki/wiki/Installing%20MaNGOS%20on%20Windows

to the letter,

i now have even MORE script errors!!

what do you think? guide wrong/old? missing files? updates?

due to the massive size of the log (due to errors) you can read it here:

http://frostbytewow.sytes.net/errs/serverlog.txt

If it seems I am in error, please quote the step I might have missed. It looks like it is all in the script section (as you notice per instructions, there is no ACID mention - I remember those days).

5even Advanced Member

5even

Posted
  • Author
Posted

WELL I saw an update today in the scripts - so I am recompiliing to see if some of that is cleared up, however i get this error now:

Error 1 error C3859: virtual memory range for PCH exceeded; please recompile with a command line option of '-Zm112' or greater C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\include\xmemory0 611 1 ScriptDev2

Error 2 error C1076: compiler limit : internal heap limit reached; use /Zm to specify a higher limit C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\include\xmemory0 611 1 ScriptDev2

something to do with the precompiled headers - not sure If i changed that, usually leave stuff at default. any suggestion for a fix?

5even Advanced Member

5even

Posted
  • Author
Posted
WELL I saw an update today in the scripts - so I am recompiliing to see if some of that is cleared up, however i get this error now:

Error 1 error C3859: virtual memory range for PCH exceeded; please recompile with a command line option of '-Zm112' or greater C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\include\xmemory0 611 1 ScriptDev2

Error 2 error C1076: compiler limit : internal heap limit reached; use /Zm to specify a higher limit C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\include\xmemory0 611 1 ScriptDev2

something to do with the precompiled headers - not sure If i changed that, usually leave stuff at default. any suggestion for a fix?

OK, for now I cranked up the -Zm, but I know I changed something when I was compiling another app, just forgot what I changed in the phc, so if someone has a setting, that would be great!

  • 4 weeks later...
antz Advanced Member

antz

Posted
Posted

I am currently preparing for two big mangos releases:

Zero - Rel20

One - Rel19

Once these are done, I will take a look at this. If you haven't seen / heard of any updates in a couple of weeks - please give me a kick :)

Le Froid Advanced Member

Le Froid

Posted
Posted

I think I located one source of the DB errors in the console.

I compared cmangos' DB Object Manager to mangos and they have a lower value for the definition MAX_MANGOS_STRING_ID (which is responsible for the 'missing string id' errors)

I'm too lazy to bother committing my changes to a local git repo to fetch the diff file, so to apply the fix simply open the src/game/ObjectMgr.h file, search for MAX_MANGOS_STRING_ID and edit the line to match the following:

#define MAX_MANGOS_STRING_ID 2000000000

There are still quite a few errors remaining, of which I'll continue searching for although some help would be appreciated!

  • 2 months later...

Archived

This topic is now archived and is closed to further replies.

Go to topic listing

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use