Load time so far: 0.08 seconds. Performing query: SELECT name,content FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC ;
Number of rows is 251 for Resource id #19
Load time so far: 0.09 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ORDER BY id DESC LIMIT 0,1;
Warning: Cannot modify header information - headers already sent by (output started at /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php:244) in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/prestart.php on line 123
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php on line 31
Getting field list for table wsnlinks_ratings
Load time so far: 0.1 seconds. Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 23 for Resource id #30
Load time so far: 0.1 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 4 for Resource id #33
Load time so far: 0.1 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 #34
Load time so far: 0.11 seconds. Performing query: SELECT COUNT(*) FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ;
Load time so far: 0.11 seconds. Performing query: UPDATE wsnlinks_settings SET content='195' WHERE name='totalsubcats';
Load time so far: 0.11 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 FROM wsnlinks_membergroups WHERE id>0 ;
Load time so far: 0.11 seconds. Performing query: SELECT id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned FROM wsnlinks_members WHERE id=1 AND validated=1 ;
Load time so far: 0.12 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=273 ;
Load time so far: 0.12 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=21 ;
Load time so far: 0.13 seconds. Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;
Load time so far: 0.13 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 #42
Load time so far: 0.13 seconds. Performing query: UNLOCK TABLES;
Load time so far: 0.13 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=1 ;
Load time so far: 0.14 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=2 ;
Load time so far: 0.14 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=26 ;
Load time so far: 0.15 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=5 ;
Load time so far: 0.15 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=110 ;
Load time so far: 0.15 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=22 ;
Load time so far: 0.15 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=29 ;
Load time so far: 0.16 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=18 ;
Load time so far: 0.16 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=4 ;
Load time so far: 0.16 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=6 ;
Load time so far: 0.16 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=181 ;
Load time so far: 0.17 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=32 ;
Load time so far: 0.17 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=8 ;
Load time so far: 0.17 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=7 ;
Load time so far: 0.17 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=157 ;
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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=9 ;
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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=11 ;
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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=28 ;
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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=12 ;
Load time so far: 0.19 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=54 ;
Load time so far: 0.2 seconds. Performing query: SELECT COUNT(*) FROM wsnlinks_membergroups WHERE 1=1 ;
Load time so far: 0.2 seconds. Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=1 ;
Load time so far: 0.2 seconds. Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=2 ;
Load time so far: 0.2 seconds. Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=3 ;
Load time so far: 0.21 seconds. Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=4 ;
Warning: Cannot modify header information - headers already sent by (output started at /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php:244) in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/end.php on line 29
Load time so far: 0.25 seconds. Performing query: DELETE FROM wsnlinks_sessions WHERE time < 1147586364;
Load time so far: 0.25 seconds. Performing query: UPDATE wsnlinks_sessions SET starttime='0' WHERE time < 15;
Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Load time so far: 0.25 seconds. Performing query: UPDATE wsnlinks_sessions SET time='0' WHERE time < 15;
Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Load time so far: 0.25 seconds. Performing query: SELECT starttime FROM wsnlinks_sessions WHERE memberid=1 ;
Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php on line 82
Number of rows is for Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Load time so far: 0.25 seconds. Performing query: INSERT INTO wsnlinks_sessions(memberid,ip,location,time,starttime,browser,catid,threadid) VALUES('1','66.75.140.132','http://www.sdrox.com/San_Diego/suggest.php?action=addcat&parent=273&debug=1','1147587264','1147587264','Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7','','');
Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Load time so far: 0.1 seconds. Performing query: SELECT name,content FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC ;
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;
Number of rows is 1 for Resource id #20
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php on line 31
Getting field list for table wsnlinks_ratings
Load time so far: 0.14 seconds. Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 59 for Resource id #36
Load time so far: 0.15 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 4 for Resource id #39
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 #40
Load time so far: 0.15 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 id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,traderrating FROM wsnlinks_members WHERE id=1 AND validated=1 ;
Load time so far: 0.17 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,extratext,banner,bannerurl,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml FROM wsnlinks_categories WHERE validated=1 AND deleted=0 AND hide=0 ;
Number of rows is 195 for Resource id #47
Load time so far: 0.23 seconds. Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;
Load time so far: 0.23 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.23 seconds. Performing query: UNLOCK TABLES;
Load time so far: 0.24 seconds. Performing query: SELECT alias FROM wsnlinks_categories WHERE id=21 ;
Number of rows is 1 for Resource id #53
Load time so far: 0.24 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,extratext,banner,bannerurl,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml FROM wsnlinks_categories WHERE id='21' ;
Number of rows is 1 for Resource id #54
Load time so far: 0.26 seconds. Performing query: SELECT COUNT(id) FROM wsnlinks_membergroups WHERE 1=1 ;
Count is 4
Load time so far: 0.26 seconds. Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=1 ;
Load time so far: 0.26 seconds. Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=2 ;
Load time so far: 0.26 seconds. Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=3 ;
Load time so far: 0.26 seconds. Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=4 ;
Load time so far: 0.27 seconds. Performing query: SELECT parent FROM wsnlinks_categories WHERE alias=21 ORDER BY id ASC ;
Number of rows is 0 for Resource id #62
Load time so far: 0.29 seconds. Performing query: SELECT parent FROM wsnlinks_categories WHERE alias=21 ;
Number of rows is 0 for Resource id #63
Load time so far: 0.3 seconds. Performing query: SELECT value FROM wsnlinks_switches WHERE name='ims' ;
Warning: Cannot modify header information - headers already sent by (output started at /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php:276) in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/end.php on line 142
Load time so far: 0.48 seconds. Performing query: SELECT COUNT(id) FROM wsnlinks_categories WHERE isalbum=0 AND deleted=0 AND moderators LIKE '%, 1[,]%' ;
Count is 0
[SOME CONTENT APPEARS HERE AND THEN MORE DEBUG CODE]
22 total queries This page was created in 0.88 seconds Memory used: 7401648 bytes
Load time so far: 1.42 seconds. Performing query: SELECT inchat,lastchat FROM wsnlinks_sessions WHERE memberid=1 LIMIT 0,1;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php on line 108
Number of rows is for Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Load time so far: 1.43 seconds. Performing query: SELECT memberid,starttime,time FROM wsnlinks_sessions WHERE time < 1147663648 AND memberid > 0 ;
Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php on line 108
Number of rows is for Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Load time so far: 1.43 seconds. Performing query: DELETE FROM wsnlinks_sessions WHERE time < 1147663648;
Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Load time so far: 1.43 seconds. Performing query: SELECT FROM wsnlinks_sessions WHERE memberid=1 ;
Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php on line 108
Number of rows is for You have an error in your SQL syntax near 'FROM wsnlinks_sessions WHERE memberid=1 ' at line 1
Load time so far: 1.43 seconds. Performing query: UPDATE wsnlinks_members SET isonline='1', lastvisit='1147664548' WHERE id=1;
You have an error in your SQL syntax near 'FROM wsnlinks_sessions WHERE memberid=1 ' at line 1
Load time so far: 1.43 seconds. Performing query: INSERT INTO wsnlinks_sessions() VALUES('');
Load time so far: 1.43 seconds. Performing query: DELETE FROM wsnlinks_sessions WHERE memberid=0 AND ip='66.75.140.132';
Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
osiris wrote: Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
This means the mysql table died. Either try to repair it with phpmyadmin's repair function (or a direct REPAIR TABLE wsnlinks_sessions; query) or if that doesn't work ask your web host for help.
Thanks for your help Paul. I contacted my web support and they corrected the db for me. I re-ran the update again and everything is working better now.
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on MySQL error - lost admin access
Member
Usergroup: Customer
Joined: Mar 01, 2003
Location: San Diego
Total Topics: 12
Total Comments: 31
Load time so far: 0.08 seconds.
Performing query: SELECT name,content FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC ;
Number of rows is 251 for Resource id #19
Load time so far: 0.09 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ORDER BY id DESC LIMIT 0,1;
Warning: Cannot modify header information - headers already sent by (output started at /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php:244) in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/prestart.php on line 123
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php on line 29
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php on line 31
Getting field list for table wsnlinks_ratings
Load time so far: 0.1 seconds.
Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 23 for Resource id #30
Load time so far: 0.1 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 4 for Resource id #33
Load time so far: 0.1 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 #34
Load time so far: 0.11 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ;
Load time so far: 0.11 seconds.
Performing query: UPDATE wsnlinks_settings SET content='195' WHERE name='totalsubcats';
Load time so far: 0.11 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 FROM wsnlinks_membergroups WHERE id>0 ;
Load time so far: 0.11 seconds.
Performing query: SELECT id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned FROM wsnlinks_members WHERE id=1 AND validated=1 ;
Load time so far: 0.12 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=273 ;
Load time so far: 0.12 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=21 ;
Load time so far: 0.13 seconds.
Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;
Load time so far: 0.13 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 #42
Load time so far: 0.13 seconds.
Performing query: UNLOCK TABLES;
Load time so far: 0.13 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=1 ;
Load time so far: 0.14 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=2 ;
Load time so far: 0.14 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=26 ;
Load time so far: 0.15 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=5 ;
Load time so far: 0.15 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=110 ;
Load time so far: 0.15 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=22 ;
Load time so far: 0.15 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=29 ;
Load time so far: 0.16 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=18 ;
Load time so far: 0.16 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=4 ;
Load time so far: 0.16 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=6 ;
Load time so far: 0.16 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=181 ;
Load time so far: 0.17 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=32 ;
Load time so far: 0.17 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=8 ;
Load time so far: 0.17 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=7 ;
Load time so far: 0.17 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=157 ;
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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=9 ;
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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=11 ;
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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=28 ;
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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=12 ;
Load time so far: 0.19 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,extratext,banner,bannerurl FROM wsnlinks_categories WHERE id=54 ;
Load time so far: 0.2 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_membergroups WHERE 1=1 ;
Load time so far: 0.2 seconds.
Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=1 ;
Load time so far: 0.2 seconds.
Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=2 ;
Load time so far: 0.2 seconds.
Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=3 ;
Load time so far: 0.21 seconds.
Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=4 ;
Warning: Cannot modify header information - headers already sent by (output started at /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php:244) in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/end.php on line 29
Load time so far: 0.25 seconds.
Performing query: DELETE FROM wsnlinks_sessions WHERE time < 1147586364;
Load time so far: 0.25 seconds.
Performing query: UPDATE wsnlinks_sessions SET starttime='0' WHERE time < 15;
Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Load time so far: 0.25 seconds.
Performing query: UPDATE wsnlinks_sessions SET time='0' WHERE time < 15;
Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Load time so far: 0.25 seconds.
Performing query: SELECT starttime FROM wsnlinks_sessions WHERE memberid=1 ;
Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php on line 82
Number of rows is for Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Load time so far: 0.25 seconds.
Performing query: INSERT INTO wsnlinks_sessions(memberid,ip,location,time,starttime,browser,catid,threadid) VALUES('1','66.75.140.132','http://www.sdrox.com/San_Diego/suggest.php?action=addcat&parent=273&debug=1','1147587264','1147587264','Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7','','');
Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Member
Usergroup: Customer
Joined: Mar 01, 2003
Location: San Diego
Total Topics: 12
Total Comments: 31
I tried upgrading to 3.3.17 but there is still a problem. I ran the debug code from: www.sdrox.com/San_Diego/edi...uals&fieldvalue=21&debug=1
This is the reply:
Load time so far: 0.1 seconds.
Performing query: SELECT name,content FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC ;
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;
Number of rows is 1 for Resource id #20
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php on line 31
Getting field list for table wsnlinks_ratings
Load time so far: 0.14 seconds.
Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 59 for Resource id #36
Load time so far: 0.15 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 4 for Resource id #39
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 #40
Load time so far: 0.15 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 id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,traderrating FROM wsnlinks_members WHERE id=1 AND validated=1 ;
Load time so far: 0.17 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,extratext,banner,bannerurl,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml FROM wsnlinks_categories WHERE validated=1 AND deleted=0 AND hide=0 ;
Number of rows is 195 for Resource id #47
Load time so far: 0.23 seconds.
Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;
Load time so far: 0.23 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.23 seconds.
Performing query: UNLOCK TABLES;
Load time so far: 0.24 seconds.
Performing query: SELECT alias FROM wsnlinks_categories WHERE id=21 ;
Number of rows is 1 for Resource id #53
Load time so far: 0.24 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,extratext,banner,bannerurl,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml FROM wsnlinks_categories WHERE id='21' ;
Number of rows is 1 for Resource id #54
Load time so far: 0.26 seconds.
Performing query: SELECT COUNT(id) FROM wsnlinks_membergroups WHERE 1=1 ;
Count is 4
Load time so far: 0.26 seconds.
Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=1 ;
Load time so far: 0.26 seconds.
Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=2 ;
Load time so far: 0.26 seconds.
Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=3 ;
Load time so far: 0.26 seconds.
Performing query: SELECT title FROM wsnlinks_membergroups WHERE id=4 ;
Load time so far: 0.27 seconds.
Performing query: SELECT parent FROM wsnlinks_categories WHERE alias=21 ORDER BY id ASC ;
Number of rows is 0 for Resource id #62
Load time so far: 0.29 seconds.
Performing query: SELECT parent FROM wsnlinks_categories WHERE alias=21 ;
Number of rows is 0 for Resource id #63
Load time so far: 0.3 seconds.
Performing query: SELECT value FROM wsnlinks_switches WHERE name='ims' ;
Warning: Cannot modify header information - headers already sent by (output started at /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php:276) in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/end.php on line 142
Load time so far: 0.48 seconds.
Performing query: SELECT COUNT(id) FROM wsnlinks_categories WHERE isalbum=0 AND deleted=0 AND moderators LIKE '%, 1[,]%' ;
Count is 0
[SOME CONTENT APPEARS HERE AND THEN MORE DEBUG CODE]
22 total queries
This page was created in 0.88 seconds
Memory used: 7401648 bytes
Load time so far: 1.42 seconds.
Performing query: SELECT inchat,lastchat FROM wsnlinks_sessions WHERE memberid=1 LIMIT 0,1;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php on line 108
Number of rows is for Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Load time so far: 1.43 seconds.
Performing query: SELECT memberid,starttime,time FROM wsnlinks_sessions WHERE time < 1147663648 AND memberid > 0 ;
Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php on line 108
Number of rows is for Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Load time so far: 1.43 seconds.
Performing query: DELETE FROM wsnlinks_sessions WHERE time < 1147663648;
Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Load time so far: 1.43 seconds.
Performing query: SELECT FROM wsnlinks_sessions WHERE memberid=1 ;
Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/sdrox.com/httpdocs/San_Diego/classes/database.php on line 108
Number of rows is for You have an error in your SQL syntax near 'FROM wsnlinks_sessions WHERE memberid=1 ' at line 1
Load time so far: 1.43 seconds.
Performing query: UPDATE wsnlinks_members SET isonline='1', lastvisit='1147664548' WHERE id=1;
You have an error in your SQL syntax near 'FROM wsnlinks_sessions WHERE memberid=1 ' at line 1
Load time so far: 1.43 seconds.
Performing query: INSERT INTO wsnlinks_sessions() VALUES('');
Load time so far: 1.43 seconds.
Performing query: DELETE FROM wsnlinks_sessions WHERE memberid=0 AND ip='66.75.140.132';
Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
closing database connection
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Can't open file: 'wsnlinks_sessions.MYD'. (errno: 145)
This means the mysql table died. Either try to repair it with phpmyadmin's repair function (or a direct REPAIR TABLE wsnlinks_sessions; query) or if that doesn't work ask your web host for help.
Member
Usergroup: Customer
Joined: Mar 01, 2003
Location: San Diego
Total Topics: 12
Total Comments: 31
Thanks for your help Paul. I contacted my web support and they corrected the db for me. I re-ran the update again and everything is working better now.