FortiGate
FortiGate Next Generation Firewall utilizes purpose-built security processors and threat intelligence security services from FortiGuard labs to deliver top-rated protection and high performance, including encrypted traffic.
pareenat
Staff
Staff
Article Id 190301
Description
After the upgrade or downgrade of a FortiGate unit that has SQL enabled, the pop-up 'SQL database error' message warning may appear on the GUI console.

Scope

All FortiOS


Solution
The message should disappear after selecting 'YES' to rebuild the SQL database. However if the message continues to appear again on access of the GUI access then the following steps should correct the symptom

1. Collect result from the commands:
# diagnose debug sqldb-error read
# diagnose debug crashlog read

2. Back up the current log to an external FTP server:
# execute backup disk alllogs ftp x.x.x.x <username> <password>

3. Run the following command to recreate the SQL database:
#execute log recreate-sqldb

4. If the symptom persists, then proceed with following command to format the log disk:
# execute formatlogdisk

Contributors