Webmastersite.net
Register Log In

mysql error

Title mysql error
Message Text 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
Rating
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5
0/5 based on 0 votes.
Ownership mattydread
Views 1,014 views. Averaging 0 views per day.
Similar Topics
Submission Date Jun 12, 2006 - 11:20 AM