Gregory Duchatelet
2007-Jan-24 02:38 UTC
[asterisk-users] Query Failed because: Incorrect information in file: './asterisk/sip.frm'
Hi, I have a working asterisk 1.4.0 with Mysql Realtime configuration, and today I encountered this error. Now, I have no acces to any information in mysql realtime, so nothing work now !!!!! [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: Everything is fine. [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM extensions WHERE exten = 'h' AND context = ' interne' AND priority = '1' [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: Query: SELECT * FROM extensions WHERE exten = 'h' AND context = 'interne ' AND priority = '1' [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: Query Failed because: Incorrect information in file: './asterisk/extensi ons.frm' [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: Everything is fine. [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM extensions WHERE exten LIKE '\\_%' AND conte xt = 'interne' AND priority = '1' ORDER BY exten [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: Query: SELECT * FROM extensions WHERE exten LIKE '\\_%' AND context = 'i nterne' AND priority = '1' ORDER BY exten [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: Query Failed because: Incorrect information in file: './asterisk/extensi ons.frm' [Jan 24 10:32:40] DEBUG[31026] res_config_mysql.c: MySQL RealTime: Everything is fine. [Jan 24 10:32:40] DEBUG[31026] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM sip WHERE name = '129.200.1.51' [Jan 24 10:32:40] DEBUG[31026] res_config_mysql.c: MySQL RealTime: Query: SELECT * FROM sip WHERE name = '129.200.1.51' [Jan 24 10:32:40] DEBUG[31026] res_config_mysql.c: MySQL RealTime: Query Failed because: Incorrect information in file: './asterisk/sip.frm 'ast -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070124/9b5ea7b6/attachment.htm
Jason Fuermann
2007-Jan-24 07:41 UTC
[asterisk-users] Query Failed because: Incorrect information in file: './asterisk/sip.frm'
Its a problem in your database. something might have corrupted...be prepared to load a backup Gregory Duchatelet wrote:> > Hi, > > > > I have a working asterisk 1.4.0 with Mysql Realtime configuration, and > today I encountered this error. > > > > Now, I have no acces to any information in mysql realtime, so nothing > work now !!!!! > > > > > > [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: > Everything is fine. > > [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: > Retrieve SQL: SELECT * FROM extensions WHERE exten = 'h' AND context = ' > > interne' AND priority = '1' > > [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: > Query: SELECT * FROM extensions WHERE exten = 'h' AND context = 'interne > > ' AND priority = '1' > > [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: > Query Failed because: Incorrect information in file: './asterisk/extensi > > ons.frm' > > [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: > Everything is fine. > > [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: > Retrieve SQL: SELECT * FROM extensions WHERE exten LIKE '\\_%' AND conte > > xt = 'interne' AND priority = '1' ORDER BY exten > > [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: > Query: SELECT * FROM extensions WHERE exten LIKE '\\_%' AND context = 'i > > nterne' AND priority = '1' ORDER BY exten > > [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: > Query Failed because: Incorrect information in file: './asterisk/extensi > > ons.frm' > > [Jan 24 10:32:40] DEBUG[31026] res_config_mysql.c: MySQL RealTime: > Everything is fine. > > [Jan 24 10:32:40] DEBUG[31026] res_config_mysql.c: MySQL RealTime: > Retrieve SQL: SELECT * FROM sip WHERE name = '129.200.1.51' > > [Jan 24 10:32:40] DEBUG[31026] res_config_mysql.c: MySQL RealTime: > Query: SELECT * FROM sip WHERE name = '129.200.1.51' > > [Jan 24 10:32:40] DEBUG[31026] res_config_mysql.c: MySQL RealTime: > Query Failed because: Incorrect information in file: './asterisk/sip.frm > > 'ast > > ------------------------------------------------------------------------ > > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070124/8b358ffa/attachment.htm