images not showing + DB error deleting members

okay the first problem i have is that the battle scenes arent showing up. they are in the correct place on the server and show up when clicking preview - however they dont show up in actual battle.

the second and more serious problem is when i try to delete a member from admincp - i get the following error:

Database error in vBulletin 3.0.7:

Invalid SQL: 
			UPDATE `socitvkx_user`
			SET `clan` = '0'
			WHERE `clanid` = ''
		
mysql error: Unknown column 'clanid' in 'where clause'

mysql error number: 1054

Date: Wednesday 20th of July 2005 03:05:39 AM
Script: http://www.socialoutkast.com/forum/admincp/user.php
Referer: 
Username: biagrin
IP Address: **************

this error also messes with the last name of the last registered user on forumhome.

any help is very appreciated

[biagrin]

:nervous: *bump*

[Revan]

A wee error in the file.
Im sending out update instructions soon.

[biagrin]

cool - thanks for getting back to me.

ive tried the update but i still get the same error

[Revan]

++++, it was the wrong file.
includes/adminfunctions.php
Sorry about that.