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 ?!?
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 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
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.
Comments on Toplist in email to members
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
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 ?!?
This is my toplist:
and this is the error:
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
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.
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
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 ...
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
Just an FYI:
I received a couple of replies to the mails I sent out and it looks like the closing
appears at the end of the toplist.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Fixed that for the next release.