I didn't think to try it twice. But no, 

freeswitch@default> show calls

-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
]

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]
[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
]
show calls

-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
]

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]
[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





-Avi


On Fri, Aug 12, 2011 at 1:12 AM, Anthony Minessale <anthony.minessale@gmail.com> wrote:
that's good, the error should be what triggered the creation of the view,

On Thu, Aug 11, 2011 at 3:22 PM, Avi Marcus <avi@avimarcus.net> wrote:
> I did 1) git pull 2) make sync, rather than doing a make clean, 3) restarted
> and 4) got:
> 2011-08-11 23:20:45.654766 [ERR] switch_core_sqldb.c:825 ERR: [select * from
> basic_calls where hostname='sip2' order by call_created_epoch]
> [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
> Would a make clean be any different?
> -Avi
>
> On Thu, Aug 11, 2011 at 11:04 PM, Anthony Minessale
> <anthony.minessale@gmail.com> wrote:
>>
>> i see a small way it may happen, update again and see if it works.
>>
>>
>> On Thu, Aug 11, 2011 at 9:30 AM, mazilo <Nabble@slickdeals.endjunk.com>
>> wrote:
>> > Avi,
>> >
>> > I also just upgraded FS since .. 03/26/2011 ago. Now, my Seagate
>> > DockStar is
>> > hosting the same FS version you have. Notice that I don't know much
>> > about
>> > using ODBC, but my current FS version has been compiled with the
>> > /--enable-core-odbc-support/ option. So, I haven't done anything to
>> > create
>> > any SQL database to use with my FS. However, then I pressed F4 key while
>> > I
>> > was on a call to ext. 3000 (conference call), it showed me with the call
>> > in
>> > progress and didn't show me the error message as you posted above. I
>> > don't
>> > know if having no SQL database file has anything to do with it.
>> >
>> > -----
>> > FreeSWITCH hosted on a Seagate DockStar with OpenWRT and ONLY consumes 3
>> > Watts of electricity.
>> > --
>> > View this message in context:
>> > http://freeswitch-users.2379917.n2.nabble.com/odbc-basic-calls-tp6676013p6676584.html
>> > Sent from the freeswitch-users mailing list archive at Nabble.com.
>> >
>> > _______________________________________________
>> > Join us at ClueCon 2011, Aug 9-11, Chicago
>> > http://www.cluecon.com 877-7-4ACLUE
>> >
>> > FreeSWITCH-users mailing list
>> > FreeSWITCH-users@lists.freeswitch.org
>> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> > http://www.freeswitch.org
>> >
>>
>>
>>
>> --
>> Anthony Minessale II
>>
>> FreeSWITCH http://www.freeswitch.org/
>> ClueCon http://www.cluecon.com/
>> Twitter: http://twitter.com/FreeSWITCH_wire
>>
>> AIM: anthm
>> MSN:anthony_minessale@hotmail.com
>> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com
>> IRC: irc.freenode.net #freeswitch
>>
>> FreeSWITCH Developer Conference
>> sip:888@conference.freeswitch.org
>> googletalk:conf+888@conference.freeswitch.org
>> pstn:+19193869900
>>
>> _______________________________________________
>> Join us at ClueCon 2011, Aug 9-11, Chicago
>> http://www.cluecon.com 877-7-4ACLUE
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users@lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>
>
> _______________________________________________
> Join us at ClueCon 2011, Aug 9-11, Chicago
> http://www.cluecon.com 877-7-4ACLUE
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users@lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>



--
Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/
Twitter: http://twitter.com/FreeSWITCH_wire

AIM: anthm
MSN:anthony_minessale@hotmail.com
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org
googletalk:conf+888@conference.freeswitch.org
pstn:+19193869900

_______________________________________________
Join us at ClueCon 2011, Aug 9-11, Chicago
http://www.cluecon.com 877-7-4ACLUE

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org