DB error

[principino1984]

Hi, I was tryin to uninstall VBshout and another plugin related to vbshout that makes the count of the totla shout made by an user (link) when I got this error as soon as I click on a member public profile.

How can I solve it?

Database error in vBulletin 3.6.7:

Invalid SQL:

    SELECT profilefieldid, required, title, type, data, def, height
    FROM vb_profilefield
    WHERE form = 6 
    ORDER BY displayorder;

MySQL Error  : Unknown column 'title' in 'field list'
Error Number : 1054
Date         : Tuesday, June 5th 2007 @ 02:56:32 PM
Script       : http://www.xtremehardware.it/forum/member.php?action=getinfo&u=238
Referrer     : http://www.xtremehardware.it/forum/
IP Address   : xxxx
Username     : xxxxx
Classname    : vb_database

Thanks Marco

[Floris]

We don't know. Perhaps the uninstall procedure is flaky. Contact the author of this mod for support on uninstalling their addon.

[Marco van Herwaarden]

There is no 'title' column in the profilefield table for default vBulletin 3.6. you are probably using a vBulletin 3.5 modification. Please contact the author for a solution.

[principino1984]

yup...that is right...thats why i was tryin to uninstall it. Since now I had this plugin disabled since I upgraded my vb to 3.6.0 ... but now that i uninstalled i got this wierd problem ...

anyone who already managed this kinda problem?

anyway..i'll try to contact the guy who made this plugin.

[principino1984]

I found luckly the problem... I was lookin aroud for a spared plugin in my forum and i found:

Extra Member Fields

and it has this code:

$profilefields = $db->query_read("
	SELECT profilefieldid, required, title, type, data, def, height
	FROM " . TABLE_PREFIX . "profilefield
	WHERE form = 6 " . iif(!($permissions['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseehiddencustomfields']), "
		AND hidden = 0") . "
	ORDER BY displayorder
");

$search = array(
	'#(\r\n|\n|\r)#',
	'#(<br />){3,}#', // Replace 3 or more <br /> with two <br />
);
$replace = array(
	'<br />',
	'<br /><br />',
);

$customfields2 = '';
while ($profilefield = $db->fetch_array($profilefields))
{
	exec_switch_bg();
	$profilefieldname = "field$profilefield[profilefieldid]";
	if ($profilefield['type'] == 'checkbox' OR $profilefield['type'] == 'select_multiple')
	{
		$data = unserialize($profilefield['data']);
		foreach ($data AS $key => $val)
		{
			if ($userinfo["$profilefieldname"] & pow(2, $key))
			{
				$profilefield['value'] .= iif($profilefield['value'], ', ') . $val;
			}
		}
	}
	else if ($profilefield['type'] == 'textarea')
	{
		$profilefield['value'] = preg_replace($search, $replace, trim($userinfo["$profilefieldname"]));
	}
	else
	{
		$profilefield['value'] = $userinfo["$profilefieldname"];
	}

	if ($profilefield['value'] != '')
	{
		$show['extrainfo'] = true;
		eval('$customfields2 .= "' . fetch_template('memberinfo_customfields') . '";');
	}

}

I just deleted the word "title, " and now it works everythin...right now i disabled this plugin...do you think I'll have no problem oni deletin it right?

thanks a lot anyway for your support!

Marco