<div dir="ltr">I dropped and recreated the channels table, which doesn&#39;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.<br clear="all">

<div dir="ltr"><span style="font-family:Verdana, Arial, Helvetica, sans-serif"><span style="font-size:small">-Avi</span><br></span></div>
<br><br><div class="gmail_quote">On Fri, Aug 12, 2011 at 3:05 PM, Avi Marcus <span dir="ltr">&lt;<a href="mailto:avi@avimarcus.net">avi@avimarcus.net</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">

<div dir="ltr"><span style="color:rgb(255, 0, 0);font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;line-height:17px">Error in query: Unknown column &#39;a.sent_callee_name&#39; in &#39;field list&#39;</span><div>


<font face="Verdana, Arial, Helvetica, sans-serif"><span style="font-size:14px;line-height:17px;background-color:rgb(255, 255, 255)">So table channels.. no, I don&#39;t see that in there. I see </span></font><span style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:13px;line-height:16px">callee_name</span><span style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:13px;line-height:16px"> in there though. Did it miss some channel table alterations?</span></div>


<div><span style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:13px;line-height:16px"><br></span></div><div><span style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:13px;line-height:16px">Huh, tables complete, db_data, interfaces and a few more all seem new. I&#39;ve been running odbc in mysql for a year? but I&#39;ve never seen these until now.</span></div>


<div><font color="#ff0000" face="Verdana, Arial, Helvetica, sans-serif"><span style="font-size:14px;line-height:17px"><br clear="all">
</span></font><font color="#888888"><div dir="ltr"><span style="font-family:Verdana, Arial, Helvetica, sans-serif"><span style="font-size:small">-Avi Marcus</span><br></span></div></font><div dir="ltr"><span style="font-family:Verdana, Arial, Helvetica, sans-serif"><span style="font-size:small"><br>


</span></span></div><div dir="ltr"><span style="font-family:Verdana, Arial, Helvetica, sans-serif"><span style="font-size:small">p.s. move this to jira now that it&#39;s back up..?</span></span></div><div><div></div><div class="h5">


<br><br><div class="gmail_quote">On Thu, Aug 11, 2011 at 5:02 PM, Peter Olsson <span dir="ltr">&lt;<a href="mailto:peter.olsson@visionutveckling.se" target="_blank">peter.olsson@visionutveckling.se</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Could you try to create it manually? The view&#39;s definition is in switch_core_sqldb.c on line 1721.<br>
<br>
/Peter<br>
________________________________________<br>
Från: <a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a> [<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a>] f&amp;#246;r Avi Marcus [<a href="mailto:avi@avimarcus.net" target="_blank">avi@avimarcus.net</a>]<br>



Skickat: den 11 augusti 2011 15:48<br>
Till: FreeSWITCH Users Help<br>
Ämne: Re: [Freeswitch-users] odbc basic_calls<br>
<div><br>
I don&#39;t see anything in the startup log about it checking the tables: <a href="http://pastebin.freeswitch.org/17013" target="_blank">http://pastebin.freeswitch.org/17013</a><br>
This happens when I do &quot;show calls&quot;. 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&#39;t see how that would be related.<br>



I haven&#39;t heard of this basic_calls table before today.<br>
<br>
-Avi Marcus<br>
<br>
</div><div>On Thu, Aug 11, 2011 at 4:33 PM, Anthony Minessale &lt;<a href="mailto:anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>&lt;mailto:<a href="mailto:anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>&gt;&gt; wrote:<br>



its a view that should be created? perhaps there is an error on<br>
startup creating the view in mysuckwell?<br>
<br>
<br>
</div><div>On Thu, Aug 11, 2011 at 6:28 AM, Avi Marcus &lt;<a href="mailto:avi@avimarcus.net" target="_blank">avi@avimarcus.net</a>&lt;mailto:<a href="mailto:avi@avimarcus.net" target="_blank">avi@avimarcus.net</a>&gt;&gt; wrote:<br>


&gt; I just upgraded FS since.. 7 weeks ago I think. Now: FreeSWITCH Version<br>
&gt; 1.0.head (git-9d98d49 2011-08-10 08-38-55 -0500)<br>
&gt; While testing the new build clean, when I hit F4 for show calls, I now get:<br>
&gt; freeswitch@internal&gt; 2011-08-11 14:24:04.574797 [ERR]<br>
&gt; switch_core_sqldb.c:825 ERR: [select * from basic_calls where<br>
&gt; hostname=&#39;sip2&#39; order by call_created_epoch]<br>
&gt; [STATE: 42S02 CODE 1146 ERROR: [unixODBC][MySQL][ODBC 3.51<br>
&gt; Driver][mysqld-5.1.41-3ubuntu12.10-log]Table &#39;freeswitch.basic_calls&#39;<br>
&gt; doesn&#39;t exist<br>
&gt; Aren&#39;t the core odbc tables supposed to be auto-created?<br>
&gt; -Avi<br>
&gt; _______________________________________________<br>
&gt; Join us at ClueCon 2011, Aug 9-11, Chicago<br>
&gt; <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a> 877-7-4ACLUE<br>
&gt;<br>
&gt; FreeSWITCH-users mailing list<br>
</div>&gt; <a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a>&lt;mailto:<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a>&gt;<br>



<div>&gt; <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
&gt; UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
&gt; <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
&gt;<br>
&gt;<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>
</div><a href="mailto:MSN%3Aanthony_minessale@hotmail.com" target="_blank">MSN:anthony_minessale@hotmail.com</a>&lt;mailto:<a href="mailto:MSN%253Aanthony_minessale@hotmail.com" target="_blank">MSN%3Aanthony_minessale@hotmail.com</a>&gt;<br>


GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com" target="_blank">PAYPAL:anthony.minessale@gmail.com</a>&lt;mailto:<a href="mailto:PAYPAL%253Aanthony.minessale@gmail.com" target="_blank">PAYPAL%3Aanthony.minessale@gmail.com</a>&gt;<br>



IRC: <a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a>&lt;<a href="http://irc.freenode.net" target="_blank">http://irc.freenode.net</a>&gt; #freeswitch<br>
<br>
FreeSWITCH Developer Conference<br>
<a href="mailto:sip%3A888@conference.freeswitch.org" target="_blank">sip:888@conference.freeswitch.org</a>&lt;mailto:<a href="mailto:sip%253A888@conference.freeswitch.org" target="_blank">sip%3A888@conference.freeswitch.org</a>&gt;<br>


<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org" target="_blank">googletalk:conf+888@conference.freeswitch.org</a>&lt;mailto:<a href="mailto:googletalk%253Aconf%252B888@conference.freeswitch.org" target="_blank">googletalk%3Aconf%2B888@conference.freeswitch.org</a>&gt;<br>



pstn:<a href="tel:%2B19193869900" value="+19193869900" target="_blank">+19193869900</a>&lt;tel:%2B19193869900&gt;<br>
<div><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>
</div><a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a>&lt;mailto:<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a>&gt;<br>


<div><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>
</div>!DSPAM:4e43de1032765001342651!<br>
<div><div></div><div><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" target="_blank">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></div></div>
</blockquote></div><br></div>