- WSN Support Forums
- Paid Scripts Support
- database.php error
database.php error
Title | database.php error |
Description | when searching comments |
Message Text | I already searched the forums for a solution but didn't find one that works.
When a registered user looks at comments and clicks on the links for searching all links/comments made by one user this error appears:
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
and this is what the debug says:
Load time so far: 0.25 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,alias,catcols,linkcols,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,catimage,descriptionde,namede FROM _categories WHERE validated=1 AND deleted=0 AND hide=0 ;
Number of rows is 5 for Resource id #48
Load time so far: 0.25 seconds.
Performing query: LOCK TABLES _email WRITE, _links WRITE, _categories WRITE, _members WRITE;
Load time so far: 0.25 seconds.
Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM _email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Number of rows is 0 for Resource id #49
Load time so far: 0.25 seconds.
Performing query: UNLOCK TABLES;
Load time so far: 0.26 seconds.
Performing query: SELECT lastsearch FROM _sessions WHERE ip='84.130.44.187' ;
Number of rows is 1 for Resource id #53
Load time so far: 0.26 seconds.
Performing query: UPDATE _sessions SET lastsearch='1156598146' WHERE ip='84.130.44.187';
Load time so far: 0.26 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,message,sticky,downloads,pollid,posticon,savedby,filesizekb,titlede,descriptionde,mirror,offsite FROM _links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((= '1')) ORDER BY rating DESC LIMIT 0,45;
Load time so far: 0.26 seconds.
Performing query: SELECT COUNT(id) FROM _links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((= '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 '= '1')) ORDER BY rating DESC LIMIT 0,45' at line 1
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 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 '= '1'))' at line 1 |
Rating |
|
Ownership | isto |
Views | 566 views. Averaging 0 views per day. |
Similar Topics | |
Submission Date | Aug 26, 2006 - 6:21 AM |