-=/PryDevServer-4TC:\=- Trinity Core!

[dagreg]

Hi I've been using pryd since rev3, for all I know the steps to mount the server haven't changed. I use navicat and get error while batching CTDB Fun or any other DB. Tried Sqlyog, and even command prompt and keep getting errors. I don't know if it is Mysql or the batching that causes the errors.

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0',imity'Mine', '', '', '0', '1', '1', '0', '35', '35', '0', '1', '1.14286', '1'' at line 1

That's an example while batching on a newly installed mysql service using navicat.

[Failboat]

Hi I've been using pryd since rev3, for all I know the steps to mount the server haven't changed. I use navicat and get error while batching CTDB Fun or any other DB. Tried Sqlyog, and even command prompt and keep getting errors. I don't know if it is Mysql or the batching that causes the errors.

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0',imity'Mine', '', '', '0', '1', '1', '0', '35', '35', '0', '1', '1.14286', '1'' at line 1

That's an example while batching on a newly installed mysql service using navicat.

Whats your MySQL Version? It works just fine on 5.1, for me atleast.

[Norxus]

Maybe you should try remove all data, then uninstall the mysql, reinstall the service or use wamp, xamp etc...

I´m using Wamp here and everything is just great with the mysql + apache

Give a try...

Btw, does anyone know how I could remove the spawn of all custom npc in the mall?
Ahm yes... I would like to remove them to move the mall to another area

I don´t remember how to create an sql file to remove their spawn x.x and I dont want to remove one by one ingame (LOL)

Thanks for the help anyone

[pryd]

i have a few errors also.

DB - UltraCore_CTDB_FUN

Quote:
ERROR: game_event_save includes event save for non-worldevent id 35
ERROR: game_event_save includes event save for non-worldevent id 36
ERROR: game_event_save includes event save for non-worldevent id 37
ERROR: game_event_save includes event save for non-worldevent id 38
ERROR: game_event_save includes event save for non-worldevent id 39
ERROR: game_event_save includes event save for non-worldevent id 40
ERROR: game_event_save includes event save for non-worldevent id 41
ERROR: game_event_save includes event save for non-worldevent id 42
ERROR: game_event_save includes event save for non-worldevent id 43
ERROR: game_event_save includes event save for non-worldevent id 44
ERROR: game_event_save includes event save for non-worldevent id 45
ERROR: `game_event_save` game event id (46) is out of range compared to max event id in `game_event`
ERROR: `game_event_save` game event id (47) is out of range compared to max event id in `game_event`
ERROR: `game_event_save` game event id (4 is out of range compared to max event id in `game_event`
ERROR: `game_event_save` game event id (49) is out of range compared to max event id in `game_event`
and also from bots and other stuff

Quote:
ERROR: PlayerbotClassAI.castSpell : returning false b/c still castin
ERROR: CreatureEventAI: Creature 28017 has events but no events added to list because of instance flags.
ERROR: SQL: INSERT INTO character_aura (guid,caster_guid,spell,effect_mask,recalculate_mask,stackcount,amount0,amount1, amount2,base_amount0,base_amount1,base_amount2,maxduration,remaintime,remainchar ges) VALUES ('10', '17379391522750984938', '58667', '3', '3', '1', '250', '20', '0', '249', '19', '0', '30000', '4032', '0')
ERROR: SQL ERROR: Duplicate entry '10-58667-3' for key 'PRIMARY'
ERROR: AuraEffect::TriggerSpell: Spell 63132 have 0 in EffectTriggered[0], not handled custom case?
ERROR: CreatureEventAI: EventMap for Creature 40001 is empty but creature is using CreatureEventAI.
and a few more but this is all basically

For the most part make sure you have updated all the character sqls from your old core / database version to the newest version that you are using.

As far as the game_event_save errors go, you can remedy that by opening your character database and truncating your game_event_save.

This error normally occurs when a person was previously using their character database with TDB then switched to a CTDB world.

As far as the other errors, they can be fixed by reading what the core says. For example if creature eventmap is empty and is using eventai, remove eventai from creature 40001<--guid most likely or find creature 40001, see what ID this is using from the creature table and link up the ID with the entry in creature_template. Again remove the eventai and the error won't come back. This is just 1 way to resolve the error.

Lastly the bot console errors will be fixed ( some of them ) in the next release.
Otherwise this feature can be turned off in your trinitycore.conf

Hope this helps

[badspeed]

thanks pryd it worked =)

im looking forward for the next release =D

[Failboat]

Maybe you should try remove all data, then uninstall the mysql, reinstall the service or use wamp, xamp etc...

I´m using Wamp here and everything is just great with the mysql + apache

Im using WAMP aswell, and everything is good to go, but whats a good website to use? sorry if this is 100% offtopic...

[Norxus]

Im using WAMP aswell, and everything is good to go, but whats a good website to use? sorry if this is 100% offtopic...

Dunno mate, I´m not using any... I just have the server to play at my home, do some tests, help find some bugs etc... Maybe you can find something here in MMOwned, just search

[SergeySV]

Thank you for your assembly, I'm from Russia tested it, liked it, but many players 3.3.3a. Are you planning to move to the nucleus?

[lorac]

Thank you for your assembly, I'm from Russia tested it, liked it, but many players 3.3.3a. Are you planning to move to the nucleus?

your welcome
Next repack will be 3.3.3a
Trinity core just released a 3.3.3a basic support
Currently we are applying our current fixes to the core

[CoDHeRo]

OMG BEST REPACK EVAR!!! all is balanced and not bugged even custom imba lvl 255 gear!! i made lvling area and all but i cant get xp from lvl 100+ i found a patch how to do it but idk how to apply it someone plz help me i will pray for u everyday if u doo.. [email protected]

[CoDHeRo]

BTW my friends who have patch 3.3.3 can log in.. without bugs =D

[lorac]

::EDITED ::
Next release will Now support 3.3.3 build 11723
ETA on release
Not announced yet currently we are patching our fixes to the core

:: Added Responce ::
Did you set your

 MaxPlayerLevel = 80

to

MaxPlayerLevel = 255 

If not ....Dont be so quick to patch up a core
and next question is Did you do the needed work in the playerclasslevel And player_xp_for_level tables in the db?
[ I wont answer questions on how to do this because I dont support modding that data..this could mess alot of things up and I will not be responcable for that ]

As for patching that patch



you need a few things

1. The raw source code not compiled
2. The know how to patch using the patch que in a repo
3. The know how to compile the source code once patched

your biggest problem will be #1 because untill everything is back into the new core
I am not pushing the new core to the developer repo

and you will find that the regular core from trinity will throw alot of errors

your best bet is to post information on how to obtain the patch
if it does not mess with the exsisting work we have done to the formulas then it might get implimented
how ever if it does .......
1 we will not support this patch in the core
2 we will not offer support to users who use this patch

theres to much we need to fix and dont need a patch to undo our fixes
So please if you want this possably implimented into the core send us more information on this patch and where we can obtain it

And you would pray for us every day only if we help you patch the core?
0.o

Imo thats the wrong reason to pray lol but hey just my thought on that
I wont go ferther on that so I dont offend anyone whos beliefs are different

I hope this helps shed a little light on things
Lor

[Norxus]

Oh nice... Should I say that I love Lorac and Pryd? hehehehe no no...but thanks alot for your efforts on this repack, you really do a great job on it.

Btw guys, check the commands of the server, beacuse with Rev14b and Rev14c some of them doesn´t work 0.o

If you need help testing something in the server you can count on me for sure, just send a PM.

Best regards!

[rullare]

nice can i get this server but i will have it on 3.1.3 plz.

[Failboat]

Will this repakc ever be released for linux base systems?