Problem With The Unsubscribe Link and Tracking Link In HTML Emails

[rizz]

Could you let us know when this problem could be resolved?

The [UNSUBSCRIBE] and [LINK4] will not work in html emails.

The Example Given In The Autoresponder Documentation Below Does Not Work:

PERSONALIZING YOUR MESSAGES

New! To add unsubscribe link now you need to put [UNSUBSCRIBE_LINK] special field anywhere in your message (in HTML messaeges you can add link tag <a href="[UNSUBSCRIBE_LINK]">Click here to unsubscribe</a>)

This issue is important to be resolved as now I am left with only using text emails because of this problem.

Could you kindly get this resolved soon? Thanks.

[drquek]

Thanks.

You mentioned problems with the [UNSUBSCRIBE] and [LINK4] features when using HTML format for your messages.

I noticed there is no problem in text format.

Try this:

{a href="[UNSUBSCRIBE_LINK]"}Click here to unsubscribe{/a}
and
{a href="[LINK4]"}Click here to visit my site{/a}

Replace above { } with < >

[rizz]

I am not sure why but somehow it works now without any modifications.

Worked as it showed in the documentation....

Still scratching my head why it did not work previously.

[drquek]

Are you using the same commands as what I showed you above?

[rizz]

Nope. I am using the same command as shown in the documentation when you choose "Add Message" as follows:

"PERSONALIZING YOUR MESSAGES

New! To add unsubscribe link now you need to put [UNSUBSCRIBE_LINK] special field anywhere in your message (in HTML messaeges you can add link tag <a href="[UNSUBSCRIBE_LINK]">Click here to unsubscribe</a> ) "

[drquek]

Thanks for replying.

Great to hear that FMLP Pro is now working for you.

[gxjenkins]

I'm sending text formated messages, and the unsubscribe link causes an Internal Server Error.

In Account Settings is where I checked the box to have the link inserted in the footer.

This is the end of the link that is inserted: /cgi-bin/fmlp/register.cgi?unsubscribe=vu8G4oOQHx9a


The path in "Settings" shows: /custom/unsubscription_done.html

Any ideas?

Thanks.
Gary

[drquek]

First of all, did you send the messages in text or HTML mode?

If it is the latter, read the above discussion.

You should try to send in text mode first to make sure it works for you.

[gxjenkins]

Sorry for the long delay, but I've been having several problems and I'm not sure if they're because of my hosting company or the software.

All my messages are sent in Text format. What I've found out is that my unsubscribe page has to outside of the cgi-bin directory. It works fine if it's in the root of the domain. I don't understand that because the "conirm", and the "thankyou" pages are inside of the cgi-bin directory. It's works, so I'm o.k. with that.

Today, I can't add any new accounts without getting an SQL error:
SQL error:
INSERT INTO swd_conf (`conf_value` , `discr` , `fk_account` , `pk_conf`) VALUES (NULL , NULL , '20' , 'ispurge')
: ERROR: 1048 - Column 'conf_value' cannot be null at lib/dbfunc.pm line 151.

All the existing accounts are fine, and I can make updates without errors. It's just the accounts created today. I've already open a support ticket with my hosting company and I'm waiting to hear back.

Also, the redirect isn't working. I seen it work once when I set it up, but now nothing. My old responder had a "Click here to continue" link that took the reader to the redirected page, or it would automatically take them there after 30 seconds.

Any ideas would be appreciated.

Thanks.

[drquek]

I read your comments three times but I am not very clear.

The redirect feature works. Please read the online manual or the readme file to understand how to do this.

[gxjenkins]

I'm still having SQL problems. I can only save a HTML message if I create a TEXT version as well. Otherwise I get an SQL error
"SQL error:
INSERT INTO swd_mess (`days` , `defmesstype` , `encoding` , `fk_account` , `mess` , `messhtml` , `messrss` , `priority` , `rsslink` , `saveinhistory` , `senddat` , `subject` , `type` , `typesend`) VALUES ('0' , '1' , 'iso-8859-1' , '2' , NULL , 'Now is the time for all good men to come to the aid of their countrymen.' , NULL , NULL , NULL , NULL , NULL , 'test 1' , 'html' , 'manual')
: ERROR: 1048 - Column 'mess' cannot be null at lib/dbfunc.pm line 151."

Now, I can get it to save if I create both html, and text versions.

After saving a message this is the SQL error I get trying to save Account Settings:
"SQL error:
INSERT INTO swd_conf (`conf_value` , `fk_account` , `pk_conf`) VALUES (NULL , '2' , 'subscribeemail')
: ERROR: 1048 - Column 'conf_value' cannot be null at lib/dbfunc.pm line 151."


Trying to figure out what is causing this I unregistered my old domain and registered a new domain. This is a fresh install. It can't be the host account.

Is there a fix for this?

Thanks
Gary

[drquek]

I can take a look at the problem if you want.

Please PM me your details.

Please describe your problem carefully as I have not come across something similar- if you want me to help.

[gxjenkins]

Sorry about the long delay, but I've got a membership site, and a store I needed to get upgraded.
With that done I need to get this running, and my problems just got worse. I had to do a clean install and now I can't restore any of my backup. I'm getting a message "errors detected".
I still have the original problem with SQL errors even after the clean install with a new database.
I'll send you my login info in PM so you can check this out.
Thanks,
Gary

[drquek]

Your problem with NULL is answered here:

http://www.doctorquek.com/forums/showthread.php?t=62

Item 8.

[gxjenkins]

Item 8 fixed the SQL problem.

Any idea why it became a problem after creating 9 accounts without getting that error?

Anyway, I'm back up and running. Thanks, for your help.

Gary

[drquek]

"Any idea why it became a problem after creating 9 accounts without getting that error?"

I am equally puzzled as all of a sudden I am receiving a number of reports on this.

I did not receive any similar reports in the past.