Webmastersite.net
Register Log In

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
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5
0/5 based on 0 votes.
Ownership isto
Views 558 views. Averaging 0 views per day.
Similar Topics
Submission Date Aug 26, 2006 - 8:21 AM