Roundup Tracker - Issues

Issue 1009701

classification
Export bug with sqlite-backend
Type: Severity: normal
Components: Command-line interface Versions:
process
Status: closed fixed
:
: richard : dlinke, richard
Priority: normal :

Created on 2004-08-15 22:40 by dlinke, last changed 2004-10-09 12:37 by dlinke.

Messages
msg1420 Author: [hidden] (dlinke) Date: 2004-08-15 22:40
Export does not work in our roundup installation:
roundup 0.7.6, default-tracker, sqlite-backend, win XP

Here is the export trial:

C:\P-Lang\Python23\Scripts>roundup-admin
Roundup 0.7.6 ready for input.
Type "help" for help.
Note: command history and editing not available
roundup> export c:/zusatz
Enter tracker home: c:/home/roundup/universal
Traceback (most recent call last):
  File
"C:\P-Lang\Python23\lib\site-packages\roundup\admin.py", 
    line 1273, in run_command
    ret = function(args[1:])
  File
"C:\P-Lang\Python23\lib\site-packages\roundup\admin.py", 
    line 1051, in do_export
    map(journals.writerow, cl.export_journals())
  File
"C:\P-Lang\Python23\lib\site-packages\roundup\backends\rdbms_common.py",
    line 2504, in export_journals
    for nodeid, date, user, action, params in
self.history(nodeid):
  File
"C:\P-Lang\Python23\lib\site-packages\roundup\backends\rdbms_common.py",
    line 1824, in history
    return self.db.getjournal(self.classname, nodeid)
  File
"C:\P-Lang\Python23\lib\site-packages\roundup\backends\rdbms_common.py",
    line 1110, in getjournal
    params = eval(params)
  File "<string>", line 1
     {'password': <roundup.password.Password instance
at 0x00EF8FD0>}
                  ^
 SyntaxError: invalid syntax
roundup>

I tried to look at this in the code but could not
figure out how this can
happen. So any help would be very much appreciated.

David
msg1421 Author: [hidden] (dlinke) Date: 2004-08-16 09:36
Logged In: YES 
user_id=734219

Richard,

maybe it helps to know that some files were written before
the exception was raised: (bytes/name)

22 744 keyword-journals.csv
1 188   keyword.csv
10 054 priority-journals.csv
   262 priority.csv
23 572 status-journals.csv
   407 status.csv
       0 user-journals.csv
 2 781 user.csv

Looks like creating user-journals.csv caused the problem.

David
msg1422 Author: [hidden] (dlinke) Date: 2004-08-16 09:36
Logged In: YES 
user_id=734219

Richard,

maybe it helps to know that some files were written before
the exception was raised: (bytes/name)

22 744 keyword-journals.csv
1 188   keyword.csv
10 054 priority-journals.csv
   262 priority.csv
23 572 status-journals.csv
   407 status.csv
       0 user-journals.csv
 2 781 user.csv

Looks like creating user-journals.csv caused the problem.

David
msg1423 Author: [hidden] (richard) Date: 2004-10-08 01:42
Logged In: YES 
user_id=6405

Hrm, it looks like a corruption (due to a bug which has been 
fixed a while ago) in a user journal. 
 
It'll have to be manually fixed before the export will work. The 
simplest way is to delete the journal table entry (or entries) 
which contain the invalid password data. To do this: 
 
1. make a copy of the sqlite "db" file beforehand - it's "<tracker 
home>/db/db" 
2. run sqlite ("sqlite <tracker home>/db/db") 
3. delete from user__journal where params like 
'%roundup.password.Password%'; 
 
msg1424 Author: [hidden] (dlinke) Date: 2004-10-09 12:37
Logged In: YES 
user_id=734219

Thanks Richard, that fixed the problem!
David
History
Date User Action Args
2004-08-15 22:40:00dlinkecreate