Problem with Itemshop

[ULTIMATESSJ]

I just installed the new itemshop, and everytime i go to make a new reply this comes up

Database error in vBulletin 2.2.5:

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

mysql error number: 1054

Date: Tuesday 25th of June 2002 02:13:05 PM
Script: http://www.animexplosion.com/forums/forums/newreply.php?s=&action=newreply&threadid=965
Referer: http://www.animexplosion.com/forums/showthread.php?s=&threadid=965

The field21 doesn't excist now cause it was deleted, and the new points field is 30, does anyone know what the problem is, or any way of me being able to reset the user profile fields to revert back to the start numbers, i remember that i used some mysql code on the forums to make the points value 0 instead of nothing on field21, so now field21 is gone, i think i keep getting problems on it

[ULTIMATESSJ]

bump

[Velocd]

So basically you need field 30 to be field 21 again? Is there currently a field21 with a value in it? I'm alittle confused..

[ULTIMATESSJ]

Originally posted by Velocd
So basically you need field 30 to be field 21 again? Is there currently a field21 with a value in it? I'm alittle confused..

yup, something like that, field21 was deleted to add the new itemshop in, but i need it again, butwhenever u add a new field it still goes up

[ULTIMATESSJ]

can someone please help me with this, my forums have been down for 3 days and this is killing my hits

[ULTIMATESSJ]

bump, can someone PLEASE help me

[Lesane]

So if the new Itemshop uses field30 then edit newreply.php and probably newthread.php aswell and change field21 to field30.

[ULTIMATESSJ]

no need to worry, i found the changes in phpmyadmin and deleted them, i added some mysql queries for the old itemshop to make it so that it says none instead of nothing, and 0 instead of nothing for points, so i got rid of those and it works now