filling the temporary table error NMS [solved]

[EMR53]

Hello,

Im using CMS Made Simple 1.0.5 "Molokai" and NMS version 1.0.1 every time i want to send a news letter i'm getting the same error


Newsletter Made Simple Batch Processing Window

ERROR- A problem occurred when filling the temporary table

Processing of output queue finished

Total processing time: 0 Seconds

Total Emails Sent (including to admin): 0

You can now close this window

I have changed the (content) in {$message_text} and tested with text alone (no html code) but the same error appears.

I did a search about this issue but it seems that everybody is getting a different error like this.

"ERROR- The temporary database table, used for job processing already exists. This probably indicates that an error occurred when trying to process a job previously."

Hope that somebody can help

Regards Eric

[EMR53]

Does nobody have an idea for this.


I have restored a sql back-up from the day before it went wrong. But the error still exist 

Regards Eric

[alby]

Does nobody have an idea for this.

I have restored a sql back-up from the day before it went wrong. But the error still exist 

I don't see this.
Try update to new version

Alby

[EMR53]

Solved it with the latest version

There is an option to clean the temp table

[ingmar75]

and how do you do that? I have the same problem

[bosserik]

I have this problem as well. How do I "clean the temp table"? No option I can see...

[RKusters]

I've just upgraded to the latest version and i now have the same problem.

ERROR- A problem occurred when filling the temporary table

so please some more info on the "There is an option to clean the temp table" part

Greetz

[Mantlet]

I've just upgraded to the latest version and i now have the same problem.

ERROR- A problem occurred when filling the temporary table

so please some more info on the "There is an option to clean the temp table" part

Greetz

I have the same problem. The option to clear the temporary table is on the jobs tab and only appears after jobs have been processed. You then have the links at the bottom: Create job, Delete completed jobs, Clean temporary table and Process jobs.

However, cleaning that table doesn't resolve the issue with me. I still get the same error as is described here, running CMS 1.2.2, NMS 2.0 and CGext 1.6

[mccord42]

I am getting the same error.  Any help would be greatly appreciated.

[martin_w]

same error here also.
cmsms 1.2.4, mandriva linux 2008, using sendmail, mail, or smtp all result in same error.
I tried about 4 different version of NMS starting with ver 1.0 up to 2.1 with same error so I don't think it's version specific.
Aha!, I just "added" a user manually and it worked.
so even though there were two users who "subscribed" they did not show up in the users, only the one I manually entered.

[the.star]

Hello everybody

I had the same problem. I could solve it by disabling the safe_mode and clearing the temp table.

Cheers