Problem: m23 App Shows ERROR:Table 'm23.i18n' doesn't exist

ucs-4
app
m23
problem

#1

Problem

m23 App Shows ERROR:Table ‘m23.i18n’ doesn’t exist when trying to login the first time.
Un-installing the app and re-installing (either through UMC or univention-app) does not help.

Solution

Note: The following will nuke the m23 database. In case you might have used m23 before the steps should not be applied.

Step 1

Make sure the app is uninstalled (UMC or univention-app remove m23)

Step 2

Verify the databases still exist even though the app is uninstalled:

ls -l /var/lib/mysql | grep m23
drwx------ 2 mysql   mysql     4096 Mär 25 16:52 m23
drwx------ 2 mysql   mysql     4096 Aug  1  2018 m23captured

Step 3

Login to MySQL/ MariaDB and drop the databases:

root@master:~# mysql -h localhost -u root -p`cat /etc/mysql.secret`
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 7
Server version: 10.1.37-MariaDB-0+deb9u1 Debian 9.6

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> drop database m23;
Query OK, 0 rows affected (0.09 sec)

MariaDB [(none)]> drop database m23captured;
Query OK, 0 rows affected (0.09 sec)

MariaDB [(none)]> exit;
Bye

Step 4

Install the app again through your preferred way.
Login should work now.


closed #2