Sooo, after backing up my old templates I uploaded everything, overwriting all files for a clean start (except for config.php, of course). Visiting upgrade.php gave me these errors:
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
So I didn't even ran the upgrade, because I'm kinda afraid that I'm going to mess up anything Here's the debug:
Load time so far: 0.02 seconds.
Query 1: SELECT `name`,`content` FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC
Load time so far: 0.08 seconds.
Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0
Number of rows is 73
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,spotlight,top100,comment,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime
Load time so far: 0.09 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
Load time so far: 0.09 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,newemail,calsub,macros
Load time so far: 0.09 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
Load time so far: 0.09 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.09 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
Load time so far: 0.09 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.09 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.09 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.09 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.09 seconds.
Query 13: 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.09 seconds.
Query 14: SHOW COLUMNS FROM wsnlinks_helpcategory
Getting field list for table wsnlinks_helpcategory: id,name,numsubjects,priority
Load time so far: 0.09 seconds.
Query 15: SHOW COLUMNS FROM wsnlinks_helpitem
Getting field list for table wsnlinks_helpitem: id,subject,helptext,priority,category
Load time so far: 0.09 seconds.
Query 16: SHOW COLUMNS FROM wsnlinks_shouts
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Getting field list for table wsnlinks_chat:
Load time so far: 0.1 seconds.
Table 'linklou_main.wsnlinks_chat' doesn't exist
Query 19: 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.1 seconds.
Query 20: SHOW COLUMNS FROM wsnlinks_searches
Getting field list for table wsnlinks_searches: id,value,memberid,catid,time
Load time so far: 0.1 seconds.
Query 21: 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.1 seconds.
Query 22: 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.1 seconds.
Query 23: 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.1 seconds.
Query 24: 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.1 seconds.
Query 25: SHOW COLUMNS FROM wsnlinks_invites
Getting field list for table wsnlinks_invites: id,inviter,invitee,time,usergroup,taken,code
Load time so far: 0.1 seconds.
Query 26: SHOW COLUMNS FROM wsnlinks_polls
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Getting field list for table wsnlinks_polls:
Load time so far: 0.1 seconds.
Table 'linklou_main.wsnlinks_polls' doesn't exist
Query 27: SHOW COLUMNS FROM wsnlinks_pollvotes
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Query 28: 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,spotlight,top100,comment,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime' WHERE name='linkfields'
Load time so far: 0.1 seconds.
Query 29: 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' WHERE name='categoryfields'
Load time so far: 0.11 seconds.
Query 30: 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,newemail,calsub,macros' WHERE name='memberfields'
Load time so far: 0.12 seconds.
Query 31: 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' WHERE name='usergroupfields'
Load time so far: 0.12 seconds.
Query 32: UPDATE wsnlinks_settings SET content='id,to,subject,message,headers,timesent,ip,replacement,mime' WHERE name='emailfields'
Load time so far: 0.13 seconds.
Query 33: UPDATE wsnlinks_settings SET content='id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility' WHERE name='sessionfields'
Load time so far: 0.13 seconds.
Query 34: UPDATE wsnlinks_settings SET content='id,votevalue,time,memberid,ip,custom,linkid,type' WHERE name='ratingfields'
Load time so far: 0.14 seconds.
Query 35: UPDATE wsnlinks_settings SET content='id,type,original,replacement,description,originalclose,replacementclose,sortorder' WHERE name='markupfields'
Load time so far: 0.14 seconds.
Query 36: 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.15 seconds.
Query 37: UPDATE wsnlinks_settings SET content='id,frequency,nextrun,filename,native' WHERE name='cronfields'
Load time so far: 0.15 seconds.
Query 38: UPDATE wsnlinks_settings SET content='1' WHERE name='tagfields'
Load time so far: 0.16 seconds.
Query 39: UPDATE wsnlinks_settings SET content='1' WHERE name='feedfields'
Load time so far: 0.17 seconds.
Query 40: UPDATE wsnlinks_settings SET content='id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time' WHERE name='calfields'
Load time so far: 0.17 seconds.
Query 41: UPDATE wsnlinks_settings SET content='id,name,numsubjects,priority' WHERE name='helpcatfields'
Load time so far: 0.18 seconds.
Query 42: UPDATE wsnlinks_settings SET content='id,subject,helptext,priority,category' WHERE name='helpitemfields'
Load time so far: 0.18 seconds.
Query 43: UPDATE wsnlinks_settings SET content='' WHERE name='shoutfields'
Load time so far: 0.19 seconds.
Query 44: UPDATE wsnlinks_settings SET content='' WHERE name='quotefields'
Load time so far: 0.47 seconds.
Query 45: UPDATE wsnlinks_settings SET content='' WHERE name='chatfields'
Load time so far: 0.48 seconds.
Query 46: UPDATE wsnlinks_settings SET content='id,toid,fromid,message,time,isread,timeread,deleted' WHERE name='imfields'
Load time so far: 0.48 seconds.
Query 47: UPDATE wsnlinks_settings SET content='id,value,memberid,catid,time' WHERE name='searchtablefields'
Load time so far: 0.49 seconds.
Query 48: 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' WHERE name='commentfields'
Load time so far: 0.49 seconds.
Query 49: 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.5 seconds.
Query 50: UPDATE wsnlinks_settings SET content='1' WHERE name='paymentfields'
Load time so far: 0.5 seconds.
Query 51: UPDATE wsnlinks_settings SET content='id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid' WHERE name='attachmentfields'
Load time so far: 0.51 seconds.
Query 52: UPDATE wsnlinks_settings SET content='' WHERE name='pollfields'
Load time so far: 0.52 seconds.
Query 53: UPDATE wsnlinks_settings SET content='' WHERE name='pollvotefields'
Load time so far: 0.52 seconds.
Query 54: UPDATE wsnlinks_settings SET content='id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments' WHERE name='traderfields'
Load time so far: 0.53 seconds.
Query 55: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 22
Load time so far: 0.53 seconds.
Query 56: 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.72 seconds.
Query 57: 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`,`newemail`,`calsub`,`macros` FROM wsnlinks_members WHERE id=1 AND validated=1
Load time so far: 0.72 seconds.
Query 58: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder
Query 60: 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 61: UNLOCK TABLES
Query 62: 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,spotlight,top100,comment,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime
Load time so far: 0.95 seconds.
Query 63: 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.95 seconds.
Query 64: 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,newemail,calsub,macros
Load time so far: 0.95 seconds.
Query 65: 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.95 seconds.
Query 66: 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.95 seconds.
Query 67: 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.96 seconds.
Query 68: 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.96 seconds.
Query 69: 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.96 seconds.
Query 70: 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.96 seconds.
Query 71: SHOW COLUMNS FROM wsnlinks_crons
Getting field list for table wsnlinks_crons: id,frequency,nextrun,filename,native
Load time so far: 0.96 seconds.
Query 72: 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.96 seconds.
Query 73: SHOW COLUMNS FROM wsnlinks_helpcategory
Getting field list for table wsnlinks_helpcategory: id,name,numsubjects,priority
Load time so far: 0.96 seconds.
Query 74: SHOW COLUMNS FROM wsnlinks_helpitem
Getting field list for table wsnlinks_helpitem: id,subject,helptext,priority,category
Load time so far: 0.96 seconds.
Query 75: SHOW COLUMNS FROM wsnlinks_shouts
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Getting field list for table wsnlinks_chat:
Load time so far: 0.96 seconds.
Table 'linklou_main.wsnlinks_chat' doesn't exist
Query 78: 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.96 seconds.
Query 79: SHOW COLUMNS FROM wsnlinks_searches
Getting field list for table wsnlinks_searches: id,value,memberid,catid,time
Load time so far: 0.96 seconds.
Query 80: 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.96 seconds.
Query 81: 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.96 seconds.
Query 82: 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.96 seconds.
Query 83: 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.96 seconds.
Query 84: SHOW COLUMNS FROM wsnlinks_invites
Getting field list for table wsnlinks_invites: id,inviter,invitee,time,usergroup,taken,code
Load time so far: 0.96 seconds.
Query 85: SHOW COLUMNS FROM wsnlinks_polls
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Getting field list for table wsnlinks_polls:
Load time so far: 0.96 seconds.
Table 'linklou_main.wsnlinks_polls' doesn't exist
Query 86: SHOW COLUMNS FROM wsnlinks_pollvotes
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Query 87: 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,spotlight,top100,comment,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime' WHERE name='linkfields'
Load time so far: 0.97 seconds.
Query 88: 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' WHERE name='categoryfields'
Load time so far: 0.97 seconds.
Query 89: 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,newemail,calsub,macros' WHERE name='memberfields'
Load time so far: 0.98 seconds.
Query 90: 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' WHERE name='usergroupfields'
Load time so far: 0.98 seconds.
Query 91: UPDATE wsnlinks_settings SET content='id,to,subject,message,headers,timesent,ip,replacement,mime' WHERE name='emailfields'
Load time so far: 0.99 seconds.
Query 92: UPDATE wsnlinks_settings SET content='id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility' WHERE name='sessionfields'
Load time so far: 0.99 seconds.
Query 93: UPDATE wsnlinks_settings SET content='id,votevalue,time,memberid,ip,custom,linkid,type' WHERE name='ratingfields'
Load time so far: 1.12 seconds.
Query 94: UPDATE wsnlinks_settings SET content='id,type,original,replacement,description,originalclose,replacementclose,sortorder' WHERE name='markupfields'
Load time so far: 1.12 seconds.
Query 95: UPDATE wsnlinks_settings SET content='id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid' WHERE name='modfields'
Load time so far: 1.13 seconds.
Query 96: UPDATE wsnlinks_settings SET content='id,frequency,nextrun,filename,native' WHERE name='cronfields'
Load time so far: 1.13 seconds.
Query 97: UPDATE wsnlinks_settings SET content='1' WHERE name='tagfields'
Load time so far: 1.14 seconds.
Query 98: UPDATE wsnlinks_settings SET content='1' WHERE name='feedfields'
Load time so far: 1.15 seconds.
Query 99: UPDATE wsnlinks_settings SET content='id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time' WHERE name='calfields'
Load time so far: 1.15 seconds.
Query 100: UPDATE wsnlinks_settings SET content='id,name,numsubjects,priority' WHERE name='helpcatfields'
Load time so far: 1.16 seconds.
Query 101: UPDATE wsnlinks_settings SET content='id,subject,helptext,priority,category' WHERE name='helpitemfields'
Load time so far: 1.17 seconds.
Query 102: UPDATE wsnlinks_settings SET content='' WHERE name='shoutfields'
Load time so far: 1.17 seconds.
Query 103: UPDATE wsnlinks_settings SET content='' WHERE name='quotefields'
Load time so far: 1.18 seconds.
Query 104: UPDATE wsnlinks_settings SET content='' WHERE name='chatfields'
Load time so far: 1.18 seconds.
Query 105: UPDATE wsnlinks_settings SET content='id,toid,fromid,message,time,isread,timeread,deleted' WHERE name='imfields'
Load time so far: 1.19 seconds.
Query 106: UPDATE wsnlinks_settings SET content='id,value,memberid,catid,time' WHERE name='searchtablefields'
Load time so far: 1.19 seconds.
Query 107: 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' WHERE name='commentfields'
Load time so far: 1.2 seconds.
Query 108: 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: 1.21 seconds.
Query 109: UPDATE wsnlinks_settings SET content='1' WHERE name='paymentfields'
Load time so far: 1.21 seconds.
Query 110: UPDATE wsnlinks_settings SET content='id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid' WHERE name='attachmentfields'
Load time so far: 1.22 seconds.
Query 111: UPDATE wsnlinks_settings SET content='' WHERE name='pollfields'
Load time so far: 1.22 seconds.
Query 112: UPDATE wsnlinks_settings SET content='' WHERE name='pollvotefields'
Load time so far: 1.23 seconds.
Query 113: UPDATE wsnlinks_settings SET content='id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments' WHERE name='traderfields'
Somehow the $quotestable line got into config.php without being in the database. Open config.php and remove $quotestable = '...'; and then rerun upgrade.php.
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on Upgrade error 4.0.32 to 4.1.3
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
Sooo, after backing up my old templates I uploaded everything, overwriting all files for a clean start (except for config.php, of course). Visiting upgrade.php gave me these errors:
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
So I didn't even ran the upgrade, because I'm kinda afraid that I'm going to mess up anything
Load time so far: 0.02 seconds.
Query 1: SELECT `name`,`content` FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC
Load time so far: 0.08 seconds.
Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0
Number of rows is 73
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,spotlight,top100,comment,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime
Load time so far: 0.09 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
Load time so far: 0.09 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,newemail,calsub,macros
Load time so far: 0.09 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
Load time so far: 0.09 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.09 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
Load time so far: 0.09 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.09 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.09 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.09 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.09 seconds.
Query 13: 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.09 seconds.
Query 14: SHOW COLUMNS FROM wsnlinks_helpcategory
Getting field list for table wsnlinks_helpcategory: id,name,numsubjects,priority
Load time so far: 0.09 seconds.
Query 15: SHOW COLUMNS FROM wsnlinks_helpitem
Getting field list for table wsnlinks_helpitem: id,subject,helptext,priority,category
Load time so far: 0.09 seconds.
Query 16: SHOW COLUMNS FROM wsnlinks_shouts
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Getting field list for table wsnlinks_shouts:
Load time so far: 0.09 seconds.
Table 'linklou_main.wsnlinks_shouts' doesn't exist
Query 17: SHOW COLUMNS FROM wsnlinks_quotes
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Getting field list for table wsnlinks_quotes:
Load time so far: 0.09 seconds.
Table 'linklou_main.wsnlinks_quotes' doesn't exist
Query 18: SHOW COLUMNS FROM wsnlinks_chat
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Getting field list for table wsnlinks_chat:
Load time so far: 0.1 seconds.
Table 'linklou_main.wsnlinks_chat' doesn't exist
Query 19: 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.1 seconds.
Query 20: SHOW COLUMNS FROM wsnlinks_searches
Getting field list for table wsnlinks_searches: id,value,memberid,catid,time
Load time so far: 0.1 seconds.
Query 21: 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.1 seconds.
Query 22: 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.1 seconds.
Query 23: 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.1 seconds.
Query 24: 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.1 seconds.
Query 25: SHOW COLUMNS FROM wsnlinks_invites
Getting field list for table wsnlinks_invites: id,inviter,invitee,time,usergroup,taken,code
Load time so far: 0.1 seconds.
Query 26: SHOW COLUMNS FROM wsnlinks_polls
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Getting field list for table wsnlinks_polls:
Load time so far: 0.1 seconds.
Table 'linklou_main.wsnlinks_polls' doesn't exist
Query 27: SHOW COLUMNS FROM wsnlinks_pollvotes
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Getting field list for table wsnlinks_pollvotes:
Load time so far: 0.1 seconds.
Table 'linklou_main.wsnlinks_pollvotes' doesn't exist
Load time so far: 0.1 seconds.
Table 'linklou_main.wsnlinks_pollvotes' doesn't exist
Query 28: 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,spotlight,top100,comment,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime' WHERE name='linkfields'
Load time so far: 0.1 seconds.
Query 29: 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' WHERE name='categoryfields'
Load time so far: 0.11 seconds.
Query 30: 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,newemail,calsub,macros' WHERE name='memberfields'
Load time so far: 0.12 seconds.
Query 31: 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' WHERE name='usergroupfields'
Load time so far: 0.12 seconds.
Query 32: UPDATE wsnlinks_settings SET content='id,to,subject,message,headers,timesent,ip,replacement,mime' WHERE name='emailfields'
Load time so far: 0.13 seconds.
Query 33: UPDATE wsnlinks_settings SET content='id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility' WHERE name='sessionfields'
Load time so far: 0.13 seconds.
Query 34: UPDATE wsnlinks_settings SET content='id,votevalue,time,memberid,ip,custom,linkid,type' WHERE name='ratingfields'
Load time so far: 0.14 seconds.
Query 35: UPDATE wsnlinks_settings SET content='id,type,original,replacement,description,originalclose,replacementclose,sortorder' WHERE name='markupfields'
Load time so far: 0.14 seconds.
Query 36: 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.15 seconds.
Query 37: UPDATE wsnlinks_settings SET content='id,frequency,nextrun,filename,native' WHERE name='cronfields'
Load time so far: 0.15 seconds.
Query 38: UPDATE wsnlinks_settings SET content='1' WHERE name='tagfields'
Load time so far: 0.16 seconds.
Query 39: UPDATE wsnlinks_settings SET content='1' WHERE name='feedfields'
Load time so far: 0.17 seconds.
Query 40: UPDATE wsnlinks_settings SET content='id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time' WHERE name='calfields'
Load time so far: 0.17 seconds.
Query 41: UPDATE wsnlinks_settings SET content='id,name,numsubjects,priority' WHERE name='helpcatfields'
Load time so far: 0.18 seconds.
Query 42: UPDATE wsnlinks_settings SET content='id,subject,helptext,priority,category' WHERE name='helpitemfields'
Load time so far: 0.18 seconds.
Query 43: UPDATE wsnlinks_settings SET content='' WHERE name='shoutfields'
Load time so far: 0.19 seconds.
Query 44: UPDATE wsnlinks_settings SET content='' WHERE name='quotefields'
Load time so far: 0.47 seconds.
Query 45: UPDATE wsnlinks_settings SET content='' WHERE name='chatfields'
Load time so far: 0.48 seconds.
Query 46: UPDATE wsnlinks_settings SET content='id,toid,fromid,message,time,isread,timeread,deleted' WHERE name='imfields'
Load time so far: 0.48 seconds.
Query 47: UPDATE wsnlinks_settings SET content='id,value,memberid,catid,time' WHERE name='searchtablefields'
Load time so far: 0.49 seconds.
Query 48: 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' WHERE name='commentfields'
Load time so far: 0.49 seconds.
Query 49: 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.5 seconds.
Query 50: UPDATE wsnlinks_settings SET content='1' WHERE name='paymentfields'
Load time so far: 0.5 seconds.
Query 51: UPDATE wsnlinks_settings SET content='id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid' WHERE name='attachmentfields'
Load time so far: 0.51 seconds.
Query 52: UPDATE wsnlinks_settings SET content='' WHERE name='pollfields'
Load time so far: 0.52 seconds.
Query 53: UPDATE wsnlinks_settings SET content='' WHERE name='pollvotefields'
Load time so far: 0.52 seconds.
Query 54: UPDATE wsnlinks_settings SET content='id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments' WHERE name='traderfields'
Load time so far: 0.53 seconds.
Query 55: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 22
Load time so far: 0.53 seconds.
Query 56: 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.72 seconds.
Query 57: 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`,`newemail`,`calsub`,`macros` FROM wsnlinks_members WHERE id=1 AND validated=1
Load time so far: 0.72 seconds.
Query 58: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder
Number of rows is 14
Query 59: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE
Load time so far: 0.73 seconds.
Query 60: 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 61: UNLOCK TABLES
Query 62: 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,spotlight,top100,comment,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime
Load time so far: 0.95 seconds.
Query 63: 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.95 seconds.
Query 64: 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,newemail,calsub,macros
Load time so far: 0.95 seconds.
Query 65: 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.95 seconds.
Query 66: 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.95 seconds.
Query 67: 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.96 seconds.
Query 68: 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.96 seconds.
Query 69: 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.96 seconds.
Query 70: 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.96 seconds.
Query 71: SHOW COLUMNS FROM wsnlinks_crons
Getting field list for table wsnlinks_crons: id,frequency,nextrun,filename,native
Load time so far: 0.96 seconds.
Query 72: 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.96 seconds.
Query 73: SHOW COLUMNS FROM wsnlinks_helpcategory
Getting field list for table wsnlinks_helpcategory: id,name,numsubjects,priority
Load time so far: 0.96 seconds.
Query 74: SHOW COLUMNS FROM wsnlinks_helpitem
Getting field list for table wsnlinks_helpitem: id,subject,helptext,priority,category
Load time so far: 0.96 seconds.
Query 75: SHOW COLUMNS FROM wsnlinks_shouts
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Getting field list for table wsnlinks_shouts:
Load time so far: 0.96 seconds.
Table 'linklou_main.wsnlinks_shouts' doesn't exist
Query 76: SHOW COLUMNS FROM wsnlinks_quotes
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Getting field list for table wsnlinks_quotes:
Load time so far: 0.96 seconds.
Table 'linklou_main.wsnlinks_quotes' doesn't exist
Query 77: SHOW COLUMNS FROM wsnlinks_chat
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Getting field list for table wsnlinks_chat:
Load time so far: 0.96 seconds.
Table 'linklou_main.wsnlinks_chat' doesn't exist
Query 78: 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.96 seconds.
Query 79: SHOW COLUMNS FROM wsnlinks_searches
Getting field list for table wsnlinks_searches: id,value,memberid,catid,time
Load time so far: 0.96 seconds.
Query 80: 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.96 seconds.
Query 81: 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.96 seconds.
Query 82: 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.96 seconds.
Query 83: 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.96 seconds.
Query 84: SHOW COLUMNS FROM wsnlinks_invites
Getting field list for table wsnlinks_invites: id,inviter,invitee,time,usergroup,taken,code
Load time so far: 0.96 seconds.
Query 85: SHOW COLUMNS FROM wsnlinks_polls
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Getting field list for table wsnlinks_polls:
Load time so far: 0.96 seconds.
Table 'linklou_main.wsnlinks_polls' doesn't exist
Query 86: SHOW COLUMNS FROM wsnlinks_pollvotes
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Getting field list for table wsnlinks_pollvotes:
Load time so far: 0.96 seconds.
Table 'linklou_main.wsnlinks_pollvotes' doesn't exist
Load time so far: 0.96 seconds.
Table 'linklou_main.wsnlinks_pollvotes' doesn't exist
Query 87: 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,spotlight,top100,comment,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime' WHERE name='linkfields'
Load time so far: 0.97 seconds.
Query 88: 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' WHERE name='categoryfields'
Load time so far: 0.97 seconds.
Query 89: 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,newemail,calsub,macros' WHERE name='memberfields'
Load time so far: 0.98 seconds.
Query 90: 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' WHERE name='usergroupfields'
Load time so far: 0.98 seconds.
Query 91: UPDATE wsnlinks_settings SET content='id,to,subject,message,headers,timesent,ip,replacement,mime' WHERE name='emailfields'
Load time so far: 0.99 seconds.
Query 92: UPDATE wsnlinks_settings SET content='id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility' WHERE name='sessionfields'
Load time so far: 0.99 seconds.
Query 93: UPDATE wsnlinks_settings SET content='id,votevalue,time,memberid,ip,custom,linkid,type' WHERE name='ratingfields'
Load time so far: 1.12 seconds.
Query 94: UPDATE wsnlinks_settings SET content='id,type,original,replacement,description,originalclose,replacementclose,sortorder' WHERE name='markupfields'
Load time so far: 1.12 seconds.
Query 95: UPDATE wsnlinks_settings SET content='id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid' WHERE name='modfields'
Load time so far: 1.13 seconds.
Query 96: UPDATE wsnlinks_settings SET content='id,frequency,nextrun,filename,native' WHERE name='cronfields'
Load time so far: 1.13 seconds.
Query 97: UPDATE wsnlinks_settings SET content='1' WHERE name='tagfields'
Load time so far: 1.14 seconds.
Query 98: UPDATE wsnlinks_settings SET content='1' WHERE name='feedfields'
Load time so far: 1.15 seconds.
Query 99: UPDATE wsnlinks_settings SET content='id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time' WHERE name='calfields'
Load time so far: 1.15 seconds.
Query 100: UPDATE wsnlinks_settings SET content='id,name,numsubjects,priority' WHERE name='helpcatfields'
Load time so far: 1.16 seconds.
Query 101: UPDATE wsnlinks_settings SET content='id,subject,helptext,priority,category' WHERE name='helpitemfields'
Load time so far: 1.17 seconds.
Query 102: UPDATE wsnlinks_settings SET content='' WHERE name='shoutfields'
Load time so far: 1.17 seconds.
Query 103: UPDATE wsnlinks_settings SET content='' WHERE name='quotefields'
Load time so far: 1.18 seconds.
Query 104: UPDATE wsnlinks_settings SET content='' WHERE name='chatfields'
Load time so far: 1.18 seconds.
Query 105: UPDATE wsnlinks_settings SET content='id,toid,fromid,message,time,isread,timeread,deleted' WHERE name='imfields'
Load time so far: 1.19 seconds.
Query 106: UPDATE wsnlinks_settings SET content='id,value,memberid,catid,time' WHERE name='searchtablefields'
Load time so far: 1.19 seconds.
Query 107: 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' WHERE name='commentfields'
Load time so far: 1.2 seconds.
Query 108: 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: 1.21 seconds.
Query 109: UPDATE wsnlinks_settings SET content='1' WHERE name='paymentfields'
Load time so far: 1.21 seconds.
Query 110: UPDATE wsnlinks_settings SET content='id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid' WHERE name='attachmentfields'
Load time so far: 1.22 seconds.
Query 111: UPDATE wsnlinks_settings SET content='' WHERE name='pollfields'
Load time so far: 1.22 seconds.
Query 112: UPDATE wsnlinks_settings SET content='' WHERE name='pollvotefields'
Load time so far: 1.23 seconds.
Query 113: UPDATE wsnlinks_settings SET content='id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments' WHERE name='traderfields'
by the way, what does "verbose output" mean?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
So I didn't even ran the upgrade, because I'm kinda afraid that I'm going to mess up anything
Run the upgrade. The warnings are normal prior to upgrade.
by the way, what does "verbose output" mean?
It means it tells you what tables and fields it's adding, basically.
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
okay, well, that was too easy
I ran the upgrade, as far as I can tell it went well, and now I get this on index.php:
Query 17: SELECT DISTINCT id,name,uses,link,ownerid,ownerip FROM wsnlinks_tags WHERE 1=1 GROUP BY name ORDER BY uses DESC LIMIT 0,10
Number of rows is 0
Load time so far: 0.54 seconds.
Query 18: SELECT `` FROM wsnlinks_quotes WHERE validated=1 ORDER BY rand() ASC LIMIT 0,1
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/linklou/public_html/databases/mysqli.php on line 18
Number of rows is Table 'linklou_main.wsnlinks_quotes' doesn't exist
Load time so far: 0.54 seconds.
apparently wsnlinks_quotes hasn't been created...
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Somehow the $quotestable line got into config.php without being in the database. Open config.php and remove $quotestable = '...'; and then rerun upgrade.php.