MyBB Community Forums

Hello,
I can not purge or delete any user. When I try to purge or delete any user I get a SQL error.



Also in forum index page Who's Online section it shows low active users.

Pls can anyone help me on this?

Thanks.

Turn on the display of errors (error logging) to have an explicit error message.

(2023-04-04, 04:51 AM)Crazycat Wrote: [ -> ]Turn on the display of errors (error logging) to have an explicit error message.

Thank you for reply. Here is the error.

Self explanatory : a table seems to be missing.
Which version of MyBB do you use ? How did you install it ?

(2023-04-04, 06:05 AM)Crazycat Wrote: [ -> ]Self explanatory : a table seems to be missing.
Which version of MyBB do you use ? How did you install it ?

Mybb version: 1.8.33 
I normally install it by seeing tutorial. I think it happen when i backup my database.
can i create table manually? do you know how can I do it?

You can create it manually, but if this table is missing, some others may be too.

can you pls tell me how can i create this one?
Thanks

The SQL to create the structure is:

CREATE TABLE `mybb_warnings` (
  `wid` int(10) UNSIGNED NOT NULL,
  `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` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `issuedby` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `expires` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `expired` tinyint(1) NOT NULL DEFAULT 0,
  `daterevoked` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `revokedby` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `revokereason` text NOT NULL,
  `notes` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

ALTER TABLE `mybb_warnings`
  ADD PRIMARY KEY (`wid`),
  ADD KEY `uid` (`uid`);

ALTER TABLE `mybb_warnings`
  MODIFY `wid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

Think to change mybb to suit the prefix you use

(2023-04-04, 02:38 PM)Crazycat Wrote: [ -> ]The SQL to create the structure is:

CREATE TABLE `mybb_warnings` (
  `wid` int(10) UNSIGNED NOT NULL,
  `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` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `issuedby` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `expires` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `expired` tinyint(1) NOT NULL DEFAULT 0,
  `daterevoked` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `revokedby` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `revokereason` text NOT NULL,
  `notes` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

ALTER TABLE `mybb_warnings`
  ADD PRIMARY KEY (`wid`),
  ADD KEY `uid` (`uid`);

ALTER TABLE `mybb_warnings`
  MODIFY `wid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

Think to change mybb to suit the prefix you use

Thank you so much. Problem solved. 
I have some other problem on my another forum. I need to create another post or I can share here?
Thank you so much again. Lots of love.

One problem, one thread.