#179 ✓resolved

Add "repair database" action to exponent menu

Reported by dleffler | May 6th, 2011 @ 10:58 PM | in Release Candidate 1 (closed)

Develop some scripts to "reattach" some of the disconnected database tables. The only problem appears to be that aggregation doesn't work on systems that were migrated early on since the sectionref table doesn't hold a reference to the container. The scripts would attempt to find and repair those type of disconnects.

Comments and changes to this ticket

  • dleffler

    dleffler May 14th, 2011 @ 03:58 AM

    • Milestone changed from Stable to Release Candidate 2
    • Milestone order changed from “2” to “0”
  • dleffler

    dleffler June 12th, 2011 @ 06:50 PM

    Will also be available as an upgrade script so it's run each time the code is upgraded.

    • Populate missing sectionref & locationref entries from other table (until locationref table is deprecated)
    • Populate missing sectionref (& locationref) entries from contaner table (error prevents aggregation)
    • Optionally empty/drop the sessionticket table (error prevents people from logging on)
    • May also look to delete deprecated tables?
    • May also look to install tables, optimize database, & remove unused tables ('_' prefix?)?
  • dleffler

    dleffler June 14th, 2011 @ 11:28 AM

    • Milestone changed from Release Candidate 2 to Release Candidate 1
    • Milestone order changed from “1” to “0”
  • expNinja

    expNinja June 17th, 2011 @ 09:16 PM

    • State changed from “open” to “resolved”

    (from [b409fc6dcda03c1e6d74e443ec67bde7867dccdd]) Revises Exponent menu and adds some additional methods to clear caches individually or all at once. Adds methods/menu items to try to fix some common database problems. Also moves ALL functions (found in Exponent menu) from the administration module to the controller. [#208 state:resolved][#179 state:resolved][#143] https://github.com/exponentcms/exponent-cms/commit/b409fc6dcda03c1e...

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

Bug Tracker for Exponent CMS

Shared Ticket Bins

People watching this ticket


Referenced by