Problem with the Installation of Estimator Plugin

Please turn on TracLogging and repeat the process. Then post your log on this ticket. (Just the parts where the errors are is fine). I grepped the code for usages, of &= and was unable to find any place I am using it. Is it possible that there is another plugin causing this problem?

Replying to bobbysmith007:

Please turn on TracLogging and repeat the process. Then post your log on this ticket. (Just the parts where the errors are is fine). I grepped the code for usages, of &= and was unable to find any place I am using it. Is it possible that there is another plugin causing this problem?

after installing estimator plugin, system asked to upgrade, we have performed the following commaind
trac-admin /home/svn/trac/venturia upgrade
while upgrading we are getting an errror : Command failed: unsupported operand type(s) for &=: 'bool' and 'OperationalError??'

and the output in error log is following

Trac[loader] DEBUG: Loading egg plugin estimatorplugin from /home/svn/trac/venturia/plugins/estimatorplugin-0.0.3-py2.5.egg Trac[api] DEBUG: Estimator needs upgrade? True [installed version:None pluginversion:1 Trac[env] WARNING: Component <estimatorplugin.api.EstimatorSetupParticipant? object at 0x9461bcc> requires environment upgrade Trac[api] DEBUG: Estimator needs upgrade? True [installed version:None pluginversion:1 Trac[api] DEBUG: Estimator about to upgrade from ver:None Trac[api] DEBUG: Creating Estimate and Estimate_Line_Item tables (Version 1) Trac[dbhelper] ERROR: There was a problem executing sql:CREATE TABLE estimate(

id integer PRIMARY KEY, rate DECIMAL, variability DECIMAL, communication DECIMAL, tickets VARCHAR(512), comment VARCHAR(8000)

)

with parameters:[]

Exception:table estimate already exists

Before installing estimator plugin we have installed Timing and Estimation Plugin, if this the problem how can i over come it, even i was tried uninstalling Timing and Estimation Plugin

please help us

Just to add some background. We installed the T&E plugin, and noticed we did not get "Estimate" on the menu bar (similar to what you have on the demo site).

Therefore we tried to install this plugin on top.

Does the T&E plugin provide the functionality of the Estimator Plugin, if so how do we enable "Estimate" on the menu bar?

Tony

after installing estimator plugin, system asked to upgrade, we have performed the following commaind trac-admin /home/svn/trac/venturia upgrade while upgrading we are getting an errror : Command failed: unsupported operand type(s) for &=: 'bool' and 'OperationalError???'

and the output in error log is following

Trac[loader] DEBUG: Loading egg plugin estimatorplugin from /home/svn/trac/venturia/plugins/estimatorplugin-0.0.3-py2.5.egg Trac[api] DEBUG: Estimator needs upgrade? True [installed version:None pluginversion:1 Trac[env] WARNING: Component <estimatorplugin.api.EstimatorSetupParticipant?? object at 0x9461bcc> requires environment upgrade Trac[api] DEBUG: Estimator needs upgrade? True [installed version:None pluginversion:1 Trac[api] DEBUG: Estimator about to upgrade from ver:None Trac[api] DEBUG: Creating Estimate and Estimate_Line_Item tables (Version 1) Trac[dbhelper] ERROR: There was a problem executing sql:CREATE TABLE estimate(

id integer PRIMARY KEY, rate DECIMAL, variability DECIMAL, communication DECIMAL, tickets VARCHAR(512), comment VARCHAR(8000)

)

with parameters:[]

Exception:table estimate already exists

Before installing estimator plugin we have installed Timing and Estimation Plugin, if this the problem how can i over come it, even i was tried uninstalling Timing and Estimation Plugin

These two are separate projects, trying to accomplish slightly different things. EstimatorPlugin was written Well after TimingandEstimationPlugin? and provides the "Estimate" menu item which allows construction of in-depth estimates. Timing and estimation plugin provides the "Estimated Hours" field to tickets.

It sounds like estimator did not properly install itself. In order to remove it completely, you will need to run sqlite (assuming you are using that) against the trac database and then tell it to drop the tables that it is complaining about.

sqlite3 /Path/to/TRACInstance/db/trac.db 'drop table estimate'

oops, meant to preview. Continuing...

Once you have that cleared up, you should be able to upgrade the plugin and have that go successfully. I am not sure what caused the initial problem, since we do not have a log for that point in time. Make sure that you keep the log rolling so that if we have any more issues, we can track them down.

HTH,

RUss

Ps. I didnt mean to imply that that was all timing and estimation plugin does. It also provides the "Billing" menu item and all of those reports. It also has a ticket change watcher to accumulate hours for you.

Thanks, will give dropping the table and resinstalling a go tomorrow. The individuals doing the install are located in India. Will update ticket with results

ok, depending on how far estimator got before it failed, you may also need to drop estimate_line_item.

even after droping two tables estimate and estimate_line_item tables, running upgrade command giving error as
get_system_value() takes exactly 2 arguments (1 given)
(trac-admin /home/svn/trac/venturia upgrade - this is the command i was used)

if i am running upgrade command again the error is changed and displayed old error as
Command failed: unsupported operand type(s) for &=: 'bool' and 'OperationalError'

please see the attached log file.

My System versions are:
fedora - 7
trac - 10.4
python 2.5
sqlite 3.3.13

trac.log file; problem with installing estimator plugin

Thanks finally i have installed the plugin.

The following changes i have done.
i have edited the dbhelper.py file at 114 line

i changed get_system_value(key): to if get_system_value(env, key):

after that i have reinstalled the plugin and its working fine.
please let me know whether i was correct or not. but the plugin is working fine as of now.

Thanks

(In [3399]) closes #2755

Fixed a missed function in dbhelper when I added env back into all the function calls

PLEASE UPGRADE TO THE LATEST VERSION

You seem to be using an older version than the current one