[Solved] NMS error on temporary database table + sending HTML

For questions and problems with the CMS core. This board is NOT for any 3rd party modules, addons, PHP scripts or anything NOT distributed with the CMS made simple package itself.
Post Reply
RonnyK
Support Guru
Support Guru
Posts: 4962
Joined: Wed Oct 25, 2006 8:29 pm

[Solved] NMS error on temporary database table + sending HTML

Post by RonnyK »

Does anyone know what table is used for NMS or another way to solve the error below, as I get the error stated below whie trying to send the NM job.
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.

Ronny
Last edited by RonnyK on Fri Mar 02, 2007 4:05 pm, edited 1 time in total.
calguy1000
Support Guru
Support Guru
Posts: 8169
Joined: Tue Oct 19, 2004 6:44 pm

Re: NMS error on temporary database table

Post by calguy1000 »

look for _NMS_temp_jobstatus
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
RonnyK
Support Guru
Support Guru
Posts: 4962
Joined: Wed Oct 25, 2006 8:29 pm

Re: NMS error on temporary database table

Post by RonnyK »

Thanks for mentioning the correct table. The error is gone now, but still the processing screen doesn't finis and the messages aren't sent, the job-status is set to "Error". Anyone an idea why it isn't processing.

Ronny
diad

Re: NMS error on temporary database table

Post by diad »

My processes all got hung up when I tried to do any kind of html newletter. I still haven't solved it and would like to choose that html option but I have to either do only a text one or I made a really generic template and now I created the entire message in fcked editor and then copy/paste it with all of it's clunky inline style stuff to the nms. Then I choose the generic template and it seems to send it like an html.

Otherwise, I would just keep getting that error and wasn't able to find out why. Got tired of deleting that table all the time. :-[
RonnyK
Support Guru
Support Guru
Posts: 4962
Joined: Wed Oct 25, 2006 8:29 pm

Re: NMS error on temporary database table

Post by RonnyK »

The problem is solved thanks to chris..

He pointed me to change the template as described in NMS while composing a message:
Note:  When using a page template as a message template, you need to use {$message_text} in place of {content} in your template.
I copied my template, and change {content} to {$messag_text}. This newly created template is than the template of choice for the message.

Sending the message is also no problem anymore.

Ronny
Post Reply

Return to “CMSMS Core”