Webmastersite.net
Register Log In

unable to auto upgrade
clicking upgrade button gets me a blank page

Comments on unable to auto upgrade

Paul
developer

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

Total Topics: 61
Total Comments: 7868
Paul
#16 - Quote - Permalink
Posted Jan 26, 2008 - 4:55 AM:

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.
mrkarron
Experienced

Usergroup: Customer
Joined: Oct 02, 2003

Total Topics: 33
Total Comments: 97
#17 - Quote - Permalink
Posted Jan 26, 2008 - 6:49 PM:

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..
hai
Forum Regular

Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA

Total Topics: 94
Total Comments: 339
hai
#18 - Quote - Permalink
Posted Jan 27, 2008 - 11:06 AM:

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!
hai
Forum Regular

Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA

Total Topics: 94
Total Comments: 339
hai
#19 - Quote - Permalink
Posted Jan 28, 2008 - 7:23 AM:

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!
Paul
developer

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

Total Topics: 61
Total Comments: 7868
Paul
#20 - Quote - Permalink
Posted Jan 29, 2008 - 4:17 PM:

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.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.