#1054 unknown column 'HP' in field list

oslander · #1 03-08-2012, 05:38 AM

Have everything at 2106, updated the entire folder tonight. I'm still getting this error when trying to create bots on my new server. Is there a fix for this? I found a couple threads with people who had the same issue and they updated their database and it was gone.. I am fully updated and it still remains.

Database Error?? #1054 unknown column 'HP' in field list

**bad_captain** · #2 03-08-2012, 10:01 AM

Check utils/sql/svn folder for 2087_required_bots_hp_and_mana_and_spell_updates.s ql.

That should fix you up.

mcast · #3 03-10-2014, 09:37 AM

I did a search for this error I was getting and found this thread. I did what was suggested and got rid of the "#1054 unknown column 'HP' in field list".

I'm now getting "#1054 unknown column 'Corrup' in field list, anyone able to help me?

sql files I've already sourced into the database:

/utils/sql/svn/bots.sql
/utils/sql/svn/2087_required_bots_hp_and_mana_and_spell_updates.s ql
/utils/sql/svn/2107_required_bot_stances.sql
/utils/sql/svn/2164_require_bots_bottimers.sql

What am I missing?

werebat · #4 03-10-2014, 10:14 AM

1723 will fix it

mcast · #5 03-10-2014, 10:34 AM

Quote:

Originally Posted by werebat

1723 will fix it

worked, thanks

**Uleat** · #6 03-10-2014, 01:30 PM

Just a note for anyone creating a new database with bots enabled...

The most likely cause of this 'unknown column HP' error is a result of sourcing in the incorrect bot.sql file.

The one you need is in the old peq SVN repository, and is titled 'load_bots.sql' - not 'bots.sql' as is found in the EQEmu got repository.

Using the old source file (or updating an older database incarnation) will likely result in the 'unknown column Corrup' error, listed above, as well
and it will need to be patched.