Page 1 of 1
filling the temporary table error NMS [solved]
Posted: Fri Sep 28, 2007 9:43 pm
by 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
Re: filling the temporary table error NMS
Posted: Thu Oct 04, 2007 7:23 pm
by 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
Re: filling the temporary table error NMS
Posted: Thu Oct 04, 2007 8:05 pm
by alby
ebbe wrote:
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
Re: filling the temporary table error NMS [solved]
Posted: Sat Oct 06, 2007 3:38 pm
by EMR53
Solved it with the latest version
There is an option to clean the temp table
Re: filling the temporary table error NMS [solved]
Posted: Sun Dec 16, 2007 9:56 pm
by ingmar75
and how do you do that? I have the same problem
Re: filling the temporary table error NMS [solved]
Posted: Wed Jan 16, 2008 2:30 pm
by bosserik
I have this problem as well. How do I "clean the temp table"? No option I can see...
Re: filling the temporary table error NMS [NOT-solved]
Posted: Thu Feb 14, 2008 11:18 am
by 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
Re: filling the temporary table error NMS [NOT-solved]
Posted: Thu Feb 21, 2008 4:49 pm
by Mantlet
RKusters wrote:
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
Re: filling the temporary table error NMS [solved]
Posted: Sun Mar 09, 2008 5:52 am
by mccord42
I am getting the same error. Any help would be greatly appreciated.
Re: filling the temporary table error NMS [solved]
Posted: Sat May 31, 2008 7:54 am
by 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.
Re: filling the temporary table error NMS [solved]
Posted: Wed Sep 17, 2008 6:02 pm
by the.star
Hello everybody
I had the same problem. I could solve it by disabling the safe_mode and clearing the temp table.
Cheers