Sql Database error on sending newsletter

   Community Suite
   SMF Gallery Pro
   SMF Store
   SMF Classifieds
   Newsletter Pro
   Downloads System Pro
   Ad Seller Pro
  
   Hacks and Mods
   Latest SMF Hacks
   TopTen Hacks
   Styles and Themes
   Add a Hack
   Manage Hacks
  
   Earn Money from Your Forum with these tips
   SMF Theme Generator
   SMF Package Parser
   Free SMF Hosting
   HostGator Webhosting for SMF
  
   Site Showcase

Advanced search

[clive]

Hi Mr Hacks...

I sent my newsletter out and see that in my SMF error log I have a couple or database problems.

Database Error: 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 isViewer = 1 WHERE ID_EMAIL = 1' at line 1
File: /home/xxxxxx/public_html/newstracking.php

and I don't know if this is connected but I haven't seen this error below before

Database Error: Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
File: /home/xxxxx/public_html/Sources/LogInOut.php
Line: 213

Can you advise a fix for this? I also had an auto mail from SMF system telling me that SMF could not connect to the database...

Site is working though.. Is the problem happening when someone clicks a link in the newsletter?

Best regards

Clive

[SMFHacks]

Does this happen for every message sent? I would suggest doing a test message and see if that error occurs?

The only thing that I can think that would cause that is if you deleted an email report inside newsletter pro then tried to click on a link that used that report.

[clive]

Hi, thanks for the reply...

I had deleted last months test mails so I guess that someone may have clicked on a link in one of these old emails that doesn't exists any more at newsletter pro...

Thanks for the advice

Clive

Help Support the SMFHacks.com mod making.