1) One of my site that i updated to 4.0.35 today went blank except for the admin section Below is what the debug was showing on the main page:
Query 2: SHOW COLUMNS FROM wsnlinks_links
Getting field list for table wsnlinks_links: id,title,url,description,rating,votes,validated,catid,sumofvotes,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,company,website,address,phone,info,fax,names,mail,days,dates,times,salary,email,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime
Load time so far: 0.07 seconds.
Query 3: 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
Load time so far: 0.07 seconds.
Query 4: 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
Load time so far: 0.07 seconds.
Query 5: 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
I ended up going back down to 4.0.34 and my site came back up so i decided to upgrade to 4.0.35 again and see if it will go blank again. Once i updated it it went blank again but this time i got the queires from the upgrade for you :
Query 2: SHOW COLUMNS FROM wsnlinks_links
Getting field list for table wsnlinks_links: id,title,url,description,rating,votes,validated,catid,sumofvotes,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,company,website,address,phone,info,fax,names,mail,days,dates,times,salary,email,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime
Load time so far: 0.08 seconds.
Query 3: 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
Load time so far: 0.08 seconds.
Query 4: 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
Load time so far: 0.08 seconds.
Query 5: 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
Load time so far: 0.08 seconds.
Query 6: 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
Load time so far: 0.08 seconds.
Load time so far: 0.18 seconds.
Query 7: SELECT `id` FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1
Number of rows is 1
Load time so far: 0.18 seconds.
Query 8: UPDATE wsnlinks_settings SET content='26' WHERE name='highestcatindex'
Load time so far: 0.18 seconds.
Query 9: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0
Number of rows is 73
Query 10: 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.18 seconds.
Query 11: 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.18 seconds.
Query 12: 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.19 seconds.
Query 13: 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.19 seconds.
Query 14: SHOW COLUMNS FROM wsnlinks_crons
Getting field list for table wsnlinks_crons: id,frequency,nextrun,filename,native
Load time so far: 0.19 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.19 seconds.
Query 16: SHOW COLUMNS FROM wsnlinks_searches
Getting field list for table wsnlinks_searches: id,value,memberid,catid,time
Load time so far: 0.19 seconds.
Query 17: 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
Load time so far: 0.19 seconds.
Load time so far: 0.19 seconds.
Query 18: 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` FROM wsnlinks_membergroups WHERE id>0
Load time so far: 0.2 seconds.
Query 19: 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` FROM wsnlinks_members WHERE id=1 AND validated=1
Query 21: 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 22: UNLOCK TABLES
Setting cookie with name commentfilters, value and expiration time 1285945901
Setting cookie with name linkfilters, value and expiration time 1285945901
Query 23: SHOW COLUMNS FROM wsnlinks_links
Getting field list for table wsnlinks_links: id,title,url,description,rating,votes,validated,catid,sumofvotes,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,company,website,address,phone,info,fax,names,mail,days,dates,times,salary,email,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime
Load time so far: 0.22 seconds.
Query 24: 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
Load time so far: 0.22 seconds.
Query 25: 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
Load time so far: 0.22 seconds.
Query 26: 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
Load time so far: 0.22 seconds.
Query 27: SHOW COLUMNS FROM wsnlinks_helpcategory
Getting field list for table wsnlinks_helpcategory: id,name,numsubjects,priority
Load time so far: 0.23 seconds.
Query 28: SHOW COLUMNS FROM wsnlinks_helpitem
Getting field list for table wsnlinks_helpitem: id,subject,helptext,priority,category
Load time so far: 0.23 seconds.
Query 29: 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.23 seconds.
Query 30: 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.23 seconds.
Query 31: 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.23 seconds.
Query 32: SHOW COLUMNS FROM wsnlinks_trader
Getting field list for table wsnlinks_trader: id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments
Load time so far: 0.23 seconds.
Query 33: SHOW COLUMNS FROM wsnlinks_invites
Getting field list for table wsnlinks_invites: id,inviter,invitee,time,usergroup,taken,code
Load time so far: 0.23 seconds.
Query 34: SHOW COLUMNS FROM wsnlinks_searches
Getting field list for table wsnlinks_searches: id,value,memberid,catid,time
Load time so far: 0.23 seconds.
Query 35: 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
Load time so far: 0.23 seconds.
Query 36: 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.23 seconds.
Query 37: 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
Load time so far: 0.23 seconds.
Query 38: 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.29 seconds.
Query 39: 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.29 seconds.
Query 40: 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.29 seconds.
Query 41: 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
Load time so far: 0.29 seconds.
Query 42: SHOW COLUMNS FROM wsnlinks_crons
Getting field list for table wsnlinks_crons: id,frequency,nextrun,filename,native
Load time so far: 0.29 seconds.
Load time so far: 0.3 seconds.
Query 43: UPDATE wsnlinks_members SET banned = '' WHERE banned = '0'
Load time so far: 0.3 seconds.
Query 44: UPDATE wsnlinks_switches SET value='0' WHERE name='chat'
Load time so far: 0.32 seconds.
Query 45: SELECT `name` FROM wsnlinks_switches WHERE id>0
Number of rows is 73
Load time so far: 0.33 seconds.
Query 46: UPDATE wsnlinks_membergroups SET numaliases='10' WHERE numaliases=''
Load time so far: 0.33 seconds.
Query 47: SELECT `name`,`content` FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC
2) I also noticed this in the admin section for both of my sites that have been upgraded to 4.0.35. I think this error existed in version 4.0.34 as well. Im not sure what it means :
Warning: mysqli_error() [function.mysqli-error]: Couldn't fetch mysqli in /home/job/public_html/databases/mysqli.php on line 17
It seem like the upgrade mess this site up although my other one is fine except for the error i see from the admin section which occured on both sites.
2) The mysqli_error is what I need the debug for, that'd tell me something. The debug on pages without mysql errors doesn't indicate anything.
Strange/frustrating since so little changed from 4.0.34 to 4.0.35. Can you give me an FTP login so I can step through it? (The 4.0.35s I've installed don't show the issue.)
Ive send the information you requested to evaluate the problem. Please update me on your progress and fell free to contact me if you need more information.
Comments on Site went blank after upgrade
Forum Regular
Usergroup: Customer
Joined: Nov 01, 2004
Total Topics: 56
Total Comments: 121
Hi Paul,
1) One of my site that i updated to 4.0.35 today went blank except for the admin section Below is what the debug was showing on the main page:
Query 2: SHOW COLUMNS FROM wsnlinks_links
Getting field list for table wsnlinks_links: id,title,url,description,rating,votes,validated,catid,sumofvotes,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,company,website,address,phone,info,fax,names,mail,days,dates,times,salary,email,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime
Load time so far: 0.07 seconds.
Query 3: 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
Load time so far: 0.07 seconds.
Query 4: 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
Load time so far: 0.07 seconds.
Query 5: 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
-------------------------------------------------------
I ended up going back down to 4.0.34 and my site came back up so i decided to upgrade to 4.0.35 again and see if it will go blank again. Once i updated it it went blank again but this time i got the queires from the upgrade for you :
Query 2: SHOW COLUMNS FROM wsnlinks_links
Getting field list for table wsnlinks_links: id,title,url,description,rating,votes,validated,catid,sumofvotes,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,company,website,address,phone,info,fax,names,mail,days,dates,times,salary,email,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime
Load time so far: 0.08 seconds.
Query 3: 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
Load time so far: 0.08 seconds.
Query 4: 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
Load time so far: 0.08 seconds.
Query 5: 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
Load time so far: 0.08 seconds.
Query 6: 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
Load time so far: 0.08 seconds.
Load time so far: 0.18 seconds.
Query 7: SELECT `id` FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1
Number of rows is 1
Load time so far: 0.18 seconds.
Query 8: UPDATE wsnlinks_settings SET content='26' WHERE name='highestcatindex'
Load time so far: 0.18 seconds.
Query 9: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0
Number of rows is 73
Query 10: 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.18 seconds.
Query 11: 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.18 seconds.
Query 12: 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.19 seconds.
Query 13: 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.19 seconds.
Query 14: SHOW COLUMNS FROM wsnlinks_crons
Getting field list for table wsnlinks_crons: id,frequency,nextrun,filename,native
Load time so far: 0.19 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.19 seconds.
Query 16: SHOW COLUMNS FROM wsnlinks_searches
Getting field list for table wsnlinks_searches: id,value,memberid,catid,time
Load time so far: 0.19 seconds.
Query 17: 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
Load time so far: 0.19 seconds.
Load time so far: 0.19 seconds.
Query 18: 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` FROM wsnlinks_membergroups WHERE id>0
Load time so far: 0.2 seconds.
Query 19: 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` FROM wsnlinks_members WHERE id=1 AND validated=1
Query 20: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE
Load time so far: 0.21 seconds.
Query 21: 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 22: UNLOCK TABLES
Setting cookie with name commentfilters, value and expiration time 1285945901
Setting cookie with name linkfilters, value and expiration time 1285945901
Query 23: SHOW COLUMNS FROM wsnlinks_links
Getting field list for table wsnlinks_links: id,title,url,description,rating,votes,validated,catid,sumofvotes,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,company,website,address,phone,info,fax,names,mail,days,dates,times,salary,email,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime
Load time so far: 0.22 seconds.
Query 24: 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
Load time so far: 0.22 seconds.
Query 25: 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
Load time so far: 0.22 seconds.
Query 26: 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
Load time so far: 0.22 seconds.
Query 27: SHOW COLUMNS FROM wsnlinks_helpcategory
Getting field list for table wsnlinks_helpcategory: id,name,numsubjects,priority
Load time so far: 0.23 seconds.
Query 28: SHOW COLUMNS FROM wsnlinks_helpitem
Getting field list for table wsnlinks_helpitem: id,subject,helptext,priority,category
Load time so far: 0.23 seconds.
Query 29: 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.23 seconds.
Query 30: 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.23 seconds.
Query 31: 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.23 seconds.
Query 32: SHOW COLUMNS FROM wsnlinks_trader
Getting field list for table wsnlinks_trader: id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments
Load time so far: 0.23 seconds.
Query 33: SHOW COLUMNS FROM wsnlinks_invites
Getting field list for table wsnlinks_invites: id,inviter,invitee,time,usergroup,taken,code
Load time so far: 0.23 seconds.
Query 34: SHOW COLUMNS FROM wsnlinks_searches
Getting field list for table wsnlinks_searches: id,value,memberid,catid,time
Load time so far: 0.23 seconds.
Query 35: 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
Load time so far: 0.23 seconds.
Query 36: 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.23 seconds.
Query 37: 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
Load time so far: 0.23 seconds.
Query 38: 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.29 seconds.
Query 39: 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.29 seconds.
Query 40: 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.29 seconds.
Query 41: 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
Load time so far: 0.29 seconds.
Query 42: SHOW COLUMNS FROM wsnlinks_crons
Getting field list for table wsnlinks_crons: id,frequency,nextrun,filename,native
Load time so far: 0.29 seconds.
Load time so far: 0.3 seconds.
Query 43: UPDATE wsnlinks_members SET banned = '' WHERE banned = '0'
Load time so far: 0.3 seconds.
Query 44: UPDATE wsnlinks_switches SET value='0' WHERE name='chat'
Load time so far: 0.32 seconds.
Query 45: SELECT `name` FROM wsnlinks_switches WHERE id>0
Number of rows is 73
Load time so far: 0.33 seconds.
Query 46: UPDATE wsnlinks_membergroups SET numaliases='10' WHERE numaliases=''
Load time so far: 0.33 seconds.
Query 47: SELECT `name`,`content` FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC
2) I also noticed this in the admin section for both of my sites that have been upgraded to 4.0.35. I think this error existed in version 4.0.34 as well. Im not sure what it means :
Warning: mysqli_error() [function.mysqli-error]: Couldn't fetch mysqli in /home/job/public_html/databases/mysqli.php on line 17
It seem like the upgrade mess this site up although my other one is fine except for the error i see from the admin section which occured on both sites.
Thanks,
Fuee
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
2) The mysqli_error is what I need the debug for, that'd tell me something. The debug on pages without mysql errors doesn't indicate anything.
Strange/frustrating since so little changed from 4.0.34 to 4.0.35. Can you give me an FTP login so I can step through it? (The 4.0.35s I've installed don't show the issue.)
Forum Regular
Usergroup: Customer
Joined: Nov 01, 2004
Total Topics: 56
Total Comments: 121
Paul,
Ive send the information you requested to evaluate the problem. Please update me on your progress and fell free to contact me if you need more information.
Thanks,
Fuee
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
For others with this problem (probably anyone using links that don't have URLs), 4.0.36 fixes it.