Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 4200
Latest: [chrisB]
New This Month: 0
New This Week: 0
New Today: 0
Stats
Total Posts: 42622
Total Topics: 7434
Most Online Today: 196
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 22
Total: 22

Author Topic: Sql Database error on sending newsletter  (Read 6103 times)

0 Members and 1 Guest are viewing this topic.

Offline clive

  • Jr. Member
  • **
  • Posts: 76
    • View Profile
Sql Database error on sending newsletter
« on: October 23, 2008, 05:05:17 am »
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
« Last Edit: October 23, 2008, 05:08:33 am by clive »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16164
    • View Profile
Re: Sql Database error on sending newsletter
« Reply #1 on: October 23, 2008, 08:34:31 pm »
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.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline clive

  • Jr. Member
  • **
  • Posts: 76
    • View Profile
Re: Sql Database error on sending newsletter
« Reply #2 on: October 28, 2008, 03:37:48 am »
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

 

Related Topics

  Subject / Started by Replies Last post
7 Replies
6918 Views
Last post July 16, 2009, 12:22:14 am
by SMFHacks
14 Replies
11389 Views
Last post November 01, 2009, 04:14:02 am
by Vincent Volmer
4 Replies
4727 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks
3 Replies
5403 Views
Last post March 26, 2013, 01:40:57 pm
by SMFHacks
1 Replies
738 Views
Last post July 30, 2021, 09:11:45 pm
by SMFHacks

+- Recent Topics

SMF 2.1 Final Released by [chrisB]
December 05, 2022, 11:56:13 am

Errors with SMF2WPBridge by SMFHacks
December 04, 2022, 11:28:57 am

List of changes in SMFGallery by Monocero
December 02, 2022, 06:23:53 am

Permissions query by davejo
November 30, 2022, 09:52:38 am

"Notify all store admins of item purchase" Not Working in SMF 2.1.2 or 2.1.3 by SMFHacks
November 29, 2022, 01:15:50 pm

Undefined index: id by Shades
November 29, 2022, 12:15:20 pm

Additional Recommendations for SMF Store by Michael Vail
November 26, 2022, 12:49:58 pm

SMF Store 5.0 Beta Errors - Trying to access array offset on value of type null by Michael Vail
November 26, 2022, 12:07:42 pm

Modification: Subcategories total in main gallery view by VisiGod
November 26, 2022, 11:27:34 am

Change log for Downloads Pro 6.13 and 6.14 by Nicole
November 20, 2022, 08:24:34 am

Powered by EzPortal