Posted by Tomas Zubov, Last modified by Alan Rusek on 03 June 2015 10:06 AM
If this status lasts for more than three hours (it depends on the size of your databases, but three hours should be enough for any size db) you can terminate the installation
This issue is most likely caused by setting the wrong syntax for some or all databases, meaning that if any of databases is set to use ODBC driver with "Default" as the syntax, the server will not run the upgrades properly. The server reads the "Default" syntax as unknown.
To fix the problem follow the steps below:
For AntiSpam, navigate to AntiSpam -> General -> select the general tab -> press the DB Settings... button. The following dialogue window will appear:
Make sure that the correct syntax is being used.
3) Do the same for the GroupWare database
Example for MSSQL
Correct syntax for MSSQL:
When all databases have the syntax set properly, run the following command:
tool upgrade <previous version>
If your previous version was 10.2.2, the command would be: tool upgrade 10.2.2
Note: If you are using "Access" databases, it is strongly recommended to migrate these to SQLite. Access is not a recommended solution for a database.