18 replies to this topic

[Michael]

File Name: (IM) DB Customization Manager 1.0.3
File Submitter: Michael
File Submitted: 23 Oct 2009
File Updated: 01 Dec 2010
File Category: IP.Board v3.0.x

After years of running a forum and performing version upgrades, converting from another forum software, installing mods, etc., your forum's database can get cluttered with extra unused junk. While this extra data doesn't typically cause any real problems with the functionality of your site, it does take up some extra room and can have a minor impact on performance.

What this application does is looks at every application installed on your forums and determines what it thinks you should have in your database for a variety of objects, then compares it to what you actually have in there, and it gives you a report of what extra stuff you have. You can then add Notes to these items to let yourself or other Admins know whether it should be kept, you can query the database for info about the particular item, and you can quickly delete the items you find. Remember that there is no Undo for deleting items, so only delete stuff you are sure you don't need!

The tool can scan your database and find the following extra types of information:

• BBCodes
  
• Caches
  
• Help Files
  
• Hooks
  
• Public Language Bits
  
• Admin Language Bits
  
• Media tags
  
• Settings
  
• Setting Groups
  
• Skin CSS
  
• Skin Replacements
  
• Skin Templates
  
• SQL Fields
  
• SQL Tables
  
• Tasks

Click here to download this file

[Cabola]

Upgrade of the ol' mod eh? Still useful I bet!

Will defiantly need this when I upgrade!

Edited by Cabola, 25 October 2009 - 03:08 PM.

[Michael]

OK, I released an update to this to version 1.0.0.  Changed in this version are the following:

• The check for extra language strings has been split into 2 separate checks, one for public and one for admin strings, to reduce the resources usage on this intensive task
  
• Fixed bugs with not being able to drop SQL columns and/or tables due to table prefixes
  
• Added an overall count of the number of found and noted entries to the overview page
  
• Added text showing which tool was run on the results page
  
• Since the SQL fields tool only works with MySQL, it's now hidden if you are using a different driver
  
• Hard-coded a few caches as being needed by IP.Board/IP.Blog even though they don't show up in the designated place for such required caches
  
• Added code to deal with the unusual file structure of IP.Subscriptions installation file, so that it's tables do not show up as extra
  
• Fixed hard-coded references to MySQL installation files
  
• Fixed issue with table prefixes and columns/tables added by hooks

Upgrading is the same as any other IP.Board app: upload the new files, visit the Manage Applications & Modules page, and click the link to upgrade.

I theory, anything this finds at this point should really be extra.  I know there are some issues with settings on IP.Shoutbox hooks, it will probably find some extra settings for that even if you are up to date.  My advice is to uninstall the 2 IP.Shoutbox hooks, run this tool and clean out anything related to those hooks, and then re-import the hooks.  If you have any questions about anything else this tool might find, post it here and I'll do my best to help.

[M1r0]

I'v got an error and I can't view the application page.

The error is this one :
System Error

Could not find Setup directory for the 'IRC Chat' application.

[Michael]

Did you delete any files from the server after you installed that IRC Chat application?  There should be a /setup/versions/install/sql/ folder in that application's folder structure.

[Guardsman]

It's not working Michael.

During install I had a screen full of database table error messages (did not exist).

I carried on regardless and the install completed.

Using the app I had several lines without text.

Selecting a line with text (eg BBCodes) resulted in a driver error:

 Date: Wed, 28 Oct 2009 11:17:14 +0000
 Error Number: 1064
 Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC' at line 1
 IP Address: xx.xxx.xxx.x
 Page: /forum/admin/index.php?adsess=06c5966e841431db6d7b2d14b5f29811&app=dbmanager&&module=dbmanager&section=dbmanager&do=tool&tool=bbcode
 Debug: array (
  1 => 
  array (
	'file' => '/home/d/public_html/forum/ips_kernel/classDb.php',
	'line' => 1010,
	'function' => 'query',
	'class' => 'db_driver_mysql',
  ),
  3 => 
  array (
	'file' => '/home/d/public_html/forum/admin/applications_addon/other/dbmanager/modules_admin/dbmanager/dbmanager.php',
	'line' => 74,
	'function' => 'loadSiteData',
	'class' => 'dbManagerLibrary',
  ),
  4 => 
  array (
	'file' => '/home/d/public_html/forum/admin/applications_addon/other/dbmanager/modules_admin/dbmanager/dbmanager.php',
	'line' => 48,
	'function' => 'doTool',
	'class' => 'admin_dbmanager_dbmanager_dbmanager',
  ),
  5 => 
  array (
	'file' => '/home/d/public_html/forum/admin/sources/base/ipsController.php',
	'line' => 291,
	'function' => 'doExecute',
	'class' => 'admin_dbmanager_dbmanager_dbmanager',
  ),
)
 mySQL query error: SELECT * FROM ibf_ ORDER BY  AS

I decided to uninstall the app and got this error (so it won't uninstall):

 Date: Wed, 28 Oct 2009 11:17:52 +0000
 Error Number: 1146
 Error: Table 'db.ibf_tags_index' doesn't exist
 IP Address: xx.xxx.xxx.x
 Page: /forum/admin/index.php?adsess=06c5966e841431db6d7b2d14b5f29811&app=core&module=applications&section=applications&do=application_remove&app_id=21
 Debug: array (
  1 => 
  array (
	'file' => '/home/d/public_html/forum/ips_kernel/classDb.php',
	'line' => 1095,
	'function' => 'query',
	'class' => 'db_driver_mysql',
  ),
  3 => 
  array (
	'file' => '/home/d/public_html/forum/admin/applications/core/modules_admin/applications/applications.php',
	'line' => 1409,
	'function' => 'delete',
	'class' => 'db_main_mysql',
  ),
  4 => 
  array (
	'file' => '/home/d/public_html/forum/admin/applications/core/modules_admin/applications/applications.php',
	'line' => 107,
	'function' => 'applicationRemove',
	'class' => 'admin_core_applications_applications',
  ),
  5 => 
  array (
	'file' => '/home/d/public_html/forum/admin/sources/base/ipsController.php',
	'line' => 291,
	'function' => 'doExecute',
	'class' => 'admin_core_applications_applications',
  ),
)
 mySQL query error: DELETE FROM ibf_tags_index WHERE app='dbmanager'

Help?

[Michael]

I have no idea what that last error message means, this mod has nothing to do with a 'tags_index' table.

[Guardsman]

Hmmm... and yet it won't uninstall?

[Michael]

This is resolved now, yes?

[Guardsman]

Not yet Michael. I'm at work right now. I'll take a look later.

BTW, I suspect tags_index is related to an old (2.x) IPBSeo mod. Why it should come to light during uninstall of your mod, I have no idea!

[Guardsman]

Now uninstalled via phpMyAdmin  

[M1r0]

Michael, on Oct 27 2009, 07:56 PM, said:

Did you delete any files from the server after you installed that IRC Chat application?  There should be a /setup/versions/install/sql/ folder in that application's folder structure.

No I didn't delete anything after have installed the IRC_Chat application.

If you would like to test the apps it is available here : http://forums.invisi...mp;showfile=378

Edited by M1r0, 09 November 2009 - 01:57 PM.

[Sprinkle]

I am also getting same error micheal like above member cannot open extra templates,bbcode just can open extra fields

[Martin]

Michael, on Oct 27 2009, 07:56 PM, said:

Did you delete any files from the server after you installed that IRC Chat application?  There should be a /setup/versions/install/sql/ folder in that application's folder structure.

Just saw this reply.

No, there shouldn't be a folder like that. If an application have no need for extra tables/columns, the folder will not exist (which is the case for the said application).

[Michael]

Released version 1.0.1.  In this version, I fixed the issue about the application halting when certain other apps were missing a setup directory.  It now just gives you a warning at the top of the page about this, and lets you continue regardless.  I also hard-coded a couple additional IP.Board caches as being default even though they weren't stored in the customary location.  Plus I did one quick minor language update.  Also moved the application icon into the application directory instead of putting it out in the higher level admin directory/skin_cp directory.

To upgrade, just upload the new files, visit the Manage Applications & Modules page in the Admin CP, and click the link to upgrade from there.

[Vinay Prajapati]

upgrade for 3.1?  

[parvaty]

Could not find Setup directory for the '(SOS30) Reputation Points' application.

im getting this erro
but i have the whole setup directory for the mod and im able to instal and uninstall it

even then its showing erro in DB manager

[Michael]

Updated to version 1.0.2 to include a few tweaks for newer versions of IPS apps, including IP.Nexus.

[Michael]

Updated to version 1.0.3 to ensure IP.Content custom databases and IP.Board/IP.Downloads custom fields are not found as being extra.