<?xml version="1.0" encoding="utf-8" ?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">

    <title type="text">Tracks</title>
    <link rel="alternate" type="text/html" href="http://www.rousette.org.uk/projects/forums/" />
    <link rel="self" type="application/atom+xml" href="http://www.rousette.org.uk/projects/forums/atom/" />
    <updated>2008-08-04T10:17:54Z</updated>
    <rights>Copyright (c) 2008</rights>
    <generator uri="http://www.pmachine.com/" version="1.6.6">ExpressionEngine</generator>
    <id>tag:rousette.org.uk,2008:07:29</id>


    <entry>
      <title>Installing Tracks as a leopard service</title>
      <link rel="alternate" type="text/html" href="http://www.rousette.org.uk/projects/forums/viewthread/257/" />      
      <id>tag:rousette.org.uk,2008:projects/forums/viewthread/.257</id>
      <published>2008-07-29T01:26:32Z</published>
      <updated>2008-08-04T10:17:54Z</updated>
      <author><name>kstuart</name></author>
      <content type="html">
      <![CDATA[
        <p>Hi Everyone,</p>

<p>I&#8217;m using mongrel as my rails server and my goal is to have tracks start automatically with OS X, having got this working I though I would share the details here in case some of you wish to do the same, this should also work on OS X Server.</p>

<p>I should point out that if you&#8217;re using apache there&#8217;s a rails module (mod_rails) available so you could use that, I haven&#8217;t looked at apache on OS X yet so don&#8217;t have it running, however that is another option.</p>

<p>I should also point out that I&#8217;m still learning about OS X and this is my first foray into the launchd technology so this may not be the most robust way of setting this up but it seems to work well.</p>

<p>If you don&#8217;t have Git installed you can get it <a href="http://code.google.com/p/git-osx-installer/downloads/list?can=3">here</a>.</p>

<p>Ok, first we need tracks:<br />
&nbsp;   <span style="color:blue;">git clone&#8212;depth 1 git://github.com/bsag/tracks.git ~/tracks</span><br />
&nbsp;   <br />
&nbsp;   If you don&#8217;t want the bleeding edge checkout a stable version:<br />
&nbsp;  &nbsp;  &nbsp; <span style="color:blue;">cd ~/tracks<br />
&nbsp;  &nbsp;  &nbsp; git checkout v1.6</span><br />
&nbsp;   <br />
Next setup the rails environment:<br />
&nbsp;   <span style="color:blue;">cd ~/tracks<br />
&nbsp;   cp ./config/environment.rb.tmpl ./config/environment.rb<br />
&nbsp;   sed -i -e &#8216;/^SALT/s/change-me/<em>&lt;your salt secret&gt;</em>/&#8216; ./config/environment.rb<br />
&nbsp;  &nbsp;  &nbsp; <br />
&nbsp;   cp -r ./log.tmpl ./log<br />
&nbsp;   touch ./log/mongrel.log</span></p>

<p>&nbsp;   </p><div class="codeblock"><code><span style="color: #000000">
<span style="color: #007700">echo&nbsp;-</span><span style="color: #0000BB">e&nbsp;</span><span style="color: #DD0000">"\<br />&nbsp;&nbsp;&nbsp;&nbsp;&gt;&nbsp;production:\n\<br />&nbsp;&nbsp;&nbsp;&nbsp;&gt;&nbsp;&nbsp;&nbsp;adapter:&nbsp;sqlite3\n\<br />&nbsp;&nbsp;&nbsp;&nbsp;&gt;&nbsp;&nbsp;&nbsp;database:&nbsp;db/production.sqlite3\n\<br />&nbsp;&nbsp;&nbsp;&nbsp;&gt;&nbsp;&nbsp;&nbsp;timeout:&nbsp;5000"&nbsp;</span><span style="color: #007700">&gt;&nbsp;./</span><span style="color: #0000BB">config</span><span style="color: #007700">/</span><span style="color: #0000BB">database</span><span style="color: #007700">.</span><span style="color: #0000BB">yml&nbsp;</span>
</span>
</code></div><p></p>

<p>&nbsp;   <span style="color:blue;">rake db:migrate RAILS_ENV=production<br />
&nbsp;   cd ~</span><br />
&nbsp;   <br />
Check it works, use Ctrl-C if it started Ok:<br />
&nbsp;   <span style="color:blue;">mongrel_rails start -e production -c ~/tracks</span></p>

<p>Create a group for mongrel based services using the next available gid:<br />
&nbsp; (not sure why I created a mongrel group, seemed like a good idea at the time)</p>

<p>&nbsp; <span style="color:blue;">dscl . list groups PrimaryGroupID | awk &#8216;id&lt;$2 &#123;id=$2&#125; END &#123;print id+1&#125;&#8216;</span></p>

<p>&nbsp; if the gid returned above was greater than 500, replace 500 below with it&#8217;s value.</p>

<p>&nbsp; <span style="color:blue;"> sudo dseditgroup -o create -i 500 _mongrel<br />
&nbsp; sudo dscl . create Groups/_mongrel RecordName _mongrel mongrel</span></p>

<p>Create a user for Tracks using the next available uid:<br />
&nbsp; <br />
&nbsp; <span style="color:blue;">dscl . list users UniqueID | awk &#8216;id&lt;$2 &#123;id=$2&#125; END &#123;print id+1&#125;&#8216;</span></p>

<p>&nbsp; If the uid returned above was greater than 500, replace 500 below with it&#8217;s value.<br />
&nbsp; The PrimaryGroupID should be the gid you assigned to the _mongrel group above.</p>

<p>&nbsp; <span style="color:blue;">sudo dscl . create Users/_tracks<br />
&nbsp; sudo dscl . create Users/_tracks RecordName _tracks tracks<br />
&nbsp; sudo dscl . create Users/_tracks UniqueID 500<br />
&nbsp; sudo dscl . create Users/_tracks PrimaryGroupID 502<br />
&nbsp; sudo dscl . create Users/_tracks NFSHomeDirectory /var/empty<br />
&nbsp; sudo dscl . create Users/_tracks UserShell /usr/bin/false</span></p>

<p>Move tracks into /opt and set owner:<br />
 <span style="color:blue;"> sudo mv ~/tracks /opt/tracks<br />
&nbsp; sudo chown -R tracks:mongrel /opt/tracks</span></p>

<p>Create the file &#8216;~/uk.org.rousette.tracks.plist&#8217; with the following content:</p>

<p></p><div class="codeblock"><code><span style="color: #000000">
<span style="color: #0000BB">&lt;?xml&nbsp;version</span><span style="color: #007700">=</span><span style="color: #DD0000">"1.0"&nbsp;</span><span style="color: #0000BB">encoding</span><span style="color: #007700">=</span><span style="color: #DD0000">"UTF-8"</span><span style="color: #0000BB">?&gt;<br /></span><span style="color: #007700">&lt;!</span><span style="color: #0000BB">DOCTYPE&nbsp;plist&nbsp;</span><span style="color: #007700">PUBLIC&nbsp;</span><span style="color: #DD0000">"-//Apple&nbsp;Computer//DTD&nbsp;PLIST&nbsp;1.0//EN"&nbsp;"http://www.apple.com/DTDs/PropertyList-1.0.dtd"</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">plist&nbsp;version</span><span style="color: #007700">=</span><span style="color: #DD0000">"1.0"</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">dict</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">key</span><span style="color: #007700">&gt;</span><span style="color: #0000BB">Label</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">key</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;</span><span style="color: #0000BB">uk</span><span style="color: #007700">.</span><span style="color: #0000BB">org</span><span style="color: #007700">.</span><span style="color: #0000BB">rousette</span><span style="color: #007700">.</span><span style="color: #0000BB">tracks</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">key</span><span style="color: #007700">&gt;</span><span style="color: #0000BB">KeepAlive</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">key</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">true</span><span style="color: #007700">/&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">key</span><span style="color: #007700">&gt;</span><span style="color: #0000BB">RunAtLoad</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">key</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">true</span><span style="color: #007700">/&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">key</span><span style="color: #007700">&gt;</span><span style="color: #0000BB">UserName</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">key</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;</span><span style="color: #0000BB">_tracks</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">key</span><span style="color: #007700">&gt;</span><span style="color: #0000BB">WorkingDirectory</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">key</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;/</span><span style="color: #0000BB">opt</span><span style="color: #007700">/</span><span style="color: #0000BB">tracks</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">key</span><span style="color: #007700">&gt;</span><span style="color: #0000BB">Program</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">key</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;/</span><span style="color: #0000BB">usr</span><span style="color: #007700">/</span><span style="color: #0000BB">bin</span><span style="color: #007700">/</span><span style="color: #0000BB">mongrel_rails</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">key</span><span style="color: #007700">&gt;</span><span style="color: #0000BB">ProgramArguments</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">key</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;array&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;</span><span style="color: #0000BB">mongrel_rails</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;</span><span style="color: #0000BB">start</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;-</span><span style="color: #0000BB">eproduction</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">&#91;b&#93;</span><span style="color: #007700">&lt;</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;-</span><span style="color: #0000BB">a127.0.0.1</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;</span><span style="color: #0000BB">&#91;</span><span style="color: #007700">/</span><span style="color: #0000BB">b&#93;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#91;b&#93;</span><span style="color: #007700">&lt;</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;-</span><span style="color: #0000BB">p3000</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;</span><span style="color: #0000BB">&#91;</span><span style="color: #007700">/</span><span style="color: #0000BB">b&#93;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">&lt;</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;-</span><span style="color: #0000BB">llog</span><span style="color: #007700">/</span><span style="color: #0000BB">mongrel</span><span style="color: #007700">.</span><span style="color: #0000BB">log</span><span style="color: #007700">&lt;/</span><span style="color: #0000BB">string</span><span style="color: #007700">&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&lt;/array&gt;<br />&lt;/</span><span style="color: #0000BB">dict</span><span style="color: #007700">&gt;<br />&lt;/</span><span style="color: #0000BB">plist</span><span style="color: #007700">&gt;&nbsp;</span>
</span>
</code></div><p></p>

<p>You should probably set the port argument above to something other than 3000.</p>

<p>If you want to access Tracks across a network remove the address argument or set it to the machines network address.</p>

<p><span style="color:gray;"><i>Personally if I wanted to access tracks across the network I would probably use apache, either as a proxy to the mongrel daemon or using mod_rails.</i></span></p>

<p>Install the plist as a launch daemon:<br />
&nbsp; <span style="color:blue;">sudo mv ~/uk.org.rousette.tracks.plist /Library/LaunchDaemons<br />
&nbsp; sudo chown root:wheel /Library/LaunchDaemons/uk.org.rousette.tracks.plist<br />
&nbsp; sudo chmod 644 /Library/LaunchDaemons/uk.org.rousette.tracks.plist</span></p>

<p>All that&#8217;s left is to launch:</p>

<p>To start the daemon:<br />
&nbsp; <span style="color:blue;">sudo launchctl load /Library/LaunchDaemons/uk.org.rousette.tracks.plist</span></p>

<p>To stop the daemon:<br />
&nbsp; <span style="color:blue;">sudo launchctl remove uk.org.rousette.tracks</span></p>

<p>To restart the daemon:<br />
&nbsp; <span style="color:blue;">sudo launchctl stop uk.org.rousette.tracks</span></p>

<p>&nbsp; stop does stop the daemon but because we have KeepAlive set to true launchd simply restarts it, removing KeepAlive will allow you to use stop/start instead of load/remove.</p>

<p>You should now be able to access Tracks from your browser at the port you&#8217;ve specified and this should remain the case after reboot, if that&#8217;s not the case take a look at the Console application and the mongrel log for errors.</p>

<p>When you want to update to the latest code cd to the /opt/tracks folder and do one of the following:<br />
&nbsp; <span style="color:blue;">sudo git pull</span><br />
&nbsp; or<br />
&nbsp; <span style="color:blue;">sudo git pull&#8212;tags</span></p>

<p>If you&#8217;re not running the bleeding edge code don&#8217;t forget to checkout the changeset or tag you want.</p>

<p>Happy tracking  <img src="http://www.rousette.org.uk/projects/images/smileys/grin.gif" width="19" height="19" alt="grin" style="border:0;" /></p>
      ]]>
      </content>
    </entry>

    <entry>
      <title>Auth type not a valid authentication type</title>
      <link rel="alternate" type="text/html" href="http://www.rousette.org.uk/projects/forums/viewthread/131/" />      
      <id>tag:rousette.org.uk,2007:projects/forums/viewthread/.131</id>
      <published>2007-03-08T22:54:50Z</published>
      <updated></updated>
      <author><name>arima</name></author>
      <content type="html">
      <![CDATA[
        <p>Getting this error when I try to sign up on a new Tracks installation, trunk/SVN today, on 10.4.8.</p>

<p>Any ideas?</p>
      ]]>
      </content>
    </entry>

    <entry>
      <title>can&#8217;t activate rubyforge (= 0.4.5), already activated rubyforge&#45;1.0.0]</title>
      <link rel="alternate" type="text/html" href="http://www.rousette.org.uk/projects/forums/viewthread/243/" />      
      <id>tag:rousette.org.uk,2008:projects/forums/viewthread/.243</id>
      <published>2008-06-22T05:05:39Z</published>
      <updated></updated>
      <author><name>leonism</name></author>
      <content type="html">
      <![CDATA[
        <p>Hi everyone, </p>

<p>I&#8217;m still so new to tracks, so I encountered a few problems in installing it. After doing all the casualties (downloading, extracting and setting up the database connection) I done exactly the same thing as instructed in the documentation </p>

<blockquote><p>
Populate your database with the Tracks 1.6 schema<br />
Open a terminal and change into the root of your Tracks 1.6 directory. Enter the following command:<br />
rake db:migrate RAILS_ENV=production</p></blockquote>

<p>than it threw a few errors as the following:</p>

<blockquote><p>
gerryleonugroho:~/Desktop/tracks-1.6 gerryleonugroho$ rake db:migrate RAILS_ENV=production<br />
(in /Users/gerryleonugroho/Desktop/tracks-1.6)<br />
rake aborted!<br />
can&#8217;t activate rubyforge (= 0.4.5), already activated rubyforge-1.0.0]
</p></blockquote>

<p>Any idea what when wrong with my installation? Oh, btw, I&#8217;m on Mac OS X 10.4.11 and using MySQL for production environment.</p>

<p>Many thanks in advanced.</p>
      ]]>
      </content>
    </entry>

    <entry>
      <title>Missing Default Helper Path</title>
      <link rel="alternate" type="text/html" href="http://www.rousette.org.uk/projects/forums/viewthread/220/" />      
      <id>tag:rousette.org.uk,2008:projects/forums/viewthread/.220</id>
      <published>2008-04-17T13:43:29Z</published>
      <updated></updated>
      <author><name>siong1987</name></author>
      <content type="html">
      <![CDATA[
        <p>SwitchEnvironmentController: missing default helper path switch_environment_helper<br />
UnobtrusiveJavascriptController: missing default helper path unobtrusive_javascript_helper</p>

<p>I found two problems when I tried to run Tracks on Leopard. Anyone know how to solve this problem?</p>

<p>Thank you.</p>
      ]]>
      </content>
    </entry>

    <entry>
      <title>Starting Tracks in Leopard</title>
      <link rel="alternate" type="text/html" href="http://www.rousette.org.uk/projects/forums/viewthread/217/" />      
      <id>tag:rousette.org.uk,2008:projects/forums/viewthread/.217</id>
      <published>2008-04-14T00:51:36Z</published>
      <updated></updated>
      <author><name>shouldbeworking</name></author>
      <content type="html">
      <![CDATA[
        <p>OK, I&#8217;ve finally installed Tracks, had it running in Leopard/Safari. Then unloaded all the contents of my brain into it &amp; used it successfully for a week. Restarted my computer and have no idea how to get Tracks going again.</p>

<p>I assume it&#8217;s not as easy as pointing the browser to &#8220;http://localhost:8080/&#8220;?</p>

<p>I used an installer and am not very code savvy!</p>
      ]]>
      </content>
    </entry>

    <entry>
      <title>Tracks rev 701 &amp;amp; sqlite3 throwing: no such file to load &#45; sqlite3</title>
      <link rel="alternate" type="text/html" href="http://www.rousette.org.uk/projects/forums/viewthread/193/" />      
      <id>tag:rousette.org.uk,2008:projects/forums/viewthread/.193</id>
      <published>2008-01-23T20:28:27Z</published>
      <updated></updated>
      <author><name>go_suns</name></author>
      <content type="html">
      <![CDATA[
        <p>Tracks is awesome.&nbsp; I used it w/ MySQL for a year and it helped me get a lot done.&nbsp; Recently I wanted to use SQLite3 instead and here&#8217;s where the troubles begin.</p>

<p>I followed instructions from both the Trac site and the installation.html file included in Tracks but no matter what I do I keep getting a &#8216;no such file to load - sqlite3&#8217; when I start the server.</p>

<p>However I can run migrations just fine to set up the schema so I&#8217;m confused&#8212;unfortunately, I&#8217;m a weak Ruby coder so I am unable to solve this myself.</p>

<p>I&#8217;m not at my home cpu (os x 10.4) so I can&#8217;t post the stack trace, but the above message is etched in my head from searching all over Google for an answer&#8212;which I can&#8217;t find.</p>

<p>I&#8217;m on Ruby 1.8.6 and Rails 2.0.2 with the proper sqlite-ruby gem installed&#8212;though this shouldn&#8217;t affect Tracks as it was probably frozen, correct?</p>

<p>Anyway, I don&#8217;t suppose someone would be willing to walk me through a fresh install of Tracks (tag = current) on OS X 10.4 w/ SQLite3?&nbsp; I&#8217;m sure I can&#8217;t be the only one having this problem.</p>

<p>Thank you for the consideration and an excellent piece of software!</p>
      ]]>
      </content>
    </entry>

    <entry>
      <title>Problem importing the DB Schema into MySQL</title>
      <link rel="alternate" type="text/html" href="http://www.rousette.org.uk/projects/forums/viewthread/196/" />      
      <id>tag:rousette.org.uk,2008:projects/forums/viewthread/.196</id>
      <published>2008-02-22T08:40:16Z</published>
      <updated></updated>
      <author><name>pwever</name></author>
      <content type="html">
      <![CDATA[
        <p>When trying to get import the tracks database schema into my MySQL database, I continuously get the following MySQL Syntax error (full rake output further below).</p>

<p></p><div class="codeblock"><code><span style="color: #000000">
<span style="color: #0000BB">Mysql</span><span style="color: #007700">::</span><span style="color: #0000BB">Error</span><span style="color: #007700">:&nbsp;</span><span style="color: #FF8000">#42000You&nbsp;have&nbsp;an&nbsp;error&nbsp;in&nbsp;your&nbsp;SQL&nbsp;syntax;&nbsp;check&nbsp;the&nbsp;manual&nbsp;that&nbsp;corresponds&nbsp;to&nbsp;your&nbsp;MySQL&nbsp;server&nbsp;version&nbsp;for&nbsp;the&nbsp;right&nbsp;syntax&nbsp;to&nbsp;use&nbsp;near&nbsp;''contexts'&nbsp;SET&nbsp;'user_id'&nbsp;=&nbsp;1'&nbsp;at&nbsp;line&nbsp;1:&nbsp;UPDATE&nbsp;'contexts'&nbsp;SET&nbsp;'user_id'&nbsp;=&nbsp;1;&nbsp;</span>
</span>
</code></div><p></p>

<p><br />
I tried using &#8220;rake migrate&#8221; both with the rails version included tracks, and the latest version I have (2.0.2).</p>

<p>I was wondering whether anybody has or could create a MySQL schema dump and post it here?<br />
Help is much appreciated! Thanks // pascal</p>

<p>OS X 10.5<br />
MySQL 5.0.45</p>

<p><br />
</p><div class="codeblock"><code><span style="color: #000000">
<span style="color: #FF8000">#&gt;$&nbsp;rake&nbsp;migrate&nbsp;--trace<br /></span><span style="color: #007700">(</span><span style="color: #0000BB">in&nbsp;tmp</span><span style="color: #007700">/</span><span style="color: #0000BB">tracks</span><span style="color: #007700">)<br />**&nbsp;</span><span style="color: #0000BB">Invoke&nbsp;migrate&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">first_time</span><span style="color: #007700">)<br />**&nbsp;</span><span style="color: #0000BB">Invoke&nbsp;environment&nbsp;</span><span style="color: #007700">(</span><span style="color: #0000BB">first_time</span><span style="color: #007700">)<br />**&nbsp;</span><span style="color: #0000BB">Execute&nbsp;environment<br /></span><span style="color: #007700">**&nbsp;</span><span style="color: #0000BB">Execute&nbsp;migrate<br />rake&nbsp;aborted</span><span style="color: #007700">!<br /></span><span style="color: #0000BB">Mysql</span><span style="color: #007700">::</span><span style="color: #0000BB">Error</span><span style="color: #007700">:&nbsp;</span><span style="color: #FF8000">#42000You&nbsp;have&nbsp;an&nbsp;error&nbsp;in&nbsp;your&nbsp;SQL&nbsp;syntax;&nbsp;check&nbsp;the&nbsp;manual&nbsp;that&nbsp;corresponds&nbsp;to&nbsp;your&nbsp;MySQL&nbsp;server&nbsp;version&nbsp;for&nbsp;the&nbsp;right&nbsp;syntax&nbsp;to&nbsp;use&nbsp;near&nbsp;''contexts'&nbsp;SET&nbsp;'user_id'&nbsp;=&nbsp;1'&nbsp;at&nbsp;line&nbsp;1:&nbsp;UPDATE&nbsp;'contexts'&nbsp;SET&nbsp;'user_id'&nbsp;=&nbsp;1;<br /></span><span style="color: #007700">/</span><span style="color: #0000BB">tmp</span><span style="color: #007700">/</span><span style="color: #0000BB">tracks</span><span style="color: #007700">/</span><span style="color: #0000BB">vendor</span><span style="color: #007700">/</span><span style="color: #0000BB">rails</span><span style="color: #007700">/</span><span style="color: #0000BB">activerecord</span><span style="color: #007700">/</span><span style="color: #0000BB">lib</span><span style="color: #007700">/</span><span style="color: #0000BB">active_record</span><span style="color: #007700">/</span><span style="color: #0000BB">connection_adapters</span><span style="color: #007700">/</span><span style="color: #0000BB">abstract_adapter</span><span style="color: #007700">.</span><span style="color: #0000BB">rb</span><span style="color: #007700">:</span><span style="color: #0000BB">88</span><span style="color: #007700">:</span><span style="color: #0000BB">in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">log'<br />/tmp/tracks/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:180:in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">execute</span><span style="color: #DD0000">'<br />/tmp/tracks/vendor/rails/activerecord/lib/active_record/migration.rb:170:in&nbsp;`send'<br /></span><span style="color: #007700">/</span><span style="color: #0000BB">tmp</span><span style="color: #007700">/</span><span style="color: #0000BB">tracks</span><span style="color: #007700">/</span><span style="color: #0000BB">vendor</span><span style="color: #007700">/</span><span style="color: #0000BB">rails</span><span style="color: #007700">/</span><span style="color: #0000BB">activerecord</span><span style="color: #007700">/</span><span style="color: #0000BB">lib</span><span style="color: #007700">/</span><span style="color: #0000BB">active_record</span><span style="color: #007700">/</span><span style="color: #0000BB">migration</span><span style="color: #007700">.</span><span style="color: #0000BB">rb</span><span style="color: #007700">:</span><span style="color: #0000BB">170</span><span style="color: #007700">:</span><span style="color: #0000BB">in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">method_missing'<br />./db/migrate//2_add_user_id.rb:6:in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">up</span><span style="color: #DD0000">'<br />/tmp/tracks/vendor/rails/activerecord/lib/active_record/migration.rb:228:in&nbsp;`send'<br /></span><span style="color: #007700">/</span><span style="color: #0000BB">tmp</span><span style="color: #007700">/</span><span style="color: #0000BB">tracks</span><span style="color: #007700">/</span><span style="color: #0000BB">vendor</span><span style="color: #007700">/</span><span style="color: #0000BB">rails</span><span style="color: #007700">/</span><span style="color: #0000BB">activerecord</span><span style="color: #007700">/</span><span style="color: #0000BB">lib</span><span style="color: #007700">/</span><span style="color: #0000BB">active_record</span><span style="color: #007700">/</span><span style="color: #0000BB">migration</span><span style="color: #007700">.</span><span style="color: #0000BB">rb</span><span style="color: #007700">:</span><span style="color: #0000BB">228</span><span style="color: #007700">:</span><span style="color: #0000BB">in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">migrate'<br />/tmp/tracks/vendor/rails/activerecord/lib/active_record/migration.rb:223:in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">each</span><span style="color: #DD0000">'<br />/tmp/tracks/vendor/rails/activerecord/lib/active_record/migration.rb:223:in&nbsp;`migrate'<br /></span><span style="color: #007700">/</span><span style="color: #0000BB">tmp</span><span style="color: #007700">/</span><span style="color: #0000BB">tracks</span><span style="color: #007700">/</span><span style="color: #0000BB">vendor</span><span style="color: #007700">/</span><span style="color: #0000BB">rails</span><span style="color: #007700">/</span><span style="color: #0000BB">activerecord</span><span style="color: #007700">/</span><span style="color: #0000BB">lib</span><span style="color: #007700">/</span><span style="color: #0000BB">active_record</span><span style="color: #007700">/</span><span style="color: #0000BB">migration</span><span style="color: #007700">.</span><span style="color: #0000BB">rb</span><span style="color: #007700">:</span><span style="color: #0000BB">190</span><span style="color: #007700">:</span><span style="color: #0000BB">in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">up'<br />/tmp/tracks/vendor/rails/activerecord/lib/active_record/migration.rb:181:in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">migrate</span><span style="color: #DD0000">'<br />/tmp/tracks/vendor/rails/railties/lib/tasks/databases.rake:3<br />/Library/Ruby/Gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in&nbsp;`call'<br /></span><span style="color: #007700">/</span><span style="color: #0000BB">Library</span><span style="color: #007700">/</span><span style="color: #0000BB">Ruby</span><span style="color: #007700">/</span><span style="color: #0000BB">Gems</span><span style="color: #007700">/</span><span style="color: #0000BB">1.8</span><span style="color: #007700">/</span><span style="color: #0000BB">gems</span><span style="color: #007700">/</span><span style="color: #0000BB">rake</span><span style="color: #007700">-</span><span style="color: #0000BB">0.8.1</span><span style="color: #007700">/</span><span style="color: #0000BB">lib</span><span style="color: #007700">/</span><span style="color: #0000BB">rake</span><span style="color: #007700">.</span><span style="color: #0000BB">rb</span><span style="color: #007700">:</span><span style="color: #0000BB">546</span><span style="color: #007700">:</span><span style="color: #0000BB">in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">execute'<br />/Library/Ruby/Gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">each</span><span style="color: #DD0000">'<br />/Library/Ruby/Gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in&nbsp;`execute'<br /></span><span style="color: #007700">/</span><span style="color: #0000BB">Library</span><span style="color: #007700">/</span><span style="color: #0000BB">Ruby</span><span style="color: #007700">/</span><span style="color: #0000BB">Gems</span><span style="color: #007700">/</span><span style="color: #0000BB">1.8</span><span style="color: #007700">/</span><span style="color: #0000BB">gems</span><span style="color: #007700">/</span><span style="color: #0000BB">rake</span><span style="color: #007700">-</span><span style="color: #0000BB">0.8.1</span><span style="color: #007700">/</span><span style="color: #0000BB">lib</span><span style="color: #007700">/</span><span style="color: #0000BB">rake</span><span style="color: #007700">.</span><span style="color: #0000BB">rb</span><span style="color: #007700">:</span><span style="color: #0000BB">508</span><span style="color: #007700">:</span><span style="color: #0000BB">in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">invoke_with_call_chain'<br />/Library/Ruby/Gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">synchronize</span><span style="color: #DD0000">'<br />/Library/Ruby/Gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in&nbsp;`invoke_with_call_chain'<br /></span><span style="color: #007700">/</span><span style="color: #0000BB">Library</span><span style="color: #007700">/</span><span style="color: #0000BB">Ruby</span><span style="color: #007700">/</span><span style="color: #0000BB">Gems</span><span style="color: #007700">/</span><span style="color: #0000BB">1.8</span><span style="color: #007700">/</span><span style="color: #0000BB">gems</span><span style="color: #007700">/</span><span style="color: #0000BB">rake</span><span style="color: #007700">-</span><span style="color: #0000BB">0.8.1</span><span style="color: #007700">/</span><span style="color: #0000BB">lib</span><span style="color: #007700">/</span><span style="color: #0000BB">rake</span><span style="color: #007700">.</span><span style="color: #0000BB">rb</span><span style="color: #007700">:</span><span style="color: #0000BB">494</span><span style="color: #007700">:</span><span style="color: #0000BB">in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">invoke'<br />/Library/Ruby/Gems/1.8/gems/rake-0.8.1/lib/rake.rb:1931:in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">invoke_task</span><span style="color: #DD0000">'<br />/Library/Ruby/Gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in&nbsp;`top_level'<br /></span><span style="color: #007700">/</span><span style="color: #0000BB">Library</span><span style="color: #007700">/</span><span style="color: #0000BB">Ruby</span><span style="color: #007700">/</span><span style="color: #0000BB">Gems</span><span style="color: #007700">/</span><span style="color: #0000BB">1.8</span><span style="color: #007700">/</span><span style="color: #0000BB">gems</span><span style="color: #007700">/</span><span style="color: #0000BB">rake</span><span style="color: #007700">-</span><span style="color: #0000BB">0.8.1</span><span style="color: #007700">/</span><span style="color: #0000BB">lib</span><span style="color: #007700">/</span><span style="color: #0000BB">rake</span><span style="color: #007700">.</span><span style="color: #0000BB">rb</span><span style="color: #007700">:</span><span style="color: #0000BB">1909</span><span style="color: #007700">:</span><span style="color: #0000BB">in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">each'<br />/Library/Ruby/Gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">top_level</span><span style="color: #DD0000">'<br />/Library/Ruby/Gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in&nbsp;`standard_exception_handling'<br /></span><span style="color: #007700">/</span><span style="color: #0000BB">Library</span><span style="color: #007700">/</span><span style="color: #0000BB">Ruby</span><span style="color: #007700">/</span><span style="color: #0000BB">Gems</span><span style="color: #007700">/</span><span style="color: #0000BB">1.8</span><span style="color: #007700">/</span><span style="color: #0000BB">gems</span><span style="color: #007700">/</span><span style="color: #0000BB">rake</span><span style="color: #007700">-</span><span style="color: #0000BB">0.8.1</span><span style="color: #007700">/</span><span style="color: #0000BB">lib</span><span style="color: #007700">/</span><span style="color: #0000BB">rake</span><span style="color: #007700">.</span><span style="color: #0000BB">rb</span><span style="color: #007700">:</span><span style="color: #0000BB">1903</span><span style="color: #007700">:</span><span style="color: #0000BB">in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">top_level'<br />/Library/Ruby/Gems/1.8/gems/rake-0.8.1/lib/rake.rb:1881:in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">run</span><span style="color: #DD0000">'<br />/Library/Ruby/Gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in&nbsp;`standard_exception_handling'<br /></span><span style="color: #007700">/</span><span style="color: #0000BB">Library</span><span style="color: #007700">/</span><span style="color: #0000BB">Ruby</span><span style="color: #007700">/</span><span style="color: #0000BB">Gems</span><span style="color: #007700">/</span><span style="color: #0000BB">1.8</span><span style="color: #007700">/</span><span style="color: #0000BB">gems</span><span style="color: #007700">/</span><span style="color: #0000BB">rake</span><span style="color: #007700">-</span><span style="color: #0000BB">0.8.1</span><span style="color: #007700">/</span><span style="color: #0000BB">lib</span><span style="color: #007700">/</span><span style="color: #0000BB">rake</span><span style="color: #007700">.</span><span style="color: #0000BB">rb</span><span style="color: #007700">:</span><span style="color: #0000BB">1878</span><span style="color: #007700">:</span><span style="color: #0000BB">in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">run'<br />/Library/Ruby/Gems/1.8/gems/rake-0.8.1/bin/rake:31<br />/usr/bin/rake:19:in&nbsp;</span><span style="color: #007700">`</span><span style="color: #0000BB">load</span><span style="color: #007700">'</span><span style="color: #0000BB"><br />/usr/bin/rake:19<br />#&gt;$&nbsp;</span>
</span>
</code></div><p></p>
      ]]>
      </content>
    </entry>

    <entry>
      <title>Slingshot: Syncing offline work a reality&#63;</title>
      <link rel="alternate" type="text/html" href="http://www.rousette.org.uk/projects/forums/viewthread/179/" />      
      <id>tag:rousette.org.uk,2007:projects/forums/viewthread/.179</id>
      <published>2007-11-07T18:08:23Z</published>
      <updated></updated>
      <author><name>Prion</name></author>
      <content type="html">
      <![CDATA[
        <p>Background: After using Tracks extensively I realized that in my current job I am offline too often to shrug away the situation of being on a train and not having a record of my todo items let alone being able to work on them (the list, I mean). <br />
A local install worked so so only, with the odd loss of changes in the database (I used and still use Chronosync which does its job well as far as I can tell).<br />
So, despite the fact that I liked almost everything else about Tracks I moved on but kept returning here until I stumbled across your post about Slinghsot. </p>

<p> <img src="http://www.rousette.org.uk/projects/images/smileys/gulp.gif" width="19" height="19" alt="gulp" style="border:0;" /> </p>

<p>If I understand this correctly this means that this will be iincorporated into Tracks and install with it, transparent to the user, right? What I don&#8217;t quite understand is if this will depend on the data being hosted on a Joyent server. I am partly concerned about cost, but also security of my data. </p>

<p>And - how could it be otherwise - the infamous question: When, oh when? </p>

<p>Can you give an update on this rather exciting matter, please? Thank you</p>

<p>Prion</p>
      ]]>
      </content>
    </entry>

    <entry>
      <title>Mac OS X install without Locomotive</title>
      <link rel="alternate" type="text/html" href="http://www.rousette.org.uk/projects/forums/viewthread/176/" />      
      <id>tag:rousette.org.uk,2007:projects/forums/viewthread/.176</id>
      <published>2007-10-21T23:21:41Z</published>
      <updated></updated>
      <author><name>Saanvik</name></author>
      <content type="html">
      <![CDATA[
        <p>I really don&#8217;t want to install MySQL on my Mac, so I&#8217;m trying to install Tracks 1.043 without Locomotive.</p>

<p>Details: <br />
&nbsp; Mac Mini, intel processor<br />
&nbsp; OS 10.4.10<br />
&nbsp; Tracks 1.043<br />
&nbsp; <br />
Installed gems okay<br />
Installed sqlite3-ruby 1.2.1 using gems</p>

<p>And then I started to run into problems.</p>

<p>In the scripts directory, I opened the installation.html file<br />
Under SQLite/SQLite3 it says that the instructions are the same as for MySQL, except they aren&#8217;t (okay, I&#8217;m paraphrasing).&nbsp; The sentence ends with &#8220;so you&#8217;re ready to go&#8221;.&nbsp; Go where?</p>

<p>So, I started reading the MySQL instructions.</p>

<p>Unzip tracks.&nbsp; Okay, already did that.<br />
Make a database - is this one of the steps that&#8217;s already done?&nbsp; Sounds like it, so I skip to the next bullet point.<br />
All about database.yml - ah, I don&#8217;t have to change that.<br />
Next, change the salt in environment.rb.&nbsp; Cool.&nbsp; Done.<br />
Now, rake migrate - oh oh, it doesn&#8217;t work.</p>

<p>rake aborted!<br />
uninitialized constant API</p>

<p>(See full trace by running task with&#8212;trace)</p>

<p>Okay, let&#8217;s trace.</p>

<p>(in /Users/stevenanderson/applications/tracks-1.043)<br />
** Invoke migrate (first_time)<br />
** Invoke db:migrate (first_time)<br />
** Invoke environment (first_time)<br />
** Execute environment<br />
** Execute db:migrate<br />
rake aborted!<br />
uninitialized constant API<br />
/Users/stevenanderson/applications/tracks-1.043/config/../vendor/rails/activerecord/lib/../../activesupport/lib/active_support/dependencies.rb:112:in `const_missing&#8217;<br />
/Users/stevenanderson/applications/tracks-1.043/config/../vendor/rails/activerecord/lib/../../activesupport/lib/active_support/dependencies.rb:122:in `send&#8217;<br />
/Users/stevenanderson/applications/tracks-1.043/config/../vendor/rails/activerecord/lib/../../activesupport/lib/active_support/dependencies.rb:122:in `const_missing&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/driver/native/driver.rb:100:in `open&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/database.rb:111:in `initialize&#8217;<br />
/Users/stevenanderson/applications/tracks-1.043/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:17:in `new&#8217;<br />
/Users/stevenanderson/applications/tracks-1.043/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:17:in `sqlite3_connection&#8217;<br />
/Users/stevenanderson/applications/tracks-1.043/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:in `send&#8217;<br />
/Users/stevenanderson/applications/tracks-1.043/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:in `connection_without_query_cache=&#8216;<br />
/Users/stevenanderson/applications/tracks-1.043/config/../vendor/rails/activerecord/lib/active_record/query_cache.rb:54:in `connection=&#8216;<br />
/Users/stevenanderson/applications/tracks-1.043/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:220:in `retrieve_connection&#8217;<br />
/Users/stevenanderson/applications/tracks-1.043/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in `connection&#8217;<br />
/Users/stevenanderson/applications/tracks-1.043/config/../vendor/rails/activerecord/lib/active_record/migration.rb:280:in `migrate&#8217;<br />
/Users/stevenanderson/applications/tracks-1.043/config/../vendor/rails/railties/lib/tasks/databases.rake:4<br />
/Users/stevenanderson/applications/tracks-1.043/config/../vendor/rails/railties/lib/tasks/databases.rake:3:in `call&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `each&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in `invoke&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `synchronize&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `invoke&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:369:in `invoke_prerequisites&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:368:in `each&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1003:in `send&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1003:in `each&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:368:in `invoke_prerequisites&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:361:in `invoke&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `synchronize&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `invoke&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `top_level&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `each&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `top_level&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1733:in `standard_exception_handling&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1733:in `top_level&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1711:in `run&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1708:in `standard_exception_handling&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1708:in `run&#8217;<br />
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/bin/rake:7<br />
/usr/bin/rake:16:in `load&#8217;<br />
/usr/bin/rake:16</p>

<p><br />
Any ideas?</p>
      ]]>
      </content>
    </entry>

    <entry>
      <title>MySQL &amp;gt; SQLite3 db transition (Tracks 1.043 Locomotive install on 10.4.10)</title>
      <link rel="alternate" type="text/html" href="http://www.rousette.org.uk/projects/forums/viewthread/169/" />      
      <id>tag:rousette.org.uk,2007:projects/forums/viewthread/.169</id>
      <published>2007-09-14T20:54:45Z</published>
      <updated></updated>
      <author><name>timfm</name></author>
      <content type="html">
      <![CDATA[
        <p>Hi All,</p>

<p>I&#8217;ve been somewhat successful getting the Locomotive install running on my new iMac. The app is there and I signed in and can login.</p>

<p>My problems arise when trying to import my old MySQL dump into the (empty/default?) SQLite3 db.</p>

<p>When I run: sqlite3 db/tracks-104.db &lt; db/tracks-104-dump.sql </p>

<p>(in terminal from my new tracks-1.043 folder&#8212;yes I named my old dump &#8220;tracks-104-dump.sql&#8221; which I did in YourSQL on my old system)</p>

<p>as per bsag&#8217;s post: <a href="http://www.rousette.org.uk/projects/forums/viewthread/132/#413">Updated Tracks 1.043 for installation with Locomotive</a></p>

<p>I get a big chunk of data and then this error:</p>

<p>SQL error: unrecognized token: &#8220;`&#8220;<br />
UNLOCK TABLES;<br />
SQL error: near &#8220;UNLOCK&#8221;: syntax error<br />
CREATE TABLE `todos` (<br />
&nbsp; `id` int(11) NOT NULL auto_increment,<br />
&nbsp; `context_id` int(11) NOT NULL default &#8216;0&#8217;,<br />
&nbsp; `project_id` int(11) default NULL,<br />
&nbsp; `description` varchar(255) NOT NULL default &#8216;&#8217;,<br />
&nbsp; `notes` text,<br />
&nbsp; `done` tinyint(1) NOT NULL default &#8216;0&#8217;,<br />
&nbsp; `created_at` datetime default NULL,<br />
&nbsp; `due` date default NULL,<br />
&nbsp; `completed` datetime default NULL,<br />
&nbsp; `user_id` int(11) default &#8216;1&#8217;,<br />
&nbsp; PRIMARY KEY  (`id`)<br />
) ENGINE=InnoDB DEFAULT CHARSET=latin1;<br />
SQL error: unrecognized token: &#8220;`&#8220;<br />
LOCK TABLES `todos` WRITE;<br />
SQL error: unrecognized token: &#8220;`&#8220;</p>

<p><br />
and then another big chunk and then this error:</p>

<p><br />
UNLOCK TABLES;<br />
SQL error: unrecognized token: &#8220;`&#8220;<br />
CREATE TABLE `users` (<br />
&nbsp; `id` int(11) NOT NULL auto_increment,<br />
&nbsp; `login` varchar(80) NOT NULL default &#8216;&#8217;,<br />
&nbsp; `password` varchar(40) NOT NULL default &#8216;&#8217;,<br />
&nbsp; `word` varchar(255) default NULL,<br />
&nbsp; `is_admin` tinyint(1) NOT NULL default &#8216;0&#8217;,<br />
&nbsp; `preferences` text,<br />
&nbsp; PRIMARY KEY  (`id`)<br />
) ENGINE=InnoDB DEFAULT CHARSET=latin1;<br />
SQL error: unrecognized token: &#8220;`&#8220;<br />
LOCK TABLES `users` WRITE;<br />
SQL error: unrecognized token: &#8220;`&#8220;<br />
INSERT INTO `users` VALUES (1,&#8216;tim&#8217;,&#8216;c4b709311c79f499e8d376767ef63eb903c1c91a&#8217;,&#8216;22fd8dd501eaa43800309a6130aff04bea8603f0&#8217;,1,&#8216;&#8212;- \nstaleness_starts: \&#8220;180\&#8220;\ndate_format: \&#8220;%d/%m/%Y\&#8220;\nno_completed: \&#8220;5\&#8220;\nadmin_email: butshesagirl at rousette dot org dot uk\nweek_starts: \&#8220;1\&#8220;\ndue_style: \&#8220;1\&#8220;&#8216;);<br />
SQL error: unrecognized token: &#8220;`&#8220;<br />
UNLOCK TABLES;<br />
SQL error: near &#8220;UNLOCK&#8221;: syntax error</p>

<p><br />
So I&#8217;m stuck. Can someone help me migrate my database to SQLite3?</p>

<p>As far as converting the boolean fields. Is bsag&#8217;s syntax correct (I was getting errors)?</p>

<p>Should:<br />
sqlite&gt; set done = ‘f’<br />
be<br />
sqlite&gt; set done = f</p>

<p>Should<br />
sqlite&gt; where done = 0;<br />
be <br />
sqlite&gt; where done = 0</p>

<p>Any help with this last hurdle would be greatly appreciated so I can et back to getting things done. I can email you mt SQL dump if needed.</p>
      ]]>
      </content>
    </entry>


</feed>