Hello,
When I try to delete users from ACP, I cannot do that. My MyBB version is 1.8.37
Quote: MyBB has experienced an internal SQL error and cannot continue.
Can someone help me? Thanks.
(2024-01-22, 10:39 PM)Crazycat Wrote: [ -> ]Read https://community.mybb.com/thread-233457.html and give us the good informations
Thank you for the reply.
The error I get:
SQL Error:
1146 - Table 'ambrosia_mybb385.mybbr1_warnings' doesn't exist
Query:
DELETE FROM mybbr1_warnings WHERE uid IN(165)
Your installation of MyBB seems incomplete, or you had a trouble somewhere and the warnings table doesn't exists anymore.
You probably don't have the warningtypes table.
Just create them:
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) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci 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 CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
notes text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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;
CREATE TABLE mybb_warningtypes (
tid int(10) UNSIGNED NOT NULL,
title varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
points smallint(5) UNSIGNED NOT NULL DEFAULT 0,
expirationtime int(10) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
ALTER TABLE mybb_warningtypes ADD PRIMARY KEY (tid);
ALTER TABLE mybb_warningtypes MODIFY tid int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
(2024-01-23, 11:09 AM)Crazycat Wrote: [ -> ]Your installation of MyBB seems incomplete, or you had a trouble somewhere and the warnings table doesn't exists anymore.
You probably don't have the warningtypes table.
Just create them:
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) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci 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 CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
notes text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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;
CREATE TABLE mybb_warningtypes (
tid int(10) UNSIGNED NOT NULL,
title varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
points smallint(5) UNSIGNED NOT NULL DEFAULT 0,
expirationtime int(10) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
ALTER TABLE mybb_warningtypes ADD PRIMARY KEY (tid);
ALTER TABLE mybb_warningtypes MODIFY tid int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
I want to make sure that I don't do anything wrong. Where should I place this code? Should I create a separate file, if so, in which directory should it be?
They are sql queries which must be run in your phpmyadmin or any client/interface you use to access your database.