On 12/12/17, 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?

The update should be automatic by these lines:
https://www.fossil-scm.org/fossil/artifact/e094c603?ln=81-85

I don't know why it is not working for you.

Possible work-around:

     Run:   fossil sql $yourrepo
     Enter:  ALTER TABLE config ADD COLUMN mtime INTEGER;
     Then: UPDATE config SET mtime=now();

Let me know if that helps.


>
> thanks
>
>
>


-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
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