[Freeswitch-users] odbc basic_calls

[Anthony Minessale]

I think i fixed it in tree now so it will

On Sun, Aug 14, 2011 at 12:00 PM, Avi Marcus <avi at avimarcus.net> wrote:
> I dropped and recreated the channels table, which doesn't have callee_name
> but sent_callee_name now. Then when I created the view manually, it worked,
> but none of this got triggered to happen automatically.
> -Avi
>
>
> On Fri, Aug 12, 2011 at 3:05 PM, Avi Marcus <avi at avimarcus.net> wrote:
>>
>> Error in query: Unknown column 'a.sent_callee_name' in 'field list'
>> So table channels.. no, I don't see that in there. I see callee_name in
>> there though. Did it miss some channel table alterations?
>> Huh, tables complete, db_data, interfaces and a few more all seem new.
>> I've been running odbc in mysql for a year? but I've never seen these until
>> now.
>> -Avi Marcus
>>
>> p.s. move this to jira now that it's back up..?
>>
>> On Thu, Aug 11, 2011 at 5:02 PM, Peter Olsson
>> <peter.olsson at visionutveckling.se> wrote:
>>>
>>> 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&#246;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!
>>>
>>> _______________________________________________
>>> 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
>>> 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 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
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
IRC: irc.freenode.net #freeswitch

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