[Freeswitch-users] odbc basic_calls

[Avi Marcus]

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
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20110814/b36dc749/attachment.html