Uploaded image for project: 'Support Team Tools'
  1. Support Team Tools
  2. STT-308

Database cleaner adds extensions even if they are unchecked

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Cannot Reproduce
    • Component/s: Support Toolkit
    • Labels:
      None

      Description

      After comparing the extensions table before and after cleaning (everything to add/remove was unmarked, but all the items at the end were selected yes) I noticed that a bunch of extensions were being added with the group id of 0.

      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(67, 0, 'gif');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(68, 0, 'jpeg');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(69, 0, 'jpg');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(70, 0, 'png');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(71, 0, 'tga');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(72, 0, 'tif');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(73, 0, 'tiff');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(74, 0, '7z');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(75, 0, 'ace');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(76, 0, 'bz2');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(77, 0, 'gtar');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(78, 0, 'gz');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(79, 0, 'rar');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(80, 0, 'tar');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(81, 0, 'tgz');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(82, 0, 'torrent');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(83, 0, 'zip');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(84, 0, 'c');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(85, 0, 'cpp');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(86, 0, 'csv');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(87, 0, 'diz');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(88, 0, 'h');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(89, 0, 'hpp');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(90, 0, 'ini');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(91, 0, 'js');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(92, 0, 'log');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(93, 0, 'txt');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(94, 0, 'xml');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(95, 0, 'ai');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(96, 0, 'doc');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(97, 0, 'docm');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(98, 0, 'docx');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(99, 0, 'dot');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(100, 0, 'dotm');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(101, 0, 'dotx');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(102, 0, 'odg');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(103, 0, 'odp');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(104, 0, 'ods');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(105, 0, 'odt');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(106, 0, 'pdf');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(107, 0, 'ppt');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(108, 0, 'pptm');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(109, 0, 'pptx');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(110, 0, 'ps');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(111, 0, 'rtf');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(112, 0, 'xls');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(113, 0, 'xlsb');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(114, 0, 'xlsm');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(115, 0, 'xlsx');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(116, 0, 'ram');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(117, 0, 'rm');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(118, 0, 'wma');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(119, 0, 'wmv');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(120, 0, 'swf');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(121, 0, '3g2');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(122, 0, '3gp');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(123, 0, 'm4a');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(124, 0, 'm4v');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(125, 0, 'mov');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(126, 0, 'mp4');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(127, 0, 'qt');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(128, 0, 'mp3');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(129, 0, 'mpeg');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(130, 0, 'mpg');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(131, 0, 'ogg');
      INSERT INTO `phpbb_extensions` (`extension_id`, `group_id`, `extension`) VALUES(132, 0, 'ogm');

        Attachments

          Activity

            People

            • Assignee:
              Noxwizard Patrick Webster
              Reporter:
              EXreaction EXreaction [X] (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: