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