[Spce-user] Voicemail Folders

[Jonathan Scott]

When saving messages into a folder it fails of fun sql errors:

Oct  5 16:43:26 sip asterisk[1722]: WARNING[7108]: res_odbc.c:105 in 
ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: 
[MySQL][ODBC 5.1 Driver][mysqld-5.1.57-rel12.8-log]Cannot add or update 
a child row: a foreign key constraint fails 
(`kamailio`.`voicemail_spool`, CONSTRAINT `v_s_mailboxuser_ref` FOREIGN 
KEY (`mailboxuser`) REFERENCES `voicemail_users` (`customer_id`) ON (289)
Oct  5 16:43:26 sip asterisk[1722]: WARNING[7108]: res_odbc.c:113 in 
ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a 
reconnect...
Oct  5 16:43:31 sip asterisk[1722]: NOTICE[7108]: res_odbc.c:537 in 
odbc_obj_connect: Connecting asterisk
Oct  5 16:43:31 sip asterisk[1722]: NOTICE[7108]: res_odbc.c:565 in 
odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]
Oct  5 16:43:31 sip asterisk[1722]: WARNING[7108]: res_odbc.c:105 in 
ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: 
[MySQL][ODBC 5.1 Driver][mysqld-5.1.57-rel12.8-log]Cannot add or update 
a child row: a foreign key constraint fails 
(`kamailio`.`voicemail_spool`, CONSTRAINT `v_s_mailboxuser_ref` FOREIGN 
KEY (`mailboxuser`) REFERENCES `voicemail_users` (`customer_id`) ON (289)
Oct  5 16:43:31 sip asterisk[1722]: WARNING[7108]: res_odbc.c:113 in 
ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a 
reconnect...
Oct  5 16:43:36 sip asterisk[1722]: NOTICE[7108]: res_odbc.c:537 in 
odbc_obj_connect: Connecting asterisk
Oct  5 16:43:36 sip asterisk[1722]: NOTICE[7108]: res_odbc.c:565 in 
odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]
Oct  5 16:43:36 sip asterisk[1722]: WARNING[7108]: app_voicemail.c:2540 
in copy_file: SQL Execute error!#012[INSERT INTO voicemail_spool (dir, 
msgnum, context, macrocontext, callerid, origtime, duration, recording, 
mailboxuser, mailboxcontext) SELECT 
?,?,context,macrocontext,callerid,origtime,duration,recording,?,? FROM 
voicemail_spool WHERE dir=? AND msgnum=?] (You probably don't have MySQL 
4.1 or later installed)#012
Oct  5 16:43:47 sip asterisk[1722]: WARNING[7108]: res_odbc.c:105 in 
ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: 
[MySQL][ODBC 5.1 Driver][mysqld-5.1.57-rel12.8-log]Cannot add or update 
a child row: a foreign key constraint fails 
(`kamailio`.`voicemail_spool`, CONSTRAINT `v_s_mailboxuser_ref` FOREIGN 
KEY (`mailboxuser`) REFERENCES `voicemail_users` (`customer_id`) ON (289)
Oct  5 16:43:47 sip asterisk[1722]: WARNING[7108]: res_odbc.c:113 in 
ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a 
reconnect...
Oct  5 16:43:52 sip asterisk[1722]: NOTICE[7108]: res_odbc.c:537 in 
odbc_obj_connect: Connecting asterisk
Oct  5 16:43:52 sip asterisk[1722]: NOTICE[7108]: res_odbc.c:565 in 
odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]
Oct  5 16:43:52 sip asterisk[1722]: WARNING[7108]: res_odbc.c:105 in 
ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: 
[MySQL][ODBC 5.1 Driver][mysqld-5.1.57-rel12.8-log]Cannot add or update 
a child row: a foreign key constraint fails 
(`kamailio`.`voicemail_spool`, CONSTRAINT `v_s_mailboxuser_ref` FOREIGN 
KEY (`mailboxuser`) REFERENCES `voicemail_users` (`customer_id`) ON (289)
Oct  5 16:43:52 sip asterisk[1722]: WARNING[7108]: res_odbc.c:113 in 
ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a 
reconnect...
Oct  5 16:43:57 sip asterisk[1722]: NOTICE[7108]: res_odbc.c:537 in 
odbc_obj_connect: Connecting asterisk
Oct  5 16:43:57 sip asterisk[1722]: NOTICE[7108]: res_odbc.c:565 in 
odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]
Oct  5 16:43:57 sip asterisk[1722]: WARNING[7108]: app_voicemail.c:2540 
in copy_file: SQL Execute error!#012[INSERT INTO voicemail_spool (dir, 
msgnum, context, macrocontext, callerid, origtime, duration, recording, 
mailboxuser, mailboxcontext) SELECT 
?,?,context,macrocontext,callerid,origtime,duration,recording,?,? FROM 
voicemail_spool WHERE dir=? AND msgnum=?] (You probably don't have MySQL 
4.1 or later installed)#012
Oct  5 16:44:39 sip asterisk[1722]: WARNING[7108]: res_odbc.c:105 in 
ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: 
[MySQL][ODBC 5.1 Driver][mysqld-5.1.57-rel12.8-log]Cannot add or update 
a child row: a foreign key constraint fails 
(`kamailio`.`voicemail_spool`, CONSTRAINT `v_s_mailboxuser_ref` FOREIGN 
KEY (`mailboxuser`) REFERENCES `voicemail_users` (`customer_id`) ON (289)
Oct  5 16:44:39 sip asterisk[1722]: WARNING[7108]: res_odbc.c:113 in 
ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a 
reconnect...
Oct  5 16:44:44 sip asterisk[1722]: NOTICE[7108]: res_odbc.c:537 in 
odbc_obj_connect: Connecting asterisk
Oct  5 16:44:44 sip asterisk[1722]: NOTICE[7108]: res_odbc.c:565 in 
odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]
Oct  5 16:44:44 sip asterisk[1722]: WARNING[7108]: res_odbc.c:105 in 
ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: 
[MySQL][ODBC 5.1 Driver][mysqld-5.1.57-rel12.8-log]Cannot add or update 
a child row: a foreign key constraint fails 
(`kamailio`.`voicemail_spool`, CONSTRAINT `v_s_mailboxuser_ref` FOREIGN 
KEY (`mailboxuser`) REFERENCES `voicemail_users` (`customer_id`) ON (289)
Oct  5 16:44:44 sip asterisk[1722]: WARNING[7108]: res_odbc.c:113 in 
ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a 
reconnect...
Oct  5 16:44:49 sip asterisk[1722]: NOTICE[7108]: res_odbc.c:537 in 
odbc_obj_connect: Connecting asterisk
Oct  5 16:44:49 sip asterisk[1722]: NOTICE[7108]: res_odbc.c:565 in 
odbc_obj_connect: res_odbc: Connected to asterisk [asterisk]

Anyone else?

-- 
Jonathan Scott Knox
Systems Administrator
XATel Communication
7 Green Street, Biddeford ME. 04005
(207)391.1000 (Mon - Thur, 9AM - 6PM. Friday - 9AM - 5PM.)