Page 1 of 1
Temporary tables never cleaned
Posted: Mon Feb 16, 2009 7:57 pm
by 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?
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).