Difference between revisions of "User:Pierre"

From ArchWiki
Jump to: navigation, search
(FluxBB 1.4 Upgrade)
(Post update tasks)
Line 109: Line 109:
 
* remove unverified users?
 
* remove unverified users?
 
* enable gzip?
 
* enable gzip?
 +
* why are there two fluxbb users

Revision as of 16:33, 29 July 2010

https://users.archlinux.de/~pierre/

L10n-de Todo

FluxBB 1.4 Upgrade

CREATE TEMPORARY TABLE tusers (
	id int(10) unsigned NOT NULL,
	username varchar(200) NOT NULL,
	PRIMARY KEY (id),
	UNIQUE KEY users_username_idx (username(25))
) DEFAULT CHARSET=utf8;
INSERT INTO tusers SELECT id, username FROM fluxbb_users;
  • <s>Backup database phpbb
  • Backup complete directory
  • import backup db into fluxbb
  • adjust config.php
$db_name = 'fluxbb';
$db_type = 'mysql_innodb';
$cookie_secure = 1;
$arch_home ='http://www.archlinux.org/';
$arch_navbar = array('Home' => 'http://www.archlinux.org/',
                      'Packages' => 'http://www.archlinux.org/packages/',
                      'Forums' => 'http://bbs.archlinux.org/',
                      'Wiki' => 'http://wiki.archlinux.org/',
                      'Bugs' => 'http://bugs.archlinux.org/',
                      'AUR' => 'http://aur.archlinux.org/',
                      'Download' => 'http://www.archlinux.org/download/');
$arch_navbar_selected = 'Forums';
  • remove fluxbb_ prefix from tables (adjust config.php)
RENAME TABLE fluxbb_bans TO bans;
RENAME TABLE fluxbb_categories TO categories;
RENAME TABLE fluxbb_censoring TO censoring;
RENAME TABLE fluxbb_config TO config;
RENAME TABLE fluxbb_forum_perms TO forum_perms;
RENAME TABLE fluxbb_forums TO forums;
RENAME TABLE fluxbb_groups TO groups;
RENAME TABLE fluxbb_online TO online;
RENAME TABLE fluxbb_posts TO posts;
RENAME TABLE fluxbb_ranks TO ranks;
RENAME TABLE fluxbb_reports TO reports;
RENAME TABLE fluxbb_search_cache TO search_cache;
RENAME TABLE fluxbb_search_matches TO search_matches;
RENAME TABLE fluxbb_search_words TO search_words;
RENAME TABLE fluxbb_subscriptions TO subscriptions;
RENAME TABLE fluxbb_topics TO topics;
RENAME TABLE fluxbb_users TO users;
  • Deny access to cache, include, lang, plugins, config.php, header.php, footer.php
  • Add password-protected access to db_update.php, install.php
  • rm -f cache/*.php
  • temporary disable apc stat cache
  • temporaray increase maximum php execution time and memory usage
  • killall php-cgi
  • run update script
  • check for wrong or duplicate mysql indexes
ALTER TABLE `bans` DROP INDEX `fluxbb_bans_username`;
ALTER TABLE `online` DROP INDEX `punbb_online_user_id_ident_idx`;
ALTER TABLE `online` DROP INDEX `punbb_online_user_id_idx`;
ALTER TABLE `fluxbb`.`online` DROP INDEX `online_user_id_ident_idx` ,
ADD UNIQUE `online_user_id_ident_idx` ( `user_id` , `ident` ( 25 ) );
ALTER TABLE `online`  ENGINE = MEMORY;
ALTER TABLE `fluxbb`.`posts` DROP INDEX `punbb_posts_topic_id_idx` ,
ADD INDEX `posts_topic_id_idx` ( `topic_id` ) ;
ALTER TABLE `fluxbb`.`posts` DROP INDEX `punbb_posts_multi_idx` ,
ADD INDEX `posts_multi_idx` ( `poster_id` , `topic_id` ) ;
ALTER TABLE `fluxbb`.`reports` DROP INDEX `punbb_reports_zapped_idx` ,
ADD INDEX `reports_zapped_idx` ( `zapped` ) ;
ALTER TABLE `fluxbb`.`search_cache` DROP INDEX `punbb_search_cache_ident_idx` ,
ADD INDEX `search_cache_ident_idx` ( `ident` ( 8 ) ) ;
ALTER TABLE `search_matches` CHANGE `word_id` `word_id` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `fluxbb`.`search_matches` DROP INDEX `punbb_search_matches_word_id_idx` ,
ADD INDEX `search_matches_word_id_idx` ( `word_id` ) ;
ALTER TABLE `fluxbb`.`search_matches` DROP INDEX `punbb_search_matches_post_id_idx` ,
ADD INDEX `search_matches_post_id_idx` ( `post_id` ) ;
ALTER TABLE `search_words` CHANGE `id` `id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ;
ALTER TABLE `fluxbb`.`search_words` DROP INDEX `punbb_search_words_id_idx` ,
ADD INDEX `search_words_id_idx` ( `id` ) ;
ALTER TABLE `topics` DROP INDEX `punbb_topics_last_post_idx` ;
ALTER TABLE `fluxbb`.`topics` DROP INDEX `punbb_topics_forum_id_idx` ,
ADD INDEX `topics_forum_id_idx` ( `forum_id` ) ;
ALTER TABLE `fluxbb`.`topics` DROP INDEX `punbb_topics_moved_to_idx` ,
ADD INDEX `topics_moved_to_idx` ( `moved_to` ) ;
ALTER TABLE `users` CHANGE `group_id` `group_id` INT( 10 ) UNSIGNED NOT NULL DEFAULT '3';
ALTER TABLE `users` CHANGE `style` `style` VARCHAR( 25 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'ArchLinux';
ALTER TABLE `users` DROP INDEX `fluxbb_users_username_idx` ;
ALTER TABLE `fluxbb`.`topics` DROP INDEX `punbb_users_registered_idx` ,
ADD INDEX `users_registered_idx` ( `registered` ) ;
  • set default style to ArchLinux
UPDATE users SET style='ArchLinux';
UPDATE config SET conf_value='ArchLinux' WHERE conf_name='o_default_style';
  • rm -f cache/*.php
  • revert changes in php.ini and apc.ini
  • re-enable public access

Post update tasks

  • if everything is fine remove phpbb db
  • where was announce_rss.php used?
  • review ban lists
  • review censor list
  • remove unverified users?
  • enable gzip?
  • why are there two fluxbb users