Usergroup: Customer
Joined: Aug 09, 2004
Location: Chile
Total Topics: 136
Total Posts: 350
Posted 02/07/08 - 07:42 PM:
#3
Thanks but it seems that there's an error that's arising presumably with 'catparentid' from my toplist at main.tpl:
Query 22: SELECT `id`,`title`,`url`,`description`,`rating`,`votes`,`validated `,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,` hide`,`ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`not ify`,`suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`ex pire`,`ip`,`inalbum`,`typeorder`,`recipurl`,`hitsin`,`recipw ith`,`hitsinips`,`hitsoutips`,`lastcomment`,`related`,`inhid den`,`viewers`,`threadviewers`,`hitsintemp`,`hitsouttemp`,`o rigtype`,`importance`,`parentids`,`timesdead`,`timesemailed` ,`threadclosed`,`threadposters`,`lastposterid`,`lastposterna me`,`ownername`,`deleted`,`deletionreason`,`movedto`,`delete dby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloa ds`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`, `recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysih tml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachet ime`,------------`timedeleted` FROM econo_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (type != "prioridad_maxima" and catparentid =185 AND invisibleto NOT LIKE '%|3|%') AND effectivetime < 1202441767 AND alias=0 AND inalbum=0 ORDER BY id DESC LIMIT 0,35
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\proyects\nndomain\nndomain\databases\mysqli. php on line 20
Number of rows is Unknown column 'catparentid' in 'where clause'
Also, pleas note that 'catparentid' does not appears at the toplist list of link variables nor at the add fields list of link variables.
Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 49
Total Posts: 5539
Posted 02/08/08 - 01:17 PM:
#4
It isn't a field, it's just a template variable, so you can't sort a toplist by it. Unless it's a category toplist in which case you use parent, of course.
Print
{LINKPARENTID} 
