Page 1 of 1

Temporary tables never cleaned

Posted: Mon Feb 16, 2009 7:57 pm
by mkalen
I use OpenEMM 5.5.1 with MySQL on Windows and I notice an increasing number of tables in the OpenEMM database named with a "TMP_CRT_" prefix.

Whenever I click "Send test mails to the administrators", "Send test mails to the test recipients", "Send mailing now" or use the WebService sendMailing method a new table is added.

Is there a "done()" call missing somewhere in the code?

Experiencing the same bug

Posted: Tue Feb 17, 2009 10:09 am
by legesund
With my installation I'm experiencing the same bug,
the OpenEMM database now contains more than 600 tables.
I'm not 100% percent sure, but this seems to have started
only after the last auto-upate to OpenEMM 5.5.1

Server Version: 5.0.32-Debian_7etch8-log
MySQL-Client-Version: 5.0.32

Re: Experiencing the same bug

Posted: Tue Feb 17, 2009 10:29 am
by mkalen
legesund wrote:Server Version: 5.0.32-Debian_7etch8-log
MySQL-Client-Version: 5.0.32
More info about my testing environment:
  • First-time install of OpenEMM 5.5.1 (no auto-upgrade)
  • MySQL Server v5.0.67 (Community Edition)
  • Sun JRE 6.0u11
  • Windows XP (SP3)

Posted: Fri Feb 27, 2009 2:58 pm
by lord_alan
I see this too.

OpenEMM 5.5.1 on Linux.

Posted: Mon Mar 02, 2009 4:10 pm
by maschoff
Actually, the tables should be dropped from time to time. We will look into this issue.

Posted: Wed Nov 25, 2009 8:58 am
by vag11
Hi, any news about this? I am one step before updating to the new version 6 and I wonder is it safe to manually drop all those TMP_CRT_* tables?

Posted: Wed Nov 25, 2009 9:12 am
by maschoff
Yes you can. This bug is fixed in 6.0 (see CHANGELOG.txt). You can drop those tables (see new install guide, section 5.3).