Webmastersite.net
Register Log In

MySQL error - lost admin access

Title MySQL error - lost admin access
Description MySQL error - lost admin access
Message Text 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)
Rating
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5
0/5 based on 0 votes.
Ownership osirs
Views 782 views. Averaging 0 views per day.
Similar Topics
Submission Date May 14, 2006 - 1:28 AM