custom table search error: WSN Support Forums

Comments on custom table search error

•david Forum Regular Usergroup: Customer Joined: Jun 22, 2005 Total Topics: 91 Total Comments: 305	•david #1 - Quote - Permalink Posted Oct 08, 2008 - 9:17 AM: Hi Paul, Trying to perform a search on the custom table I added. I can add and edit fine, but searching produces an error. My custom table is 'bemutatva'. I have added an entry to it, with the 'property' value of 213. The property field is an integer field. When I try this: search.php?action=filter&filled=1&whichtype=bemutatva&propertycondition=or&propertysearch=213&usewrapper=no I get the following error: Query 6: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 AND inprogress=0 ORDER BY id ASC LIMIT 0,10 Load time so far: 0.07 seconds. Number of rows is 0 Query 7: SELECT `id`,`time`,`lastedit`,`ownerid`,`editedby`,`showdate`,`property`,`tomember` FROM wsnlinks_bemutatva WHERE () AND (((property = 213))) ORDER BY LIMIT 0,60 Load time so far: 0.08 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 (((property = 213))) ORDER BY LIMIT 0,60' at line 1 Load time so far: 0.08 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 (((property = 213))) ORDER BY LIMIT 0,60' at line 1 Query 8: SELECT COUNT(id) FROM wsnlinks_bemutatva WHERE () AND (((property = 213))) An error occoured at xxx.net/search.php?action=f...tysearch=213&usewrapper=no on 2008-10-08 14:12:21. Please relay this data to support. Error #2: 'mysql_fetch_row(): supplied argument is not a valid MySQL result resource' in /home/xxx/public_html/xxx/databases/mysql.php on line 50. Debug info: Count is An error occoured at xxx.net/search.php?action=f...tysearch=213&usewrapper=no on 2008-10-08 14:12:21. Please relay this data to support. Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /home/xxx/public_html/xxx/databases/mysql.php on line 47. Debug info: Number of rows is 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 (((property = 213)))' at line 1 Query 9: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE memberid=1 Load time so far: 0.09 seconds. Number of rows is 1 Creating online with Array as row Load time so far: 0.09 seconds. Am I missing something, or this is a bug? Thanks David
•Paul developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7867	•Paul #2 - Quote - Permalink Posted Oct 09, 2008 - 5:23 AM: You did create bemutatva_search.tpl? I'm getting a very different error, but I'll fix mine.
•david Forum Regular Usergroup: Customer Joined: Jun 22, 2005 Total Topics: 91 Total Comments: 305	•david #3 - Quote - Permalink Posted Oct 09, 2008 - 6:48 AM: Yep, it is in the custom folder.
•david Forum Regular Usergroup: Customer Joined: Jun 22, 2005 Total Topics: 91 Total Comments: 305	•david #4 - Quote - Permalink Posted Oct 09, 2008 - 8:40 AM: I upgraded to 5.0.12. The above search error is gone, but another search in my custom table not working. Could be toplist and NOT search related though. This is the searchquery: search.php?action=filter&filled=1&whichtype=links&condition=and&usewrapper=no&kiez=1&custom=yes&TID=listlinksonmembers&helysegcondition=%3D&helysegsearch=budapest There is an extra information 'KIEZ' that is passed in the search query. Here is the above custom TID: <!-- BEGIN SEARCH links RESULTS --> <!-- BEGIN REGULAR --> <tr <? if ({NUMBER} % 2) { ?>class="even"<? } else { ?>class="odd"<? } ?>> <td> <p><a href="index.php?action=displaycat&catid={LINKCATID}" target="_blank">{LINKCATNAME}</a></p> </td> <td> <p><a href="{TRACKLINKURL}&usewrapper=no&custom=yes&TID=listonelinkonmembers" target="memberlist_listonelink">{LINKHAZSZAM} {LINKCIM}</a></p> </td> <td> <p><!-- BEGIN TOPLIST --> <CONFIG>bemutatva,property,999,ascending,tomember={KIEZ} AND property={LINKID},,,0,0,0,0,0,0,,0</CONFIG> <img src="{IMAGESURL}/xxx/visitedinperson.gif" alt="" title="" /> <!-- END TOPLIST --></p> </td> </tr> <!-- END REGULAR --> <!-- END SEARCH links RESULTS --> Here is the debug info when submitting the search: Query 6: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 AND inprogress=0 ORDER BY id ASC LIMIT 0,10 Load time so far: 0.19 seconds. Number of rows is 0 Creating search with new as new Query 7: INSERT INTO wsnlinks_searches(`id`,`value`,`memberid`,`catid`,`time`) VALUES('','budapest','1','','1223558818') Query 8: SELECT `id` FROM wsnlinks_searches ORDER BY id DESC Load time so far: 0.2 seconds. Setting cookie with name testcookie, value 83 and expiration time 3447117635 Query 9: SELECT `id`,`title`,`url`,`description`,`rating`,`votes`,`validated`,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,`suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`recipurl`,`hitsin`,`recipwith`,`hitsinips`,`hitsoutips`,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers`,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parentids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposters`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`deletionreason`,`movedto`,`deletedby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloads`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted`,`helyseg`,`ar`,`varos`,`epitoanyag`,`alapterulet`,`kertmeret`,`szobaszam`,`felszobaszam`,`erkely`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`emeleten`,`parkolas`,`lakasallapot`,`extrak`,`butorozott`,`szintek`,`kiadoar`,`epitoanyagenglish`,`erkelyenglish`,`futesenglish`,`kilatasenglish`,`tajolasenglish`,`komfortenglish`,`liftenglish`,`parkolasenglish`,`lakasallapotenglish`,`extrakenglish`,`butorozottenglish`,`descriptionenglish`,`kerulet`,`megye`,`eladokiado`,`gepesitett`,`gepesitettenglish`,`cim`,`hazszam`,`adminnotes`,`telek`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longitude`,`zip`,`kiadoareuro`,`phone`,`kiemelt`,`kertkapcsolat`,`kertkapcsolatenglish`,`helysegszam`,`summary` FROM wsnlinks_links WHERE (validated=1 AND invisibleto NOT LIKE '%\|3\|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1223558818) AND (helyseg = 'budapest')) ORDER BY typeorder ASC,time DESC LIMIT 0,60 Load time so far: 0.21 seconds. Load time so far: 0.21 seconds. Query 10: SELECT COUNT(id) FROM wsnlinks_links WHERE (validated=1 AND invisibleto NOT LIKE '%\|3\|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1223558818) AND (helyseg = 'budapest')) Count is 3 Number of rows is 3 Creating link with Array as row Query 11: 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`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl`,`nameenglish`,`specialurl`,`invisibleto` FROM wsnlinks_categories WHERE id=63 Load time so far: 0.23 seconds. Query 12: 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`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl`,`nameenglish`,`specialurl`,`invisibleto` FROM wsnlinks_categories WHERE id=63 Load time so far: 0.23 seconds. Creating link with Array as row Query 13: 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`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl`,`nameenglish`,`specialurl`,`invisibleto` FROM wsnlinks_categories WHERE id=63 Load time so far: 0.24 seconds. Query 14: 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`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl`,`nameenglish`,`specialurl`,`invisibleto` FROM wsnlinks_categories WHERE id=63 Load time so far: 0.24 seconds. Creating link with Array as row Query 15: 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`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl`,`nameenglish`,`specialurl`,`invisibleto` FROM wsnlinks_categories WHERE id=63 Load time so far: 0.24 seconds. Query 16: 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`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl`,`nameenglish`,`specialurl`,`invisibleto` FROM wsnlinks_categories WHERE id=63 Load time so far: 0.24 seconds. Query 17: SELECT `id`,`time`,`lastedit`,`ownerid`,`editedby`,`showdate`,`property`,`tomember` FROM wsnlinks_bemutatva WHERE 1=1 AND (tomember=1 AND property=217) ORDER BY property ASC LIMIT 0,999 Load time so far: 0.25 seconds. Number of rows is 0 Query 18: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE memberid=1 Load time so far: 0.28 seconds. Number of rows is 1 Creating online with Array as row Load time so far: 0.28 seconds. The search itself is produced fine, the results are ok. It is the toplist that is generated for each result, that is now broken. In the above debug info, you will see that it has 3 search results, but it generates the toplist for only the last 2 of the results displayed. AND it doesn't just output the IMG that is between the TOPLIST tags, but displays the toplist config for the last 2 search results, next to the image: bemutatva,property,999,ascending,tomember={KIEZ} AND property=215,,,0,0,0,0,0,0,,0 Thanks David
•david Forum Regular Usergroup: Customer Joined: Jun 22, 2005 Total Topics: 91 Total Comments: 305	•david #5 - Quote - Permalink Posted Oct 09, 2008 - 10:04 AM: interesting. i created another search, which searches in the customtable I created, and put a toplist in between the <!-- BEGIN SEARCH customtable RESULTS -->, and it only seems to generate the first toplist. This is the query: search.php?action=filter&filled=1&whichtype=customtablename&condition=%3D&usewrapper=no&propertycondition=%3D&propertysearch=213 This search produces the desired results, namely finding 2 properties, which is correct. It displays their information correctly. However, there is a toplist to be displayed for each result. This toplist is: <select name="tomember" class="bordered"> <!-- BEGIN TOPLIST --> <CONFIG>members,fullname,999999,ascending,,,,0,0,0,0,0,0,,0</CONFIG> <option value="{MEMBERID}" <IF {MEMBERID} is {BEMUTATVATOMEMBER}>selected="selected"</IF>>{MEMBERFULLNAME} - {MEMBERNAME}</option> <!-- END TOPLIST --> </select> This generates a dropdown for the first search result, but doesn't generate it for the second one. INSTEAD for the second one, it uses MY ADMIN member information (since I am logged in). So really, it doesn't generate the toplist, but uses any available MEMBERFULLNAME and MEMBERNAME info, which is mine as a logged admin. here is the debug info: Query 6: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 AND inprogress=0 ORDER BY id ASC LIMIT 0,10 Load time so far: 0.15 seconds. Number of rows is 0 Query 7: SELECT `id`,`time`,`lastedit`,`ownerid`,`editedby`,`showdate`,`property`,`tomember` FROM wsnlinks_bemutatva WHERE ((property = 213)) ORDER BY id DESC LIMIT 0,60 Load time so far: 0.15 seconds. Load time so far: 0.15 seconds. Query 8: SELECT COUNT(id) FROM wsnlinks_bemutatva WHERE ((property = 213)) Count is 2 Number of rows is 2 Creating bemutatva with Array as row Query 9: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`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`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader`,`minar`,`maxar`,`varos`,`epitoanyag`,`minalapterulet`,`maxalapterulet`,`minhelysegszam`,`maxhelysegszam`,`minfelszobaszam`,`maxfelszobaszam`,`erkely`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`minemeleten`,`maxemeleten`,`parkolas`,`lakasallapot`,`extrak`,`butorozott`,`telefon`,`minkiadoar`,`maxkiadoar`,`megye`,`kerulet`,`eladokategoria`,`gepesitett`,`mintelek`,`maxtelek`,`inactiveemail`,`minkiadoareuro`,`maxkiadoareuro`,`kiadokategoria`,`fullname`,`kertkapcsolat` FROM wsnlinks_members WHERE id='1' Load time so far: 0.16 seconds. Number of rows is 1 Creating bemutatva with Array as row Query 10: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`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`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader`,`minar`,`maxar`,`varos`,`epitoanyag`,`minalapterulet`,`maxalapterulet`,`minhelysegszam`,`maxhelysegszam`,`minfelszobaszam`,`maxfelszobaszam`,`erkely`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`minemeleten`,`maxemeleten`,`parkolas`,`lakasallapot`,`extrak`,`butorozott`,`telefon`,`minkiadoar`,`maxkiadoar`,`megye`,`kerulet`,`eladokategoria`,`gepesitett`,`mintelek`,`maxtelek`,`inactiveemail`,`minkiadoareuro`,`maxkiadoareuro`,`kiadokategoria`,`fullname`,`kertkapcsolat` FROM wsnlinks_members WHERE id='1' Load time so far: 0.16 seconds. Number of rows is 1 Query 11: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`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`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader`,`minar`,`maxar`,`varos`,`epitoanyag`,`minalapterulet`,`maxalapterulet`,`minhelysegszam`,`maxhelysegszam`,`minfelszobaszam`,`maxfelszobaszam`,`erkely`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`minemeleten`,`maxemeleten`,`parkolas`,`lakasallapot`,`extrak`,`butorozott`,`telefon`,`minkiadoar`,`maxkiadoar`,`megye`,`kerulet`,`eladokategoria`,`gepesitett`,`mintelek`,`maxtelek`,`inactiveemail`,`minkiadoareuro`,`maxkiadoareuro`,`kiadokategoria`,`fullname`,`kertkapcsolat` FROM wsnlinks_members WHERE validated=1 ORDER BY fullname ASC LIMIT 0,999999 Load time so far: 0.17 seconds. Number of rows is 3 Creating member with Array as row Creating member with Array as row Creating member with Array as row Creating bemutatva with 14 as id Query 12: SELECT `id`,`time`,`lastedit`,`ownerid`,`editedby`,`showdate`,`property`,`tomember` FROM wsnlinks_bemutatva WHERE id=14 Load time so far: 0.17 seconds. Creating bemutatva with 12 as id Query 13: SELECT `id`,`time`,`lastedit`,`ownerid`,`editedby`,`showdate`,`property`,`tomember` FROM wsnlinks_bemutatva WHERE id=12 Load time so far: 0.17 seconds. Query 14: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE memberid=1 Load time so far: 0.21 seconds. Number of rows is 1 Creating online with Array as row Load time so far: 0.21 seconds. Thanks David
•Paul developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7867	•Paul #6 - Quote - Permalink Posted Oct 13, 2008 - 4:31 PM: There problem must be in your maze of custom fields, because a search for "test" at http://sandbox.wsnforum.com/box4/ shows that that selector toplist works fine.
•david Forum Regular Usergroup: Customer Joined: Jun 22, 2005 Total Topics: 91 Total Comments: 305	•david #7 - Quote - Permalink Posted Oct 14, 2008 - 9:58 AM: PLEASE READ THE PART BELOW THE STARRED LINE BEFORE POSTING A REPLY. THANKS Not sure what you mean by maze of custom fields... I know I have a lot, but what do they have to do with doing a toplist on members with the condition 'id = 1' (or any other number)? They shouldn't. Even if I change what I want to display in the toplist content to the letter 'a' only, the error is still the same. Again, now running 5.0.13, here is something new to ponder: - I have a search result that does a search in my custom table -> results queried and displayed are fine. - I have the below toplist for each search result <!-- BEGIN TOPLIST --> <CONFIG>members,fullname,1,ascending,,,,0,0,0,0,0,0,,0</CONFIG> {MEMBERNAME} <!-- END TOPLIST --> This works fine, but it is not what I need. - As soon as I give a condition to the above toplist, it only generates the toplist once. So if My CONFIG becomes this: <CONFIG>members,name,1,ascending,id={BEMUTATVATOMEMBER},,,0,0,0,0,0,0,,0</CONFIG> Then the area where the second, third, so on, toplist content is supposed to appear, just displays the toplist config. BUT what is really interesting, is that the line that it displays, looks like this: <CONFIG>members,name,1,ascending,id=25,,,0,0,0,0,0,0,,0</CONFIG> 25 is one of the members that was found in the search and used in this search results page, which is working fine. WHAT IS INTERESTING, is that the number 25 DOES get put into the proper place in the CONFIG line of the second toplist, BUT the toplist content doesn't get rendered. ******************* I saw the sandbox you sent the me the link to, but I am not sure if the test you ran there is exactly how the problem came up. The complete setup: - setup a custom table (for description sake, let's call it WIDGETS) - WIDGETS custom table should have the following fields: id, tomember, link - look up 2 members and 1 link in your existing WSN installation. Jot down their ID numbers. Let's say you have member IDs #3 and #4, and link ID #32. - make sure that your widgets_search.tpl contains this: <!-- BEGIN SEARCH widgets RESULTS --> <!-- BEGIN TOPLIST --> <CONFIG>members,name,1,ascending,id={WIDGETSTOMEMBER},,,0,0,0,0,0,0,,0</CONFIG> {MEMBERID} - {MEMBERNAME} <!-- END TOPLIST --> <!-- END SEARCH widgets RESULTS --> - manually or however, add 2 new entries to the WIDGETS table in the DB: line 1: ID (incremented, so whatever); TOMEMBER: 3; LINK: 32 line 2: ID (incremented, so whatever); TOMEMBER: 4; LINK: 32 - do a search: search.php?action=filter&filled=1whichtype=widgets&condition=%3D&usewrapper=no&linkcondition=%3D&linksearch=32 It should produce the same problems, which is: - you would see 2 results to the search -> good - you would see the MEMBERID and MEMBERNAME displayed for only the first toplist in the first searchresult -> good - you would see CONFIG displayed for the second toplist in the second searchresult -> not good Thanks David
•david Forum Regular Usergroup: Customer Joined: Jun 22, 2005 Total Topics: 91 Total Comments: 305	•david #8 - Quote - Permalink Posted Oct 14, 2008 - 10:08 AM: Hi Paul, While the above issue IS an issue I think, I have temporarily patched it like this: - instead of showing a toplist in the search results page for this custom table search, I put an iframe in there and passed the needed {WIDGETSTOMEMBERS} variable <iframe name="widgetssuper{WIDGETSID}" src="index.php?custom=yes&TID=widget_search_extra&usewrapper=no&widgetstomember={WIDGETSTOMEMBER}"></iframe> - and I put the original toplist in the 'widget_search_extra' custom template. BUT, I still think that the above error is an error...
•Paul developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7867	•Paul #9 - Quote - Permalink Posted Oct 17, 2008 - 11:32 AM: <CONFIG>members,name,1,ascending,id={BEMUTAT VATOMEMBER},,,0,0,0,0,0,0,,0</CONFIG> So what in the world is {BEMUTATVATOMEMBER}?
•david Forum Regular Usergroup: Customer Joined: Jun 22, 2005 Total Topics: 91 Total Comments: 305	•david #10 - Quote - Permalink Posted Oct 17, 2008 - 11:36 AM: BEMUTATVATOMEMBER = WIDGETSTOMEMBER It's a field in the custom table called 'bemutatva' in my DB.

Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.