phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

Lost a LOT of topics


 
Search this topic... | Search General Support... | Search Box
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Author Message
poeee
Board Member



Joined: 29 Mar 2010

Posts: 3



PostPosted: Mon Mar 29, 2010 10:33 am 
Post subject: Lost a LOT of topics

My forum http://www.ausmini.com/forums lost every post but all polls and the one announcement in our major subforum (Mini Chat).

You can see on the index page that the number of topics is 300ish (say the number of polls that were in there) and 300,000 posts. That equals an average of roughly 1000 replies per thread. Not likely!

Apparently the last backup of the server is no good, so I can't reinstate that.

The forum sees the posts, but I can't view the topics. If I try to manually find a topic by number, I can't find any in Mini Chat. It says the thread has been deleted or doesn't exist.

Please HELP! We have lost thousands and thousands of threads from over 5 years.
Back to top
Dog Cow
Board Member



Joined: 18 Nov 2008

Posts: 378


flag
PostPosted: Mon Mar 29, 2010 9:58 pm 
Post subject: Re: Lost a LOT of topics

Did the forum prune get activated?

Try going to the Forums Admin page and clicking the Resync link.

_________________
Moof!
Lincoln's Tomb, Oak Ridge Cemetery, Springfield IL • Mac 512K Blog • Mac GUI
Back to top
dogs and things
Board Member



Joined: 18 Nov 2008

Posts: 621
Location: Spain


flag
PostPosted: Mon Mar 29, 2010 11:03 pm 
Post subject: Re: Lost a LOT of topics

I don't know but I see lots of topics and posts and can read all of them.
_________________
phpBB2 will never die, I hope!
Back to top
poeee
Board Member



Joined: 29 Mar 2010

Posts: 3



PostPosted: Tue Mar 30, 2010 2:24 am 
Post subject: Re: Lost a LOT of topics

Ive tried the resync.

New topics still work fine. Only polls were left. Even if you do a search that will show thousands of results, it shows many many pages but as you click through the result pages it will suddenly show no results on the page. The posts are there somewhere for it to be finding them when searching.

Is it worth creating a new subforum, deleting the problem forum and moving everything in to the new subforum?
Back to top
dogs and things
Board Member



Joined: 18 Nov 2008

Posts: 621
Location: Spain


flag
PostPosted: Tue Mar 30, 2010 7:25 am 
Post subject: Re: Lost a LOT of topics

No, donīt do anything like that.

Copy this code:
Code:
<?php

## phpBB Sync All
##
## Author: uncle.f < soft at purple-yonder.com >
##
## This script performs the compete sync of all posts/topic/forums statistics
## including the approval data.
##
## Usage: copy this script to the 'admin' directory of your phpBB installation;
## you should get a new 'Sync All' lnk in the admin panel ('Forums' section).
## Simply click on the 'Sync All' link to synchronize everything.
## It would make sense to do that when there is low user activity on your forum,
## especially if it contains a lot of posts.

define('IN_PHPBB', 1);

if( !empty($setmodules) )
{
   $file = basename(__FILE__);
   $module['Forums']['Sync All'] = $file;
   return;
}

$phpbb_root_path = "./../";
require($phpbb_root_path . 'extension.inc');
require('./pagestart.' . $phpEx);
include($phpbb_root_path . 'includes/functions_admin.'.$phpEx);

// sync all topics and forums first
sync('all topics');
sync('all forums');

$end_msg = 'Topics and Forums sync is complete!';

// sync users' # of posts counters (only for MySQL 4.1+)
if (substr(SQL_LAYER,0,5) == 'mysql')
{
   $sql = "SHOW VARIABLES LIKE 'version'";
   if ( !($result = $db->sql_query($sql)) )
   {
      message_die(GENERAL_ERROR, 'Error gettting MySQL server information!', '', __LINE__, __FILE__, $sql);
   }

   if ( $total = $db->sql_fetchrow($result))
   {
      $db->sql_freeresult($result);

      if (substr($total['Value'],0,3) == '4.1' || substr($total['Value'],0,1) > 4)
      {
         $sql = "UPDATE " . USERS_TABLE . " u SET u.user_posts =
                 (SELECT COUNT(p.poster_id)
                  FROM " . POSTS_TABLE . " p
                  WHERE u.user_id = p.poster_id
                  GROUP BY p.poster_id)";

         if ( !$db->sql_query($sql) )
         {
            message_die(GENERAL_ERROR, 'Error updating user statistics!', '', __LINE__, __FILE__, $sql);
         }

         $end_msg = 'Topics, Forums and user posts counters sync is complete!';
      }
   }
}

message_die(GENERAL_MESSAGE, $end_msg);

?>


Save it as admin_sync_all.php and ftp it to your board's admin folder.

You now see under the administer forums section a new link, sync_all, click it and wait while the script performs the complete sync of all posts/topic/forums statistics, when it ends you'll see a confirmation message.

This files comes as a bonus with the Approval MOD and works very nicely for me, I donīt know if it will work for you.

See if it fixes your problem.

_________________
phpBB2 will never die, I hope!
Back to top
poeee
Board Member



Joined: 29 Mar 2010

Posts: 3



PostPosted: Tue Mar 30, 2010 11:09 am 
Post subject: Re: Lost a LOT of topics

Cheers mate. It did not fix the issue but I guess it is good to have there for the future.
Back to top
Sylver Cheetah 53
Board Member



Joined: 17 Dec 2008

Posts: 426
Location: Milky Way


flag
PostPosted: Sat Apr 03, 2010 10:31 pm 
Post subject: Re: Lost a LOT of topics

Did you recently did a full backup restore? Maybe the backup wasn't complete or it did not restored completly, this things happen. icon_wink.gif
_________________
Image link
My Forum || My Blog

phpBB2 forever! icon_smile.gif
Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Mon Apr 05, 2010 4:54 pm 
Post subject: Re: Lost a LOT of topics

(For backups and restoring backups I recommend mysqldumper, again and again.)
Back to top
Display posts from previous:   
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.1144 seconds using 15 queries. (SQL 0.0866 Parse 0.0009 Other 0.0269)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo