#1054: Unknown column 'corrup' in 'field list'

[Huppy]

Got this error when using the #bot create (name) (class id) (race id) (gender)

#1054: Unknown column 'corrup' in 'field list'
Unable to save (bot name) as a bot.
Is there a fix or patch for this ?

I'm using 1751 DB from svn. I compiled with bots release and
sourced in the load_bots.sql

[joligario]

You need to run 1723's sql

[Huppy]

Ya, I did that already, got some errors with it, but bots work now.
Trevius stated in one of my other posts that I shouldn't have to do those
sql updates if using a clean install of 1751 db from svn, which is what I
did. (I mean not just updating db, the whole emuserver and DB was wiped
from puter and a totally clean compile done with current svn downloads)

[joligario]

Yes, but if you read the message from cavedude, he didn't apply all the changes to the player tables. He's been real busy.

http://code.google.com/p/projecteqdb/source/detail?r=52

So I suggest you go through all the required updates from 1667 through 1751. Reading your other posts, you need to figure out how to continue running the scripts even if it runs into a duplicate error.

[causticsand]

I am, also, getting this error. I have sourced in 1751. I would like to take your advice and source in the 1723 sql, but I can't find that one. I have looked at the PEQ site and in my 1751 "updates" directory, but I do not see "1723." I am probably not looking in the right spot. Thank you.

[trevius]

All of the individual SQL updates can be found here:

http://code.google.com/p/projecteqem...ls%2Fsql%2Fsvn

[joligario]

Originally Posted by causticsand

I am, also, getting this error. I have sourced in 1751. I would like to take your advice and source in the 1723 sql, but I can't find that one. I have looked at the PEQ site and in my 1751 "updates" directory, but I do not see "1723." I am probably not looking in the right spot. Thank you.

If you are using a build after 1751, then the sql folder is in the eqemu\utils\sql\svn folder. If you are not finding it in the eqemu\utils\sql\svn folder, then you wouldn't need the update because you are not using the build after 1751.

[causticsand]

Thank you both. That worked.

[Llyrus]

i have sourced all the required updates and am using the latest db and server revisions and am getting this error also..any ideas or suggestions as to what I might try?

[joligario]

My guess is you sourced in the updates, but it ran into errors and stopped on duplicates prior to executing the entire script. You should either run each line individually, or turn off halting on errors.