On Tue, Dec 12, 2017 at 6:57 PM, J Knight <j...@j2mfk.com> wrote:

> Hello. I have some older fossil archives that report:
>
>
>
> SQLITE_ERROR: table config has no column named mtime
>
> fossil: table config has no column named mtime: {REPLACE INTO
> config(name,value,mtime) VALUES('hash-policy',1,now())}
>
>
>
> issuing a ‘rebuild’ and a ‘rebuild –force’ gives the same error. Is there
> some way to bring these up to date or somehow migrate?
>

i'm not 100% certain that this will do the job, but it's worth a try...

See:

[stephan@host:~]$ f help decon
Usage f deconstruct ?OPTIONS? DESTINATION


This command exports all artifacts of a given repository and
writes all artifacts to the file system. The DESTINATION directory
will be populated with subdirectories AA and files AA/BBBBBBBBB.., where
AABBBBBBBBB.. is the 40+ character artifact ID, AA the first 2 characters.
If -L|--prefixlength is given, the length (default 2) of the directory
prefix can be set to 0,1,..,9 characters.

Options:
  -R|--repository REPOSITORY  deconstruct given REPOSITORY
  -L|--prefixlength N         set the length of the names of the DESTINATION
                              subdirectories to N
  --private                   Include private artifacts.

See also: rebuild, reconstruct

[stephan@host:~]$ f help recon
Usage: f reconstruct FILENAME DIRECTORY

This command studies the artifacts (files) in DIRECTORY and
reconstructs the fossil record from them. It places the new
fossil repository in FILENAME. Subdirectories are read, files
with leading '.' in the filename are ignored.

See also: deconstruct, rebuil


So... (untested)...

fossil decon -R repo.file ~/tmp/xxx

Then:

fossil recon repo-new.file ~/tmp/xxx


-- 
----- stephan beal
http://wanderinghorse.net/home/stephan/
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
_______________________________________________
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users

Reply via email to