Hi Bill,<br><br>OK, no problem.<br><br>Regarding the database query. Apparently my testing database had become corrupt -- I am not sure whether this was a result of my tinkering with the database or from the scripts. I suspect that the corruption was not a result of the scripts. After your email, I started mysql manually, and mysql detected that the "testing" database was corrupt. I am not sure why mysql did not detect this earlier since I had started mysql manually a few times, albeit with a different user name and not "shim". Mysql said something about needing to repair the database, which it did behind the scenes. I did not need to run any of the scripts again. Then, when I started the shim, it just started working.<br>
<br>Before I had run the latest sql scripts for the first time (I had an older version of the shim database setup from over 1 year ago), I manually deleted the trading database. The testing database would not "drop" for some reason -- I cannot remember the error message. However, the setup.sql script had run OK, and the testing database looked fine upon running queries so I had initially assumed it was OK.<br>
<br>So to answer your question, I am not sure what I did to fix it. Somehow mysql detected the database corruption. Perhaps I should rerun the "setup.sql" script, but I have not done this since the shim says it connects OK.<br>
<br>Thanks.<br>Mike<br><br><div class="gmail_quote">On Tue, Mar 23, 2010 at 10:21 AM, Bill Pippin <span dir="ltr"><<a href="mailto:pippin@owlriver.net">pippin@owlriver.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Mike,<br>
<br>
Before I respond to your new question about history data, would<br>
you please be so kind as to let us know what the result was with<br>
respect to your previous query?<br>
<br>
In particular, I'm interested in whether you corrected the database<br>
permissions by using the setup.sql script, or whether you avoided<br>
the problem by manually entering the account code, offline, and in<br>
either case, what happended when you next started the shim.<br>
<br>
Your answer may also be of later interest to readers browsing our<br>
list archives.<br>
<br>
Thanks,<br>
<br>
Bill<br>
<br>
_______________________________________________<br>
ts-general mailing list<br>
<a href="mailto:ts-general@trading-shim.org">ts-general@trading-shim.org</a><br>
<a href="http://www.trading-shim.org/mailman/listinfo/ts-general" target="_blank">http://www.trading-shim.org/mailman/listinfo/ts-general</a><br>
</blockquote></div><br>