WebmasterSite.net: PHP scripts to enable your creativity
WSN Links PHP Directory Software
PHP Scripts Webmaster Links Support Forums


multipage toplist error

Version: 1.3.4
printPrint


multipage toplist error
sertan6
Experienced

Usergroup: Customer
Joined: Feb 22, 2004
Total Topics: 45
Total Posts: 83
Posted 11/09/06 - 04:12 AM:
quote post
#1
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</CONF IG>
{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) http://127.0.0.1/wsnforum/index.php?action=displa...[6]=2&order[6]=&field[6]=&thecolumns[6]=&number[6]=1

3rd page) http://127.0.0.1/wsnforum/index.php?action=displa...[6]=3&order[6]=&field[6]=&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,repla cementclose,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,canem ail,validatecats,validatecomments,validatelinks,validateedit s,cansubmitlinks,cansubmitcategories,cansubmitcomments,caned itownlinks,caneditowncategories,caneditowncomments,caneditow nprofile,caneditalllinks,caneditallcategories,caneditallcomm ents,caneditallprofiles,candownloadfiles,canupload,canviewip ,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canal ias,candeleteown,candeleteall,candofulledit,candeletecategor ies,candeletecomments,candeleteowncategories,candeleteowncom ments,candeletemembers,candeleteownmembers,canaliascategorie s,canviewpages,caneditvotes,numaliases,canviewvotes,canhideo wnlinks,canhideowncategories,canhideowncomments,canhideallli nks,canhideallcategories,canhideallcomments,canratecomments, bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily ,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpo lls,caneditpolls,caneditownpolls,attachperpost,attachperpm,c anviewshouts,caneditshouts,caneditownshouts,candeleteshouts, candeleteownshouts,cansubmitshouts,canpollvote,customtitle,c anviewinvisible,namestyle,canpmimportant,canviewmodlog,islea der,cansubmitquotes,validatequotes,candeletequotes,candelete ownquotes,canreport,canusesearch,validateattachments,canedit ownquotes,caneditallquotes,canviewchat,caneditownevents,cane ditallevents,candeleteownevents,candeleteevents,cansubmiteve nts,validateevents,bulkpms,issupermod,cansuggestban,shoutspe rday 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,avatarna me,stylesheet,allowuseremail,albumid,failedattempts,totalbyt es,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,n otifyofpms,acceptpms,cookieduration,banned,topics,posts,loca tion,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,time online,totalpms,buddies,ignored,isonline,acceptims,adminperm issions,referrer,groupreverttime,grouprevertto,moderationpm, secondarygroups,linksperpage,commentsperpage,shouts,customti tle,shoutban,topicbans,forumbans,visibility,birthdate,lastse ssion,interests,posteditor,forumaccess,pmpopup,pmnotify,modn otes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,l astguestnote,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,parent ids,numlinks,hide,lastlinktime,custom,lastedit,moderators,he aderinfo,related,numsub,type,permissions,subscribers,mixtype s,isalbum,orderlinks,totalcomments,alias,catcols,sponsorlink s,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,pr iority,levelsdeep,lastposterid,lastpostername,lastcommenttim e,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,un validatedcomments,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,parent ids,numlinks,hide,lastlinktime,custom,lastedit,moderators,he aderinfo,related,numsub,type,permissions,subscribers,mixtype s,isalbum,orderlinks,totalcomments,alias,catcols,sponsorlink s,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,pr iority,levelsdeep,lastposterid,lastpostername,lastcommenttim e,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,un validatedcomments,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;
Paul
Administrator
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5703
Posted 11/10/06 - 07:24 PM:
quote post
#2
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).
sertan6
Experienced

Usergroup: Customer
Joined: Feb 22, 2004
Total Topics: 45
Total Posts: 83
Posted 11/12/06 - 04:43 AM:
quote post
#3
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.

Edited by sertan6 on 11/12/06 - 04:53 AM
Paul
Administrator
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5703
Posted 11/12/06 - 11:47 PM:
quote post
#4
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}: http://www.wsnforum.com/wsnmanual/articles/Using_...
Search thread for
Download thread as


You don't have permission to post.

Please login or register.

   
 
© 2008 Paul Knierim. All rights reserved.