FreePBX 2.11 & FOP2

  1. 11 years ago

    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.

  2. admin

    27 Apr 2013 Administrator

    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,

  3. 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

  4. 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.

  5. I fixed it just had to repair the database

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

  7. admin

    29 Apr 2013 Administrator

    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.

or Sign Up to reply!