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

Huppy · #1 12-01-2010, 09:41 PM

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** · #2 12-02-2010, 02:56 PM

You need to run 1723's sql

Huppy · #3 12-02-2010, 05:27 PM

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** · #4 12-02-2010, 05:33 PM

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 · #5 03-15-2011, 07:04 AM

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** · #6 03-15-2011, 08:07 AM

All of the individual SQL updates can be found here:

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

**joligario** · #7 03-15-2011, 08:37 AM

Quote:

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 · #8 03-16-2011, 01:20 PM

Thank you both. That worked.

Llyrus · #9 03-16-2011, 01:35 PM

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** · #10 03-16-2011, 01:52 PM

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.

causticsand · #11 03-16-2011, 11:46 PM

I made a stupid mistake the first time I went to Trevius's SVN page. When I right clicked to <save link as> on the SQL files, they didn't want to import into my database. Either of them. I am pretty new to all of this, but decided to open the sql files I downloaded and see what it is they were doing. They were HTML. I had saved the pages that linked to the information, not the actual SQL information itself. If you did what I did, you might click the sql page in the SVN to go to the page that lists the queries an SQL file WOULD do if sourced in. I cut and pasted the commands and now I have bots. Hope this helps.

Llyrus · #12 03-17-2011, 03:19 PM

heh...i fixed it...stupidity seems to run rampant...i dropped all the bot tables and resourced the information and the updates...it works now...and it was because i didn't turn off "stop on errors"

are the bots able to cast spells and should i be able to see the particle effects when they do? a shaman bot seems to be casting, or at least he is making the motion of casting, but i don't think anything is happening