I get an error message when trying to warn a user from the warn button on the post bit;
Quote: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
Seems like a plugin issue. What plugins did you recently activate?
(2013-07-31, 10:49 PM)Arbaz Wrote: [ -> ]Seems like a plugin issue. What plugins did you recently activate?
I haven't activated or installed any recently...
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.
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).
(2013-08-02, 04:40 AM)effone Wrote: [ -> ]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?
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.