In phpmyadmin v2.2.2, here is the manual way of changing the field name:
- Click on your vBulletin Database so that the list of tables drops down.
- Click on the table called `items_user`
- In the far left column, look for a field called "Item3". Click on the "Change" link across from this field. It should bring you to a screen that lets you change the name of the field.
- Change the name of the field from "Item3" to "item3".
- Click "Save". The field name should now be correct.
If you are running a different version, or can't figure it out, then here is another way to change it:
In your vBulletin database, run the following query:
Code:
ALTER TABLE `items_user` CHANGE `Item3` `item3` CHAR(250) DEFAULT 'No Item' NOT NULL
One of those two methods should work.