My server is empty ?

[BrainStorm]

Hi there.. i got this problem that my server has no enemeys or npc's ?

how do i fix this ?

i started as an blood elf paladin..

[Senpuria]

Sounds like you have no creature_template or creature in the database.

Did you setup your database correctly?

[BrainStorm]

i think i did..

so in otherwords i must

re insert the world db ?

[Senpuria]

Indeed where did you get your database from?

[Auntie Mangos]

Didn't you install UDB revision 392 and wanted to upgrade from there? Must have been something gone wrong on the way there.

[BrainStorm]

well ive used git://github.com/mangos/mangos.git

and in ther the sql/ files

i realy cant understand wye this is happening

[Senpuria]

The git you pulled is for the mangos source code, this has nothing to do with the database. And the mangos sqls are only updates for the database, this will not populate it.

http://udb.no-ip.org/

You can grab a full database from UDB, it should be 393, and you'll have to use the update packs to get to 399 which is the latest version.

[BrainStorm]

aaah ty !

well hmm i just know im gonna stamble on errors.. how do i do this ?

apply all the updates that is after the "require_mangos/char/realm_****" data ?

[Auntie Mangos]

1. Download UDB release archives or checkout the sources with Subversion
   
2. Install the world database using the last UDB release, and apply the UDB updates
   
3. Clone the MaNGOS source code from github.
   
4. Compile and install MaNGOS.
   
5. Use the SQL updates folder from MaNGOS source tree and upgrade the realm, world, and character database
   

If desired, add ScriptDevZero to the list, and add a fourth database to the mix.

That is the short route

[BrainStorm]

well thats wye i get errors !..

i have started with importing the sql files in the git source then after applying the UDB.. thanks !

[BrainStorm]

Nope that dosent work eiter i get this

Error occured at:2011-03-18 21:16:52

Line no.:2

Error Code: 1146 - Table 'mangos.character_db_version' doesn't exist

Query:

CREATE FUNCTION `ConvertAuras`(`auras` varchar(1024))

RETURNS varchar(1024) CHARSET utf8

so i get to the part (2) and update the UDB update files..

i get to 399_corepatch_mangos_11157_to_11242.sql

[Senpuria]

It looks like your trying to execute the character database into mangos

hence *mangos.character_db_version*

mangos. = the database you tried to execute into

character_db_version is the table you couldn't find because it should be in characters

[Lynx3d]

As Senpuria mentioned, there's three types of SQL updates, for the three databases you need, mangos (a.k.a. "world"), characters and realmd.

If you don't have any character and realm database content yet, just use the characters.sql and realmd.sql from sources and skip those sql updates.

Those are only needed if you already have those databases from an older revision.

[BrainStorm]

It looks like your trying to execute the character database into mangos

hence *mangos.character_db_version*

mangos. = the database you tried to execute into

character_db_version is the table you couldn't find because it should be in characters

Is this one for charecters ?

399_corepatch_mangos_11157_to_11242.sql

i dont think so

it stands mangos and not charecter

and its that file who gives me the mangos.charecter_db_version error.. wtf !?

[Lynx3d]

that's pretty much impossible if you have that file from UDB SVN, it does not reference character_db_version anywhere...

[Senpuria]

Indeed, but you have to select the database in order for it to execute it into the correct database, otherwise it won't be able to locate.

It looks to me like you've assumed if you have any database highlighted it will automatically place it into the mangos database anyway.

If your using sqlyog, which you should if you followed the instillation guide, right click the mangos database to make sure you have that selected and click on import > from sql dump.

Locate your corepatch and execute it from there.

[BrainStorm]

hmm maaaby i havent selected "mangos" but i think i have !

this is wery weird i think to..

[Senpuria]

I have installed many many databases and that error is 100% wrong database selection when sql dumping

[BrainStorm]

Now im gonna dcument what im doin maby u can see if i do somthing wrong.

First of :

UDB_0.12.1.393_mangos_10545_SD2_1833 import to mangos (selected)

then

trunk\\Updates\\0.12.1_additions\\393_updatepack_mangos import to mangos (selected)

And so on all the way up to 398_updatepack_mangos

now i will do the same to the next one (399_corepatch_mangos_11157_to_11242)

SAME THING AGEN !

[Senpuria]

I suggest if your getting that many errors when trying to update, drop your mangos database and create a fresh

then follow this guide;

http://udb.no-ip.org/index.php/topic,9543.0.html

It should take less time to drop and re execute rather than trying to get rid of the errors

[BrainStorm]

ive droped the database wen ive done this..

and btw so ehm the link u have u must register to see..

[Senpuria]

Well, as this is a database issue which is actually nothing related to mangos, I suggest signing up to the forums of the database you are trying to use.

You'll probably find some information there, but I'll still try and sort your problem out.

You must be executing the files in the wrong order, that thread will show you how to properly execute the sqls in the correct order.