SMFHacks.com

Newsletter Pro => Support => Topic started by: mwmanle1 on August 12, 2008, 11:51:27 am

Title: Another Problem With Links
Post by: mwmanle1 on August 12, 2008, 11:51:27 am

    I was excited to start using your new newsletter tool and sent out a newsletter last night. The letter contained
a forwarded email with a link to sign up against certain legislation. Unfortunately, the link didn't work. The error message I
received was;
   You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near 'SET isClicker = 1 WHERE ID_EMAIL = 3' at line 1
File: /SMF/newstracking.php
Line; 96

        How do I fix this?

Title: Re: Another Problem With Links
Post by: SMFHacks on August 12, 2008, 07:14:57 pm

It looks like it failed to create the temp table that stores the emails. Check inside the database that it created at table like newslist_22_05_08_8_24_23 they should be a prefix for newlist

Also check under Admin -> Error log for any relevant erorrs.

Did it install without errors?