Difference between revisions of "User:Pierre"

From ArchWiki
Jump to: navigation, search
(Post update tasks)
Line 19: Line 19:
 
</pre>
 
</pre>
 
* if everything is fine remove phpbb db
 
* if everything is fine remove phpbb db
* review ban lists
 
* review censor list
 
* remove unverified users?
 
 
* why are there two fluxbb users
 
* why are there two fluxbb users
 
* why is the db that slow?
 
* why is the db that slow?
 
* create backup script
 
* create backup script
 +
 +
==dbscripts package pool migration==

Revision as of 15:01, 9 August 2010

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

L10n-de Todo

FluxBB 1.4 Upgrade

  • done :-)

Post update tasks

  • write a script to check and fix database integrity
update topics a set a.first_post_id=(SELECT MIN(posts.id) FROM posts WHERE posts.topic_id=a.id);
update topics a set a.last_post_id=(SELECT MAX(posts.id) FROM posts WHERE posts.topic_id=a.id);
update topics set first_post_id=0, last_post_id=0, last_poster=null, num_views=0, num_replies=0 where moved_to is not null;
update topics set num_replies=(select count(id)-1 from posts where topic_id=topics.id) where topics.moved_to is null;
update forums set num_topics=(select count(id) from topics where forum_id=forums.id);
update forums set num_posts=(select sum(num_replies)+count(topics.id) from topics where forum_id=forums.id and topics.moved_to is null);
  • if everything is fine remove phpbb db
  • why are there two fluxbb users
  • why is the db that slow?
  • create backup script

dbscripts package pool migration