NMS - 'error' when trying to send or 'process jobs'

[prendo]

When I try to process a job in order to send out my email I get a pop up window open up with the following message:

Newsletter Made Simple Batch Processing Window

Keep this window open till all messages have been sent.

Sending the next batch of 50 emails; starting at: 0

Processing Job: Job created at: 03/11/07 16:01:20

Processing records 0 to 1

When I go back to the Newsletter Made Simple admin panel the Job Status message says ERROR.

I think that I have done everything correctly according to the instructions eg set admin preferences for NMS, created my list, set up messages etc. I have also set up my email preferences in CMS MS and this works fine.

Could anyone give me an idea of where I could look to fix this??

I'm also not sure where the NMS 'Configuration' link is that keeps getting mentioned in the instructions and also in this forum. Am I missing something?

Thanks

[RonnyK]

Prendo,

if you're trying to mail a HTML-styled e-mail, you should check the help of the NMS-module. It says that you need to have a template, in which not {content} is called but {$message_text}. The message is put in that place. I copied my template to a template-NMS and changed that part. After that the message is sent without any problems.

Ronny

[volume]

I'm sure I'll look back and laugh at this ... one day.

I was trying to replicate Prendos error on my perfectly working NMS only to mess things up

I now get the folowing error when trying to post via NMS:

Newsletter Made Simple Batch Processing Window

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.

Processing of output queue finished

Total processing time: 1 Seconds

Total Emails Sent (including to admin): 0

You can now close this window

Any idea how I can rectify this? I don't have phpmyadmin or anything like that.

Thanks in advance,

volume.

[volume]

Well that was an exciting ride... fixed the problem by deleting all (2) rows in the cms_module_NMS_temp_jobstatus table

All working fine again.

This may help you [Prendo] or I might have unintentionally taken this thread on a small diversion.

volume

[mar]

Hi,
I had the same problem. Could you please explain me how you find the cms_module_NMS_temp_jobstatus table ?

Thanks.

[lernet]

Yes, I am having the same problem too. I have replaced the template with {$message_text} but I still cannot send out the newsletters. When I try to process the jobs, it keeps saying 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.

What can I do? I saw something about deleting temp job status but could not find it anywhere. Please let me know where to find cms_module_NMS_temp_jobstatus table or _NMS_temp_jobstatus

Please advise. This is really getting on my nerves.

[RonnyK]

The table can be found within the SQL-db. With mySQLadmin you can navigate to that table and delete the entries.

_NMS_temp_jobstatus (most people leave the prefix with the default cms), so "cms_NMS_temp_jobstatus"

Ronny

[lernet]

I am so sorry if I sound very hopeless. Can I know what is SQL-db? I have mySQLadmin in my computer but could not log on because I am not sure about the server name. I have tried all those listed in the forums but none seemed to work. When I check on the connection, it keeps saying "Request timed out".

Is there a standard server name? If not, how do I find out what is my server name? I am very clueless with this SQL, PHP thing. I eagerly await any advice coming this way. 

[Dr.CSS]

How did you set up the server?...

[lernet]

Hi. I set up mySQL server using my CMS login. Is that correct? I am not sure about the port no. and the server name. Is there any other advanced options for the setting up?

[RonnyK]

Are you running the site on a machine you administrate or is it hosted by a hosting company. If a hosting-company created the DB and mailed the login/pw to you, you have to login to your account on the providers site, similar to requesting the DB. Then there will be an DB-admin area over there.

Or didn't you mean with the last post, that you ONLY entered the DB-information while installing CMSMS.

Ronny

[lernet]

Hi! Thanks for the help offered. I finally managed to find the cms_module_NMS_temp_jobstatus table in the phpMYSQL thing. FINALLY!

Have a great weekend everyone.