I get an error when I try to do something in battle

Invalid SQL: SELECT field6 FROM userfield WHERE userid='1'
mysql error: Unknown column 'field6' in 'field list'

mysql error number: 1054
vb ver:2.2.8

mli:
You need to add several fields to your `user` table. I am not sure which part of the query failed or why it failed. Can you tell me the name of the last field in your `user` table?

Strider Xero:
What battle options do you have enabled (set to 'Yes')?

jags2ooo:
Make sure that you added the new categories to a default item type. In the admin cp, go to "Edit Item Type" and make sure the categories are associated with an item type.

Yes, it is supposed to say "current" even after you have changed it. This is to reduce queries.

Mrpolish:
What battle options do you have enabled (set to 'Yes')?

Ok, I decided to install ALL OVER AGAIN!!! And everything works alright so far, but when I attack my opponent in battle it gives me this error:

Yes
1.Battle hack is on
2.Give exp to users
3.Do you want a user's power level calculated by and based on their post count?
A user's power level determines ALL of their stats for the battle hack.
No.
Battles are private

mli and Mrpolish:
Did you run "install_itemshop_items.php"?

I did

lol, we're getting the same error jsut noticed that. Sorry for my post I guess. Here are my options:

RPG Name Field: field6
Battle hack: ON
Max # of battles: 0
Battles are Private: No
Post Battle Results: Yes

Power Level determined by post count: Yes
Power Level Modifier: 3
User's Level Field: field7

Give expierence to user for battles: No

Yup, I did

Does it have something to do with the RPG Character's name? Since it complains about field6?

It says Generic, not default, and generic is the only type should there be more?