Webmastersite.net
Register Log In

Toplist in email to members

Comments on Toplist in email to members

Jenny
Forum Regular

Usergroup: Customer
Joined: May 11, 2003

Total Topics: 64
Total Comments: 199
Jenny
Posted Jun 08, 2010 - 3: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 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

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

Total Topics: 61
Total Comments: 7868
Paul
Posted Jun 10, 2010 - 3: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.
Jenny
Forum Regular

Usergroup: Customer
Joined: May 11, 2003

Total Topics: 64
Total Comments: 199
Jenny
Posted Jun 10, 2010 - 1: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

Usergroup: Customer
Joined: May 11, 2003

Total Topics: 64
Total Comments: 199
Jenny
Posted Jun 11, 2010 - 9: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

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

Total Topics: 61
Total Comments: 7868
Paul
Posted Jun 14, 2010 - 8:02 AM:

Fixed that for the next release.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



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