Updated today and have naked char's :-)

[gaeorn]

Yup, make clean before building took care of it. Stupid dependencies... (mutter grumble).

[Xelaan]

make clean fixed my inventory problem as well. Thank you! One more thing I have learned.

However, I have a new problem. I cannot cast any spells. I get an Arguement out of range when I try to cast a spell. It gives me that error if I try to cast a spell from my spell gem, or if I try to use the #castspell command as well.

Any thoughts for this one?

[cavedude]

I had the same problem, try:

update spells_new set teleport_zone='' where teleport_zone is null;
update spells_new set you_cast ='' where you_cast is null;
update spells_new set other_casts ='' where other_casts is null;
update spells_new set cast_on_you ='' where cast_on_you is null;
update spells_new set cast_on_other ='' where cast_on_other is null;
update spells_new set spell_fades ='' where spell_fades is null;

Or, just grab the newest PEQ database and use that spells_new table.

[Xelaan]

I tried both solutions, I tried entering the SQL to update the table, problem still existed.

I then did another drop_system.sql and sourced in the 669 version of the database.

I am still getting these messages in game.

You say, '#castspell 278'
Error: #castspell: Arguement out of range

Beginning to memorize Spikecoat...
Unexpected error: spell id out of range

[nosfentora]

Try using #findspell - see if it says spells not loaded.

[Xelaan]

You called it, it says Spells not loaded when I tried to do a #findspell.

When I looked into my DB I can see the spells_new table is populated with 14,000+ rows of data.

Do I need to set something else someplace?

[nosfentora]

yea i was having the same problem and i couldn't figure out why (still can't). i had to recompile my binaries, setting the server to load spells from the files instead of the db table.

i just updated to the 679 binaries, compiled (with database spells) and it works. you may want to either re-download the source and re-compile, or download the compiled binaries.

Someone plz correct me if the pre-compiled binaries are not database spell table enabled.

[Yeormom]

Originally Posted by cavedude

I had the same problem, try:

update spells_new set teleport_zone='' where teleport_zone is null;
update spells_new set you_cast ='' where you_cast is null;
update spells_new set other_casts ='' where other_casts is null;
update spells_new set cast_on_you ='' where cast_on_you is null;
update spells_new set cast_on_other ='' where cast_on_other is null;
update spells_new set spell_fades ='' where spell_fades is null;

I ran into this same issue. What is interesting about it crashing in zone/net.cpp when trying to strcpy a null result row is if you change the select statement from order by ascending to descending, it works just fine. This little quark has me scratching my head. :(

Performing a sanity check before copying a null in works just fine but I'm more curious as to what caused this change to appear mroe than anything. Also wish I had not seen the "select *" statement used to populate spells...