NWN Server log errors.. PLEASE HELP...

Jaguar · Post by **Jaguar** » Tue Oct 12, 2004 6:23 am

I just need someone to look at this log and let me know how to handle it... The custom creator is still not working and I added all the items from the treasure table txt into the sql database but still seeing treasure errors..... You will see the errors below.. ALSO, is there a crafting SQL txt pull to populate the tables? let me know if I missed anything here....

[Tue Oct 12 00:41:20] Loading Module: The World of Etheria_CoPaP
[Tue Oct 12 00:41:20]---- Server Options ----
Max Players: 16
Char Levels: (1-40)
Player Password: YES
DM Login Enabled: NO
Server Admin Login Enabled: YES
Post Game To Internet: YES
Game Type: PW Action
Difficulty: 2
PVP Setting: FULL
Vault: SERVER
Only One Party: NO
Enforce Legal Characters: YES
Item Level Restrictions: YES
Player pausing: DISABLED
Auto Save: Enabled
Saving Characters in Saved Game
---- End Server Options ----
.[Tue Oct 12 00:42:00] L404_SR: Initializing subraces.
[Tue Oct 12 00:42:00] L404_SR: Finished initializing subraces.
[Tue Oct 12 00:42:00] ars: AddSkills added 0 tradeskills.
[Tue Oct 12 00:42:01] ars: AddRecipes added 0 recipes.
[Tue Oct 12 00:42:01] Treasure Drop, Not PC: NW_IT_GOLD001
[Tue Oct 12 00:42:01] Treasure Drop, Not PC: NW_IT_GOLD001
[Tue Oct 12 00:42:01] Treasure Drop, Not PC: nw_it_trap043
**DESIGN***
******it_sparscr510 is an invalid item template. Please report as bug to Brent.
*******
[Tue Oct 12 00:42:01] Treasure Drop, Not PC: it_sparscr510
**DESIGN***
******it_sparscr662 is an invalid item template. Please report as bug to Brent.
*******
[Tue Oct 12 00:42:01] Treasure Drop, Not PC: it_sparscr662
[Tue Oct 12 00:42:01] Treasure Drop, Not PC: NW_IT_GOLD001
[Tue Oct 12 00:42:01] ars: AddIngredients added 0 ingredients.
[Tue Oct 12 00:42:01] Treasure Drop, Not PC: NW_IT_GOLD001
[Tue Oct 12 00:42:01] Treasure Drop, Not PC: NW_IT_GOLD001
[Tue Oct 12 00:42:01] Treasure Drop, Not PC: NW_IT_GOLD001
[Tue Oct 12 00:42:01] Treasure Drop, Not PC: nw_it_gem013
[Tue Oct 12 00:42:01] Treasure Drop, Not PC: NW_IT_GOLD001
[Tue Oct 12 00:42:01] Treasure Drop, Not PC: NW_IT_GOLD001
.[Tue Oct 12 00:42:11] Treasure Drop, Not PC: nw_it_gem008
[Tue Oct 12 00:42:11] Treasure Drop, Not PC: NW_IT_GOLD001
**DESIGN***
******it_sparscr302 is an invalid item template. Please report as bug to Brent.
*******
[Tue Oct 12 00:42:11] Treasure Drop, Not PC: it_sparscr302
[Tue Oct 12 00:42:11] Treasure Drop, Not PC: nw_it_gem007
**DESIGN***
******it_sparscr628 is an invalid item template. Please report as bug to Brent.
*******
[Tue Oct 12 00:42:11] Treasure Drop, Not PC: it_sparscr628
[Tue Oct 12 00:42:11] Treasure Drop, Not PC: nw_wammbo004
[Tue Oct 12 00:42:11] Treasure Drop, Not PC: nw_it_mneck001
[Tue Oct 12 00:42:12] Treasure Drop, Not PC: nw_it_mneck001
[Tue Oct 12 00:42:12] Treasure Drop, Not PC: NW_IT_GOLD001
[Tue Oct 12 00:42:12] Treasure Drop, Not PC: nw_it_gem005
[Tue Oct 12 00:42:12] Treasure Drop, Not PC: nw_it_mpotion018
[Tue Oct 12 00:42:12] Treasure Drop, Not PC: NW_IT_GOLD001
[Tue Oct 12 00:42:12] Treasure Drop, Not PC: NW_IT_GOLD001
**DESIGN***
******it_sparscr661 is an invalid item template. Please report as bug to Brent.
*******
[Tue Oct 12 00:42:12] Treasure Drop, Not PC: it_sparscr661
[Tue Oct 12 00:42:12] Treasure Drop, Not PC: NW_IT_GOLD001
[Tue Oct 12 00:42:12] Treasure Drop, Not PC: NW_IT_GOLD001
[Tue Oct 12 00:42:13] Treasure Drop, Not PC: nw_wammbo001
[Tue Oct 12 00:42:13] Treasure Drop, Not PC: NW_IT_GOLD001
[Tue Oct 12 00:42:13] Treasure Drop, Not PC: nw_it_gem004
......................................Connection Attempt made by Jaguar-LOA (FFUXF7WR)
[Tue Oct 12 00:48:32] Jaguar-LOA (FFUXF7WR) Joined as Player 1
.[Tue Oct 12 00:48:42] Invalid character - player login refused. Character race is a non player race. Player Name: Jaguar-LOA Player ID: 0 Character: tondashaleneset (FFUXF7WR) (QMAJHTQK) (93TH3LFV)
........[Tue Oct 12 00:50:00] Creature armor not found.
[Tue Oct 12 00:50:00] Command to follow this line:
L404EXECUTE:autoelc -player Jaguar-LOA -result_row 1 -confirmation_code l40419222 -validation_results_file l404_validation.2da
[Tue Oct 12 00:50:00] ERROR in PC Skin system, blueprint: NO_PC_HIDE does not exist.
.[Tue Oct 12 00:50:12] Validation result for .Autobic Test 2 After all table creation: PASS [Autobic Test 2 After all table creation]
......[Tue Oct 12 00:51:10] L404_SR: Booting Jaguar-LOA to modify saved character file (Gold%20Dwarf).
[Tue Oct 12 00:51:10] L404_SR: Command to follow this line:
L404EXECUTE:autobic -subrace Gold%20Dwarf -player Jaguar-LOA
[Tue Oct 12 00:51:10] Jaguar-LOA Left as a Player (0 players left)
[Tue Oct 12 00:51:10] Exiting object was not a PC
..Connection Attempt made by Jaguar-LOA (FFUXF7WR)
[Tue Oct 12 00:51:30] Jaguar-LOA (FFUXF7WR) Joined as Player 1
[Tue Oct 12 00:51:35] Invalid character - player login refused. Invalid ability scores. Player Name: Jaguar-LOA Player ID: 0 Character: autobictest2afte (FFUXF7WR) (QMAJHTQK) (93TH3LFV)
...[Tue Oct 12 00:52:00] Invalid character - player login refused. Invalid ability scores. Player Name: Jaguar-LOA Player ID: 0 Character: autobictest2afte (FFUXF7WR) (QMAJHTQK) (93TH3LFV)
[Tue Oct 12 00:52:02] Invalid character - player login refused. Character race is a non player race. Player Name: Jaguar-LOA Player ID: 0 Character: half-orcbarbtest (FFUXF7WR) (QMAJHTQK) (93TH3LFV)
........[Tue Oct 12 00:53:22] Creature armor not found.
[Tue Oct 12 00:53:22] Command to follow this line:
L404EXECUTE:autoelc -player Jaguar-LOA -result_row 2 -confirmation_code l40430375 -validation_results_file l404_validation.2da
[Tue Oct 12 00:53:22] ERROR in PC Skin system, blueprint: NO_PC_HIDE does not exist.
....[Tue Oct 12 00:53:59] ERROR: No ELC check results found after 6 checks. Please report to server admin.
...........[Tue Oct 12 00:55:46] L404_SR: Booting Jaguar-LOA to modify saved character file (Wild%20Elf).
[Tue Oct 12 00:55:46] L404_SR: Command to follow this line:
L404EXECUTE:autobic -subrace Wild%20Elf -player Jaguar-LOA
[Tue Oct 12 00:55:46] Jaguar-LOA Left as a Player (0 players left)
[Tue Oct 12 00:55:46] Exiting object was not a PC
..Connection Attempt made by Jaguar-LOA (FFUXF7WR)
[Tue Oct 12 00:56:08] Jaguar-LOA (FFUXF7WR) Joined as Player 1
.[Tue Oct 12 00:56:19] Invalid character - player login refused. Invalid ability scores. Player Name: Jaguar-LOA Player ID: 0 Character: autobictest3 (FFUXF7WR) (QMAJHTQK) (93TH3LFV)
.[Tue Oct 12 00:56:33] Jaguar-LOA Left as a Player (0 players left)

Mistcaller · Post by **Mistcaller** » Tue Oct 12, 2004 9:18 am

Enforce Legal Characters: YES
Item Level Restrictions: YES

The first should be turned off when you use autobic and custom ecl.
The second should be turned off too, if you use the custom ILR checker.

About the treasure log results, it seems to me that somewhere in teh mod there might be a faction problem where some NPCs fight each other and drop treasure. Probably in death planes if you have some? Dont know...

Jaguar · Post by **Jaguar** » Tue Oct 12, 2004 11:46 am

Ok COOL…. I can change the ELC and ILR very easily…. I thought I had to have those on for the AVLIS/Abyss Custom Creator to work. Hmmm…. Wish I had known that..

ALSO, what version of RG’s Custom Creator should I use? I am running 1.61 now…. Just found the update last night..
If you have a later version can you email that to me? PLEASE…

Ok next, thing.. the Treasure drops are controlled by BESIE a custom encounter package… I can easily just default the treasure drops… BUT BESIE doesn’t change the factions…..
How can I handle this?
If I were to place the monsters as normal and use on heartbeat scripts for encounters would that work? You see, BESIE does not use Heartbeat scripts for encounters… and that is where the faction problem is coming in (if that is the problem) The placeable for encounters is invisible and holds it’s own faction. Do those factions carry thru is the idea…. I dunno… I DO like BESIE cause it runs like a MMORPG for random encounters….

As far as Death planes.. I know my colleague add a area where you get transported to on death. We use the Avlis on death script.

ANY insight would be helpful….

Mistcaller -I WANT TO THANK YOU FOR YOUR HELP SO FAR…..

Jaguar

Jaguar · Post by **Jaguar** » Tue Oct 12, 2004 2:26 pm

AWESOME Mistcaller…. The ELC and ILR are working and I can create custom characters now….

Now to tackle the treasure problem…
Hey, do you know where I can find the SQL Create/Population scripts for the crafting system?

dougnoel · Post by **dougnoel** » Tue Oct 12, 2004 2:47 pm

Jaguar wrote:Hey, do you know where I can find the SQL Create/Population scripts for the crafting system?

I'm not in front of the right computer ATM, but I believe it's ars_include.

Jaguar · Post by **Jaguar** » Tue Oct 12, 2004 3:00 pm

Dougnoel I dunno if that will help me…. I am running SQL server and need the SQL code to pump and the crafting recipes into the Table I created in SQL.

I know when doing the treasure table There was the Create code for the table and then the listing of all the items code to do the insert in SQL into the table

I hope I didn’t confuse anyone…. I just want to know is this code text file exists?

Thank you ahead of time…

teleri · Post by **teleri** » Tue Oct 12, 2004 9:34 pm

Jag,

I have copies of these files and will send them to you when I return to my house 17 October. Or someone Else can get them to you if they can do so faster.

Cheers,
teleri

Cromwell · Post by **Cromwell** » Tue Oct 12, 2004 10:01 pm

Just go to the Avlis FTP.

IT has all the DB tables in text files.

teleri · Post by **teleri** » Tue Oct 12, 2004 10:24 pm

Cromwell wrote:Just go to the Avlis FTP.

IT has all the DB tables in text files.

I was never able to find them there. Nor was anyone ever able able to point me to them including Themi who also looked for them.

Would love to find them there though. (:

Cheers,
teleri

Guest · Post by **Guest** » Tue Oct 12, 2004 10:28 pm

I got all of them fine, so unless they were deleted, they are all there.

Jaguar · Post by **Jaguar** » Tue Oct 12, 2004 10:34 pm

Thank you Teleri....

Did any of you pump all of this data into the tables manually? OR did you use a script to automate the process?

Just curious.... Hell, I am estatic that I got the creator running.... That is a milestone....

Cromwell · Post by **Cromwell** » Wed Oct 13, 2004 11:52 am

When i get home in a few hours i will shoot them over your way. I just pulled up a console and opened up mysql, viewed the nwn DB and simply cut and paste the create table statements from the textfile. Then you just hit enter, and away you go. Its relatively simple.

Guest · Post by **Guest** » Wed Oct 13, 2004 12:06 pm

That is AWESOME Cromwell....

Maybe a few of us can help Teleri gethis documentation up to par on this....

It would make it a lot easier for someone coming in if the ftp site was more organized and there was docs supporting the steps needed to get all this up and running.....

Again, I need the Crafting tables (just to make sure we are on the same page.. hehehe.. I know my pages are a bit fuzzy)
Also, if there is any other code you think I would need it would be greatly appreciated...

At this point, after struggling so much, I welcome ANY AND ALL HELP.....

Thank you ahead of time Cromwell....

Jaguar

dougnoel · Post by **dougnoel** » Wed Oct 13, 2004 12:55 pm

Oooh....I misunderstood. I thought you were interested in the code that loaded the tables. I did not realize you wanted the data in the tables themselves. But looks like you're all set now.

Jordicus · Post by **Jordicus** » Wed Oct 13, 2004 1:03 pm

as for this message:

Code: Select all

Treasure Drop, Not PC:

i have found a few mistakes in nw_io_coinclude (or whatever it's named) this particular mistake is that the code is incorrectly checking the placeable object to see if it's a PC, which will be true of course, so it generates this message instead of writing to the item_tracking table.

i have that issue fixed in Ferrell, but I am also trying to debug a few other issues before I release the fixed version.