FOP2 Community Forum

Thanks, yea I've gone over everything and all is normal, I appreciate the detail. You'd be surprised what some zealous department operators can do

I've made some adjustments and we'll see how this goes, thank you for your responsiveness!!

Interesting, out of curiosity, why does it do this every time the fop2 manager is loaded?

There's free space, and no other tables exhibit this issue, every time you visit the manager home it deletes the entries in the fop2GroupButton table and recreates them, is this normal? It looks like multiple managers may be colliding on it in some way or something.

Here's what I see when I load the manager home-

| 147418 | asteriskuser | localhost | asterisk | Query | 0 | updating | DELETE FROM fop2GroupButton WHERE group_name='All Buttons' |
| 147418 | asteriskuser | localhost | asterisk | Query | 0 | updating | DELETE FROM fop2GroupButton WHERE group_name='All Extensions' |
| 147418 | asteriskuser | localhost | asterisk | Query | 0 | update | INSERT INTO fop2GroupButton (group_name,id_button,context_id) VALUES ('All Extensions','346','0') |
| 147419 | asteriskuser | localhost | asterisk | Query | 0 | Sending data | SELECT extension, name, IF(dial IS null,CONCAT('VIRTUAL/',extension),dial) AS dial, IF(voicemail='no |
| 147419 | asteriskuser | localhost | asterisk | Query | 1 | updating | DELETE FROM fop2GroupButton WHERE group_name='All Extensions' |
| 147419 | asteriskuser | localhost | asterisk | Query | 0 | updating | DELETE FROM fop2GroupButton WHERE group_name='All Queues' |

Thoughts?

Hello,

When we create a new button group, the table fop2GroupButton is dropped and recreated many many times, sometimes it crashes the table-

ERROR 145 (HY000): Table './asterisk/fop2GroupButton' is marked as crashed and should be repaired

We're able to recover the table but this shouldn't be happening and it's entirely reproducible, does anyone know if this is a known issue? A brief search of the forum didn't yield anything that seemed to be the same as what we're experiencing.

Running the latest and greatest 2.30.02

Thanks!!