No Monster or NPC's

For any problems with Dawn of Light website or game server, please direct questions and problems here.

Moderator: Support Team

No Monster or NPC's

Postby munchies » Mon Jun 18, 2007 4:26 am

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?
User avatar
munchies
DOL Novice
 
Posts: 94
Joined: Sun Jun 17, 2007 8:34 am
Yahoo Messenger: ronetx01@sbcglobal.net
Location: Dark Side of the Moon or To close to the Sun

Postby Krin » Mon Jun 18, 2007 4:31 am

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.
Krin
DOL Novice
 
Posts: 61
Joined: Mon May 15, 2006 10:53 pm
Location: Tacoma, Washington

Postby munchies » Mon Jun 18, 2007 4:41 am

Yeah the db connections are set to mysql.
User avatar
munchies
DOL Novice
 
Posts: 94
Joined: Sun Jun 17, 2007 8:34 am
Yahoo Messenger: ronetx01@sbcglobal.net
Location: Dark Side of the Moon or To close to the Sun

Postby Krin » Mon Jun 18, 2007 4:55 am

Check your databases make sure things actually went in, also check error logs for anything reguarding the databases.
Krin
DOL Novice
 
Posts: 61
Joined: Mon May 15, 2006 10:53 pm
Location: Tacoma, Washington

Postby munchies » Mon Jun 18, 2007 5:17 am

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
User avatar
munchies
DOL Novice
 
Posts: 94
Joined: Sun Jun 17, 2007 8:34 am
Yahoo Messenger: ronetx01@sbcglobal.net
Location: Dark Side of the Moon or To close to the Sun

Postby Krin » Mon Jun 18, 2007 5:20 am

Ok, thoes errors are all telling you that your databases do not exsists.
Krin
DOL Novice
 
Posts: 61
Joined: Mon May 15, 2006 10:53 pm
Location: Tacoma, Washington

Postby munchies » Mon Jun 18, 2007 5:28 am

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?
User avatar
munchies
DOL Novice
 
Posts: 94
Joined: Sun Jun 17, 2007 8:34 am
Yahoo Messenger: ronetx01@sbcglobal.net
Location: Dark Side of the Moon or To close to the Sun

Postby Krin » Mon Jun 18, 2007 5:31 am

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.
Krin
DOL Novice
 
Posts: 61
Joined: Mon May 15, 2006 10:53 pm
Location: Tacoma, Washington

Postby munchies » Mon Jun 18, 2007 5:32 am

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?
Last edited by munchies on Mon Jun 18, 2007 5:37 am, edited 1 time in total.
User avatar
munchies
DOL Novice
 
Posts: 94
Joined: Sun Jun 17, 2007 8:34 am
Yahoo Messenger: ronetx01@sbcglobal.net
Location: Dark Side of the Moon or To close to the Sun

Postby Krin » Mon Jun 18, 2007 5:37 am

Get a list of the errors that the query's give if they don't run fully also.
Krin
DOL Novice
 
Posts: 61
Joined: Mon May 15, 2006 10:53 pm
Location: Tacoma, Washington

Postby munchies » Mon Jun 18, 2007 6:00 am

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
User avatar
munchies
DOL Novice
 
Posts: 94
Joined: Sun Jun 17, 2007 8:34 am
Yahoo Messenger: ronetx01@sbcglobal.net
Location: Dark Side of the Moon or To close to the Sun

Postby Krin » Mon Jun 18, 2007 6:13 am

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.
Krin
DOL Novice
 
Posts: 61
Joined: Mon May 15, 2006 10:53 pm
Location: Tacoma, Washington

Postby munchies » Mon Jun 18, 2007 6:31 am

Where can I find the updated databases? I downloaded all the databases from this website.
User avatar
munchies
DOL Novice
 
Posts: 94
Joined: Sun Jun 17, 2007 8:34 am
Yahoo Messenger: ronetx01@sbcglobal.net
Location: Dark Side of the Moon or To close to the Sun

Postby Krin » Mon Jun 18, 2007 6:35 am

Thoes are the most recent databases - it's your source code that is out of date with thoes databases.
Krin
DOL Novice
 
Posts: 61
Joined: Mon May 15, 2006 10:53 pm
Location: Tacoma, Washington

Postby munchies » Mon Jun 18, 2007 6:39 am

I downloaded version 1.8 which I though was the newest is there another version?
User avatar
munchies
DOL Novice
 
Posts: 94
Joined: Sun Jun 17, 2007 8:34 am
Yahoo Messenger: ronetx01@sbcglobal.net
Location: Dark Side of the Moon or To close to the Sun


Return to “%s” Support

Who is online

Users browsing this forum: No registered users and 1 guest