Kcurek
Pomógł: 1 raz Posty: 40
|
Wysłany: 26-08-2014, 15:25 Mnożące się grupy w bazie
|
|
|
Witam. Dziś, kopiąc w bazie danych mojego testowego forum, wykryłem, że w tabeli phpbb_users znajduje się masa wpisów, w których nie ma podanej nazwy grupy, a opis grupy to "Personal User". Poza tym niczym ciekawym się to nie wyróżnia. W zrzucie bazy wygląda to tak:
Kod: | INSERT INTO `phpbb_groups` (`group_id`, `group_type`, `group_name`, `group_description`, `group_moderator`, `group_single_user`, `group_order`, `group_count`, `group_count_enable`, `group_mail_enable`, `group_no_unsub`, `group_color`, `group_prefix`, `group_style`) VALUES
(3, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(4, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(13, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(14, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(36, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(37, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(38, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(39, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(40, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(41, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(42, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(43, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(44, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(45, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(46, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(47, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(48, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(49, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(50, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(51, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(52, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(53, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(54, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(55, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(56, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(57, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(58, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(59, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(60, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(61, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(62, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(63, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(64, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(65, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(66, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(67, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(68, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(69, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(70, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(71, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(72, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(73, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(74, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(76, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(77, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(78, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(79, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(80, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(81, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(82, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(83, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(84, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(85, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(86, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(87, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(88, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(89, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(90, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(91, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(92, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(93, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(94, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(95, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(96, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(97, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(98, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(99, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(100, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(101, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(102, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(103, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(104, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(105, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(106, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(107, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(108, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL),
(109, 1, '', 'Personal User', 0, 1, 0, 99999999, 0, 0, 0, NULL, NULL, NULL); |
Chwila dedukcji doprowadziła mnie do stwierdzenia, że wpisów tych jest dokładnie tyle, ilu użytkowników rejestrowało się na forum (czyli o jeden mniej, niż ogólnie zarejestrowanych na forum). Sprawdziłem zatem w plikach i znalazłem w /includes/usercp_register.php taki kod:
Kod: | $sql = "INSERT INTO " . GROUPS_TABLE . " (group_name, group_description, group_single_user, group_moderator)
VALUES ('', 'Personal User', 1, 0)";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not insert data into groups table', '', __LINE__, __FILE__, $sql);
} |
Mam zatem pytanie - czy to coś wnosi do skryptu, czy można to zwyczajnie usunąć? Bo wygląda mi na to, że to tylko bazę zaśmieca. A ten problem występuje od dawna, bo pamiętam jak dziś, że 5 lat temu, jeszcze na 1.12.5 zastanawiałem się, dlaczego przy tworzeniu nowej grupy po jakimś czasie użytkowania forum, dostaje ona jakieś kosmiczne ID, zamiast o jeden większego od ostatniej utworzonej grupy... |
|