Artifact 01476f5b439f0b7f12fc07cba672bd16ee00cba0
Ticket change
[01476f5b43]
- Ticket 665995e480 no such table: vvar status still Open with 1 other change
by
rwilson on
2009-09-23 05:41:03.
D 2009-09-23T05:41:03
J comment i\swas\sunable\sto\sdo\sa\ssimple\snew,\sopen:\r\n<pre>\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments>\sfossil\snew\sp:\\backup\\backup.f\r\nproject-id:\s0c559eca39534d82928edd0dee0e59a011461098\r\nserver-id:\s\s6b95e35610a5ea0b56e9cb1e8593d305ca6510a7\r\nadmin-user:\sron\swilson\s(initial\spassword\sis\s"2a32a6")\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments>\sfossil\sopen\sp:\\backup\\backup.f\r\nC:\\WINDOWS\\system32\\fossil.exe:\sno\ssuch\stable:\svvar\r\nREPLACE\sINTO\svvar(name,value)\sVALUES('repository','p:\\backup\\backup.f')\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments>\sfossil\sver\r\nThis\sis\sfossil\sversion\s[37f295c310]\s2009-09-21\s19:19:20\sUTC\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments>\r\n</pre>\r\n\r\n<hr><i>rwilson\sadded\son\s2009-09-23\s05:16:46:</i><br>\r\nthis\smay\sbe\shardware\srelated.\s\sseems\sto\swork\sfine\son\sC\sdrive,\sbut\sP\sis\sa\ssata\sdrive\sin\sa\susb\sexternal\senclosure.\s\swill\sinvestigate\sfurther.\r\n\r\n<hr><i>rwilson\sadded\son\s2009-09-23\s05:39:29:</i><br>\r\nit\sis\snot\shardware\srelated.\s\sfor\ssome\sreason\sfossil\sis\snot\sable\sopen\sa\srepository\sin\sthe\s'my\sdocuments'\sfolder.\s\sodd.\s\sit\sis\sable\sto\screate\sthe\s_FOSSIL_\sfile\sin\s'my\sdocuments'\sand\sit\sappears\sto\sbe\scomplete,\sso\si\scan't\sexplain\sthe\serror.\r\n\r\n<pre>\r\nPS\sC:\\fossil>\sfossil\snew\sp:\\backup\\test.f\r\nproject-id:\s711304708008228f835ddfed439613f3179944d6\r\nserver-id:\s\sacdf9cf7de168d7d9a08f18b360b1ed1c5e9b422\r\nadmin-user:\sron\swilson\s(initial\spassword\sis\s"36625a")\r\nPS\sC:\\fossil>\smd\snospaces\r\nPS\sC:\\fossil>\scd\snospaces\r\nPS\sC:\\fossil\\nospaces>\sfossil\sopen\sp:\\backup\\test.f\r\nPS\sC:\\fossil\\nospaces>\scd\s..\r\nPS\sC:\\fossil>\smd\s"one\sspace"\r\nPS\sC:\\fossil>\scd\s'one\sspace'\r\nPS\sC:\\fossil\\one\sspace>\sfossil\sopen\sp:\\backup\\test.f\r\nPS\sC:\\fossil\\one\sspace>\scd\s'C:\\Documents\sand\sSettings'\r\nPS\sC:\\Documents\sand\sSettings>\sfossil\sopen\sp:\\backup\\test.f\r\nPS\sC:\\Documents\sand\sSettings>\scd\s'ron\swilson'\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson>\sfossil\sopen\sp:\\backup\\test.f\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson>\scd\s'My\sDocuments'\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments>\sfossil\sopen\sp:\\backup\\test.f\r\nC:\\WINDOWS\\system32\\fossil.exe:\sno\ssuch\stable:\svvar\r\nREPLACE\sINTO\svvar(name,value)\sVALUES('repository','p:\\backup\\test.f')\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments>\sls\r\n\s\s\s\sDirectory:\sMicrosoft.PowerShell.Core\\FileSystem::C:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments\r\nMode\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\sLastWriteTime\s\s\s\s\sLength\sName\r\n----\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s-------------\s\s\s\s\s------\s----\r\n-a---\s\s\s\s\s\s\s\s\s9/23/2009\s\s\s1:35\sAM\s\s\s\s\s\s\s7168\s_FOSSIL_\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments>\ssqlite3\s_FOSSIL_\r\nSQLite\sversion\s3.6.1\r\nEnter\s".help"\sfor\sinstructions\r\nEnter\sSQL\sstatements\sterminated\swith\sa\s";"\r\nsqlite>\s.schema\r\nCREATE\sTABLE\svfile(\r\n\s\sid\sINTEGER\sPRIMARY\sKEY,\r\n\s\svid\sINTEGER\sREFERENCES\sblob,\r\n\s\schnged\sINT\sDEFAULT\s0,\r\n\s\sdeleted\sBOOLEAN\sDEFAULT\s0,\r\n\s\srid\sINTEGER,\r\n\s\smrid\sINTEGER,\r\n\s\smtime\sINTEGER,\r\n\s\spathname\sTEXT,\r\n\s\sorigname\sTEXT,\r\n\s\sUNIQUE(pathname,vid)\r\n);\r\nCREATE\sTABLE\svmerge(\r\n\s\sid\sINTEGER\sREFERENCES\svfile,\r\n\s\smerge\sINTEGER,\r\n\s\sUNIQUE(id,\smerge)\r\n);\r\nCREATE\sTABLE\svvar(\r\n\s\sname\sTEXT\sPRIMARY\sKEY\sNOT\sNULL,\r\n\s\svalue\sCLOB,\r\n\s\sCHECK(\stypeof(name)='text'\sAND\slength(name)>=1\s)\r\n);\r\nsqlite>\s.quit\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments>cd\s..\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson>\smd\s'my\sdocuments2'\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson>\scd\s'my\sdocuments2'\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\my\sdocuments2>\sfossil\sopen\sp:\\backup\\test.f\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\my\sdocuments2>cd\s'..\\My\sDocuments'\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments>\smd\stest\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments>\scd\stest\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments\\test>\sfossil\sopen\sp:\\backup\\test.f\r\nPS\sC:\\Documents\sand\sSettings\\ron\swilson\\My\sDocuments\\test>\r\n</pre>
K 665995e4806e119cc5eb62abdc4df5214324a7f3
U rwilson
Z c0b08a7fe7217357878b4967e67321f0