Ok I have added a new MySQL example here. http://wiki.freeswitch.org/wiki/Mod_lcr#Sample_Data Diego On Wed, Jun 10, 2009 at 12:43 AM, Diego Viola <diego.viola@gmail.com> wrote:
Fixed the issue, I will update the wiki now with a MySQL example.
Regards,
Diego
On Wed, Jun 10, 2009 at 12:21 AM, Mathieu Rene <mrene_lists@avgs.ca>wrote:
If we look at the message again, (`fs_lcr/lcr`, CONSTRAINT `carrier_id` FOREIGN KEY (`carrier_id`) REFERENCES `carriers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) And put it into words: The contrainst names fs_lcr/lcr affecting field carrier_id, and referencing the id field of the carriers table, fails. In other words, the value you have for carrier_id does not match any value of id in the carriers table.
Math
On 10-Jun-09, at 12:13 AM, Diego Viola wrote:
(`fs_lcr/lcr`, CONSTRAINT `carrier_id` FOREIGN KEY (`carrier_id`) REFERENCES `carriers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
_______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org