Code: Select all
Root mode: On
Hostname: localhost.localdomain
Free diskspace: 78.9 % (of 27.19 GiB)
OpenEMM License: OpenEMM (ID: 0)
OpenEMM Runtime Version: 23.10.000.131
OpenEMM Version: 23.10.000.131
System-Url: http://192.168.0.1
Are you sure to drop all current data from database? ('DROP' => drop data, Blank => Back):
> DROP
Please enter database root user password:
> ********
Dropping database data (openemm) ...
+-----------------+
| VERSION() |
+-----------------+
| 10.3.39-MariaDB |
+-----------------+
Database data was dropped
Creating database (openemm) and user (openemm) ...
+-----------------+
| VERSION() |
+-----------------+
| 10.3.39-MariaDB |
+-----------------+
Database and user were created
Creating new database structure
Creating OpenEMM database structure ...
Database update started
DB already contains version 23.01.378
DB already contains version 23.01.379
DB already contains version 23.01.392
DB already contains version 23.01.515
DB already contains version 23.01.520
DB already contains version 23.01.557
DB already contains version 23.01.562
DB already contains version 23.04.381
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-messages.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-messages-deleted.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-messages-openemm.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.01.402-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.04.001-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.04.062-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.04.188-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.04.194-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.04.198-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.04.222-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.04.242-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.04.255-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.04.256-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.04.347-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.04.360-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.04.369-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.04.386-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.04.418-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.04.434-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.04.451-basic.sql
Executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.07.097-basic.sql
ERROR 1064 (42000) at line 13: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'COLUMN default_value TO bk_default_value' at line 1
Error while executing /home/openemm/webapps/emm/WEB-INF/sql/mariadb/emm-mariadb-update-23.07.097-basic.sql
SQL database updates caused an error. Press any key to continue.