THat commit just removes a .rej file, don't see how it can affect<div><br></div><div><div>$ git diff --stat 1d2c64d33bf033788c5521c212b861ba11c229af..5530de66ef6880621086c6276731504459eb6709</div><div><br></div><div>(those are the two SHA1s I'm getting stats on, first is tony's just before my changes, second is mine)</div>
<div><br></div><div><div> src/include/switch_types.h.orig | 1714 ------</div><div> .../mod_conference/mod_conference.c.orig | 6343 --------------------</div><div> .../mod_conference/mod_conference.c.rej | 50 -</div>
<div> src/mod/formats/mod_sndfile/mod_sndfile.c.orig | 462 --</div><div> .../languages/mod_python/mod_python_wrap.cpp.rej | 38 -</div><div> src/switch_core.c.orig | 2018 -------</div><div>
src/switch_time.c.orig | 1962 ------</div><div> 7 files changed, 0 insertions(+), 12587 deletions(-)</div></div><div><br></div><div><br></div><div>Don't see how removing patch droppings can possibly cause your problem.</div>
</div><div><br></div><div>The real issue is that the interfaces table doesn't exist. The last error is because the table didn't exist for the records to be inserted into. As with all core tables, this SHOULD be auto-created.</div>
<div><br></div><div>Are you running against odbc for core or sqlite?</div><div><br><div class="gmail_quote">On Wed, May 12, 2010 at 6:48 AM, Muhammad Shahzad <span dir="ltr"><<a href="mailto:shaheryarkh@googlemail.com">shaheryarkh@googlemail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi,<br><br>For last two days i am trying to setup a freeswitch box for an voip application testing against it. FreeSWITCH compiles successfully but when i try to start it i get a lot critical errors from switch_core_sqldb.c, e.g.<br>
<br><br><span style="color:rgb(255, 0, 0)">2010-05-12 16:35:42.691358 [ERR] switch_core_sqldb.c:404 SQL ERR [no such table: interfaces]</span><br style="color:rgb(255, 0, 0)"><span style="color:rgb(255, 0, 0)">insert into interfaces (type,name,description,syntax,ikey,filename,hostname) values('chat','event','','','mod_dptools','/usr/local/freeswitch/mod/mod_dptools.so','lenovo');</span><br style="color:rgb(255, 0, 0)">
<span style="color:rgb(255, 0, 0)">insert into interfaces (type,name,description,syntax,ikey,filename,hostname) values('chat','api','','','mod_dptools','/usr/local/freeswitch/mod/mod_dptools.so','lenovo');</span><br style="color:rgb(255, 0, 0)">
<span style="color:rgb(255, 0, 0)">insert into interfaces (type,name,description,syntax,ikey,filename,hostname) values('api','expr','Eval an expression','<expr>','mod_expr','/usr/local/freeswitch/mod/mod_expr.so','lenovo');</span><br style="color:rgb(255, 0, 0)">
<br style="color:rgb(255, 0, 0)"><span style="color:rgb(255, 0, 0)">2010-05-12 16:35:42.691419 [ERR] switch_core_sqldb.c:670 SQL ERR [no such table: interfaces]</span><br style="color:rgb(255, 0, 0)"><span style="color:rgb(255, 0, 0)">2010-05-12 16:35:42.791490 [CRIT] switch_core_sqldb.c:889 SQL thread unable to commit transaction, records lost!</span><br style="color:rgb(255, 0, 0)">
<br>and it continues till my machine eventually hangs. Its happening with latest git revision, i don't know how to get revision number in git (i am not much familiar with it) but "git log" command give this as first line.<br>
<br>commit 5530de66ef6880621086c6276731504459eb6709<br>Author: Rupa Schomaker <<a href="mailto:rupa@rupa.com" target="_blank">rupa@rupa.com</a>><br>Date: Wed May 12 03:32:18 2010 -0500<br><br clear="all">I suspect the last line, i.e.<br>
<span style="color:rgb(255, 0, 0)">2010-05-12 16:35:42.791490 [CRIT]
switch_core_sqldb.c:889 SQL thread unable to commit transaction, records
lost!</span><br><br>is the reason for these errors but i am not sure why its happening.<br><br>Thank you.<br><font color="#888888"><br><br>-- <br>Muhammad Shahzad<br>-----------------------------------<br>CISCO Rich Media Communication Specialist (CRMCS)<br>
CISCO Certified Network Associate (CCNA)<br>Cell: +92 334 422 40 88<br>MSN: <a href="mailto:shari_786pk@hotmail.com" target="_blank">shari_786pk@hotmail.com</a><br>Email: <a href="mailto:shaheryarkh@googlemail.com" target="_blank">shaheryarkh@googlemail.com</a><br>
</font><br>_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">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>
<br></blockquote></div><br><br clear="all"><br>-- <br>-Rupa<br>
</div>