[buro9]

Originally Posted by chadi

I dropped "customprofilepic" and then now I get database error when viewing any member profile.

You dropped the whole table?

That's a default vBulletin table, to which this hack merely added two columns. You should've dropped the columns not the table!

The solution is to create a new version of the table:
[sql]
CREATE TABLE IF NOT EXISTS customprofilepic (
userid int(10) unsigned NOT NULL default '0',
picture_id int(10) unsigned NOT NULL auto_increment,
filedata mediumblob NOT NULL,
thumbnaildata mediumtext NOT NULL,
dateline int(10) unsigned NOT NULL default '0',
filename varchar(100) NOT NULL default '',
comment varchar(255) NOT NULL default '',
visible smallint(6) NOT NULL default '1',
filesize int(10) unsigned NOT NULL default '0',
width smallint(5) unsigned NOT NULL default '0',
height smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (picture_id),
KEY userid (userid)
) TYPE=MyISAM AUTO_INCREMENT=1;
[/sql]

And don't drop tables without checking in future!!!