<div dir="ltr">I didn't think to try it twice. But no, <div><br></div><div><div>freeswitch@default> show calls</div><div><br></div><div>-ERR SQL Error [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 3.51 Driver][mysqld-5.1.41-3ubuntu12.10-log]Table 'freeswitch.basic_calls' doesn't exist</div>
<div>]</div><div><br></div><div>freeswitch@default> 2011-08-12 01:17:40.494779 [ERR] switch_core_sqldb.c:825 ERR: [select * from basic_calls where hostname='sip2' order by call_created_epoch]</div><div>[STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 3.51 Driver][mysqld-5.1.41-3ubuntu12.10-log]Table 'freeswitch.basic_calls' doesn't exist</div>
<div>]</div><div>show calls</div><div><br></div><div>-ERR SQL Error [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 3.51 Driver][mysqld-5.1.41-3ubuntu12.10-log]Table 'freeswitch.basic_calls' doesn't exist</div>
<div>]</div><div><br></div><div>freeswitch@default> 2011-08-12 01:17:41.314777 [ERR] switch_core_sqldb.c:825 ERR: [select * from basic_calls where hostname='sip2' order by call_created_epoch]</div><div>[STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 3.51 Driver][mysqld-5.1.41-3ubuntu12.10-log]Table 'freeswitch.basic_calls' doesn't exist</div>
</div><div><br></div><div><br></div><div><br></div><div><br></div><div><br clear="all"><div dir="ltr"><span style="font-family:Verdana, Arial, Helvetica, sans-serif"><span style="font-size:small">-Avi</span></span></div>
<br><br><div class="gmail_quote">On Fri, Aug 12, 2011 at 1:12 AM, Anthony Minessale <span dir="ltr"><<a href="mailto:anthony.minessale@gmail.com">anthony.minessale@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
that's good, the error should be what triggered the creation of the view,<br>
<div><div></div><div class="h5"><br>
On Thu, Aug 11, 2011 at 3:22 PM, Avi Marcus <<a href="mailto:avi@avimarcus.net">avi@avimarcus.net</a>> wrote:<br>
> I did 1) git pull 2) make sync, rather than doing a make clean, 3) restarted<br>
> and 4) got:<br>
> 2011-08-11 23:20:45.654766 [ERR] switch_core_sqldb.c:825 ERR: [select * from<br>
> basic_calls where hostname='sip2' order by call_created_epoch]<br>
> [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 3.51<br>
> Driver][mysqld-5.1.41-3ubuntu12.10-log]Table 'freeswitch.basic_calls'<br>
> doesn't exist<br>
> Would a make clean be any different?<br>
> -Avi<br>
><br>
> On Thu, Aug 11, 2011 at 11:04 PM, Anthony Minessale<br>
> <<a href="mailto:anthony.minessale@gmail.com">anthony.minessale@gmail.com</a>> wrote:<br>
>><br>
>> i see a small way it may happen, update again and see if it works.<br>
>><br>
>><br>
>> On Thu, Aug 11, 2011 at 9:30 AM, mazilo <<a href="mailto:Nabble@slickdeals.endjunk.com">Nabble@slickdeals.endjunk.com</a>><br>
>> wrote:<br>
>> > Avi,<br>
>> ><br>
>> > I also just upgraded FS since .. 03/26/2011 ago. Now, my Seagate<br>
>> > DockStar is<br>
>> > hosting the same FS version you have. Notice that I don't know much<br>
>> > about<br>
>> > using ODBC, but my current FS version has been compiled with the<br>
>> > /--enable-core-odbc-support/ option. So, I haven't done anything to<br>
>> > create<br>
>> > any SQL database to use with my FS. However, then I pressed F4 key while<br>
>> > I<br>
>> > was on a call to ext. 3000 (conference call), it showed me with the call<br>
>> > in<br>
>> > progress and didn't show me the error message as you posted above. I<br>
>> > don't<br>
>> > know if having no SQL database file has anything to do with it.<br>
>> ><br>
>> > -----<br>
>> > FreeSWITCH hosted on a Seagate DockStar with OpenWRT and ONLY consumes 3<br>
>> > Watts of electricity.<br>
>> > --<br>
>> > View this message in context:<br>
>> > <a href="http://freeswitch-users.2379917.n2.nabble.com/odbc-basic-calls-tp6676013p6676584.html" target="_blank">http://freeswitch-users.2379917.n2.nabble.com/odbc-basic-calls-tp6676013p6676584.html</a><br>
>> > Sent from the freeswitch-users mailing list archive at Nabble.com.<br>
>> ><br>
>> > _______________________________________________<br>
>> > Join us at ClueCon 2011, Aug 9-11, Chicago<br>
>> > <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a> 877-7-4ACLUE<br>
>> ><br>
>> > FreeSWITCH-users mailing list<br>
>> > <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> > <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> > UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> > <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>> ><br>
>><br>
>><br>
>><br>
>> --<br>
>> Anthony Minessale II<br>
>><br>
>> FreeSWITCH <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org/</a><br>
>> ClueCon <a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com/</a><br>
>> Twitter: <a href="http://twitter.com/FreeSWITCH_wire" target="_blank">http://twitter.com/FreeSWITCH_wire</a><br>
>><br>
>> AIM: anthm<br>
>> <a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>
>> GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
>> IRC: <a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #freeswitch<br>
>><br>
>> FreeSWITCH Developer Conference<br>
>> <a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br>
>> <a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>
>> pstn:<a href="tel:%2B19193869900" value="+19193869900">+19193869900</a><br>
>><br>
>> _______________________________________________<br>
>> Join us at ClueCon 2011, Aug 9-11, Chicago<br>
>> <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a> 877-7-4ACLUE<br>
>><br>
>> FreeSWITCH-users mailing list<br>
>> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
><br>
><br>
> _______________________________________________<br>
> Join us at ClueCon 2011, Aug 9-11, Chicago<br>
> <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a> 877-7-4ACLUE<br>
><br>
> FreeSWITCH-users mailing list<br>
> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
><br>
><br>
<br>
<br>
<br>
--<br>
Anthony Minessale II<br>
<br>
FreeSWITCH <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org/</a><br>
ClueCon <a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com/</a><br>
Twitter: <a href="http://twitter.com/FreeSWITCH_wire" target="_blank">http://twitter.com/FreeSWITCH_wire</a><br>
<br>
AIM: anthm<br>
<a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>
GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #freeswitch<br>
<br>
FreeSWITCH Developer Conference<br>
<a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>
pstn:<a href="tel:%2B19193869900" value="+19193869900">+19193869900</a><br>
<br>
_______________________________________________<br>
Join us at ClueCon 2011, Aug 9-11, Chicago<br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a> 877-7-4ACLUE<br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br></div></div>