What version of MySQL do you use?
Seems like your database does not support the syntax:
ALTER TABLE prevent_table_drop DROP KEY IF EXISTS lock$cust_ban_tbl;
If so, just execute the statements of this script "one by one" manually"
Search found 34 matches
- Mon Mar 08, 2021 5:08 pm
- Forum: Installation & Upgrades
- Topic: Websevices crashing after upgrade to OpenEMM Version: 19.10.000.169
- Replies: 20
- Views: 24167
- Mon Nov 09, 2020 10:51 am
- Forum: Installation & Upgrades
- Topic: new installation errors on centos 8
- Replies: 22
- Views: 42295
Re: new installation errors on centos 8
Problem is fixed in OpenEMM Runtime version 20.10.039, which is now available.
- Fri Oct 16, 2020 1:31 pm
- Forum: Installation & Upgrades
- Topic: Erros while Install/Upgrade to 20.10-beta from 19.04
- Replies: 13
- Views: 23553
Re: Erros while Install/Upgrade to 20.10-beta from 19.04
This bug was already fixed.
To repair your DB and prevent this from happening again, please execute this SQL on your DB:
INSERT INTO agn_dbversioninfo_tbl (version_number, updating_user, update_timestamp)
VALUES ('20.07.020', CURRENT_USER, CURRENT_TIMESTAMP);
To repair your DB and prevent this from happening again, please execute this SQL on your DB:
INSERT INTO agn_dbversioninfo_tbl (version_number, updating_user, update_timestamp)
VALUES ('20.07.020', CURRENT_USER, CURRENT_TIMESTAMP);
- Fri Sep 25, 2020 10:23 am
- Forum: Installation & Upgrades
- Topic: MySQLdb._exceptions.ProgrammingError: (1146, "Table 'openemm.config_tbl' doesn't exist")
- Replies: 4
- Views: 3127
Re: MySQLdb._exceptions.ProgrammingError: (1146, "Table 'openemm.config_tbl' doesn't exist")
Bugfix is backported in Runtime 20.04.000.047 an available at Update Site
- Fri Sep 25, 2020 10:00 am
- Forum: Installation & Upgrades
- Topic: Unable to change configuration variables
- Replies: 10
- Views: 7346
Re: Unable to change configuration variables
In LTS 20.04 all relevant configuration properties are migrated from emm.properties in db config_tbl for later use in LTS 20.10.
This happens on EMM startup. SO if the values are included in emm.peroperties an you (re-)start up your EMM the values should pop up in config_tbl.
This happens on EMM startup. SO if the values are included in emm.peroperties an you (re-)start up your EMM the values should pop up in config_tbl.
- Thu Sep 24, 2020 5:35 pm
- Forum: Installation & Upgrades
- Topic: MySQLdb._exceptions.ProgrammingError: (1146, "Table 'openemm.config_tbl' doesn't exist")
- Replies: 4
- Views: 3127
Re: MySQLdb._exceptions.ProgrammingError: (1146, "Table 'openemm.config_tbl' doesn't exist")
This bug is fixed in LTS 20.10
Will be backported in LTS 20.04 quite soon (maybe tomorrow)
Will be backported in LTS 20.04 quite soon (maybe tomorrow)
- Wed Sep 16, 2020 1:22 pm
- Forum: Installation & Upgrades
- Topic: Invalid variable for CATALINA_HOME
- Replies: 6
- Views: 6105
Re: Invalid variable for CATALINA_HOME
Is the following file available in your CATALINA_HOME ?: ${CATALINA_HOME}/lib/catalina.jar Can you execute: ${JAVA_HOME}/bin/java -cp ${CATALINA_HOME}/lib/catalina.jar org.apache.catalina.util.ServerInfo This should return your available Tomcat Version Info. The Data in our shipped folder "/hom...
- Wed Sep 09, 2020 12:37 pm
- Forum: Installation & Upgrades
- Topic: MySQLdb._exceptions.ProgrammingError: (1146, "Table 'openemm.config_tbl' doesn't exist")
- Replies: 4
- Views: 3127
Re: MySQLdb._exceptions.ProgrammingError: (1146, "Table 'openemm.config_tbl' doesn't exist")
Can you please restart the Program "OpenEMMInstaller.sh" with parameter "-debug".
It will print the stacktrace of the problem.
Please post it here.
It will print the stacktrace of the problem.
Please post it here.
- Tue Aug 04, 2020 1:14 pm
- Forum: Installation & Upgrades
- Topic: multiple config entries with same key after upgrade to 20.04
- Replies: 4
- Views: 2244
Re: multiple config entries with same key after upgrade to 20.04
Hi, Seems like there have been duplicates in some older OpenEMM version which were migrated. When there are duplicates the first entry returned by database will be used. To fix this just remove the unwanted configuration entries from database table "config_tbl". Next OpenEMM version 20.10 ...
- Thu Jun 25, 2020 8:35 am
- Forum: Installation & Upgrades
- Topic: error in 20.04 sql upgrade script - userrights.sql
- Replies: 6
- Views: 3156
Re: error in 20.04 sql upgrade script - userrights.sql
Please try our new released Version 20.04.000.155.
It is available via the standard update process and should fix this problem.
It is available via the standard update process and should fix this problem.
- Wed Jun 24, 2020 3:22 pm
- Forum: Installation & Upgrades
- Topic: error in 20.04 sql upgrade script - userrights.sql
- Replies: 6
- Views: 3156
Re: error in 20.04 sql upgrade script - userrights.sql
Didn't you write you tried to install "frontend 20.04.000.143" in your first post?
Does the error happen in version 20.04 or 19.10?
In 19.10 this permission did not exist.
It is new in 20.04.
Does the error happen in version 20.04 or 19.10?
In 19.10 this permission did not exist.
It is new in 20.04.
- Wed Jun 24, 2020 12:00 pm
- Forum: Installation & Upgrades
- Topic: error in 20.04 sql upgrade script - userrights.sql
- Replies: 6
- Views: 3156
Re: error in 20.04 sql upgrade script - userrights.sql
Line 18 means the permission "campaign.autoopt". Maybe this permission entry vanished somehow in your database. Please try this statement and re-execute the userrights.sql. INSERT INTO permission_tbl (permission_name, category, sub_category, sort_order, feature_package) VALUES ('campaign.a...
- Fri May 15, 2020 11:59 am
- Forum: Bugs, bug fixes & releases
- Topic: No layoutdata for favicon.ico
- Replies: 3
- Views: 5641
Re: No layoutdata for favicon.ico
Hello, It seems like something went wrong in the initial migration to the new version. Please execute the following SQL Statement once on your database. Then restart the OpenEMM. This will execute the migration for the layout logos again. This should fix the Logo problem once for all. After the Rest...
- Mon Feb 10, 2020 2:07 pm
- Forum: Installation & Upgrades
- Topic: openEMM 2019: Webservice-API throws Error 500
- Replies: 11
- Views: 5221
Re: openEMM 2019: Webservice-API throws Error 500
Hello, I also checked the currently available online Version of the OpenEMM Runtime (19.10.009.016). - It copies server.xml.template to server.xml if there is no server.xml yet - It backups and restores an existing server.xml As far as I can see there is no problem with the current version. Does the...
- Fri Dec 06, 2019 1:45 pm
- Forum: Installation & Upgrades
- Topic: installing openemm 2019 not working on centos
- Replies: 41
- Views: 18879
Re: installing openemm 2019 not working on centos
Problem ist that the property value "dbms" in your "dbcfg"-file is missing. Default location of that file is "/opt/agnitas.com/etc/dbcfg". Other locations may be: - "/home/openemm/etc/dbcfg" - "/opt/openemm/dbcfg" It should contain one of the followi...