Ok I have added a new MySQL example here.<br><br><a href="http://wiki.freeswitch.org/wiki/Mod_lcr#Sample_Data">http://wiki.freeswitch.org/wiki/Mod_lcr#Sample_Data</a><br><br>Diego<br><br><div class="gmail_quote">On Wed, Jun 10, 2009 at 12:43 AM, Diego Viola <span dir="ltr"><<a href="mailto:diego.viola@gmail.com">diego.viola@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Fixed the issue, I will update the wiki now with a MySQL example.<br><br>Regards,<br><font color="#888888"><br>
Diego</font><div><div></div><div class="h5"><br><br><div class="gmail_quote">On Wed, Jun 10, 2009 at 12:21 AM, Mathieu Rene <span dir="ltr"><<a href="mailto:mrene_lists@avgs.ca" target="_blank">mrene_lists@avgs.ca</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">If we look at the message again,<br>
<div>(`fs_lcr/lcr`, CONSTRAINT `carrier_id` FOREIGN KEY (`carrier_id`)<br>
REFERENCES `carriers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)<br>
</div>And put it into words:<br>
The contrainst names fs_lcr/lcr affecting field carrier_id, and<br>
referencing the id field of the carriers table, fails.<br>
In other words, the value you have for carrier_id does not match any<br>
value of id in the carriers table.<br>
<br>
Math<br>
<div><br>
On 10-Jun-09, at 12:13 AM, Diego Viola wrote:<br>
<br>
> (`fs_lcr/lcr`, CONSTRAINT `carrier_id` FOREIGN KEY (`carrier_id`)<br>
> REFERENCES `carriers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)<br>
<br>
<br>
</div><div><div></div><div>_______________________________________________<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></blockquote></div><br>