[burntire]

Just remove the problem query from the uninstall code in manage products section. I used this to remove.

$db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` IN(51,52,53,54,55,56,57,58,59,60,61,62,63,64,65)");
	$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "userfield` DROP `field50`,	DROP `field51`, DROP `field52`, DROP `field53`, DROP `field54`, DROP `field55`, DROP `field56`, DROP `field57`, DROP `field58`, DROP `field59`, DROP `field60`, DROP `field61`, DROP `field62`, DROP `field63`, DROP `field64`, DROP `field65`");
	$db->query_write("OPTIMIZE TABLE " . TABLE_PREFIX . "userfield");
	require_once(DIR . '/includes/adminfunctions_profilefield.php');