Filename: Default search box on the main category page. I typed 'insurance' into the search box and hit search.
Also get the same error message if I use the advanced search using search.php
I have not upgraded.
Recently changed default order from title alphabetical, ascending order to ....
By title, rotating starting letter
Error messages from debug:
Load time so far: 0.23 seconds. Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;
Load time so far: 0.24 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 #42
Load time so far: 0.24 seconds. Performing query: UNLOCK TABLES;
Load time so far: 0.28 seconds. Performing query: SELECT id FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0) AND ((title LIKE '%insurance%' OR url LIKE '%insurance%' OR description LIKE '%insurance%' OR county LIKE '%insurance%' OR company LIKE '%insurance%' OR city LIKE '%insurance%' OR region LIKE '%insurance%' OR keywords LIKE '%insurance%')) ;
Number of rows is 2 for Resource id #47
Load time so far: 0.28 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,county,company,add1,add2,city,state,zip,region,keywords,submitter,certification,phone FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0) AND ((title LIKE '%insurance%' OR url LIKE '%insurance%' OR description LIKE '%insurance%' OR county LIKE '%insurance%' OR company LIKE '%insurance%' OR city LIKE '%insurance%' OR region LIKE '%insurance%' OR keywords LIKE '%insurance%')) ORDER BY typeorder ASC,rotating case LIMIT 0,15;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.chippy/techdi/bizgeorgia.com/ga/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 'case LIMIT 0,15' at line 1
Load time so far: 0.3 seconds. Performing query: SELECT id FROM wsnlinks_pm WHERE timeread=0 AND time > 0 AND deleted=0 AND toid=1 ;
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 'case LIMIT 0,15' at line 1
Number of rows is 0 for Resource id #50
Load time so far: 0.3 seconds. Performing query: SELECT id FROM wsnlinks_pm WHERE deleted=0 AND time > 0 AND toid=1 ;
Comments on Database error when performing searches
Beginner
Usergroup: Customer
Joined: Mar 21, 2005
Location: Marietta, GA
Total Topics: 2
Total Comments: 7
Filename: Default search box on the main category page. I typed 'insurance' into the search box and hit search.
Also get the same error message if I use the advanced search using search.php
I have not upgraded.
Recently changed default order from title alphabetical, ascending order to ....
By title, rotating starting letter
Error messages from debug:
Load time so far: 0.23 seconds.
Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;
Load time so far: 0.24 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 #42
Load time so far: 0.24 seconds.
Performing query: UNLOCK TABLES;
Load time so far: 0.28 seconds.
Performing query: SELECT id FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0) AND ((title LIKE '%insurance%' OR url LIKE '%insurance%' OR description LIKE '%insurance%' OR county LIKE '%insurance%' OR company LIKE '%insurance%' OR city LIKE '%insurance%' OR region LIKE '%insurance%' OR keywords LIKE '%insurance%')) ;
Number of rows is 2 for Resource id #47
Load time so far: 0.28 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,county,company,add1,add2,city,state,zip,region,keywords,submitter,certification,phone FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0) AND ((title LIKE '%insurance%' OR url LIKE '%insurance%' OR description LIKE '%insurance%' OR county LIKE '%insurance%' OR company LIKE '%insurance%' OR city LIKE '%insurance%' OR region LIKE '%insurance%' OR keywords LIKE '%insurance%')) ORDER BY typeorder ASC,rotating case LIMIT 0,15;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.chippy/techdi/bizgeorgia.com/ga/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 'case LIMIT 0,15' at line 1
Load time so far: 0.3 seconds.
Performing query: SELECT id FROM wsnlinks_pm WHERE timeread=0 AND time > 0 AND deleted=0 AND toid=1 ;
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 'case LIMIT 0,15' at line 1
Number of rows is 0 for Resource id #50
Load time so far: 0.3 seconds.
Performing query: SELECT id FROM wsnlinks_pm WHERE deleted=0 AND time > 0 AND toid=1 ;
Number of rows is 0 for Resource id #51
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
ORDER BY typeorder ASC,rotating case LIMIT 0,15;
Rotating letters only works as a sort order for displaying links in categories, not for searches.