FreePBX 2.11 & FOP2

[adiehlman]

We upgrading our servers to the newest FREEPBX Version. 2.11 and now when we try to get FOP2 to work. it gives an error. We have licenses on all the servers from you guys.

Reload failed because retrieve_conf encountered an error: 1

exit: 1
found language dir fr for directory, not installed on system, skipping
[FATAL] SELECT data FROM parkinglot WHERE keyword='parkext' [nativecode=1146 ** Table 'asterisk.parkinglot' doesn't exist]SQL -
SELECT data FROM parkinglot WHERE keyword='parkext'

Trace Back:

/var/www/html/admin/libraries/sql.functions.php:25 die_freepbx()
[0]: SELECT data FROM parkinglot WHERE keyword='parkext' [nativecode=1146 ** Table 'asterisk.parkinglot' doesn't exist]SQL -
SELECT data FROM parkinglot WHERE keyword='parkext'

/var/www/html/admin/modules/fop2admin/functions.inc.php:71 sql()
[0]: SELECT data FROM parkinglot WHERE keyword='parkext'
[1]: getRow
[2]: 2

/var/lib/asterisk/bin/retrieve_conf:682 fop2admin_get_config()
[0]: asterisk

1 error(s) occurred, you should view the notification log on the dashboard or main screen to check for more details.

[nicolas]

There was a modification in the parking module in recent freepbx version. You must upgrade to the latest fop2admin available in the download page (1.2.13).

Best regards,

[adiehlman]

Ok upgrade and when I apply this happened.

Module Administration
FATAL ERROR
SELECT * FROM module_xml WHERE id = 'xml' [nativecode=1194 ** Table 'module_xml' is marked as crashed and should be repaired]SQL -
SELECT * FROM module_xml WHERE id = 'xml'
Trace Back
/var/www/html/admin/libraries/sql.functions.php:25 die_freepbx()
[0]: SELECT * FROM module_xml WHERE id = 'xml' [nativecode=1194 ** Table 'module_xml' is marked as crashed and should be repaired]SQL - <br /> SELECT * FROM module_xml WHERE id = 'xml'

/var/www/html/admin/libraries/module.functions.php:25 sql()
[0]: SELECT * FROM module_xml WHERE id = 'xml'
[1]: getRow
[2]: 2

/var/www/html/admin/page.modules.php:317 module_getonlinexml()
[0]:
[1]:
[2]:

/var/www/html/admin/config.php:300 include()
[0]: /var/www/html/admin/page.modules.php

[adiehlman]

I tried to remove fop2 and this is what happened

Error!close
Reload failed because retrieve_conf encountered an error: 1

exit: 1
found language dir fr for directory, not installed on system, skipping
[FATAL] SELECT id,device FROM fop2buttons [nativecode=1146 ** Table 'asterisk.fop2buttons' doesn't exist]SQL -
SELECT id,device FROM fop2buttons

Trace Back:

/var/www/html/admin/libraries/sql.functions.php:25 die_freepbx()
[0]: SELECT id,device FROM fop2buttons [nativecode=1146 ** Table 'asterisk.fop2buttons' doesn't exist]SQL -
SELECT id,device FROM fop2buttons

/var/www/html/admin/modules/fop2admin/functions.inc.php:751 sql()
[0]: SELECT id,device FROM fop2buttons
[1]: getAll
[2]: 2

/var/www/html/admin/modules/fop2admin/functions.inc.php:240 fop2_getDeviceId()

/var/www/html/admin/modules/fop2admin/functions.inc.php:1311 fop2_all_freepbx_buttons()

/var/www/html/admin/modules/fop2admin/functions.inc.php:7 fop2_set_queuemember_strings()

/var/lib/asterisk/bin/retrieve_conf:682 fop2admin_get_config()
[0]: asterisk

1 error(s) occurred, you should view the notification log on the dashboard or main screen to check for more details.

[adiehlman]

I fixed it just had to repair the database

[artarzi]

Could you expand on this a little - "repair the database"?

[nicolas]

There was a problem with some table in the mysql database (not related to fop2):

0]: SELECT * FROM module_xml WHERE id = 'xml' [nativecode=1194 ** Table 'module_xml' is marked as crashed and should be repaired]SQL - <br /> SELECT * FROM module_xml WHERE id = 'xml'

A table marked as crashed in mysql needs to be repaired within mysql itself, it throws those warnings that will prevent freepbx from reloading or whatever, to repair a table, the mysql command is, in this case:

repair table module_xml

You have to issue that command using the mysql command line interface, phpmyadmin or whatever tool you are familiar with.