[Freeswitch-users] odbc basic_calls

[Peter Olsson]

Could you try to create it manually? The view's definition is in switch_core_sqldb.c on line 1721.

/Peter
________________________________________
Från: freeswitch-users-bounces at lists.freeswitch.org [freeswitch-users-bounces at lists.freeswitch.org] för Avi Marcus [avi at avimarcus.net]
Skickat: den 11 augusti 2011 15:48
Till: FreeSWITCH Users Help
Ämne: Re: [Freeswitch-users] odbc basic_calls

I don't see anything in the startup log about it checking the tables: http://pastebin.freeswitch.org/17013
This happens when I do "show calls". I know you changed something for show calls to even show 1 legged IVRs since my last update, but not having looked at the code, I don't see how that would be related.
I haven't heard of this basic_calls table before today.

-Avi Marcus

On Thu, Aug 11, 2011 at 4:33 PM, Anthony Minessale <anthony.minessale at gmail.com<mailto:anthony.minessale at gmail.com>> wrote:
its a view that should be created? perhaps there is an error on
startup creating the view in mysuckwell?


On Thu, Aug 11, 2011 at 6:28 AM, Avi Marcus <avi at avimarcus.net<mailto:avi at avimarcus.net>> wrote:
> I just upgraded FS since.. 7 weeks ago I think. Now: FreeSWITCH Version
> 1.0.head (git-9d98d49 2011-08-10 08-38-55 -0500)
> While testing the new build clean, when I hit F4 for show calls, I now get:
> freeswitch at internal> 2011-08-11 14:24:04.574797 [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
> Aren't the core odbc tables supposed to be auto-created?
> -Avi
> _______________________________________________
> Join us at ClueCon 2011, Aug 9-11, Chicago
> http://www.cluecon.com 877-7-4ACLUE
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org<mailto:FreeSWITCH-users at 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 at hotmail.com<mailto:MSN%3Aanthony_minessale at hotmail.com>
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<mailto:PAYPAL%3Aanthony.minessale at gmail.com>
IRC: irc.freenode.net<http://irc.freenode.net> #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org<mailto:sip%3A888 at conference.freeswitch.org>
googletalk:conf+888 at conference.freeswitch.org<mailto:googletalk%3Aconf%2B888 at conference.freeswitch.org>
pstn:+19193869900<tel:%2B19193869900>

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

FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org<mailto:FreeSWITCH-users at lists.freeswitch.org>
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

!DSPAM:4e43de1032765001342651!