MyBB Community Forums

I have this plugin installed on a site I managed. It was working fine until today.

I did a plugin update check and it said there was a new version (1.0) and I should download it. So I did.

This is for the PC version in the file.

I installed it, tried to deactivate and I get this error:

Quote:MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1091 - Can't DROP 'fid'; check that column/key exists
Query:
ALTER TABLE mybb_userfields DROP fid

I compared the old file with the newly downloaded one and it seems they both say v. 0.1 in there. FYI - all of them say (Xbox 360) version where you see it.

Copied from "old" file on server now.

Quote:function mybc2_info()
{
return array(
"name" => "mybc2",
"description" => "Display a user's BC2 stats in their profile. (XBox 360 Version)",
"website" => "http://www.360elites.net",
"author" => "euantor",
"authorsite" => "http://www.360elites.net",
"version" => "0.1",
"guid" => "ce3fbbe73deb81dcdaf8affd30811e9a",
"compatibility" => "*"
);
}

function mybc2_activate()
{
global $mybb, $db;

$profilefield = array(
"fid" => "",
"name" => "PC ID",
"description" => "Your ID in Battlefield bad Company 2 on the PC",
"type" => "text",
"maxlength" => "50",
"editable" => "1",
"hidden" => "1",
);

Copied from new file in folder:

Quote:function mybc2_info()
{
return array(
"name" => "mybc2",
"description" => "Display a user's BC2 stats in their profile. (XBox 360 Version)",
"website" => "http://www.360elites.net",
"author" => "euantor",
"authorsite" => "http://www.360elites.net",
"version" => "0.1",
"guid" => "ce3fbbe73deb81dcdaf8affd30811e9a",
"compatibility" => "*"
);
}

function mybc2_activate()
{
global $mybb, $db;

$profilefield = array(
"fid" => "",
"name" => "PC ID",
"description" => "Your ID in Battlefield bad Company 2 on the PC",
"type" => "text",
"maxlength" => "50",
"editable" => "1",
"hidden" => "1",
);

Does anyone know how to correct this issue?
Does anyone know why the two files say the same thing?
Any help would be appreciated.

Sorry about this, I'll supply a new version asap. I've been meaning to update the plugin anyway. I think I know what the problem is.

Sweet thanks.

What you're going to fix will sort out that error too?

It'll sort out both errors and provide a few small enhancements if I get time to add them

Has this been fixed and uploaded yet? I haven't been on the board in awhile and just came straight here to look/check.