MySQLdb._exceptions.ProgrammingError: (1146, "Table 'openemm.config_tbl' doesn't exist")

Use this forum for questions regarding installation, upgrading and configuration of OpenEMM

Moderator: moderator

Manoj Sreepada
Posts: 21
Joined: Thu Aug 06, 2020 1:32 pm

MySQLdb._exceptions.ProgrammingError: (1146, "Table 'openemm.config_tbl' doesn't exist")

Post by Manoj Sreepada » Wed Sep 09, 2020 10:40 am

Hi,

We get the following Error:

[root@mail1 ~]# /home/openemm/bin/OpenEMMInstaller.sh
Checking python installation ...
Python version found: 3.8.5
Checking MariaDB/MySQL installation ...
DB version found: mysql Ver 15.1 Distrib 10.2.22-MariaDB, for Linux (x86_64) using EditLine wrapper
Checking Zip installation ...
Zip version 3.0 found
Starting python ...
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'openemm.config_tbl' doesn't exist")

what can we do?

Thanks, Please Advice for Any help.

aso
Posts: 21
Joined: Fri Jun 19, 2015 12:43 pm

Re: MySQLdb._exceptions.ProgrammingError: (1146, "Table 'openemm.config_tbl' doesn't exist")

Post by aso » Wed Sep 09, 2020 12:37 pm

Can you please restart the Program "OpenEMMInstaller.sh" with parameter "-debug".
It will print the stacktrace of the problem.
Please post it here.

Manoj Sreepada
Posts: 21
Joined: Thu Aug 06, 2020 1:32 pm

Re: MySQLdb._exceptions.ProgrammingError: (1146, "Table 'openemm.config_tbl' doesn't exist")

Post by Manoj Sreepada » Wed Sep 09, 2020 1:22 pm

Same Error:

[root@mail1 ~]# cd /home/openemm/bin/
[root@mail1 bin]# ./OpenEMMInstaller.sh
Checking python installation ...
Python version found: 3.8.5
Checking MariaDB/MySQL installation ...
DB version found: mysql Ver 15.1 Distrib 10.2.22-MariaDB, for Linux (x86_64) using EditLine wrapper
Checking Zip installation ...
Zip version 3.0 found
Starting python ...
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'openemm.config_tbl' doesn't exist")

Thnaks, Please Advice for any help .

aso
Posts: 21
Joined: Fri Jun 19, 2015 12:43 pm

Re: MySQLdb._exceptions.ProgrammingError: (1146, "Table 'openemm.config_tbl' doesn't exist")

Post by aso » Thu Sep 24, 2020 5:35 pm

This bug is fixed in LTS 20.10
Will be backported in LTS 20.04 quite soon (maybe tomorrow)

aso
Posts: 21
Joined: Fri Jun 19, 2015 12:43 pm

Re: MySQLdb._exceptions.ProgrammingError: (1146, "Table 'openemm.config_tbl' doesn't exist")

Post by aso » Fri Sep 25, 2020 10:23 am

Bugfix is backported in Runtime 20.04.000.047 an available at Update Site

Post Reply