WebmasterSite.net

Toplist in email to members

Version: 5.1.36
URL:

PrintPrint


Toplist in email to members
Jenny
Forum Regular
Avatar

Usergroup: Customer
Joined: May 11, 2003

Total Topics: 64
Total Posts: 199
quote post #1
Posted 06/08/10 - 2:59 PM:

I would like to send an email to my members including a list of their sites. For that I created a small toplist, which is unfortunately causing an error when I try to preview or send the email. Not sure if I have the wrong settings for the toplist ?!? sad

This is my toplist:

<!-- BEGIN TOPLIST -->
<CONFIG>links[,]id[,]5[,]ascending[,]ownerid={THISMEMBERID}[,][,]0[,]0[,]
0[,]0[,][,]0[,]0[,][,]0[,][,][,]</CONFIG>
{LINKTITLE} ({LINKURL})<br />
Description: {LINKDESCRIPTION}<br />
Category: {CATNAME}<br />
Link back URL: http://link-lounge.com/thelinks/in.php?id={LINKID}
<!-- END TOPLIST -->


and this is the error:

Error occurred at http://link-lounge.com/thelinks/ad....php?filled=1&type=members on 2010-06-08 22:51:13. Error text: Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in /home/xxx/public_html/thelinks/databases/mysqli.php on line 73.
Last SQL 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 '} AND invisibleto NOT LIKE '%|3|%') AND alias=0 AND inalbum=0 ORDER BY id ASC LI' at line 1

Debug info:

Load time so far: 0.04 seconds.


Query 1: SHOW TABLE STATUS LIKE 'wsnlinksclone1_categories'
Load time so far: 0.04 seconds.


Query 2: SET CHARACTER SET 'utf8'
Load time so far: 0.04 seconds.


Query 3: SET character_set_server = 'utf8'
Load time so far: 0.04 seconds.


Query 4: SET CHARACTER_SET_CLIENT=utf8
Load time so far: 0.04 seconds.


Query 5: SET CHARACTER_SET_RESULTS=utf8
Load time so far: 0.04 seconds.


Query 6: SET CHARACTER_SET_CONNECTION=utf8
Query 7: SELECT [huge field list omitted] FROM wsnlinksclone1_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (ownerid={THISMEMBERID} AND invisibleto NOT LIKE '%|3|%') AND alias=0 AND inalbum=0 ORDER BY id ASC LIMIT 0,5
Load time so far: 0.1 seconds.

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 '} AND invisibleto NOT LIKE '%|3|%') AND alias=0 AND inalbum=0 ORDER BY id ASC LI' at line 1

Step 1 of backtrace:
File: /home/xxx/public_html/thelinks/databases/mysqli.php
Line: 73
Function: mysqli_num_rows
Arguments:


Step 2 of backtrace:
File: /home/xxx/public_html/thelinks/classes/database.php
Line: 165
Function: numrows
Arguments:
Class: db


Step 3 of backtrace:
File: /home/xxx/public_html/thelinks/includes/templatefunctions.php
Line: 565
Function: numrows
Arguments:
Class: database


Step 4 of backtrace:
File: /home/xxx/public_html/thelinks/admin/email.php
Line: 29
Function: runtoplist
Arguments:
Paul
developer
Avatar

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 65
Total Posts: 7614
quote post #2
Posted 06/10/10 - 2:24 AM:

Fixed in 5.1.37. Note though that if you're going to use HTML <br /> tags in a toplist this can only work in MIME emails, I believe they'll show up literal in a regular text email (or they might get stripped out, not sure which).

The preview was failing to show the line breaks in regular text emails, which I've fixed.

Edited by Paul on 06/10/10 - 2:28 AM
Jenny
Forum Regular
Avatar

Usergroup: Customer
Joined: May 11, 2003

Total Topics: 64
Total Posts: 199
quote post #3
Posted 06/10/10 - 12:37 PM:

Thanks for the fix and the reminder about the HTML tags. I'd rather turn them off altogether, don't need them for this anyway.

Now I just need to figure out how to contact as many members and link submitters as possible without emailing them several times ...
Jenny
Forum Regular
Avatar

Usergroup: Customer
Joined: May 11, 2003

Total Topics: 64
Total Posts: 199
quote post #4
Posted 06/11/10 - 8:12 AM:

Just an FYI:

I received a couple of replies to the mails I sent out and it looks like the closing
<!-- END TOPLIST 1 -->

appears at the end of the toplist.
Paul
developer
Avatar

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 65
Total Posts: 7614
quote post #5
Posted 06/14/10 - 7:02 AM:

Fixed that for the next release.
 
Search thread for
Download thread as


Sorry, you don't have permission to post. Log in, or register if you haven't yet.