I am attempting to restore a backup from a FreePBX 184.108.40.206 instance to a new FreePBX 220.127.116.11 instance and I am receiving the following error when attempting the restore:
Running with: /usr/sbin/fwconsole backup --restore=’/var/spool/asterisk/backup/uploads/20200804-000001-1596513601-18.104.22.168-178581441.tgz’ --transaction=‘8f4e18c1-7740-4b5c-bba2-9ba089000216’
Determining backup file type…type is legacy
Legacy CDR Restore Option: 0
Starting restore job with file: /var/spool/asterisk/backup/uploads/20200804-000001-1596513601-22.214.171.124-178581441.tgz
Loading manifest to memory
Loading astdb to memory
Parsing out SQL tables. This may take a moment depending on backup size.
Found 2 database files in the backup.
File named: /tmp/backup/8f4e18c1-7740-4b5c-bba2-9ba089000216/mysql-2.sql.gz
Detected file /tmp/backup/8f4e18c1-7740-4b5c-bba2-9ba089000216/mysql-2.sql.gz as the PBX (Asterisk) database. Attempting restore
Extracting supplied database file mysql-2.sql.gz
Loading supplied database file mysql-2.sql
SQLSTATE[HY000]: General error: 1 near “)”: syntax error
Can anyone point me in the right direction as to why this may be happening? The research that I did beforehand pointed me in the direction of turning on the edge repositories and doing a full module update, however, that didn’t solve my problem.