[Error Message] Warn on postbit

[MYBB GHOST]

I get an error message when trying to warn a user from the warn button on the post bit;

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'w.pid' in 'where clause'
Query:
SELECT w.*, t.title AS type_title, u.username FROM mybb_warnings w LEFT JOIN mybb_warningtypes t ON (t.tid=w.tid) LEFT JOIN mybb_users u ON (u.uid=w.issuedby) WHERE w.pid='733' ORDER BY w.expired ASC, w.dateline DESC

[MYBB GHOST]

Any help here?

[Arbaz]

Seems like a plugin issue. What plugins did you recently activate?

[MYBB GHOST]

Seems like a plugin issue. What plugins did you recently activate?

I haven't activated or installed any recently...

[Arbaz]

Oh. Well try disabling all your plugins and check if it helps.

Go to ACP>Configuration>Settings>General>Disable All Plugins

If it does then provide a list of all your installed plugins.

[MYBB GHOST]

Oh. Well try disabling all your plugins and check if it helps.

Go to ACP>Configuration>Settings>General>Disable All Plugins

If it does then provide a list of all your installed plugins.

I get the same error...

[effone]

1. Try restoring original "warnings.php".
2. Make sure table "mybb_warnings" is present and not corrupted in your database.
3. The column pid (4th, int(10)) is present in the table (not dropped).

[MYBB GHOST]

1. Try restoring original "warnings.php".
2. Make sure table "mybb_warnings" is present and not corrupted in your database.
3. The column pid (4th, int(10)) is present in the table (not dropped).

The pid (4th, int(10)) is not their, so what do I do?

[effone]

If the warning table is empty you can add the column manually, or drop the table and create fresh. Something like this:

CREATE TABLE `mybb_warnings` (
  `wid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `tid` int(10) unsigned NOT NULL DEFAULT '0',
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `title` varchar(120) NOT NULL DEFAULT '',
  `points` int(10) unsigned NOT NULL DEFAULT '0',
  `dateline` bigint(30) NOT NULL DEFAULT '0',
  `issuedby` int(10) unsigned NOT NULL DEFAULT '0',
  `expires` bigint(30) NOT NULL DEFAULT '0',
  `expired` int(1) NOT NULL DEFAULT '0',
  `daterevoked` bigint(30) NOT NULL DEFAULT '0',
  `revokedby` int(10) unsigned NOT NULL DEFAULT '0',
  `revokereason` text NOT NULL,
  `notes` text NOT NULL,
  PRIMARY KEY (`wid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

If there are existing warning entries, I'm afraid you've lost a bit of data.

If you have old db backup then open it and try restoring only 'warnings' table from it.