Sql Database error on sending newsletter

[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