Uploaded image for project: 'FreePBX'
  1. FreePBX
  2. FREEPBX-7155

installation / administration problem

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.11
    • Fix Version/s: 2.11
    • Component/s: Backup & Restore
    • Labels:
    • Environment:

      opensuse 13.1; asterisk 11.7.0

    • ToDo:
    • Asterisk Version:
      11.7.0
    • Distro Version:
      opensuse 13.1
    • Distro:
      Other

      Description

      Fresh installation of FreePBX 2.11 on a newly installed O.S.

      When I tried to add backup/restore module, it produced an error, because it was trying to insert a value of '' as id field in a backup table which had autoincrement for id field.
      I edited install.php, removed all the id '' lines , i.e. i did:

      //create default servers
      $server['legacy'] = array(
      COMMENTED 'id' => '',
      'name' => 'Legacy Backup',
      'desc' => _('Location of backups pre 2.10'),
      'immortal' => '',
      'type' => 'local',
      'path' => '_ASTVARLIBDIR_/backups',
      );

      and the installation completed succesfully, also creating the backup tenplates
      When I tried to insert a new backup job, I got the same kind of error:
      ----------
      FATAL ERROR

      REPLACE INTO backup (id, name, description) VALUES ('', 'giornaliero', 'giornaliero') [nativecode=1366 ** Incorrect integer value: '' for column 'id' at row 1]

      Trace Back
      /srv/www/amp/admin/modules/backup/functions.inc/backup.php:180 die_freepbx()
      [0]: REPLACE INTO backup (id, name, description) VALUES ('', 'giornaliero', 'giornaliero') [nativecode=1366 ** Incorrect integer value: '' for column 'id' at row 1]

      /srv/www/amp/admin/modules/backup/page.backup.php:59 backup_put_backup()
      [0]:

      /srv/www/amp/admin/config.php:424 include()
      [0]: /srv/www/amp/admin/modules/backup/page.backup.php
      -----------------

      So my guess now is that it was not a bug in install php, but into the function backup_put_backup(), that shoul omit to insert "id" if id value is ''.

      Or maybe could it be some php module missing from my O.S. installation ?

      O.S. opensuse 13.1
      asterisk version 11.7.0
      mysql version 5.6.12
      php version 5.4.20
      apache2 version 2.4.6

      thanks in advance,
      Andrea

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                GameGamer43 Bryan Walters
                Reporter:
                alanza@gas.it alanza
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  NextupJiraPlusStatus

                  Error rendering 'slack.nextup.jira:nextup-jira-plus-status'. Please contact your Jira administrators.