Webmastersite.net
Register Log In

Search not working
Directory search facility not working

Comments on Search not working

egdcltd
Member

Usergroup: Customer
Joined: May 06, 2005

Total Topics: 5
Total Comments: 15
egdcltd
Posted Nov 05, 2005 - 8:57 AM:

The search facility is not working. When a search is made, the following error message appears:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/directo/public_html/games/gamezone/classes/database.php on line 82

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/directo/public_html/games/gamezone/classes/database.php on line 82
and no results are ever found
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Nov 06, 2005 - 4:51 AM:

You haven't read the pinned thread at the top of the forum: https://www.webmastersite.net/forums/thread/4382

Needless to say the search works fine in default usage.
egdcltd
Member

Usergroup: Customer
Joined: May 06, 2005

Total Topics: 5
Total Comments: 15
egdcltd
Posted Nov 06, 2005 - 5:19 AM:

Is this the stuff you need?

Load time so far: 0.07 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ORDER BY id DESC LIMIT 0,1;


Warning: Cannot modify header information - headers already sent by (output started at /home/directo/public_html/games/gamezone/classes/database.php:244) in /home/directo/public_html/games/gamezone/prestart.php on line 123

Load time so far: 0.07 seconds.
Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;

Number of rows is 23 for Resource id #30

Load time so far: 0.08 seconds.
Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder ;

Number of rows is 4 for Resource id #32

Load time so far: 0.08 seconds.
Performing query: SELECT original,replacement,description,id,sortorder FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder ;

Number of rows is 14 for Resource id #33

Load time so far: 0.08 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;

Number of rows is 100 for Resource id #34

Load time so far: 0.08 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,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem FROM wsnlinks_membergroups WHERE id>0 ;

Load time so far: 0.08 seconds.
Performing query: 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 FROM wsnlinks_members WHERE id=1 AND validated=1 ;

Load time so far: 0.09 seconds.
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;

Number of rows is 100 for Resource id #39

Load time so far: 0.11 seconds.
Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;

Load time so far: 0.11 seconds.
Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;

Number of rows is 0 for Resource id #40

Load time so far: 0.11 seconds.
Performing query: UNLOCK TABLES;

Load time so far: 0.12 seconds.
Performing query: SELECT id FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0) AND ((( LIKE '%snake%'))) ;


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/directo/public_html/games/gamezone/classes/database.php on line 82

Number of rows is for 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 'LIKE '%snake%')))' at line 1

Load time so far: 0.12 seconds.
Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,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,price,longdescription,xwidth,yheight FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0) AND ((( LIKE '%snake%'))) ORDER BY rating DESC LIMIT 0,15;

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 'LIKE '%snake%')))' at line 1

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/directo/public_html/games/gamezone/classes/database.php on line 82

Number of rows is for 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 'LIKE '%snake%'))) ORDER BY rating DESC LIMIT 0,15' at line 1

Warning: Cannot modify header information - headers already sent by (output started at /home/directo/public_html/games/gamezone/classes/database.php:244) in /home/directo/public_html/games/gamezone/end.php on line 29

Load time so far: 0.13 seconds.
Performing query: DELETE FROM wsnlinks_sessions WHERE time < 1131282159;

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 'LIKE '%snake%'))) ORDER BY rating DESC LIMIT 0,15' at line 1

Load time so far: 0.13 seconds.
Performing query: UPDATE wsnlinks_sessions SET starttime='0' WHERE time < 15;

Load time so far: 0.13 seconds.
Performing query: UPDATE wsnlinks_sessions SET time='0' WHERE time < 15;

Load time so far: 0.13 seconds.
Performing query: SELECT starttime FROM wsnlinks_sessions WHERE memberid=1 ;

Number of rows is 1 for Resource id #46

Load time so far: 0.13 seconds.
Performing query: UPDATE wsnlinks_sessions SET time='1131283059', location='http://games.directorygold.com/gamezone/search.php?filled=1&condition=and', catid='', threadid='', areaname='Search' WHERE memberid=1;
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Nov 09, 2005 - 9:59 AM:

It says you have no searchable fields. What do you have selected under settings->search? Did you go in there and deselect all the fields for some reason?
egdcltd
Member

Usergroup: Customer
Joined: May 06, 2005

Total Topics: 5
Total Comments: 15
egdcltd
Posted Nov 09, 2005 - 10:07 AM:

No, all the fields were deselected from the beginning by the looks of it. Have just gone there and fixed the problem thanks.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.