You can use the following in a script in the same dir as your db (for most
environments it would be in the db folder):
checkdb.py
#===================
import sqlite3
tracdb = sqlite3.connect('trac.db') # enter the file name of your db here
cursor = tracdb.cursor()
cursor.execute("SELECT * FROM system WHERE name =
'milestoneteams_plugin_version' ")
print "System table where name = 'milestoneteams_plugin_version' "
for row in cursor:
print row
cursor.execute("SELECT * FROM milestone_teams")
print "\n\nmilestone_teams table:"
for row in cursor:
print row
tracdb.close()
#===================
It's also a good idea to download sqlite3 shells and get acclimated with
them as a tool:
http://www.sqlite.org/download.html
So that you don't have to roll your own script just to poke around your db.
:)
Let me know what that script prints out and maybe that will help.
The next step is for me to get bothered and install the plugin on a local
instance of trac 0.12.
-Nelson
On Tue, May 8, 2012 at 12:04 PM, Roger Oberholtzer <
[email protected]> wrote:
> On Tue, 2012-05-08 at 08:03 -0400, Nelson Brown wrote:
> > Sometimes certain plugins when they check to see if they are
> > installed correctly only do a partial examination of the tables of the
> > database or only check certain properties so it may have only
> > partially updated and it looks at that partial update and thinks you
> > are fully updated.
> >
> > I looked at the source very quickly, and it looks like there could be
> > a couple of culprits. Questions that could help you isolate where you
> > got to in the upgrade process:
> >
> > (*) What database backend are you using? MySQL/PostGRES/Sqlite3? If
> > you are using Sqlite3, when it attempts to do a rollback it can't undo
> > newly created tables. That might have left the system in a strange
> > spot in the upgrade.
>
> Sqlite3
>
> >
> > (*) Does the milestone teams plugin appear in your plugins list?
>
> Yes
>
> >
> > (*) Do you have any errors in your log message which indicate an error
> > when you go to perform any of the actions it provides?
>
> Not a peep.
>
> >
> > Looking at the source [1] which does the table setup leads to the
> > following questions:
> >
> > (*) You could look to see if there is a row in the system table with a
> > name of 'milestoneteams_plugins_version'. If it is present, what is
> > the value of that key?
>
> How to check this?
>
> > (*) Was there a milestone_teams table created? Is there anything in
> > that table?
>
> How to check this?
>
> > If you post any answers you have, it'll help in figuring this out. If
> > you need a hand in figuring out how to find the answers, we can give
> > you some instructions.
> >
> > [1] :
> >
> http://trac-hacks.org/browser/milestoneteamsplugin/0.11/milestoneteams/setup.py
> >
> > -Nelson
> >
> >
> > On Tue, May 8, 2012 at 5:42 AM, Roger Oberholtzer
> > <[email protected]> wrote:
> > Is anyone using the MilestoneTeams plugin on Trac 0.12? I
> > installed it
> > and have it enabled. But I get nothing - no place to specify
> > the
> > milestone leader or members. It did request that the database
> > be updated
> > to add the required variables. I got this message at that
> > time:
> >
> > MilestoneTeams plugin needs an upgrade
> > * Upgrading db
> > Creating 'milestone_teams' table.
> > Registering plugin version.
> > Done upgrading
> > AttributeError: 'NoneType' object has no attribute 'rollback'
> >
> > Perhaps the AttributeError resulted in an incomplete job of
> > updating the
> > database? I do not get the message to do the update again, so
> > some part
> > of it must be done. I do not see any messages in the Trac log
> > file. If I
> > run the update again, it says "Database is up to date, no
> > upgrade
> > necessary."
> >
> > --
> > Roger Oberholtzer
> >
> > --
> > You received this message because you are subscribed to the
> > Google Groups "Trac Users" group.
> > To post to this group, send email to
> > [email protected].
> > To unsubscribe from this group, send email to trac-users
> > [email protected].
> > For more options, visit this group at
> > http://groups.google.com/group/trac-users?hl=en.
> >
> >
> > --
> > You received this message because you are subscribed to the Google
> > Groups "Trac Users" group.
> > To post to this group, send email to [email protected].
> > To unsubscribe from this group, send email to trac-users
> > [email protected].
> > For more options, visit this group at
> > http://groups.google.com/group/trac-users?hl=en.
>
> --
> Roger Oberholtzer
>
> --
> You received this message because you are subscribed to the Google Groups
> "Trac Users" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/trac-users?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en.
