Webmastersite.net
Register Log In

mysql error

Comments on mysql error

mattydread
Member

Usergroup: Customer
Joined: Apr 15, 2006

Total Topics: 7
Total Comments: 15
Posted Jun 12, 2006 - 11:20 AM:

Sometimes I receive this message at the top of my pages:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/albanyto/public_html/dir/classes/database .php on line 108




here's the debug info:

Load time so far: 0.13 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1;



Load time so far: 0.14 seconds.
Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;



Number of rows is 58 for Resource id #36

Load time so far: 0.14 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 22 for Resource id #38

Load time so far: 0.15 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 #39

Load time so far: 0.16 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,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod FROM wsnlinks_membergroups WHERE id>0 ;



Load time so far: 0.16 seconds.
Performing query: SELECT userid,usergroupid,membergroupids,displaygroupid,username,password,passworddate,email,styleid,parentemail,homepage,icq,aim,yahoo,msn,skype,showvbcode,showbirthday,usertitle,customtitle,joindate,daysprune,lastvisit,lastactivity,lastpost,posts,reputation,reputationlevelid,timezoneoffset,pmpopup,avatarid,avatarrevision,profilepicrevision,options,birthday,birthday_search,maxposts,startofweek,ipaddress,referrerid,languageid,emailstamp,threadedmode,autosubscribe,pmtotal,pmunread,salt,links,comments,totalhits,totalhitsin,validated,template,language,lastattempt,allowemail,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,timezone,rating,notifyofpms,acceptpms,cookieduration,banned,location,occupation,bio,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmnotify,modnotes,guestnotes,lastmodnote,newpms,imflag,orderalbums,lastguestnote,notifymethod,showavatars,showsigs,warninglevel,topics,chatcolor,traderrating,sr_classifieds_score,sr_classifieds_pcnt,arcadeoptions,challengecache,favcache FROM user WHERE userid=1 AND validated=1 ;



Load time so far: 0.17 seconds.
Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, user WRITE;



Load time so far: 0.17 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 #49

Load time so far: 0.18 seconds.
Performing query: UNLOCK TABLES;



Load time so far: 0.18 seconds.
Performing query: SELECT id,frequency,filename,nextrun FROM wsnlinks_crons WHERE nextrun < 1150128965 ORDER BY id ASC LIMIT 0,1;



Number of rows is 0 for Resource id #51

Load time so far: 0.18 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,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 AND deleted=0 ORDER BY priority ASC,name ASC LIMIT 0,40;



Number of rows is 23 for Resource id #53

Load time so far: 0.18 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 AND deleted=0 ;



Number of rows is 23 for Resource id #54

Setting cookie with name returnto, value http://www.albanytolakegeorge.com/dir/index.php?debug=1 and duration 1150129865


Warning: Cannot modify header information - headers already sent by (output started at /home/albanyto/public_html/dir/classes/database.php:276) in /home/albanyto/public_html/dir/commonfuncs.php on line 463

Warning: Cannot modify header information - headers already sent by (output started at /home/albanyto/public_html/dir/classes/database.php:276) in /home/albanyto/public_html/dir/commonfuncs.php on line 467

Warning: Cannot modify header information - headers already sent by (output started at /home/albanyto/public_html/dir/classes/database.php:276) in /home/albanyto/public_html/dir/end.php on line 143


Load time so far: 0.57 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_sessions WHERE memberid>0 ;



Count is 1


Load time so far: 0.57 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_sessions WHERE memberid=0 AND isrobot=0 ;



Count is 1


Load time so far: 0.57 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_sessions WHERE memberid=0 AND isrobot=1 ;



Count is 0


Load time so far: 0.62 seconds.
Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility FROM wsnlinks_sessions WHERE time > 1150128065 AND (memberid>0) ORDER BY time DESC LIMIT 0,100;



Number of rows is 1 for Resource id #59

17 total queries
This page was created in 0.79 seconds
Server Status: time since last reboot is 1 day, 23:41, load average: 1.32, 2.11, 2.02

Load time so far: 0.81 seconds.
Performing query: SELECT inchat,lastchat FROM wsnlinks_sessions WHERE memberid=1 LIMIT 0,1;



Number of rows is 1 for Resource id #68

Load time so far: 0.81 seconds.
Performing query: SELECT memberid,starttime,time FROM wsnlinks_sessions WHERE time < 1150128065 AND memberid > 0 ;



Number of rows is 0 for Resource id #69

Load time so far: 0.81 seconds.
Performing query: DELETE FROM wsnlinks_sessions WHERE time < 1150128065;



Load time so far: 1.06 seconds.
Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility FROM wsnlinks_sessions WHERE memberid=1 ;



Number of rows is 1 for Resource id #70

Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET id='1088' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET memberid='1' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET location='http://www.albanytolakegeorge.com/dir/index.php?debug=1' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET time='1150128965' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET ip='167.230.38.118' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET browser='Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET starttime='1150126704' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET catid='0' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET threadid='' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET areaname='Main' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET lastsearch='0' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET nopermission='0' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET inchat='0' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET name='Mattyk72' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET isrobot='0' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET lastchat='0' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET groupnamestyle='admincolor' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET acceptims='' WHERE id=1088;



Load time so far: 1.07 seconds.
Performing query: UPDATE wsnlinks_sessions SET visibility='' WHERE id=1088;



closing database connection
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Jun 12, 2006 - 2:13 PM:

There are no mysql warnings in the debug you posted. It's not useful to post the debug of a page where you don't get the error.

Some crons were fixed a while back, no idea if that was before or after 3.3.13.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.