i am getting an error when i click on the next pages of a multipage toplist
i use this code in displaylinks.tpl, copied from toplist generator: -------------------------------------------------------------------- <!-- BEGIN TOPLIST 6 --> <CONFIG>topics,id,1,ascending,,,,0,0,0,0</CONFIG> {TOPICTITLE} <!-- END TOPLIST 6 -->
i can see the first topic but if i click on the 2nd-page link, i get: ------------------------------------------------------------------------ Fatal error: Unsupported operand types in d:\easyphp1-8\www\wsnforum\index.php on line 556
debug=1 ---------------------------------------------------------------------- Load time so far: 0.12 seconds. Performing query: SELECT id FROM wsnforum_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1;
Number of rows is 1 for Resource id #20
Load time so far: 0.14 seconds. Performing query: SELECT name,value FROM wsnforum_switches WHERE id>0 ;
Number of rows is 58 for Resource id #43
Load time so far: 0.14 seconds. Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM wsnforum_markup WHERE type='wsncode' ORDER BY sortorder ;
Number of rows is 22 for Resource id #45
Load time so far: 0.15 seconds. Performing query: SELECT original,replacement,description,id,sortorder FROM wsnforum_markup WHERE type='smilie' ORDER BY sortorder ;
Number of rows is 14 for Resource id #46
Load time so far: 0.15 seconds. Performing query: SELECT id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,cansuggestban,shoutsperday FROM wsnforum_membergroups WHERE id>0 ;
Load time so far: 0.16 seconds. Performing query: SELECT id,name,time,usergroup,password,ip,totalhits,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,topics,posts,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,chatcolor,autosubscribepost,validatedemail FROM wsnforum_members WHERE id=1 AND validated=1 ;
Load time so far: 0,17 seconds. Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,mixtypes,isalbum,orderlinks,totalcomments,alias,catcols,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,opwords FROM wsnforum_categories WHERE validated=1 AND deleted=0 AND hide=0 ;
Number of rows is 21 for Resource id #53
Load time so far: 0,19 seconds. Performing query: LOCK TABLES wsnforum_email WRITE, wsnforum_links WRITE, wsnforum_categories WRITE, wsnforum_members WRITE;
Load time so far: 0,19 seconds. Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnforum_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Number of rows is 0 for Resource id #54
Load time so far: 0,19 seconds. Performing query: UNLOCK TABLES;
Load time so far: 0,19 seconds. Performing query: SELECT id,frequency,filename,nextrun FROM wsnforum_crons WHERE nextrun < 1163073763 ORDER BY id ASC LIMIT 0,1;
Number of rows is 0 for Resource id #56
Load time so far: 0,2 seconds. Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,mixtypes,isalbum,orderlinks,totalcomments,alias,catcols,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,opwords FROM wsnforum_categories WHERE parent=2 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY priority ASC,name ASC LIMIT 0,300;
Number of rows is 5 for Resource id #61
Load time so far: 0.26 seconds. Performing query: SELECT COUNT(id) FROM wsnforum_links WHERE catid=2 AND hide=0 AND deleted=0 AND validated=1 ;
Count is 0
Fatal error: Unsupported operand types in d:\easyphp1-8\www\wsnforum\index.php on line 556 -------------------------------------------------------------------------
the code in index.php is: ------------------------------- 556) $start = ($page * $perpage) - $perpage; // have to adjust for starting the numbering at 1 557) $end = $start + $perpage - 1;
You can't do that on the 'show topics in forum' page since that page already has pagination for for the topics which your toplist is overwriting (thus making it not know what page of topics to show).
Paul, i forgot to say that i have removed all code used to show topics (the entire table of <!-- BEGIN REGULAR TOPICS --> ) and also the code for the pagination <IF {MULTIPAGE}>...</IF>, but i still get the same message.
It doesn't matter what you remove from the template or if you use an entirely blank template, the topics will be queried just the same since that's what that page is for. If you don't want to show topics, put your custom template over another page -- you can still use forum template vars if you pass the forum id to the page as &catid={FORUMID}: www.wsnforum.com/wsnmanual/...ng_Custom_Templates-6.html
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on multipage toplist error
Experienced
Usergroup: Customer
Joined: Feb 22, 2004
Total Topics: 47
Total Comments: 88
i am getting an error when i click on the next pages of a multipage toplist
i use this code in displaylinks.tpl, copied from toplist generator:
--------------------------------------------------------------------
<!-- BEGIN TOPLIST 6 -->
<CONFIG>topics,id,1,ascending,,,,0,0,0,0</CONFIG>
{TOPICTITLE}
<!-- END TOPLIST 6 -->
<IF {TOPLIST6MULTIPAGE}>
<br>Page: {TOPLIST6PREVIOUS} <b>{TOPLIST6CURRENTPAGE}</b> {TOPLIST6NEXT}
</IF>
----------------------------------------------------------------------
i have 3 topics (except the soft-deleted ones) and the page links are:
------------------------------------------------------------------------
2nd page) 127.0.0.1/wsnforum/index.ph...thecolumns[6]=&number[6]=1
3rd page) 127.0.0.1/wsnforum/index.ph...thecolumns[6]=&number[6]=1
------------------------------------------------------------------------
i can see the first topic but if i click on the 2nd-page link, i get:
------------------------------------------------------------------------
Fatal error: Unsupported operand types in d:\easyphp1-8\www\wsnforum\index.php on line 556
debug=1
----------------------------------------------------------------------
Load time so far: 0.12 seconds.
Performing query: SELECT id FROM wsnforum_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1;
Number of rows is 1 for Resource id #20
Load time so far: 0.14 seconds.
Performing query: SELECT name,value FROM wsnforum_switches WHERE id>0 ;
Number of rows is 58 for Resource id #43
Load time so far: 0.14 seconds.
Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM wsnforum_markup WHERE type='wsncode' ORDER BY sortorder ;
Number of rows is 22 for Resource id #45
Load time so far: 0.15 seconds.
Performing query: SELECT original,replacement,description,id,sortorder FROM wsnforum_markup WHERE type='smilie' ORDER BY sortorder ;
Number of rows is 14 for Resource id #46
Load time so far: 0.15 seconds.
Performing query: SELECT id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,cansuggestban,shoutsperday FROM wsnforum_membergroups WHERE id>0 ;
Load time so far: 0.16 seconds.
Performing query: SELECT id,name,time,usergroup,password,ip,totalhits,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,topics,posts,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,chatcolor,autosubscribepost,validatedemail FROM wsnforum_members WHERE id=1 AND validated=1 ;
Load time so far: 0,17 seconds.
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,mixtypes,isalbum,orderlinks,totalcomments,alias,catcols,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,opwords FROM wsnforum_categories WHERE validated=1 AND deleted=0 AND hide=0 ;
Number of rows is 21 for Resource id #53
Load time so far: 0,19 seconds.
Performing query: LOCK TABLES wsnforum_email WRITE, wsnforum_links WRITE, wsnforum_categories WRITE, wsnforum_members WRITE;
Load time so far: 0,19 seconds.
Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnforum_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Number of rows is 0 for Resource id #54
Load time so far: 0,19 seconds.
Performing query: UNLOCK TABLES;
Load time so far: 0,19 seconds.
Performing query: SELECT id,frequency,filename,nextrun FROM wsnforum_crons WHERE nextrun < 1163073763 ORDER BY id ASC LIMIT 0,1;
Number of rows is 0 for Resource id #56
Load time so far: 0,2 seconds.
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,mixtypes,isalbum,orderlinks,totalcomments,alias,catcols,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,opwords FROM wsnforum_categories WHERE parent=2 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY priority ASC,name ASC LIMIT 0,300;
Number of rows is 5 for Resource id #61
Load time so far: 0.26 seconds.
Performing query: SELECT COUNT(id) FROM wsnforum_links WHERE catid=2 AND hide=0 AND deleted=0 AND validated=1 ;
Count is 0
Fatal error: Unsupported operand types in d:\easyphp1-8\www\wsnforum\index.php on line 556
-------------------------------------------------------------------------
the code in index.php is:
-------------------------------
556) $start = ($page * $perpage) - $perpage; // have to adjust for starting the numbering at 1
557) $end = $start + $perpage - 1;
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
You can't do that on the 'show topics in forum' page since that page already has pagination for for the topics which your toplist is overwriting (thus making it not know what page of topics to show).
Experienced
Usergroup: Customer
Joined: Feb 22, 2004
Total Topics: 47
Total Comments: 88
Paul, i forgot to say that i have removed all code used to show topics
(the entire table of <!-- BEGIN REGULAR TOPICS --> ) and also the code for
the pagination <IF {MULTIPAGE}>...</IF>, but i still get the same message.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It doesn't matter what you remove from the template or if you use an entirely blank template, the topics will be queried just the same since that's what that page is for. If you don't want to show topics, put your custom template over another page -- you can still use forum template vars if you pass the forum id to the page as &catid={FORUMID}: www.wsnforum.com/wsnmanual/...ng_Custom_Templates-6.html