Clean Database

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
allaboutmarbles
Registered User
Posts: 181
Joined: Tue Jan 12, 2010 1:31 pm

Re: Clean Database

Post by allaboutmarbles »

Can i please get some help here?

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51908
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Clean Database

Post by Brf »

There is a revision to the database_cleaner here: http://code.phpbb.com/projects/support- ... leaner.php
and a second patch here: http://code.phpbb.com/projects/support- ... roller.php

allaboutmarbles
Registered User
Posts: 181
Joined: Tue Jan 12, 2010 1:31 pm

Re: Clean Database

Post by allaboutmarbles »

That's great and all but i don't what to do with those revisions...

allaboutmarbles
Registered User
Posts: 181
Joined: Tue Jan 12, 2010 1:31 pm

Re: Clean Database

Post by allaboutmarbles »

Here, let's try using pictures. I can see in my ACP that something isn't right, how do i fix this, i want to remove the MODS that are showing in my ACP.

[attachment=0]mods2.jpg[/attachment]
[attachment=1]mods1.jpg[/attachment]
[attachment=2]mods.jpg[/attachment]

Maybe those pictures can better help you understand what i am trying to do, i don't want to use any mods to remove mods, i just want to get rid of them, will a fresh install get rid of those?? Every time i do a fresh install and point the new install to my database they show back up!
Attachments
I WANT TO REMOVE THE MOD TABS!!!! AND MODS!!!!
I WANT TO REMOVE THE MOD TABS!!!! AND MODS!!!!
mods.jpg (48.95 KiB) Viewed 207 times
I WANT TO FIX THIS!! Should it be showing scroll brackets???
I WANT TO FIX THIS!! Should it be showing scroll brackets???
mods1.jpg (47.14 KiB) Viewed 207 times
I WANT TO REMOVE THE CASH MOD!!!!!!
I WANT TO REMOVE THE CASH MOD!!!!!!
mods2.jpg (59.41 KiB) Viewed 207 times

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51908
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Clean Database

Post by Brf »

Those patches tell you which lines to fix in the Support Toolkit, so you can use it to clean your database.

SoutlinK
Registered User
Posts: 42
Joined: Wed Dec 12, 2007 5:53 pm

Re: Clean Database

Post by SoutlinK »

OK. I tried to cleean my database, and it all looks like works good, but when I continue to reset roboots list I get an error. So I tried to check my forum and it dosnt works.

Looks like STK remove default phpbb3 tables, like users_new (in phpbb_users) for example, or in styles table.

Why it happend?

I mean, I think that STK its cleaning my database form old version like 3.0.5 or something like that, because it tried to delete new columns in phpbb 3.0.7 :S

Help please?

allaboutmarbles
Registered User
Posts: 181
Joined: Tue Jan 12, 2010 1:31 pm

Re: Clean Database

Post by allaboutmarbles »

Brf wrote:Those patches tell you which lines to fix in the Support Toolkit, so you can use it to clean your database.
On those revisions, on the first one, do i just add that line of code in the green?

Example, here is what i have in mine now...

Code: Select all

include PHPBB_ROOT_PATH . 'includes/functions_admin.' . PHP_EXT;
	}
	$filelist = array_shift(filelist(STK_ROOT_PATH . 'includes/database_cleaner/', 'data/', PHP_EXT));
    
	// Add the data
	foreach ($filelist as $file)
Do i just add this "sort($filelist);" on the blank line above //Add the data?

allaboutmarbles
Registered User
Posts: 181
Joined: Tue Jan 12, 2010 1:31 pm

Re: Clean Database

Post by allaboutmarbles »

Ok, i got it......

Here is what it's telling me now, i assume you just remove the ones, but will it auto add the other ones?


DATABASE TABLES TYPE ACTION
allaboutmarbles_gallery_albums Extra Remove
allaboutmarbles_gallery_albums_track Extra Remove
allaboutmarbles_gallery_comments Extra Remove
allaboutmarbles_gallery_config Extra Remove
allaboutmarbles_gallery_contests Extra Remove
allaboutmarbles_gallery_favorites Extra Remove
allaboutmarbles_gallery_images Extra Remove
allaboutmarbles_gallery_modscache Extra Remove
allaboutmarbles_gallery_permissions Extra Remove
allaboutmarbles_gallery_rates Extra Remove
allaboutmarbles_gallery_reports Extra Remove
allaboutmarbles_gallery_roles Extra Remove
allaboutmarbles_gallery_users Extra Remove
allaboutmarbles_gallery_watch Extra Remove
allaboutmarbles_mods Extra Remove
allaboutmarbles_search_wordlist Missing Add
allaboutmarbles_search_wordmatch Missing Add

allaboutmarbles
Registered User
Posts: 181
Joined: Tue Jan 12, 2010 1:31 pm

Re: Clean Database

Post by allaboutmarbles »

Never mind, i got it, will report back if i have any problems..

allaboutmarbles
Registered User
Posts: 181
Joined: Tue Jan 12, 2010 1:31 pm

Re: Clean Database

Post by allaboutmarbles »

Sorry guys, i only have one thing left to try and get rid of, here is a picture, the toolkit did not work for this...
ACP_.jpg
ACP_.jpg (42.05 KiB) Viewed 176 times

User avatar
ameeck
Former Team Member
Posts: 6559
Joined: Mon Mar 21, 2005 6:57 pm

Re: Clean Database

Post by ameeck »

Go to ACP > System > Administration Control Panel Module management and delete the module manually.

allaboutmarbles
Registered User
Posts: 181
Joined: Tue Jan 12, 2010 1:31 pm

Re: Clean Database

Post by allaboutmarbles »

It's not showing in there, it does however show in the UCP, would it be ok to delete it there to?

User avatar
ameeck
Former Team Member
Posts: 6559
Joined: Mon Mar 21, 2005 6:57 pm

Re: Clean Database

Post by ameeck »

If you want to remove the MOD, then yes. Deleting a module through the ACP doesn't delete any files or settings, you can't do anything unless your remove the module management module itself.

The ACP module must show up there, did you browse to the right category in the managment?

allaboutmarbles
Registered User
Posts: 181
Joined: Tue Jan 12, 2010 1:31 pm

Re: Clean Database

Post by allaboutmarbles »

ns.jpg
ns.jpg (84.62 KiB) Viewed 163 times

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51908
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Clean Database

Post by Brf »

Yes.
That is ACP / Module management
The thing you are asking to remove is on the Maintenance tab, so click on "Maintenance" and then "Forum Logs"

Locked

Return to “[3.0.x] Support Forum”