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

[Timmy420]

When I attempt to run worldserver it opens than quickly closes. I dunno what I am doing wrong. I set it up to make a log file but the log file dosent say anything at all.

[drazy]

Hey, I last played with a prydev server last summer; how have things changed since then? For example, how are the raid instances these days? Back then for the most part things were in good shape, apart from some issues with Ulduar that iirc made it impossible to complete.

Still got my old installation for now, I don't suppose there'd be any issues with importing my characters from that to the latest version?


And I realize this isn't strictly related, but does anyone know of a database site like wowhead that'd still have pre-cata data only? There's mods for loot tables and stuff of course, but what I'm mostly interesting is the uncategorized/NPC spells - they make solo raiding much more fun.



Great to see the team still hard at work btw., kudos for your efforts!

[starwolf64]

Timmy420 it's probably due to not having either your characters or world database versions up to date or compatible with one another. The character db has to be supported by the world db or the worldserver.exe will crash, I know because it's happened to me. If you're using older character/world dbs and are updating than it can sometimes be a mess, just import the character and world databases (and auth unless youre updating) within prydevserver/core/pds-10969/sql/base folder and everything "should" work. My log file doesn't seem to record any problems either that's why updating can be a bit tricky.

drazy I'm thinking that as long as you stick to the prydev repack updating shouldn't be a problem unless there's been a major overhaul... I could be totally wrong though.

[Timmy420]

Yea that's prolly my problem. Sucks tho cause the sql files from the pry folder takes forever to execute!

[starwolf64]

Use SQLyog (world db shouldn't take more than a minute), navicat sucks and takes for ever when restoring the databases.

[jammie]

Hey,

I think this is a nice repack, good job guys. When I start world then it will close after 5 seconds with this error:

2011-01-22 16:33:10 ERROR: Error in gameobject_template table, probably sql file format was updated (there should be 42 fields in sql).

I use the newest database of PryDevServer, that's PDS-4TC_v5a I think?
And I use this world database of v5a = PDS-4TC_tdb_v5a_blizzlike.

Can someone help me with this problem?

Thank you very much!

Jamie

---------- Post added at 10:51 AM ---------- Previous post was at 10:41 AM ----------

It is already working, I did something wrong, because I mixed some databases =P
But I have a question, is V5 the newest repack?
Thnxx
Jamie

[leso]

Hello i have following error when i make the configuration for the visual studio project map with cmake

WARNING - No revision-information found

* TrinityCore revision : 0 (Archive)

i have Download the latest pryd core Files with svn.

Have somebody some idea? I will have the Rev in core ^^ with normal Trinity Core Source from Git it will works Fine
Sry for bad english ^^

[marko94]

Uhm, I can't download the server cause ur download link sends me to download some custom fun database witch is 12mb and i noticed on ur tutorial that u are sayin u need to download my file and u opened some file that is 60+ mb and none of ur links send me to download such file.

EDIT: Nvm now I found it

[elementalseraph]

Hm, getting this error when I try to boot up the worldserver (in bold red):

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Ultracore\Stable>worldserver
Using configuration file worldserver.conf.
TrinityCore Rev: 0 Release Hash: Archive (Win64, little-endian) (core-daemon)
<Ctrl-C> to stop.

. . .
. .
____ . \ / .
/\ / \ . - ^ -
\ \_ / . / | \ . .
\ \\ _ .
\ \\ \// _ _ /\ __
\ \\ \\ \\ // /`'\ \__ \ /
\//__\\ \\// /____\ \__ \/
_____// ````````
/\ ___\ PDS-CC-2010
\ \ \__/ ______ _ __ _____
\ \ \ /\ __ \/\`'__\/\ __\
,, \ \ \___\ \ \_\ \ \ \_/\ \ \//_
_/\_|_____\ \_____\ \_____\ \_\ \ \____\
` ` ` ` ` \______/\/_____/\/_/ \/____/

PDS-CC Core based on TrinityCore
PDS Project Resource Locations
Main: Http://prydevserver.com
Repo: Http://sf.net/projects/prydevserver
Forum: Http://prydevserver.com/ultracore/forum
PryDevServer.com Development for the Community
Opening databasepool 'world'. Async threads: 1, synch threads: 1
MySQL client library: 5.1.50
MySQL server ver: 5.1.51-community
[WARNING] MySQL client/server version mismatch; may conflict with behaviour of p
repared statements.
MySQL client library: 5.1.50
MySQL server ver: 5.1.51-community
[WARNING] MySQL client/server version mismatch; may conflict with behaviour of p
repared statements.
Databasepool opened succesfuly. 2 total connections running.
Opening databasepool 'characters'. Async threads: 1, synch threads: 2
MySQL client library: 5.1.50
MySQL server ver: 5.1.51-community
[WARNING] MySQL client/server version mismatch; may conflict with behaviour of p
repared statements.
[ERROR]: In mysql_stmt_prepare() id: 27, sql: "SELECT creatorGuid, giftCreatorGu
id, count, duration, charges, flags, enchantments, randomPropertyId, durability,
playedTime, text, bag, slot, item, itemEntry FROM character_inventory ci JOIN i
tem_instance ii ON ci.item = ii.guid WHERE ci.guid = ? ORDER BY bag, slot"
[ERROR]: Unknown column 'itemEntry' in 'field list'
~DatabaseWorkerPool for ''.
~DatabaseWorkerPool for 'characters'.
~DatabaseWorkerPool for 'world'.

C:\Ultracore\Stable>

I wasn't 100% sure which sqls needed to be imported, so this is what I did:

- Cmake'd the core files
- Cleaned solution, then built
- Created auth, world and character DBs in MySQL
- Loaded auth and character sqls from core/sql/PryDevCore_Addons/Full_World/Charcter_Database and ""/LoginAuth_Database
- Loaded latest YTDB Custom sqls into world DB
- Updated using sqls from /core/sql/updates
- Loaded sqls from /core/sql/PryDevCore_Addons (Full_world/Full_NPC_ScriptNames.sql, /Essential_sqls, /non-essential_sqls)
- Loaded sqls from /core/sql/Bots

Then I set up the conf files and tried to run. Authserver booted up fine; Worldserver threw the above error and crashed.

Any ideas? Any help would be appreciated...

[jammie]

Hey!

V5 is the newest version of this repack, isn't?
When will come the update to V6 =)
Great repack! +1

[elementalseraph]

OK, looks like I solved the previous issue by using the auth and char DBs from the /core/sql/base folder instead of the PryDevCore_Addons folder... new question, though. How do I go about truncating TDB character tables to work with YTDB? I tried to export under a drop/create, delete-insert (Truncate) rule, but it didn't seem to work.

Thanks in advance for any help...

[drazy]

Right, got the server running - I see the Horde mall (Stratholme) still has Alliance trainers for classes and skills. Is there any quick way to change this or did I just mess something up?

[Germo]

You could .npc del them and respawn the real hord trainers insted. If you use the admin tool that came along, you can easy make a search for the right npc. Just an idea.
I had them too. You didnt do anything wrong. It took me 5 min. Then i found the right trainers and replaced the wrong ones.

Cheers Germo

[Nimogrea]

When I download it I only get a SQL file, am I doing something wrong?

[drazy]

You could .npc del them and respawn the real hord trainers insted. If you use the admin tool that came along, you can easy make a search for the right npc. Just an idea.
I had them too. You didnt do anything wrong. It took me 5 min. Then i found the right trainers and replaced the wrong ones.

Cheers Germo

Ah I never fiddled around with the .npc commands last time I played - if I just use .npc add the character will stick in the realm then (as opposed to being temporary 'summon' until server resets)?

Edit: Seems to work fine.

Oh and what tool is that if you don't mind me asking? PDS-4TC_v5a.rar is the only thing I downloaded and it didn't come with any, tho I still have the TrinityAdmin 3.3.2 rev.019 from my previous install that seems to work fine.