Welcome to all phpBB2 Refugees!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. |
|
Author |
Message |
poeee Board Member
Joined: 29 Mar 2010
Posts: 3
|
Posted: Mon Mar 29, 2010 6: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
|
|
Back to top |
|
|
dogs and things Board Member
Joined: 18 Nov 2008
Posts: 628 Location: Spain
|
Posted: Mon Mar 29, 2010 7: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
|
Posted: Mon Mar 29, 2010 10:24 pm 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: 628 Location: Spain
|
Posted: Tue Mar 30, 2010 3: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
|
Posted: Tue Mar 30, 2010 7: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
|
Posted: Sat Apr 03, 2010 6: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. _________________ Image link
My Forum || My Blog
phpBB2 forever! |
|
Back to top |
|
|
Holger Board Member
Joined: 19 Jan 2009
Posts: 509 Location: Hanover
|
Posted: Mon Apr 05, 2010 12:54 pm Post subject: Re: Lost a LOT of topics |
|
|
(For backups and restoring backups I recommend mysqldumper, again and again.) |
|
Back to top |
|
|
|
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0545 seconds using 16 queries. (SQL 0.0089 Parse 0.0007 Other 0.0449) |
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com
|
|