Issue 1009701
Created on 2004-08-15 22:40 by dlinke, last changed 2004-10-09 12:37 by dlinke.
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
|
|
Date |
User |
Action |
Args |
2004-08-15 22:40:00 | dlinke | create | |
|