Temporary tables never cleaned

[mkalen]

Hello,
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?

[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

[mkalen]

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)

[lord_alan]

I see this too.

OpenEMM 5.5.1 on Linux.

[maschoff]

Actually, the tables should be dropped from time to time. We will look into this issue.

[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?

[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).