From ArchWiki
Revision as of 12:20, 29 July 2010 by Pierre (talk | contribs) (FluxBB 1.4 Upgrade)
Jump to: navigation, search

L10n-de Todo

FluxBB 1.4 Upgrade

	id int(10) unsigned NOT NULL,
	username varchar(200) NOT NULL,
	UNIQUE KEY users_username_idx (username(25))
INSERT INTO tusers SELECT id, username FROM fluxbb_users;
  • 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 ='';
$arch_navbar = array('Home' => '',
                      'Packages' => '',
                      'Forums' => '',
                      'Wiki' => '',
                      'Bugs' => '',
                      'AUR' => '',
                      '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
  • set default style to ArchLinux
UPDATE users SET style='ArchLinux';
  • revert changes in php.ini and apc.ini
  • re-enable public access
  • if everything is fine remove phpbb db
  • where was announce_rss.php used?