No Monster or NPC's

[munchies]

I got server up and running thanks to the help of Jaystar. I ran all the batch files from the zips on the web site but none of the NPC, Mobs, and the spell and weapon styles are showing up. what did I do wrong?

[Krin]

Did you set the DB connection string, and DB type in the server config to Your SQL stuff? If not chances are they're still reading from the basic XML databases.

[munchies]

Yeah the db connections are set to mysql.

[Krin]

Check your databases make sure things actually went in, also check error logs for anything reguarding the databases.

[munchies]

THe most recent log it gives gives a bunch of errors.

heres a link to the error log


http://www.yourfilehost.com/media.php?c ... rror.log.1

[Krin]

Ok, thoes errors are all telling you that your databases do not exsists.

[munchies]

All the tables the log puts out are filled if data. There were A few that I tired to run that error'd out should I try rerunning them?

[Krin]

If they have data in them, then I have no clue what's going on. From the error log. It says they don't exsist, but the server doesn't create them. Chances are you ran the query's before the server created the tables.

I would try to delete the whole tables, and re-lauch the server so it can create them again. Then run the SQL query's to add the data again.

[munchies]

Tired that earlier, I could try it again and write a list of the ones that don't run the qurys if that would be more of a help. Or could it have some thing to do with the serverproperty tables?

[Krin]

Get a list of the errors that the query's give if they don't run fully also.

[munchies]

Heres the errors and the fil list the file comes first then the errors.

loototd [Msg] Finished - 0 queries executed successfully
loottemplate [Err] 1054 - Unknown column 'Realm' in 'field list'
[Msg] Finished – Unsuccessfully

CraftedItem [Err] 1048 - Column 'CraftingLevel' cannot be null
[Msg] Finished – Unsuccessfully

ItemTemplate [Err] 1062 - Duplicate entry 'alb_bindstone' for key 1
[Msg] Finished – Unsuccessfully

Door [Err] 1054 - Unknown column 'RegionID' in 'field list'
[Msg] Finished – Unsuccessfully

worldobject [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 '250df1cd-efd4-4a69-b1fc-421e59ed0749 DOL.GS.GameStaticItem Alchemy Table 628376 ' at line 1
[Msg] Finished – Unsuccessfully

Zone [Err] 1146 - Table 'daoc.zones' doesn't exist
[Msg] Finished – Unsuccessfully

faction [Msg] Finished - 0 queries executed successfully
linkedfaction [Msg] Finished - 0 queries executed successfully
mob Err] 1054 - Unknown column 'Brain' in 'field list'
[Msg] Finished – Unsuccessfully

[Krin]

Your source is out of date with the latest databases. When you boot your sever up for the fist time the databases only create the tables with the column's they are told to.

Reason -

Code: Select all

mob Err] 1054 - Unknown column 'Brain' in 'field list'
Door [Err] 1054 - Unknown column 'RegionID' in 'field list'
mob Err] 1054 - Unknown column 'Brain' in 'field list'

happens because the database build upon server boot up doesn't have that column.

Get the newest source code and try again.


As for -

Code: Select all

ItemTemplate [Err] 1062 - Duplicate entry 'alb_bindstone' for key 1
[Msg] Finished – Unsuccessfully

Look at the error, duplicate entry - delete one.

And for

Code: Select all

CraftedItem [Err] 1048 - Column 'CraftingLevel' cannot be null
[Msg] Finished – Unsuccessfully

It's saying they are NULL they need to be set.

and -

Code: Select all

Zone [Err] 1146 - Table 'daoc.zones' doesn't exist

No table with the name daoc.zones exsist.


Last but not least -

Code: Select all

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 '250df1cd-efd4-4a69-b1fc-421e59ed0749 DOL.GS.GameStaticItem Alchemy Table 628376 ' at line 1

I downloaded that package and looked at worldobject, it's likely because that query doesn't tell it what to do with the info that is inside. So it has no where to go.

[munchies]

Where can I find the updated databases? I downloaded all the databases from this website.

[Krin]

Thoes are the most recent databases - it's your source code that is out of date with thoes databases.

[munchies]

I downloaded version 1.8 which I though was the newest is there another version?