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
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;
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?
Comments on Search not working
Member
Usergroup: Customer
Joined: May 06, 2005
Total Topics: 5
Total Comments: 15
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
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
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.
Member
Usergroup: Customer
Joined: May 06, 2005
Total Topics: 5
Total Comments: 15
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;
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
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?
Member
Usergroup: Customer
Joined: May 06, 2005
Total Topics: 5
Total Comments: 15
No, all the fields were deselected from the beginning by the looks of it. Have just gone there and fixed the problem thanks.