I get the following errors when I click on a search result (I have a toplist which outputs the most searched for keywords, and I've hyperlinked these...)
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in ....../classes/database.php on line 256
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ......./classes/database.php on line 108
I get the following debug output:
Load time so far: 0.19 seconds. Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;
Load time so far: 0.2 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 #48
Load time so far: 0.2 seconds. Performing query: UNLOCK TABLES;
Load time so far: 0.29 seconds. Performing query: SELECT lastsearch FROM wsnlinks_sessions WHERE ip=à¾.9.52.15' ;
Number of rows is 1 for Resource id #53
Load time so far: 0.3 seconds. Performing query: UPDATE wsnlinks_sessions SET lastsearch=èžï¿½' WHERE ip=à¾.9.52.15'
Load time so far: 0.32 seconds. Performing query: 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,price,currency,message,sticky,downloads,pollid,posticon,savedby,pagerank FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND (((title LIKE '%jobs%') OR (url LIKE '%jobs%') OR (description LIKE '%jobs%') OR (price LIKE '%jobs%') OR (longdescription LIKE '%jobs%'))) ORDER BY rating DESC LIMIT 0,45;
Load time so far: 0.32 seconds. Performing query: SELECT COUNT(id) FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND (((title LIKE '%jobs%') OR (url LIKE '%jobs%') OR (description LIKE '%jobs%') OR (price LIKE '%jobs%') OR (longdescription LIKE '%jobs%'))) ;
Unknown column 'longdescription' in 'where clause'
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in ......../classes/database.php on line 256 Count is
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ......./classes/database.php on line 108
Number of rows is for Unknown column 'longdescription' in 'where clause'
Load time so far: 0.5 seconds. Performing query: SELECT COUNT(id) FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND parent=0 AND deleted=0 ;
Unknown column 'longdescription' in 'where clause' Count is 3
I have removed 'longdescription' from all possible areas using the remove field feature in admin panel! SO I'm not sure why this happens...
You have 'longdesription' selected as a field which should be searched by the simple search, and you don't actually have such a field since you've removed it, hence the error.
Thanks. I actually found that that wasn't the case. I went into Search/Searchable fields and found that longdescription was not in the drop-down list at all. I had a few fields selected though, so I de-selected everything and then re-selected those fields.
And that fixed it. I don't have this issue anymore. However it looks like it somehow 'stickied' somewhere... and that if you delete a field that was also a searchable one, you have to also de-select and re-select the other fields again.
It wasn't in the list, because the list only includes existing fields, but it was selected anyhow. If you remove a field which is selected in list somewhere -- be it there or in required fields -- you'll have to submit the page in order to get it unselected.
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on not a valid MySQL result resource in ...
Forum Regular
Usergroup: Customer
Joined: Aug 05, 2005
Total Topics: 94
Total Comments: 272
I get the following errors when I click on a search result (I have a toplist which outputs the most searched for keywords, and I've hyperlinked these...)
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in ....../classes/database.php on line 256
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ......./classes/database.php on line 108
I get the following debug output:
Load time so far: 0.19 seconds.
Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;
Load time so far: 0.2 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 #48
Load time so far: 0.2 seconds.
Performing query: UNLOCK TABLES;
Load time so far: 0.29 seconds.
Performing query: SELECT lastsearch FROM wsnlinks_sessions WHERE ip=à¾.9.52.15' ;
Number of rows is 1 for Resource id #53
Load time so far: 0.3 seconds.
Performing query: UPDATE wsnlinks_sessions SET lastsearch=èžï¿½' WHERE ip=à¾.9.52.15'
Load time so far: 0.32 seconds.
Performing query: 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,price,currency,message,sticky,downloads,pollid,posticon,savedby,pagerank FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND (((title LIKE '%jobs%') OR (url LIKE '%jobs%') OR (description LIKE '%jobs%') OR (price LIKE '%jobs%') OR (longdescription LIKE '%jobs%'))) ORDER BY rating DESC LIMIT 0,45;
Load time so far: 0.32 seconds.
Performing query: SELECT COUNT(id) FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND (((title LIKE '%jobs%') OR (url LIKE '%jobs%') OR (description LIKE '%jobs%') OR (price LIKE '%jobs%') OR (longdescription LIKE '%jobs%'))) ;
Unknown column 'longdescription' in 'where clause'
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in ......../classes/database.php on line 256
Count is
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ......./classes/database.php on line 108
Number of rows is for Unknown column 'longdescription' in 'where clause'
Load time so far: 0.5 seconds.
Performing query: SELECT COUNT(id) FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND parent=0 AND deleted=0 ;
Unknown column 'longdescription' in 'where clause'
Count is 3
I have removed 'longdescription' from all possible areas using the remove field feature in admin panel! SO I'm not sure why this happens...
Forum Regular
Usergroup: Customer
Joined: Aug 05, 2005
Total Topics: 94
Total Comments: 272
Paul the WYSWIG editor here just isn't working.... can't even use italics! And sorry, don't want to have to use the plain text editor....
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
You have 'longdesription' selected as a field which should be searched by the simple search, and you don't actually have such a field since you've removed it, hence the error.
Forum Regular
Usergroup: Customer
Joined: Aug 05, 2005
Total Topics: 94
Total Comments: 272
Thanks. I actually found that that wasn't the case. I went into Search/Searchable fields and found that longdescription was not in the drop-down list at all. I had a few fields selected though, so I de-selected everything and then re-selected those fields.
And that fixed it. I don't have this issue anymore. However it looks like it somehow 'stickied' somewhere... and that if you delete a field that was also a searchable one, you have to also de-select and re-select the other fields again.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It wasn't in the list, because the list only includes existing fields, but it was selected anyhow. If you remove a field which is selected in list somewhere -- be it there or in required fields -- you'll have to submit the page in order to get it unselected.