| Message Text |
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
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: |
