Ones I have that you don't: xmlwriter, libxml, dom, xmlreader, SimpleXML, SPL, SQLite, Reflection, mysqli, mcrypt, json, hash, filter, date
But I doubt they're important. Only a compression-related library might be involved in the autoupgrade, and there are none there in the list. Anyhow, again, the probably would probably take 15 minutes to identify if you let me and will almost certainly never be identified by abstract hands-off theorizing.
I have to say that mrkarron got my hopes up and I tried to do a manual upgrade to version 4.1.28 but alas I ended up with the same, yet slightly different, problem. I followed the manual upgrade instructions and ran upgrade.php and when I did, I got the same error message. However, when I returned to the admin control panel, the overview page says "Your WSN Links 4.1.28 is up to date." How is it possible that my upgrade could fail and yet succeed at the same time.
I am thoroughly confused and frustrated by this problem. I am concerned that I will not be able to upgrade to the next version and the problem will just repeat itself. I am going to go fill out your inspection form now. I hope that you find whatever it is quickly.
Here is the debug run via upgrade.php for what it's worth:
Load time so far: 0.03 seconds.
Query 1: SELECT `name`,`content` FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC
Number of rows is 473
Load time so far: 0.12 seconds.
Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0
Number of rows is 93
Query 3: SHOW COLUMNS FROM wsnlinks_links
Getting field list for table wsnlinks_links: 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,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime,tags,xmlsource,ordercomments,lastpadupdate,padfile,lastmonthlycheck,invisibleto,profileurl,lastprofileurl,timesrenewed,timedeleted
Load time so far: 0.13 seconds.
Query 4: SHOW COLUMNS FROM wsnlinks_categories
Getting field list for table wsnlinks_categories: 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,linksperpage,wysihtml,numonline,sponsorship,lastprofileurl,defaultnoaccess,lastthreadurl,lastposturl
Load time so far: 0.13 seconds.
Query 5: SHOW COLUMNS FROM wsnlinks_members
Getting field list for table wsnlinks_members: 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,invitessent,validatedemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader
Load time so far: 0.13 seconds.
Query 6: SHOW COLUMNS FROM wsnlinks_membergroups
Getting field list for table wsnlinks_membergroups: 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,numinv,allowugspec,validateemails,validatesponsorlinks,cansubmittags,candeletetags,cansubmitfeeds,validatefeeds,validatefeeditems,numaliasestot,shoutsperday,validatetrader,renewdays,renewtimes,canviewownfulltrc,canviewallfulltrc
Load time so far: 0.14 seconds.
Query 7: SHOW COLUMNS FROM wsnlinks_email
Getting field list for table wsnlinks_email: id,to,subject,message,headers,timesent,ip,replacement,mime
Load time so far: 0.14 seconds.
Query 8: SHOW COLUMNS FROM wsnlinks_sessions
Getting field list for table wsnlinks_sessions: id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility,profileurl
Load time so far: 0.14 seconds.
Query 9: SHOW COLUMNS FROM wsnlinks_ratings
Getting field list for table wsnlinks_ratings: id,votevalue,time,memberid,ip,custom,linkid,type
Load time so far: 0.14 seconds.
Query 10: SHOW COLUMNS FROM wsnlinks_markup
Getting field list for table wsnlinks_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder
Load time so far: 0.14 seconds.
Query 11: SHOW COLUMNS FROM wsnlinks_modlog
Getting field list for table wsnlinks_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid
Load time so far: 0.14 seconds.
Query 12: SHOW COLUMNS FROM wsnlinks_crons
Getting field list for table wsnlinks_crons: id,frequency,nextrun,filename,native
Load time so far: 0.14 seconds.
Query 13: SHOW COLUMNS FROM wsnlinks_tags
Getting field list for table wsnlinks_tags: id,name,uses,link,ownerid,ownerip
Load time so far: 0.14 seconds.
Query 14: SHOW COLUMNS FROM wsnlinks_xmlfeeds
Getting field list for table wsnlinks_xmlfeeds: id,url,ownerid,lastfetched,validated,catid,time,title,description,homepage
Load time so far: 0.14 seconds.
Query 15: SHOW COLUMNS FROM wsnlinks_calendar
Getting field list for table wsnlinks_calendar: id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time
Load time so far: 0.14 seconds.
Query 16: SHOW COLUMNS FROM wsnlinks_helpcategory
Getting field list for table wsnlinks_helpcategory: id,name,numsubjects,priority
Load time so far: 0.14 seconds.
Query 17: SHOW COLUMNS FROM wsnlinks_helpitem
Getting field list for table wsnlinks_helpitem: id,subject,helptext,priority,category
Load time so far: 0.14 seconds.
Query 18: SHOW COLUMNS FROM wsnlinks_shouts
Getting field list for table wsnlinks_shouts: id,ownerid,time,deleted,message,name,ip
Load time so far: 0.14 seconds.
Query 19: SHOW COLUMNS FROM wsnlinks_quotes
Getting field list for table wsnlinks_quotes: content,author,id,source,ownerid,ownername,validated
Load time so far: 0.14 seconds.
Query 20: SHOW COLUMNS FROM wsnlinks_chat
Getting field list for table wsnlinks_chat: id,name,message,time,ownerid
Load time so far: 0.14 seconds.
Query 21: SHOW COLUMNS FROM wsnlinks_im
Getting field list for table wsnlinks_im: id,toid,fromid,message,time,isread,timeread,deleted
Load time so far: 0.14 seconds.
Query 22: SHOW COLUMNS FROM wsnlinks_searches
Getting field list for table wsnlinks_searches: id,value,memberid,catid,time
Load time so far: 0.14 seconds.
Query 23: SHOW COLUMNS FROM wsnlinks_comments
Getting field list for table wsnlinks_comments: id,linkid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised,internalto,hasinternal,invisibleto,hostname
Load time so far: 0.14 seconds.
Query 24: SHOW COLUMNS FROM wsnlinks_pm
Getting field list for table wsnlinks_pm: id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,flag,filefield,important,replyto,replied,sentdeleted,wysihtml,cc
Load time so far: 0.14 seconds.
Query 25: SHOW COLUMNS FROM wsnlinks_payments
Getting field list for table wsnlinks_payments: id,linkid,memberid,price,email,type,time
Load time so far: 0.14 seconds.
Query 26: SHOW COLUMNS FROM wsnlinks_attachments
Getting field list for table wsnlinks_attachments: id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid,importurl
Load time so far: 0.14 seconds.
Query 27: SHOW COLUMNS FROM wsnlinks_trader
Getting field list for table wsnlinks_trader: id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments,validated,response
Load time so far: 0.15 seconds.
Query 28: SHOW COLUMNS FROM wsnlinks_invites
Getting field list for table wsnlinks_invites: id,inviter,invitee,time,usergroup,taken,code
Load time so far: 0.15 seconds.
Query 29: SHOW COLUMNS FROM wsnlinks_reports
Getting field list for table wsnlinks_reports: id,type,objectid,reporter,action,time,moderator,discussionthread,reason,forumid,parentids,topicid,offender
Load time so far: 0.15 seconds.
Query 30: SHOW COLUMNS FROM wsnlinks_polls
Getting field list for table wsnlinks_polls: id,topicid,catid,question,options,time,endtime,deleted,multi,public,totals
Load time so far: 0.15 seconds.
Query 31: SHOW COLUMNS FROM wsnlinks_pollvotes
Getting field list for table wsnlinks_pollvotes: id,pollid,vote,memberid,ip,deleted,membername,time
Load time so far: 0.15 seconds.
Query 32: SHOW COLUMNS FROM wsnlinks_zipcodes
Getting field list for table wsnlinks_zipcodes: id,zip,lat,lon,city,state,country
Load time so far: 0.15 seconds.
Load time so far: 0.15 seconds.
Query 33: UPDATE wsnlinks_settings SET content='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,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime,tags,xmlsource,ordercomments,lastpadupdate,padfile,lastmonthlycheck,invisibleto,profileurl,lastprofileurl,timesrenewed,timedeleted' WHERE name='linkfields'
Load time so far: 0.15 seconds.
Query 34: UPDATE wsnlinks_settings SET content='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,linksperpage,wysihtml,numonline,sponsorship,lastprofileurl,defaultnoaccess,lastthreadurl,lastposturl' WHERE name='categoryfields'
Load time so far: 0.15 seconds.
Query 35: UPDATE wsnlinks_settings SET content='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,invitessent,validatedemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader' WHERE name='memberfields'
Load time so far: 0.15 seconds.
Query 36: UPDATE wsnlinks_settings SET content='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,numinv,allowugspec,validateemails,validatesponsorlinks,cansubmittags,candeletetags,cansubmitfeeds,validatefeeds,validatefeeditems,numaliasestot,shoutsperday,validatetrader,renewdays,renewtimes,canviewownfulltrc,canviewallfulltrc' WHERE name='usergroupfields'
Load time so far: 0.24 seconds.
Query 37: UPDATE wsnlinks_settings SET content='id,to,subject,message,headers,timesent,ip,replacement,mime' WHERE name='emailfields'
Load time so far: 0.24 seconds.
Query 38: UPDATE wsnlinks_settings SET content='id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility,profileurl' WHERE name='sessionfields'
Load time so far: 0.24 seconds.
Query 39: UPDATE wsnlinks_settings SET content='id,votevalue,time,memberid,ip,custom,linkid,type' WHERE name='ratingfields'
Load time so far: 0.25 seconds.
Query 40: UPDATE wsnlinks_settings SET content='id,type,original,replacement,description,originalclose,replacementclose,sortorder' WHERE name='markupfields'
Load time so far: 0.25 seconds.
Query 41: UPDATE wsnlinks_settings SET content='id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid' WHERE name='modfields'
Load time so far: 0.25 seconds.
Query 42: UPDATE wsnlinks_settings SET content='id,frequency,nextrun,filename,native' WHERE name='cronfields'
Load time so far: 0.25 seconds.
Query 43: UPDATE wsnlinks_settings SET content='id,name,uses,link,ownerid,ownerip' WHERE name='tagfields'
Load time so far: 0.25 seconds.
Query 44: UPDATE wsnlinks_settings SET content='id,url,ownerid,lastfetched,validated,catid,time,title,description,homepage' WHERE name='feedfields'
Load time so far: 0.25 seconds.
Query 45: UPDATE wsnlinks_settings SET content='id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time' WHERE name='calfields'
Load time so far: 0.26 seconds.
Query 46: UPDATE wsnlinks_settings SET content='id,name,numsubjects,priority' WHERE name='helpcatfields'
Load time so far: 0.26 seconds.
Query 47: UPDATE wsnlinks_settings SET content='id,subject,helptext,priority,category' WHERE name='helpitemfields'
Load time so far: 0.26 seconds.
Query 48: UPDATE wsnlinks_settings SET content='id,ownerid,time,deleted,message,name,ip' WHERE name='shoutfields'
Load time so far: 0.26 seconds.
Query 49: UPDATE wsnlinks_settings SET content='content,author,id,source,ownerid,ownername,validated' WHERE name='quotefields'
Load time so far: 0.26 seconds.
Query 50: UPDATE wsnlinks_settings SET content='id,name,message,time,ownerid' WHERE name='chatfields'
Load time so far: 0.27 seconds.
Query 51: UPDATE wsnlinks_settings SET content='id,toid,fromid,message,time,isread,timeread,deleted' WHERE name='imfields'
Load time so far: 0.27 seconds.
Query 52: UPDATE wsnlinks_settings SET content='id,value,memberid,catid,time' WHERE name='searchtablefields'
Load time so far: 0.27 seconds.
Query 53: UPDATE wsnlinks_settings SET content='id,linkid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised,internalto,hasinternal,invisibleto,hostname' WHERE name='commentfields'
Load time so far: 0.27 seconds.
Query 54: UPDATE wsnlinks_settings SET content='id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,flag,filefield,important,replyto,replied,sentdeleted,wysihtml,cc' WHERE name='pmfields'
Load time so far: 0.27 seconds.
Query 55: UPDATE wsnlinks_settings SET content='id,linkid,memberid,price,email,type,time' WHERE name='paymentfields'
Load time so far: 0.27 seconds.
Query 56: UPDATE wsnlinks_settings SET content='id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid,importurl' WHERE name='attachmentfields'
Load time so far: 0.28 seconds.
Query 57: UPDATE wsnlinks_settings SET content='id,topicid,catid,question,options,time,endtime,deleted,multi,public,totals' WHERE name='pollfields'
Load time so far: 0.28 seconds.
Query 58: UPDATE wsnlinks_settings SET content='id,pollid,vote,memberid,ip,deleted,membername,time' WHERE name='pollvotefields'
Load time so far: 0.28 seconds.
Query 59: UPDATE wsnlinks_settings SET content='id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments,validated,response' WHERE name='traderfields'
Load time so far: 0.28 seconds.
Query 60: UPDATE wsnlinks_settings SET content='id,zip,lat,lon,city,state,country' WHERE name='zipcodefields'
Load time so far: 0.29 seconds.
Query 61: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 23
Load time so far: 0.3 seconds.
Query 62: 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`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansubmitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot`,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes`,`canviewownfulltrc`,`canviewallfulltrc` FROM wsnlinks_membergroups WHERE id>0
Load time so far: 0.3 seconds.
Query 63: 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`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader` FROM wsnlinks_members WHERE id='1' AND validated=1
Access denied for user: 'dbuser@localhost' to database 'dbname'
Query 65: 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
Query 66: UNLOCK TABLES
Query 67: SHOW COLUMNS FROM wsnlinks_links
Getting field list for table wsnlinks_links: 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,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime,tags,xmlsource,ordercomments,lastpadupdate,padfile,lastmonthlycheck,invisibleto,profileurl,lastprofileurl,timesrenewed,timedeleted
Load time so far: 0.37 seconds.
Query 68: SHOW COLUMNS FROM wsnlinks_categories
Getting field list for table wsnlinks_categories: 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,linksperpage,wysihtml,numonline,sponsorship,lastprofileurl,defaultnoaccess,lastthreadurl,lastposturl
Load time so far: 0.37 seconds.
Query 69: SHOW COLUMNS FROM wsnlinks_members
Getting field list for table wsnlinks_members: 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,invitessent,validatedemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader
Load time so far: 0.37 seconds.
Query 70: SHOW COLUMNS FROM wsnlinks_membergroups
Getting field list for table wsnlinks_membergroups: 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,numinv,allowugspec,validateemails,validatesponsorlinks,cansubmittags,candeletetags,cansubmitfeeds,validatefeeds,validatefeeditems,numaliasestot,shoutsperday,validatetrader,renewdays,renewtimes,canviewownfulltrc,canviewallfulltrc
Load time so far: 0.38 seconds.
Query 71: SHOW COLUMNS FROM wsnlinks_email
Getting field list for table wsnlinks_email: id,to,subject,message,headers,timesent,ip,replacement,mime
Load time so far: 0.38 seconds.
Query 72: SHOW COLUMNS FROM wsnlinks_sessions
Getting field list for table wsnlinks_sessions: id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility,profileurl
Load time so far: 0.38 seconds.
Query 73: SHOW COLUMNS FROM wsnlinks_ratings
Getting field list for table wsnlinks_ratings: id,votevalue,time,memberid,ip,custom,linkid,type
Load time so far: 0.38 seconds.
Query 74: SHOW COLUMNS FROM wsnlinks_markup
Getting field list for table wsnlinks_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder
Load time so far: 0.38 seconds.
Query 75: SHOW COLUMNS FROM wsnlinks_modlog
Getting field list for table wsnlinks_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid
Load time so far: 0.38 seconds.
Query 76: SHOW COLUMNS FROM wsnlinks_crons
Getting field list for table wsnlinks_crons: id,frequency,nextrun,filename,native
Load time so far: 0.38 seconds.
Query 77: SHOW COLUMNS FROM wsnlinks_tags
Getting field list for table wsnlinks_tags: id,name,uses,link,ownerid,ownerip
Load time so far: 0.38 seconds.
Query 78: SHOW COLUMNS FROM wsnlinks_xmlfeeds
Getting field list for table wsnlinks_xmlfeeds: id,url,ownerid,lastfetched,validated,catid,time,title,description,homepage
Load time so far: 0.38 seconds.
Query 79: SHOW COLUMNS FROM wsnlinks_calendar
Getting field list for table wsnlinks_calendar: id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time
Load time so far: 0.38 seconds.
Query 80: SHOW COLUMNS FROM wsnlinks_helpcategory
Getting field list for table wsnlinks_helpcategory: id,name,numsubjects,priority
Load time so far: 0.38 seconds.
Query 81: SHOW COLUMNS FROM wsnlinks_helpitem
Getting field list for table wsnlinks_helpitem: id,subject,helptext,priority,category
Load time so far: 0.38 seconds.
Query 82: SHOW COLUMNS FROM wsnlinks_shouts
Getting field list for table wsnlinks_shouts: id,ownerid,time,deleted,message,name,ip
Load time so far: 0.38 seconds.
Query 83: SHOW COLUMNS FROM wsnlinks_quotes
Getting field list for table wsnlinks_quotes: content,author,id,source,ownerid,ownername,validated
Load time so far: 0.38 seconds.
Query 84: SHOW COLUMNS FROM wsnlinks_chat
Getting field list for table wsnlinks_chat: id,name,message,time,ownerid
Load time so far: 0.38 seconds.
Query 85: SHOW COLUMNS FROM wsnlinks_im
Getting field list for table wsnlinks_im: id,toid,fromid,message,time,isread,timeread,deleted
Load time so far: 0.38 seconds.
Query 86: SHOW COLUMNS FROM wsnlinks_searches
Getting field list for table wsnlinks_searches: id,value,memberid,catid,time
Load time so far: 0.38 seconds.
Query 87: SHOW COLUMNS FROM wsnlinks_comments
Getting field list for table wsnlinks_comments: id,linkid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised,internalto,hasinternal,invisibleto,hostname
Load time so far: 0.38 seconds.
Query 88: SHOW COLUMNS FROM wsnlinks_pm
Getting field list for table wsnlinks_pm: id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,flag,filefield,important,replyto,replied,sentdeleted,wysihtml,cc
Load time so far: 0.38 seconds.
Query 89: SHOW COLUMNS FROM wsnlinks_payments
Getting field list for table wsnlinks_payments: id,linkid,memberid,price,email,type,time
Load time so far: 0.39 seconds.
Query 90: SHOW COLUMNS FROM wsnlinks_attachments
Getting field list for table wsnlinks_attachments: id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid,importurl
Load time so far: 0.39 seconds.
Query 91: SHOW COLUMNS FROM wsnlinks_trader
Getting field list for table wsnlinks_trader: id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments,validated,response
Load time so far: 0.39 seconds.
Query 92: SHOW COLUMNS FROM wsnlinks_invites
Getting field list for table wsnlinks_invites: id,inviter,invitee,time,usergroup,taken,code
Load time so far: 0.39 seconds.
Query 93: SHOW COLUMNS FROM wsnlinks_reports
Getting field list for table wsnlinks_reports: id,type,objectid,reporter,action,time,moderator,discussionthread,reason,forumid,parentids,topicid,offender
Load time so far: 0.39 seconds.
Query 94: SHOW COLUMNS FROM wsnlinks_polls
Getting field list for table wsnlinks_polls: id,topicid,catid,question,options,time,endtime,deleted,multi,public,totals
Load time so far: 0.39 seconds.
Query 95: SHOW COLUMNS FROM wsnlinks_pollvotes
Getting field list for table wsnlinks_pollvotes: id,pollid,vote,memberid,ip,deleted,membername,time
Load time so far: 0.39 seconds.
Query 96: SHOW COLUMNS FROM wsnlinks_zipcodes
Getting field list for table wsnlinks_zipcodes: id,zip,lat,lon,city,state,country
Load time so far: 0.39 seconds.
Load time so far: 0.39 seconds.
Query 97: UPDATE wsnlinks_settings SET content='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,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime,tags,xmlsource,ordercomments,lastpadupdate,padfile,lastmonthlycheck,invisibleto,profileurl,lastprofileurl,timesrenewed,timedeleted' WHERE name='linkfields'
Load time so far: 0.39 seconds.
Query 98: UPDATE wsnlinks_settings SET content='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,linksperpage,wysihtml,numonline,sponsorship,lastprofileurl,defaultnoaccess,lastthreadurl,lastposturl' WHERE name='categoryfields'
Load time so far: 0.39 seconds.
Query 99: UPDATE wsnlinks_settings SET content='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,invitessent,validatedemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader' WHERE name='memberfields'
Load time so far: 0.39 seconds.
Query 100: UPDATE wsnlinks_settings SET content='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,numinv,allowugspec,validateemails,validatesponsorlinks,cansubmittags,candeletetags,cansubmitfeeds,validatefeeds,validatefeeditems,numaliasestot,shoutsperday,validatetrader,renewdays,renewtimes,canviewownfulltrc,canviewallfulltrc' WHERE name='usergroupfields'
Load time so far: 0.4 seconds.
Query 101: UPDATE wsnlinks_settings SET content='id,to,subject,message,headers,timesent,ip,replacement,mime' WHERE name='emailfields'
Load time so far: 0.4 seconds.
Query 102: UPDATE wsnlinks_settings SET content='id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility,profileurl' WHERE name='sessionfields'
Load time so far: 0.4 seconds.
Query 103: UPDATE wsnlinks_settings SET content='id,votevalue,time,memberid,ip,custom,linkid,type' WHERE name='ratingfields'
Load time so far: 0.4 seconds.
Query 104: UPDATE wsnlinks_settings SET content='id,type,original,replacement,description,originalclose,replacementclose,sortorder' WHERE name='markupfields'
Load time so far: 0.4 seconds.
Query 105: UPDATE wsnlinks_settings SET content='id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid' WHERE name='modfields'
Load time so far: 0.4 seconds.
Query 106: UPDATE wsnlinks_settings SET content='id,frequency,nextrun,filename,native' WHERE name='cronfields'
Load time so far: 0.41 seconds.
Query 107: UPDATE wsnlinks_settings SET content='id,name,uses,link,ownerid,ownerip' WHERE name='tagfields'
Load time so far: 0.41 seconds.
Query 108: UPDATE wsnlinks_settings SET content='id,url,ownerid,lastfetched,validated,catid,time,title,description,homepage' WHERE name='feedfields'
Load time so far: 0.41 seconds.
Query 109: UPDATE wsnlinks_settings SET content='id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time' WHERE name='calfields'
Load time so far: 0.41 seconds.
Query 110: UPDATE wsnlinks_settings SET content='id,name,numsubjects,priority' WHERE name='helpcatfields'
Load time so far: 0.41 seconds.
Query 111: UPDATE wsnlinks_settings SET content='id,subject,helptext,priority,category' WHERE name='helpitemfields'
Load time so far: 0.41 seconds.
Query 112: UPDATE wsnlinks_settings SET content='id,ownerid,time,deleted,message,name,ip' WHERE name='shoutfields'
Load time so far: 0.42 seconds.
Query 113: UPDATE wsnlinks_settings SET content='content,author,id,source,ownerid,ownername,validated' WHERE name='quotefields'
Load time so far: 0.42 seconds.
Query 114: UPDATE wsnlinks_settings SET content='id,name,message,time,ownerid' WHERE name='chatfields'
Load time so far: 0.42 seconds.
Query 115: UPDATE wsnlinks_settings SET content='id,toid,fromid,message,time,isread,timeread,deleted' WHERE name='imfields'
Load time so far: 0.42 seconds.
Query 116: UPDATE wsnlinks_settings SET content='id,value,memberid,catid,time' WHERE name='searchtablefields'
Load time so far: 0.42 seconds.
Query 117: UPDATE wsnlinks_settings SET content='id,linkid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised,internalto,hasinternal,invisibleto,hostname' WHERE name='commentfields'
Load time so far: 0.42 seconds.
Query 118: UPDATE wsnlinks_settings SET content='id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,flag,filefield,important,replyto,replied,sentdeleted,wysihtml,cc' WHERE name='pmfields'
Load time so far: 0.43 seconds.
Query 119: UPDATE wsnlinks_settings SET content='id,linkid,memberid,price,email,type,time' WHERE name='paymentfields'
Load time so far: 0.43 seconds.
Query 120: UPDATE wsnlinks_settings SET content='id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid,importurl' WHERE name='attachmentfields'
Load time so far: 0.43 seconds.
Query 121: UPDATE wsnlinks_settings SET content='id,topicid,catid,question,options,time,endtime,deleted,multi,public,totals' WHERE name='pollfields'
Load time so far: 0.43 seconds.
Query 122: UPDATE wsnlinks_settings SET content='id,pollid,vote,memberid,ip,deleted,membername,time' WHERE name='pollvotefields'
Load time so far: 0.43 seconds.
Query 123: UPDATE wsnlinks_settings SET content='id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments,validated,response' WHERE name='traderfields'
Load time so far: 0.43 seconds.
Query 124: UPDATE wsnlinks_settings SET content='id,zip,lat,lon,city,state,country' WHERE name='zipcodefields'
Load time so far: 0.45 seconds.
Query 125: UPDATE wsnlinks_members SET banned = '' WHERE banned = '0'
Load time so far: 0.45 seconds.
Query 126: UPDATE wsnlinks_switches SET value='0' WHERE name='chat'
Load time so far: 0.47 seconds.
Query 127: SELECT `name` FROM wsnlinks_switches WHERE id>0
Number of rows is 93
Load time so far: 0.48 seconds.
Query 128: UPDATE wsnlinks_membergroups SET renewtimes='0' WHERE renewtimes = '' OR renewtimes = NULL
Load time so far: 0.48 seconds.
Query 129: SELECT `name`,`content` FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC
Number of rows is 473
Unable to create directory './temp/wsnlinks/admin/'Unable to create path for ./temp/wsnlinks/admin/Unable to create directory './temp/wsnlinks/admin/'Unable to create path for ./temp/wsnlinks/admin/Couldn't extract!
Access denied for user: 'dbuser@localhost' to database 'dbname'
Now, I changed the real database user and name for my own peace of mind. I have no problems connecting to the database to add links, make changes so I'm obviously connected to it. I also confirmed that the config.php has the information listed correctly. Like I said, I don't know if this tidbit matters or not but I'm throwing it out there just in case!
That message doesn't follow a mysql warning, so it's just the last error on the server being echoed meaninglessly. If it were actually unable to access the database then none of those other queries would be working as it says they are.
As I said in the email, your problem is that your web host is broken.
Comments on unable to auto upgrade
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
A missing extension would be a more likely issue... looks like I have
Apache/2.2.4 (Ubuntu) PHP/5.2.3-1ubuntu6.3
PHP 5.2.3-1ubuntu6.3 with zend engine 2.2.0
Loaded PHP Extensions: zip, xmlwriter, libxml, dom, xmlreader, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, session, pcre, SimpleXML, sockets, soap, SPL, shmop, standard, Reflection, posix, mime_magic, mbstring, json, iconv, hash, gettext, ftp, filter, exif, dba, date, ctype, calendar, bz2, bcmath, zlib, openssl, apache2handler, gd, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, SQLite, xmlrpc
on localhost and
Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4
PHP 5.2.5 with zend engine 2.2.0
Loaded PHP Extensions: xmlwriter, libxml, dom, xmlreader, xml, tokenizer, session, pcre, SimpleXML, SPL, sockets, SQLite, standard, Reflection, pspell, posix, mysqli, mysql, mcrypt, json, imap, iconv, hash, gd, ftp, filter, date, curl, ctype, calendar, bcmath, zlib, cgi, Zend Optimizer
on my server.
Ones I have that you don't:
xmlwriter, libxml, dom, xmlreader, SimpleXML, SPL, SQLite, Reflection, mysqli, mcrypt, json, hash, filter, date
But I doubt they're important. Only a compression-related library might be involved in the autoupgrade, and there are none there in the list. Anyhow, again, the probably would probably take 15 minutes to identify if you let me and will almost certainly never be identified by abstract hands-off theorizing.
Experienced
Usergroup: Customer
Joined: Oct 02, 2003
Total Topics: 33
Total Comments: 97
Interesting note: the upgrade to 4.1.28 worked without any problems on all sites and on all servers. Keeping fingers crossed for future updates..
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
I have to say that mrkarron got my hopes up and I tried to do a manual upgrade to version 4.1.28 but alas I ended up with the same, yet slightly different, problem. I followed the manual upgrade instructions and ran upgrade.php and when I did, I got the same error message. However, when I returned to the admin control panel, the overview page says "Your WSN Links 4.1.28 is up to date." How is it possible that my upgrade could fail and yet succeed at the same time.
I am thoroughly confused and frustrated by this problem. I am concerned that I will not be able to upgrade to the next version and the problem will just repeat itself. I am going to go fill out your inspection form now. I hope that you find whatever it is quickly.
Here is the debug run via upgrade.php for what it's worth:
Load time so far: 0.03 seconds.
Query 1: SELECT `name`,`content` FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC
Number of rows is 473
Load time so far: 0.12 seconds.
Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0
Number of rows is 93
Query 3: SHOW COLUMNS FROM wsnlinks_links
Getting field list for table wsnlinks_links: 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,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime,tags,xmlsource,ordercomments,lastpadupdate,padfile,lastmonthlycheck,invisibleto,profileurl,lastprofileurl,timesrenewed,timedeleted
Load time so far: 0.13 seconds.
Query 4: SHOW COLUMNS FROM wsnlinks_categories
Getting field list for table wsnlinks_categories: 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,linksperpage,wysihtml,numonline,sponsorship,lastprofileurl,defaultnoaccess,lastthreadurl,lastposturl
Load time so far: 0.13 seconds.
Query 5: SHOW COLUMNS FROM wsnlinks_members
Getting field list for table wsnlinks_members: 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,invitessent,validatedemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader
Load time so far: 0.13 seconds.
Query 6: SHOW COLUMNS FROM wsnlinks_membergroups
Getting field list for table wsnlinks_membergroups: 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,numinv,allowugspec,validateemails,validatesponsorlinks,cansubmittags,candeletetags,cansubmitfeeds,validatefeeds,validatefeeditems,numaliasestot,shoutsperday,validatetrader,renewdays,renewtimes,canviewownfulltrc,canviewallfulltrc
Load time so far: 0.14 seconds.
Query 7: SHOW COLUMNS FROM wsnlinks_email
Getting field list for table wsnlinks_email: id,to,subject,message,headers,timesent,ip,replacement,mime
Load time so far: 0.14 seconds.
Query 8: SHOW COLUMNS FROM wsnlinks_sessions
Getting field list for table wsnlinks_sessions: id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility,profileurl
Load time so far: 0.14 seconds.
Query 9: SHOW COLUMNS FROM wsnlinks_ratings
Getting field list for table wsnlinks_ratings: id,votevalue,time,memberid,ip,custom,linkid,type
Load time so far: 0.14 seconds.
Query 10: SHOW COLUMNS FROM wsnlinks_markup
Getting field list for table wsnlinks_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder
Load time so far: 0.14 seconds.
Query 11: SHOW COLUMNS FROM wsnlinks_modlog
Getting field list for table wsnlinks_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid
Load time so far: 0.14 seconds.
Query 12: SHOW COLUMNS FROM wsnlinks_crons
Getting field list for table wsnlinks_crons: id,frequency,nextrun,filename,native
Load time so far: 0.14 seconds.
Query 13: SHOW COLUMNS FROM wsnlinks_tags
Getting field list for table wsnlinks_tags: id,name,uses,link,ownerid,ownerip
Load time so far: 0.14 seconds.
Query 14: SHOW COLUMNS FROM wsnlinks_xmlfeeds
Getting field list for table wsnlinks_xmlfeeds: id,url,ownerid,lastfetched,validated,catid,time,title,description,homepage
Load time so far: 0.14 seconds.
Query 15: SHOW COLUMNS FROM wsnlinks_calendar
Getting field list for table wsnlinks_calendar: id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time
Load time so far: 0.14 seconds.
Query 16: SHOW COLUMNS FROM wsnlinks_helpcategory
Getting field list for table wsnlinks_helpcategory: id,name,numsubjects,priority
Load time so far: 0.14 seconds.
Query 17: SHOW COLUMNS FROM wsnlinks_helpitem
Getting field list for table wsnlinks_helpitem: id,subject,helptext,priority,category
Load time so far: 0.14 seconds.
Query 18: SHOW COLUMNS FROM wsnlinks_shouts
Getting field list for table wsnlinks_shouts: id,ownerid,time,deleted,message,name,ip
Load time so far: 0.14 seconds.
Query 19: SHOW COLUMNS FROM wsnlinks_quotes
Getting field list for table wsnlinks_quotes: content,author,id,source,ownerid,ownername,validated
Load time so far: 0.14 seconds.
Query 20: SHOW COLUMNS FROM wsnlinks_chat
Getting field list for table wsnlinks_chat: id,name,message,time,ownerid
Load time so far: 0.14 seconds.
Query 21: SHOW COLUMNS FROM wsnlinks_im
Getting field list for table wsnlinks_im: id,toid,fromid,message,time,isread,timeread,deleted
Load time so far: 0.14 seconds.
Query 22: SHOW COLUMNS FROM wsnlinks_searches
Getting field list for table wsnlinks_searches: id,value,memberid,catid,time
Load time so far: 0.14 seconds.
Query 23: SHOW COLUMNS FROM wsnlinks_comments
Getting field list for table wsnlinks_comments: id,linkid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised,internalto,hasinternal,invisibleto,hostname
Load time so far: 0.14 seconds.
Query 24: SHOW COLUMNS FROM wsnlinks_pm
Getting field list for table wsnlinks_pm: id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,flag,filefield,important,replyto,replied,sentdeleted,wysihtml,cc
Load time so far: 0.14 seconds.
Query 25: SHOW COLUMNS FROM wsnlinks_payments
Getting field list for table wsnlinks_payments: id,linkid,memberid,price,email,type,time
Load time so far: 0.14 seconds.
Query 26: SHOW COLUMNS FROM wsnlinks_attachments
Getting field list for table wsnlinks_attachments: id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid,importurl
Load time so far: 0.14 seconds.
Query 27: SHOW COLUMNS FROM wsnlinks_trader
Getting field list for table wsnlinks_trader: id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments,validated,response
Load time so far: 0.15 seconds.
Query 28: SHOW COLUMNS FROM wsnlinks_invites
Getting field list for table wsnlinks_invites: id,inviter,invitee,time,usergroup,taken,code
Load time so far: 0.15 seconds.
Query 29: SHOW COLUMNS FROM wsnlinks_reports
Getting field list for table wsnlinks_reports: id,type,objectid,reporter,action,time,moderator,discussionthread,reason,forumid,parentids,topicid,offender
Load time so far: 0.15 seconds.
Query 30: SHOW COLUMNS FROM wsnlinks_polls
Getting field list for table wsnlinks_polls: id,topicid,catid,question,options,time,endtime,deleted,multi,public,totals
Load time so far: 0.15 seconds.
Query 31: SHOW COLUMNS FROM wsnlinks_pollvotes
Getting field list for table wsnlinks_pollvotes: id,pollid,vote,memberid,ip,deleted,membername,time
Load time so far: 0.15 seconds.
Query 32: SHOW COLUMNS FROM wsnlinks_zipcodes
Getting field list for table wsnlinks_zipcodes: id,zip,lat,lon,city,state,country
Load time so far: 0.15 seconds.
Load time so far: 0.15 seconds.
Query 33: UPDATE wsnlinks_settings SET content='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,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime,tags,xmlsource,ordercomments,lastpadupdate,padfile,lastmonthlycheck,invisibleto,profileurl,lastprofileurl,timesrenewed,timedeleted' WHERE name='linkfields'
Load time so far: 0.15 seconds.
Query 34: UPDATE wsnlinks_settings SET content='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,linksperpage,wysihtml,numonline,sponsorship,lastprofileurl,defaultnoaccess,lastthreadurl,lastposturl' WHERE name='categoryfields'
Load time so far: 0.15 seconds.
Query 35: UPDATE wsnlinks_settings SET content='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,invitessent,validatedemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader' WHERE name='memberfields'
Load time so far: 0.15 seconds.
Query 36: UPDATE wsnlinks_settings SET content='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,numinv,allowugspec,validateemails,validatesponsorlinks,cansubmittags,candeletetags,cansubmitfeeds,validatefeeds,validatefeeditems,numaliasestot,shoutsperday,validatetrader,renewdays,renewtimes,canviewownfulltrc,canviewallfulltrc' WHERE name='usergroupfields'
Load time so far: 0.24 seconds.
Query 37: UPDATE wsnlinks_settings SET content='id,to,subject,message,headers,timesent,ip,replacement,mime' WHERE name='emailfields'
Load time so far: 0.24 seconds.
Query 38: UPDATE wsnlinks_settings SET content='id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility,profileurl' WHERE name='sessionfields'
Load time so far: 0.24 seconds.
Query 39: UPDATE wsnlinks_settings SET content='id,votevalue,time,memberid,ip,custom,linkid,type' WHERE name='ratingfields'
Load time so far: 0.25 seconds.
Query 40: UPDATE wsnlinks_settings SET content='id,type,original,replacement,description,originalclose,replacementclose,sortorder' WHERE name='markupfields'
Load time so far: 0.25 seconds.
Query 41: UPDATE wsnlinks_settings SET content='id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid' WHERE name='modfields'
Load time so far: 0.25 seconds.
Query 42: UPDATE wsnlinks_settings SET content='id,frequency,nextrun,filename,native' WHERE name='cronfields'
Load time so far: 0.25 seconds.
Query 43: UPDATE wsnlinks_settings SET content='id,name,uses,link,ownerid,ownerip' WHERE name='tagfields'
Load time so far: 0.25 seconds.
Query 44: UPDATE wsnlinks_settings SET content='id,url,ownerid,lastfetched,validated,catid,time,title,description,homepage' WHERE name='feedfields'
Load time so far: 0.25 seconds.
Query 45: UPDATE wsnlinks_settings SET content='id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time' WHERE name='calfields'
Load time so far: 0.26 seconds.
Query 46: UPDATE wsnlinks_settings SET content='id,name,numsubjects,priority' WHERE name='helpcatfields'
Load time so far: 0.26 seconds.
Query 47: UPDATE wsnlinks_settings SET content='id,subject,helptext,priority,category' WHERE name='helpitemfields'
Load time so far: 0.26 seconds.
Query 48: UPDATE wsnlinks_settings SET content='id,ownerid,time,deleted,message,name,ip' WHERE name='shoutfields'
Load time so far: 0.26 seconds.
Query 49: UPDATE wsnlinks_settings SET content='content,author,id,source,ownerid,ownername,validated' WHERE name='quotefields'
Load time so far: 0.26 seconds.
Query 50: UPDATE wsnlinks_settings SET content='id,name,message,time,ownerid' WHERE name='chatfields'
Load time so far: 0.27 seconds.
Query 51: UPDATE wsnlinks_settings SET content='id,toid,fromid,message,time,isread,timeread,deleted' WHERE name='imfields'
Load time so far: 0.27 seconds.
Query 52: UPDATE wsnlinks_settings SET content='id,value,memberid,catid,time' WHERE name='searchtablefields'
Load time so far: 0.27 seconds.
Query 53: UPDATE wsnlinks_settings SET content='id,linkid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised,internalto,hasinternal,invisibleto,hostname' WHERE name='commentfields'
Load time so far: 0.27 seconds.
Query 54: UPDATE wsnlinks_settings SET content='id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,flag,filefield,important,replyto,replied,sentdeleted,wysihtml,cc' WHERE name='pmfields'
Load time so far: 0.27 seconds.
Query 55: UPDATE wsnlinks_settings SET content='id,linkid,memberid,price,email,type,time' WHERE name='paymentfields'
Load time so far: 0.27 seconds.
Query 56: UPDATE wsnlinks_settings SET content='id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid,importurl' WHERE name='attachmentfields'
Load time so far: 0.28 seconds.
Query 57: UPDATE wsnlinks_settings SET content='id,topicid,catid,question,options,time,endtime,deleted,multi,public,totals' WHERE name='pollfields'
Load time so far: 0.28 seconds.
Query 58: UPDATE wsnlinks_settings SET content='id,pollid,vote,memberid,ip,deleted,membername,time' WHERE name='pollvotefields'
Load time so far: 0.28 seconds.
Query 59: UPDATE wsnlinks_settings SET content='id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments,validated,response' WHERE name='traderfields'
Load time so far: 0.28 seconds.
Query 60: UPDATE wsnlinks_settings SET content='id,zip,lat,lon,city,state,country' WHERE name='zipcodefields'
Load time so far: 0.29 seconds.
Query 61: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 23
Load time so far: 0.3 seconds.
Query 62: 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`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansubmitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot`,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes`,`canviewownfulltrc`,`canviewallfulltrc` FROM wsnlinks_membergroups WHERE id>0
Load time so far: 0.3 seconds.
Query 63: 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`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader` FROM wsnlinks_members WHERE id='1' AND validated=1
Query 64: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE
Load time so far: 0.36 seconds.
Access denied for user: 'dbuser@localhost' to database 'dbname'
Query 65: 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
Query 66: UNLOCK TABLES
Query 67: SHOW COLUMNS FROM wsnlinks_links
Getting field list for table wsnlinks_links: 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,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime,tags,xmlsource,ordercomments,lastpadupdate,padfile,lastmonthlycheck,invisibleto,profileurl,lastprofileurl,timesrenewed,timedeleted
Load time so far: 0.37 seconds.
Query 68: SHOW COLUMNS FROM wsnlinks_categories
Getting field list for table wsnlinks_categories: 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,linksperpage,wysihtml,numonline,sponsorship,lastprofileurl,defaultnoaccess,lastthreadurl,lastposturl
Load time so far: 0.37 seconds.
Query 69: SHOW COLUMNS FROM wsnlinks_members
Getting field list for table wsnlinks_members: 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,invitessent,validatedemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader
Load time so far: 0.37 seconds.
Query 70: SHOW COLUMNS FROM wsnlinks_membergroups
Getting field list for table wsnlinks_membergroups: 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,numinv,allowugspec,validateemails,validatesponsorlinks,cansubmittags,candeletetags,cansubmitfeeds,validatefeeds,validatefeeditems,numaliasestot,shoutsperday,validatetrader,renewdays,renewtimes,canviewownfulltrc,canviewallfulltrc
Load time so far: 0.38 seconds.
Query 71: SHOW COLUMNS FROM wsnlinks_email
Getting field list for table wsnlinks_email: id,to,subject,message,headers,timesent,ip,replacement,mime
Load time so far: 0.38 seconds.
Query 72: SHOW COLUMNS FROM wsnlinks_sessions
Getting field list for table wsnlinks_sessions: id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility,profileurl
Load time so far: 0.38 seconds.
Query 73: SHOW COLUMNS FROM wsnlinks_ratings
Getting field list for table wsnlinks_ratings: id,votevalue,time,memberid,ip,custom,linkid,type
Load time so far: 0.38 seconds.
Query 74: SHOW COLUMNS FROM wsnlinks_markup
Getting field list for table wsnlinks_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder
Load time so far: 0.38 seconds.
Query 75: SHOW COLUMNS FROM wsnlinks_modlog
Getting field list for table wsnlinks_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid
Load time so far: 0.38 seconds.
Query 76: SHOW COLUMNS FROM wsnlinks_crons
Getting field list for table wsnlinks_crons: id,frequency,nextrun,filename,native
Load time so far: 0.38 seconds.
Query 77: SHOW COLUMNS FROM wsnlinks_tags
Getting field list for table wsnlinks_tags: id,name,uses,link,ownerid,ownerip
Load time so far: 0.38 seconds.
Query 78: SHOW COLUMNS FROM wsnlinks_xmlfeeds
Getting field list for table wsnlinks_xmlfeeds: id,url,ownerid,lastfetched,validated,catid,time,title,description,homepage
Load time so far: 0.38 seconds.
Query 79: SHOW COLUMNS FROM wsnlinks_calendar
Getting field list for table wsnlinks_calendar: id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time
Load time so far: 0.38 seconds.
Query 80: SHOW COLUMNS FROM wsnlinks_helpcategory
Getting field list for table wsnlinks_helpcategory: id,name,numsubjects,priority
Load time so far: 0.38 seconds.
Query 81: SHOW COLUMNS FROM wsnlinks_helpitem
Getting field list for table wsnlinks_helpitem: id,subject,helptext,priority,category
Load time so far: 0.38 seconds.
Query 82: SHOW COLUMNS FROM wsnlinks_shouts
Getting field list for table wsnlinks_shouts: id,ownerid,time,deleted,message,name,ip
Load time so far: 0.38 seconds.
Query 83: SHOW COLUMNS FROM wsnlinks_quotes
Getting field list for table wsnlinks_quotes: content,author,id,source,ownerid,ownername,validated
Load time so far: 0.38 seconds.
Query 84: SHOW COLUMNS FROM wsnlinks_chat
Getting field list for table wsnlinks_chat: id,name,message,time,ownerid
Load time so far: 0.38 seconds.
Query 85: SHOW COLUMNS FROM wsnlinks_im
Getting field list for table wsnlinks_im: id,toid,fromid,message,time,isread,timeread,deleted
Load time so far: 0.38 seconds.
Query 86: SHOW COLUMNS FROM wsnlinks_searches
Getting field list for table wsnlinks_searches: id,value,memberid,catid,time
Load time so far: 0.38 seconds.
Query 87: SHOW COLUMNS FROM wsnlinks_comments
Getting field list for table wsnlinks_comments: id,linkid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised,internalto,hasinternal,invisibleto,hostname
Load time so far: 0.38 seconds.
Query 88: SHOW COLUMNS FROM wsnlinks_pm
Getting field list for table wsnlinks_pm: id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,flag,filefield,important,replyto,replied,sentdeleted,wysihtml,cc
Load time so far: 0.38 seconds.
Query 89: SHOW COLUMNS FROM wsnlinks_payments
Getting field list for table wsnlinks_payments: id,linkid,memberid,price,email,type,time
Load time so far: 0.39 seconds.
Query 90: SHOW COLUMNS FROM wsnlinks_attachments
Getting field list for table wsnlinks_attachments: id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid,importurl
Load time so far: 0.39 seconds.
Query 91: SHOW COLUMNS FROM wsnlinks_trader
Getting field list for table wsnlinks_trader: id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments,validated,response
Load time so far: 0.39 seconds.
Query 92: SHOW COLUMNS FROM wsnlinks_invites
Getting field list for table wsnlinks_invites: id,inviter,invitee,time,usergroup,taken,code
Load time so far: 0.39 seconds.
Query 93: SHOW COLUMNS FROM wsnlinks_reports
Getting field list for table wsnlinks_reports: id,type,objectid,reporter,action,time,moderator,discussionthread,reason,forumid,parentids,topicid,offender
Load time so far: 0.39 seconds.
Query 94: SHOW COLUMNS FROM wsnlinks_polls
Getting field list for table wsnlinks_polls: id,topicid,catid,question,options,time,endtime,deleted,multi,public,totals
Load time so far: 0.39 seconds.
Query 95: SHOW COLUMNS FROM wsnlinks_pollvotes
Getting field list for table wsnlinks_pollvotes: id,pollid,vote,memberid,ip,deleted,membername,time
Load time so far: 0.39 seconds.
Query 96: SHOW COLUMNS FROM wsnlinks_zipcodes
Getting field list for table wsnlinks_zipcodes: id,zip,lat,lon,city,state,country
Load time so far: 0.39 seconds.
Load time so far: 0.39 seconds.
Query 97: UPDATE wsnlinks_settings SET content='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,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime,tags,xmlsource,ordercomments,lastpadupdate,padfile,lastmonthlycheck,invisibleto,profileurl,lastprofileurl,timesrenewed,timedeleted' WHERE name='linkfields'
Load time so far: 0.39 seconds.
Query 98: UPDATE wsnlinks_settings SET content='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,linksperpage,wysihtml,numonline,sponsorship,lastprofileurl,defaultnoaccess,lastthreadurl,lastposturl' WHERE name='categoryfields'
Load time so far: 0.39 seconds.
Query 99: UPDATE wsnlinks_settings SET content='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,invitessent,validatedemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader' WHERE name='memberfields'
Load time so far: 0.39 seconds.
Query 100: UPDATE wsnlinks_settings SET content='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,numinv,allowugspec,validateemails,validatesponsorlinks,cansubmittags,candeletetags,cansubmitfeeds,validatefeeds,validatefeeditems,numaliasestot,shoutsperday,validatetrader,renewdays,renewtimes,canviewownfulltrc,canviewallfulltrc' WHERE name='usergroupfields'
Load time so far: 0.4 seconds.
Query 101: UPDATE wsnlinks_settings SET content='id,to,subject,message,headers,timesent,ip,replacement,mime' WHERE name='emailfields'
Load time so far: 0.4 seconds.
Query 102: UPDATE wsnlinks_settings SET content='id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility,profileurl' WHERE name='sessionfields'
Load time so far: 0.4 seconds.
Query 103: UPDATE wsnlinks_settings SET content='id,votevalue,time,memberid,ip,custom,linkid,type' WHERE name='ratingfields'
Load time so far: 0.4 seconds.
Query 104: UPDATE wsnlinks_settings SET content='id,type,original,replacement,description,originalclose,replacementclose,sortorder' WHERE name='markupfields'
Load time so far: 0.4 seconds.
Query 105: UPDATE wsnlinks_settings SET content='id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid' WHERE name='modfields'
Load time so far: 0.4 seconds.
Query 106: UPDATE wsnlinks_settings SET content='id,frequency,nextrun,filename,native' WHERE name='cronfields'
Load time so far: 0.41 seconds.
Query 107: UPDATE wsnlinks_settings SET content='id,name,uses,link,ownerid,ownerip' WHERE name='tagfields'
Load time so far: 0.41 seconds.
Query 108: UPDATE wsnlinks_settings SET content='id,url,ownerid,lastfetched,validated,catid,time,title,description,homepage' WHERE name='feedfields'
Load time so far: 0.41 seconds.
Query 109: UPDATE wsnlinks_settings SET content='id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time' WHERE name='calfields'
Load time so far: 0.41 seconds.
Query 110: UPDATE wsnlinks_settings SET content='id,name,numsubjects,priority' WHERE name='helpcatfields'
Load time so far: 0.41 seconds.
Query 111: UPDATE wsnlinks_settings SET content='id,subject,helptext,priority,category' WHERE name='helpitemfields'
Load time so far: 0.41 seconds.
Query 112: UPDATE wsnlinks_settings SET content='id,ownerid,time,deleted,message,name,ip' WHERE name='shoutfields'
Load time so far: 0.42 seconds.
Query 113: UPDATE wsnlinks_settings SET content='content,author,id,source,ownerid,ownername,validated' WHERE name='quotefields'
Load time so far: 0.42 seconds.
Query 114: UPDATE wsnlinks_settings SET content='id,name,message,time,ownerid' WHERE name='chatfields'
Load time so far: 0.42 seconds.
Query 115: UPDATE wsnlinks_settings SET content='id,toid,fromid,message,time,isread,timeread,deleted' WHERE name='imfields'
Load time so far: 0.42 seconds.
Query 116: UPDATE wsnlinks_settings SET content='id,value,memberid,catid,time' WHERE name='searchtablefields'
Load time so far: 0.42 seconds.
Query 117: UPDATE wsnlinks_settings SET content='id,linkid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised,internalto,hasinternal,invisibleto,hostname' WHERE name='commentfields'
Load time so far: 0.42 seconds.
Query 118: UPDATE wsnlinks_settings SET content='id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,flag,filefield,important,replyto,replied,sentdeleted,wysihtml,cc' WHERE name='pmfields'
Load time so far: 0.43 seconds.
Query 119: UPDATE wsnlinks_settings SET content='id,linkid,memberid,price,email,type,time' WHERE name='paymentfields'
Load time so far: 0.43 seconds.
Query 120: UPDATE wsnlinks_settings SET content='id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid,importurl' WHERE name='attachmentfields'
Load time so far: 0.43 seconds.
Query 121: UPDATE wsnlinks_settings SET content='id,topicid,catid,question,options,time,endtime,deleted,multi,public,totals' WHERE name='pollfields'
Load time so far: 0.43 seconds.
Query 122: UPDATE wsnlinks_settings SET content='id,pollid,vote,memberid,ip,deleted,membername,time' WHERE name='pollvotefields'
Load time so far: 0.43 seconds.
Query 123: UPDATE wsnlinks_settings SET content='id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments,validated,response' WHERE name='traderfields'
Load time so far: 0.43 seconds.
Query 124: UPDATE wsnlinks_settings SET content='id,zip,lat,lon,city,state,country' WHERE name='zipcodefields'
Load time so far: 0.45 seconds.
Query 125: UPDATE wsnlinks_members SET banned = '' WHERE banned = '0'
Load time so far: 0.45 seconds.
Query 126: UPDATE wsnlinks_switches SET value='0' WHERE name='chat'
Load time so far: 0.47 seconds.
Query 127: SELECT `name` FROM wsnlinks_switches WHERE id>0
Number of rows is 93
Load time so far: 0.48 seconds.
Query 128: UPDATE wsnlinks_membergroups SET renewtimes='0' WHERE renewtimes = '' OR renewtimes = NULL
Load time so far: 0.48 seconds.
Query 129: SELECT `name`,`content` FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC
Number of rows is 473
Unable to create directory './temp/wsnlinks/admin/'Unable to create path for ./temp/wsnlinks/admin/Unable to create directory './temp/wsnlinks/admin/'Unable to create path for ./temp/wsnlinks/admin/Couldn't extract!
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
I don't know if this matters or not, but I did notice in the above debug, in query 64 it says:
Query 64: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE
Load time so far: 0.36 seconds.
Access denied for user: 'dbuser@localhost' to database 'dbname'
Now, I changed the real database user and name for my own peace of mind. I have no problems connecting to the database to add links, make changes so I'm obviously connected to it. I also confirmed that the config.php has the information listed correctly. Like I said, I don't know if this tidbit matters or not but I'm throwing it out there just in case!
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
That message doesn't follow a mysql warning, so it's just the last error on the server being echoed meaninglessly. If it were actually unable to access the database then none of those other queries would be working as it says they are.
As I said in the email, your problem is that your web host is broken.
Simple test for anyone:
<?php echo file_get_contents("http://scripts.webmastersite.net/wsnlinks/version.txt"); ?>If that gives no output, your host has broken url wrappers. Which is okay if curl is available, but that's broken on hai's server too.