phpbb DB Maintenance mod for phpnuke

Worker Joined: Oct 22, 2005 Posts: 201

Hey,

I have a big forum and it is starting to mess-up. topic are missing on viewforum, users are not apearing and all kind of crazy stuff.

I search and found this is a known problem with phpbb as to conversion with phpnuke might be altered the solution as I understand is DB Maintenance for phpbb.

http://www.phpbbhacks.com/download/4372

I have tried to install it but I think it is just not compatible with phpnuke.

someone can have a look and convert it maybe? couldnt find this mod anywhere.

p.s here is the explantion to the problem:
http://drupal.org/node/98482
it is happaning in phpnuke too.
Rolling Eyes

Posted: Sun Jun 01, 2008 11:05 am

Have you tried the optimise option in the phpNuke admin? Also you might want to go into phpmyadmin and check if any of the database tables require repairing.

The Mod you mention above is unlikely to work out of the box for the forums in phpnuke and therefore it will probably take some editing to work.

Posted: Sun Jun 01, 2008 11:09 am

yeah I have tried the optimise option its not fixing the problem.

visit http://drupal.org/node/98482 this will explain the problem. the same thing is happaning using phpnuke. maybe other idea on how to deal with it?

Posted: Sun Jun 01, 2008 11:12 am

So you have deleted a user and the posts related to that user have disappeared?

Posted: Sun Jun 01, 2008 11:16 am

If you delete a user with the nuke administration meny you should not have a problem as it leaves the posts behind but marks the user for the posts either as the site admin or anonymous (I forget which).
You should only have this sort of problem if you removed the user directly from the database which, you should never do or, your table structure was already out of synch due to a bad upgrade.

Posted: Sun Jun 01, 2008 11:21 am

Wired.. when I delete a user his posts are being deleted too. (using phpnuke administration).

jakec after I delete a user all the topics which he replaied in disappeared from viewforum.

Guardian2003, how can I check table structure is synch?

Posted: Sun Jun 01, 2008 11:24 am

and this is in phpnuke 7.6, not RN?

Posted: Sun Jun 01, 2008 11:26 am

yes.

Worker Joined: Aug 26, 2007 Posts: 236

Have you tried to Resync your forum from Forum admin?

3.1.1.4: Resync

Some information in the database is contained it multiple tables. This makes the board run faster by reducing the number of database queries on some pages. Sometimes the information in different tables of the database gets out of sync. This usually is caused by a connection problem which interrupts updating of the database.

When this happens, your forum may start behaving in a strange way. Links to topics or posts that don't exist are common symptoms of this problem.

If you are having this problem, you can fix it by clicking Resync in the General Forum Settings Panel. This will recalculate the forum information based on the actual posts that exist. This operation has no harmful effect on the forums, just generates a small amount of overhead while you are doing it. This is a good thing to try if you are not sure what is causing a problem on your board.

http://www.phpbb.com/support/documentation/2.0/#section3_1_1_4

Posted: Mon Jun 02, 2008 2:49 am

Hmm, i dont have that 'Resync' -function, or cant find it Wink

Running php-nuke 7.9 here.

The only thing I experience is empty topic overview pages in forums with a big nmbr of pages.
The last 2-3 pages display the page but without any topics, so useless empty pages you might say Razz

I wonder if that 'Resync' -function can solve that, if it exists.

Posted: Mon Jun 02, 2008 6:11 am

slackervaara tried this too. it is not helping.

warren-the-ape yup, this is part of the problem too. the mod I have posted in my first post should solve all those problems but it just not compatible with nukephpbb and no one yet converted the mod.

any more suggestions maybe?

Posted: Mon Jun 02, 2008 6:13 am

You have the resync option, if you have phpbb-forum, which most PHP-Nukers have. You find it in Forum admin and in that part in Forum administration. If you look the first part there Forum Managemeent with the view over all forums you will find resync to the right of each forum.

Posted: Mon Jun 02, 2008 7:37 am

Aah lolll, big DOH Embarassed

I see it now slackervaara, thnx for pointing out Wink

Used that page hundreds of times but probably ignored the 'resync' links all the time Cool

Posted: Mon Jun 02, 2008 8:03 am

warren-the-ape can you please report if it fix the problem you described (empy viewtopic pages). this 'resync' button fails to fix this at my end.

Posted: Mon Jun 02, 2008 11:30 am

warren-the-ape wrote:

Hmm, i dont have that 'Resync' -function, or cant find it Wink

Running php-nuke 7.9 here.

The only thing I experience is empty topic overview pages in forums with a big nmbr of pages.
The last 2-3 pages display the page but without any topics, so useless empty pages you might say Razz

I wonder if that 'Resync' -function can solve that, if it exists.

I had exactly this problem earlier and it was caused by the fact, that I had deleted members directly from the database and thus their posts were still present, which gives this errror.

I had to check, if I had posts available in the database from non-members. I had to create this member again and then delete it through admin.php as one always should. I had approx 10 members that I had to do this for.

Posted: Mon Jun 02, 2008 11:52 am

prekill wrote:

warren-the-ape can you please report if it fix the problem you described (empy viewtopic pages). this 'resync' button fails to fix this at my end.

Nope didnt help.

@ slackervaara

Hmm, thats a very good point, we had one admin in the past who removed his own account (before i took over unfortunately Sad

), I was checking our 'archive' -forum which should have posts from him still there somewhere (approx. 1000).

So im pretty sure thats what causing it.

Any tips on this one;

Quote:

I had to check, if I had posts available in the database from non-members. I had to create this member again

How should I check in db, and how do I assign a new user to those 'lost' posts?

Edit:
Damnn it takes some time to undo all the db and nuke damage from the past Cool

But its getting better after every change and upgrade, mainly thnx to the help from you guys.

P.s. sorry for the little topic hijack Wink

Posted: Mon Jun 02, 2008 12:10 pm

I checked for missing members like this.

I looked in the database with phpMyAdmin in nuke_users for members that were missing. You can easily see, if a user_id is missing.

Then go to nuke_bbposts and Search. Search for poster_id with the number of the user_id of the missing member. If the missing member have posts still present in the database they will show up then.

Create a new account for a member. Then in phpMyAdmin change the user_id to the number of the missing member with posts for this account. After that you can via admin.php delete that account. Afterwards you can check that the posts have been deleted. This solved the problem I had.

Posted: Tue Jun 03, 2008 1:47 am

Thnx for the detailed description slackervaara.

Couldnt find him very quick in the nuke_users table so i went to nuke_bbposts and sorted on poster_id. All posts from this old user/admin had a poster_id of '-1' Razz

His username was still listed in the post tables as well btw Very Happy

I checked our registred members and noticed id '41' was missing, so that was probably his old id.
I will 1st re-add this old user and fill up the missing id 41.

You have any quick solutions/ideas to convert all those poster id's from '-1' to '41' ? (didnt found one in phpmyadmin other than 'per post').
approx. 1000 posts is quite a lot to change manually post per post Laughing

But well keeps me off the streets i suppose Cool

Posted: Tue Jun 03, 2008 11:11 am

I don't know, if you need to change to 41, because maybe you can change the new account you create to user_id -1. I am not 100 % sure, if this would work, but personally I think so. If you delete the account all posts with poster_id -1 would be deleted. Maybe someone else have an idea here.

I checked my database and I had neither -1 as poster_id or user_id.

registered · Posted: Wed Jun 04, 2008 6:13 am

warren-the-ape wrote:

You have any quick solutions/ideas to convert all those poster id's from '-1' to '41' ?

Yes there is, but you had better know what you are doing or have a good backup prior to making this change. I'll just give you one example, but you may need to find other occurrences.

For table nuke_bbposts:

UPDATE nuke_bbposts SET poster_id = 41 WHERE poster_id = -1;

Posted: Wed Jun 04, 2008 9:13 am

Thnx Montego,

But i have changed them manually already Cool

Took me a while but nevermind..

Another problem was that not all '-1' posts were from the same user, luckely i could just sort on username and id.

In this case i dont want to remove the posts cause this admin deleted his account just before he left without any notification or anything, this was 1.5 years ago.

So i brought them back now, only thing i need to restore as well are _bbtopics, they are still listed as '-1' as well.

Problem with that table is that it only consists of id's, no usernames there, so i need to crosscheck with the correspondent topic, if it was indeed the topic he started.

Posted: Wed Jun 04, 2008 9:26 am

guys anyone might have a look at the mod from the first post?

(tried to install it again, its basically working, you can see it in the admin panel of the forum but every choice gives a 404 error page.)

Posted: Wed Jun 04, 2008 1:28 pm

prekill wrote:

but every choice gives a 404 error page.)

Uploaded some files to the wrong directory?

root/modules/forums/(admin/).. I suppose?

Posted: Wed Jun 04, 2008 5:35 pm

nop, everything where it should be.

admin_db_maintenance.php under root/modules/forums/admin
4 tpl files under root/modules/forums/templates/subSilver/admin/
functions_dbmtnc.php under root/includes

To tell you the truth it is really wired I always install phpbb mods and each one of them worked just fine, this is the first which making me troubles.

Posted: Fri Jun 06, 2008 3:19 pm

Another symptom of this problem will show you:

"No posts exist for this topic"

This happens when the posts and topics tables get out of sync.

The official fix is the mod I gave in the first post, heres the link to this problem at the phpbb official forum:

http://www.phpbb.com/community/viewtopic.php?f=1&t=348975&start=0&st=0&sk=t&sd=a

I really think we should get this mod working on nukephpbb too.

make it built-in even.