mySQL error on upgrade: WSN Support

Quick Links open

New Posts Member List

WSN Support » WSN Links » mySQL error on upgrade » mySQL error on upgrade

mySQL error on upgrade
cant go pass the first step - debug included

Version: 3.12
Example URL: truefresco.org/link_directory

mySQL error on upgrade

fresco
Experienced

Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 18
Total Posts: 90

Posted 04/14/08 - 12:06 AM:	#1
Load time so far: 0.15 seconds. Query 1: SELECT `name`,`content` FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC Number of rows is 490 Load time so far: 0.37 seconds. Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0 Number of rows is 93 Query 3: SHOW COLUMNS FROM wsnlinks_links Getting field list for table wsnlinks_links: id,title,url,description,rating,votes,recip,validated,recipu rl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid ,hitsin,voterips,voterids,keywords,lastedit,type,filename,fi letitle,notify,suspect,downloads,pendingedit,funds,suspended ,recipwith,alias,expire,ip,inalbum,typeorder,hitsinips,hitso utips,lastcomment,related,inhidden,viewers,threadviewers,hit sintemp,hitsouttemp,origtype,importance,parentids,timesdead, timesemailed,threadclosed,threadposters,country,states,city, travel,ecommerce,lastposterid,lastpostername,ownername,delet ed,deletionreason,movedto,deletedby,timevalidated,filefield, message,sticky,pollid,posticon,savedby,validatedemail,unpaid ,recipverified,effectivetime,sugcatid,pagerank,wysihtml,move did,unrevised,feedurl,feedcache,feedcachetime,tags,xmlsource ,ordercomments,lastpadupdate,padfile,lastmonthlycheck,invisi bleto,profileurl,lastprofileurl,timesrenewed,timedeleted Load time so far: 0.38 seconds. Query 4: SHOW COLUMNS FROM wsnlinks_categories Getting field list for table wsnlinks_categories: id,name,parent,validated,description,time,parentnames,parent ids,numlinks,hide,lastlinktime,custom,moderators,lastedit,he aderinfo,related,numsub,type,permissions,subscribers,subscri ber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ul searchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sp onsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlink sdelay,priority,levelsdeep,lastposterid,lastpostername,lastc ommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidate dlinks,unvalidatedcomments,actaslink,countposts,subcatshtml, linksperpage,wysihtml,numonline,sponsorship,lastprofileurl,d efaultnoaccess,lastthreadurl,lastposturl Load time so far: 0.38 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,al lowemail,signature,avatarname,stylesheet,allowuseremail,albu mid,failedattempts,totalbytes,images,funds,notifyoflinks,las tvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cooki eduration,banned,location,homepage,occupation,bio,aim,icq,ms n,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonlin e,acceptims,adminpermissions,referrer,groupreverttime,groupr evertto,moderationpm,secondarygroups,linksperpage,commentspe rpage,shouts,customtitle,shoutban,topicbans,forumbans,visibi lity,birthdate,lastsession,interests,posteditor,forumaccess, pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms ,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod ,showavatars,showsigs,warninglevel,topics,posts,chatcolor,tr aderrating,invitessent,validatedemail,calsub,macros,guestnot ify,keychecktime,notifykeywords,autosubscribepost,blogrss,po sitivepct,notifytrader Load time so far: 0.39 seconds. Query 6: SHOW COLUMNS FROM wsnlinks_membergroups Getting field list for table wsnlinks_membergroups: id,title,caneditown,caneditall,canvote,isadmin,canpost,canem ail,validatecats,validatecomments,validatelinks,validateedit s,cansubmitlinks,cansubmitcategories,cansubmitcomments,caned itownlinks,caneditowncategories,caneditowncomments,caneditow nprofile,caneditalllinks,caneditallcategories,caneditallcomm ents,caneditallprofiles,candownloadfiles,canupload,canviewip ,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canal ias,cancopy,candeleteown,candeleteall,candofulledit,candelet ecategories,candeletecomments,candeleteowncategories,candele teowncomments,candeletemembers,candeleteownmembers,canaliasc ategories,canviewpages,caneditvotes,numaliases,canviewvotes, canhideownlinks,canhideowncategories,canhideowncomments,canh idealllinks,canhideallcategories,canhideallcomments,canratec omments,bytespermem,canpm,canim,canharddelete,limitpms,limit pmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candel eteownpolls,caneditpolls,caneditownpolls,attachperpost,attac hperpm,canviewshouts,caneditshouts,caneditownshouts,candelet eshouts,candeleteownshouts,cansubmitshouts,canpollvote,custo mtitle,canviewinvisible,namestyle,canpmimportant,canviewmodl og,isleader,cansubmitquotes,validatequotes,candeletequotes,c andeleteownquotes,canreport,canusesearch,attachperlink,valid ateattachments,caneditownquotes,caneditallquotes,canviewchat ,caneditownevents,caneditallevents,candeleteownevents,candel eteevents,cansubmitevents,validateevents,bulkpms,issupermod, numinv,allowugspec,validateemails,validatesponsorlinks,cansu bmittags,candeletetags,cansubmitfeeds,validatefeeds,validate feeditems,numaliasestot,shoutsperday,validatetrader,renewday s,renewtimes,canviewownfulltrc,canviewallfulltrc Load time so far: 0.39 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.41 seconds. Query 8: SHOW COLUMNS FROM wsnlinks_sessions Getting field list for table wsnlinks_sessions: id,memberid,location,time,ip,browser,starttime,catid,threadi d,areaname,lastsearch,nopermission,inchat,name,isrobot,lastc hat,groupnamestyle,acceptims,visibility,profileurl Load time so far: 0.41 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.41 seconds. Query 10: SHOW COLUMNS FROM wsnlinks_markup Getting field list for table wsnlinks_markup: id,type,original,replacement,description,originalclose,repla cementclose,sortorder Load time so far: 0.41 seconds. Query 11: SHOW COLUMNS FROM wsnlinks_modlog Getting field list for table wsnlinks_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,dest ination,time,catid,memberid Load time so far: 0.41 seconds. Query 12: SHOW COLUMNS FROM wsnlinks_crons Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_crons: Load time so far: 0.41 seconds. Table 'truefresco_org.wsnlinks_crons' doesn't exist Query 13: SHOW COLUMNS FROM wsnlinks_tags Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_tags: Load time so far: 0.41 seconds. Table 'truefresco_org.wsnlinks_tags' doesn't exist Query 14: SHOW COLUMNS FROM wsnlinks_xmlfeeds Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_xmlfeeds: Load time so far: 0.41 seconds. Table 'truefresco_org.wsnlinks_xmlfeeds' doesn't exist Query 15: SHOW COLUMNS FROM wsnlinks_calendar Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_calendar: Load time so far: 0.41 seconds. Table 'truefresco_org.wsnlinks_calendar' doesn't exist Query 16: SHOW COLUMNS FROM wsnlinks_helpcategory Getting field list for table wsnlinks_helpcategory: id,name,numsubjects,priority Load time so far: 0.41 seconds. Query 17: SHOW COLUMNS FROM wsnlinks_helpitem Getting field list for table wsnlinks_helpitem: id,subject,helptext,priority,category Load time so far: 0.41 seconds. Query 18: SHOW COLUMNS FROM wsnlinks_shouts Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_shouts: Load time so far: 0.41 seconds. Table 'truefresco_org.wsnlinks_shouts' doesn't exist Query 19: SHOW COLUMNS FROM wsnlinks_quotes Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_quotes: Load time so far: 0.41 seconds. Table 'truefresco_org.wsnlinks_quotes' doesn't exist Query 20: SHOW COLUMNS FROM wsnlinks_chat Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_chat: Load time so far: 0.41 seconds. Table 'truefresco_org.wsnlinks_chat' doesn't exist Query 21: SHOW COLUMNS FROM wsnlinks_im Getting field list for table wsnlinks_im: id,toid,fromid,message,time,isread,timeread,deleted Load time so far: 0.41 seconds. Query 22: SHOW COLUMNS FROM wsnlinks_searches Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_searches: Load time so far: 0.41 seconds. Table 'truefresco_org.wsnlinks_searches' doesn't exist Query 23: SHOW COLUMNS FROM wsnlinks_comments Getting field list for table wsnlinks_comments: id,linkid,posterid,postername,message,time,linkname,validate d,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,las teditby,catid,editreason,preventedit,inhidden,deleted,deleti onreason,usernoteon,modnote,filefield,title,deletedby,parent ids,disablesmilies,disablesig,icon,disablewsn,disablehtml,or iginalmessage,flagged,wysihtml,unrevised,internalto,hasinter nal,invisibleto,hostname Load time so far: 0.42 seconds. Query 24: SHOW COLUMNS FROM wsnlinks_pm Getting field list for table wsnlinks_pm: id,toid,fromid,timeread,message,subject,time,icon,folderid,d eleted,attachment,flag,filefield,important,replyto,replied,s entdeleted,wysihtml,cc Load time so far: 0.42 seconds. Query 25: SHOW COLUMNS FROM wsnlinks_payments Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_payments: Load time so far: 0.42 seconds. Table 'truefresco_org.wsnlinks_payments' doesn't exist Query 26: SHOW COLUMNS FROM wsnlinks_attachments Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_attachments: Load time so far: 0.42 seconds. Table 'truefresco_org.wsnlinks_attachments' doesn't exist Query 27: SHOW COLUMNS FROM wsnlinks_trader Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_trader: Load time so far: 0.42 seconds. Table 'truefresco_org.wsnlinks_trader' doesn't exist Query 28: SHOW COLUMNS FROM wsnlinks_invites Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_invites: Load time so far: 0.42 seconds. Table 'truefresco_org.wsnlinks_invites' doesn't exist Query 29: SHOW COLUMNS FROM wsnlinks_reports Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_reports: Load time so far: 0.42 seconds. Table 'truefresco_org.wsnlinks_reports' doesn't exist Query 30: SHOW COLUMNS FROM wsnlinks_polls Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_polls: Load time so far: 0.42 seconds. Table 'truefresco_org.wsnlinks_polls' doesn't exist Query 31: SHOW COLUMNS FROM wsnlinks_pollvotes Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_pollvotes: Load time so far: 0.42 seconds. Table 'truefresco_org.wsnlinks_pollvotes' doesn't exist Query 32: SHOW COLUMNS FROM wsnlinks_zipcodes Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_zipcodes: Load time so far: 0.42 seconds. Table 'truefresco_org.wsnlinks_zipcodes' doesn't exist Load time so far: 0.42 seconds. Table 'truefresco_org.wsnlinks_zipcodes' doesn't exist Query 33: UPDATE wsnlinks_settings SET content='id,title,url,description,rating,votes,recip,val idated,recipurl,catid,sumofvotes,email,time,hits,numcomments ,hide,ownerid,hitsin,voterips,voterids,keywords,lastedit,typ e,filename,filetitle,notify,suspect,downloads,pendingedit,fu nds,suspended,recipwith,alias,expire,ip,inalbum,typeorder,hi tsinips,hitsoutips,lastcomment,related,inhidden,viewers,thre adviewers,hitsintemp,hitsouttemp,origtype,importance,parenti ds,timesdead,timesemailed,threadclosed,threadposters,country ,states,city,travel,ecommerce,lastposterid,lastpostername,ow nername,deleted,deletionreason,movedto,deletedby,timevalidat ed,filefield,message,sticky,pollid,posticon,savedby,validate demail,unpaid,recipverified,effectivetime,sugcatid,pagerank, wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime,t ags,xmlsource,ordercomments,lastpadupdate,padfile,lastmonthl ycheck,invisibleto,profileurl,lastprofileurl,timesrenewed,ti medeleted' WHERE name='linkfields' Load time so far: 0.42 seconds. Query 34: UPDATE wsnlinks_settings SET content='id,name,parent,validated,description,time,paren tnames,parentids,numlinks,hide,lastlinktime,custom,moderator s,lastedit,headerinfo,related,numsub,type,permissions,subscr ibers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,u lsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcol s,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,re qcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpos tername,lastcommenttime,lastthreadid,lastthreadtitle,linkshe re,unvalidatedlinks,unvalidatedcomments,actaslink,countposts ,subcatshtml,linksperpage,wysihtml,numonline,sponsorship,las tprofileurl,defaultnoaccess,lastthreadurl,lastposturl' WHERE name='categoryfields' Load time so far: 0.43 seconds. Query 35: UPDATE wsnlinks_settings SET content='id,name,links,comments,time,usergroup,password, ip,totalhits,totalhitsin,email,validated,template,language,l astattempt,allowemail,signature,avatarname,stylesheet,allowu seremail,albumid,failedattempts,totalbytes,images,funds,noti fyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,ac ceptpms,cookieduration,banned,location,homepage,occupation,b io,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ig nored,isonline,acceptims,adminpermissions,referrer,groupreve rttime,grouprevertto,moderationpm,secondarygroups,linksperpa ge,commentsperpage,shouts,customtitle,shoutban,topicbans,for umbans,visibility,birthdate,lastsession,interests,posteditor ,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastm odnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe ,notifymethod,showavatars,showsigs,warninglevel,topics,posts ,chatcolor,traderrating,invitessent,validatedemail,calsub,ma cros,guestnotify,keychecktime,notifykeywords,autosubscribepo st,blogrss,positivepct,notifytrader' WHERE name='memberfields' Load time so far: 0.43 seconds. Query 36: UPDATE wsnlinks_settings SET content='id,title,caneditown,caneditall,canvote,isadmin, canpost,canemail,validatecats,validatecomments,validatelinks ,validateedits,cansubmitlinks,cansubmitcategories,cansubmitc omments,caneditownlinks,caneditowncategories,caneditowncomme nts,caneditownprofile,caneditalllinks,caneditallcategories,c aneditallcomments,caneditallprofiles,candownloadfiles,canupl oad,canviewip,limitlinks,canemailmembers,canusehtml,limitlin ksdaily,canalias,cancopy,candeleteown,candeleteall,candofull edit,candeletecategories,candeletecomments,candeleteowncateg ories,candeleteowncomments,candeletemembers,candeleteownmemb ers,canaliascategories,canviewpages,caneditvotes,numaliases, canviewvotes,canhideownlinks,canhideowncategories,canhideown comments,canhidealllinks,canhideallcategories,canhideallcomm ents,canratecomments,bytespermem,canpm,canim,canharddelete,l imitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candelet epolls,candeleteownpolls,caneditpolls,caneditownpolls,attach perpost,attachperpm,canviewshouts,caneditshouts,caneditownsh outs,candeleteshouts,candeleteownshouts,cansubmitshouts,canp ollvote,customtitle,canviewinvisible,namestyle,canpmimportan t,canviewmodlog,isleader,cansubmitquotes,validatequotes,cand eletequotes,candeleteownquotes,canreport,canusesearch,attach perlink,validateattachments,caneditownquotes,caneditallquote s,canviewchat,caneditownevents,caneditallevents,candeleteown events,candeleteevents,cansubmitevents,validateevents,bulkpm s,issupermod,numinv,allowugspec,validateemails,validatespons orlinks,cansubmittags,candeletetags,cansubmitfeeds,validatef eeds,validatefeeditems,numaliasestot,shoutsperday,validatetr ader,renewdays,renewtimes,canviewownfulltrc,canviewallfulltr c' WHERE name='usergroupfields' Load time so far: 0.5 seconds. Query 37: UPDATE wsnlinks_settings SET content='id,to,subject,message,headers,timesent,ip,repla cement,mime' WHERE name='emailfields' Load time so far: 0.51 seconds. Query 38: UPDATE wsnlinks_settings SET content='id,memberid,location,time,ip,browser,starttime, catid,threadid,areaname,lastsearch,nopermission,inchat,name, isrobot,lastchat,groupnamestyle,acceptims,visibility,profile url' WHERE name='sessionfields' Load time so far: 0.51 seconds. Query 39: UPDATE wsnlinks_settings SET content='id,votevalue,time,memberid,ip,custom,linkid,typ e' WHERE name='ratingfields' Load time so far: 0.51 seconds. Query 40: UPDATE wsnlinks_settings SET content='id,type,original,replacement,description,origin alclose,replacementclose,sortorder' WHERE name='markupfields' Load time so far: 0.51 seconds. Query 41: UPDATE wsnlinks_settings SET content='id,topicid,postid,type,nature,reason,moderatori d,source,destination,time,catid,memberid' WHERE name='modfields' Load time so far: 0.52 seconds. Query 42: UPDATE wsnlinks_settings SET content='' WHERE name='cronfields' Load time so far: 0.52 seconds. Query 43: UPDATE wsnlinks_settings SET content='' WHERE name='tagfields' Load time so far: 0.52 seconds. Query 44: UPDATE wsnlinks_settings SET content='' WHERE name='feedfields' Load time so far: 0.53 seconds. Query 45: UPDATE wsnlinks_settings SET content='' WHERE name='calfields' Load time so far: 0.53 seconds. Query 46: UPDATE wsnlinks_settings SET content='id,name,numsubjects,priority' WHERE name='helpcatfields' Load time so far: 0.54 seconds. Query 47: UPDATE wsnlinks_settings SET content='id,subject,helptext,priority,category' WHERE name='helpitemfields' Load time so far: 0.54 seconds. Query 48: UPDATE wsnlinks_settings SET content='' WHERE name='shoutfields' Load time so far: 0.57 seconds. Query 49: UPDATE wsnlinks_settings SET content='' WHERE name='quotefields' Load time so far: 0.57 seconds. Query 50: UPDATE wsnlinks_settings SET content='' WHERE name='chatfields' Load time so far: 0.61 seconds. Query 51: UPDATE wsnlinks_settings SET content='id,toid,fromid,message,time,isread,timeread,del eted' WHERE name='imfields' Load time so far: 0.61 seconds. Query 52: UPDATE wsnlinks_settings SET content='' WHERE name='searchtablefields' Load time so far: 0.61 seconds. Query 53: UPDATE wsnlinks_settings SET content='id,linkid,posterid,postername,message,time,link name,validated,ip,ownerid,lastedit,type,approved,votes,hide, typeorder,lasteditby,catid,editreason,preventedit,inhidden,d eleted,deletionreason,usernoteon,modnote,filefield,title,del etedby,parentids,disablesmilies,disablesig,icon,disablewsn,d isablehtml,originalmessage,flagged,wysihtml,unrevised,intern alto,hasinternal,invisibleto,hostname' WHERE name='commentfields' Load time so far: 0.62 seconds. Query 54: UPDATE wsnlinks_settings SET content='id,toid,fromid,timeread,message,subject,time,ic on,folderid,deleted,attachment,flag,filefield,important,repl yto,replied,sentdeleted,wysihtml,cc' WHERE name='pmfields' Load time so far: 0.62 seconds. Query 55: UPDATE wsnlinks_settings SET content='' WHERE name='paymentfields' Load time so far: 0.62 seconds. Query 56: UPDATE wsnlinks_settings SET content='' WHERE name='attachmentfields' Load time so far: 0.62 seconds. Query 57: UPDATE wsnlinks_settings SET content='' WHERE name='pollfields' Load time so far: 0.63 seconds. Query 58: UPDATE wsnlinks_settings SET content='' WHERE name='pollvotefields' Load time so far: 0.63 seconds. Query 59: UPDATE wsnlinks_settings SET content='' WHERE name='traderfields' Load time so far: 0.63 seconds. Query 60: UPDATE wsnlinks_settings SET content='' WHERE name='zipcodefields' Load time so far: 0.65 seconds. Query 61: SELECT `id`,`type`,`original`,`replacement`,`description`,`original close`,`replacementclose`,`sortorder` FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder Number of rows is 4 Creating markup with Array as row Creating markup with Array as row Creating markup with Array as row Creating markup with Array as row Load time so far: 0.66 seconds. Query 62: SELECT `id`,`title`,`caneditown`,`caneditall`,`canvote`,`isadmin`,` canpost`,`canemail`,`validatecats`,`validatecomments`,`valid atelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategor ies`,`cansubmitcomments`,`caneditownlinks`,`caneditowncatego ries`,`caneditowncomments`,`caneditownprofile`,`caneditallli nks`,`caneditallcategories`,`caneditallcomments`,`caneditall profiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitl inks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`cana lias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit `,`candeletecategories`,`candeletecomments`,`candeleteowncat egories`,`candeleteowncomments`,`candeletemembers`,`candelet eownmembers`,`canaliascategories`,`canviewpages`,`caneditvot es`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideow ncategories`,`canhideowncomments`,`canhidealllinks`,`canhide allcategories`,`canhideallcomments`,`canratecomments`,`bytes permem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpms daily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`c andeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachpe rpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`canedi townshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmi tshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`nam estyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubm itquotes`,`validatequotes`,`candeletequotes`,`candeleteownqu otes`,`canreport`,`canusesearch`,`attachperlink`,`validateat tachments`,`caneditownquotes`,`caneditallquotes`,`canviewcha t`,`caneditownevents`,`caneditallevents`,`candeleteownevents `,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulk pms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`v alidatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansub mitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot `,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes`,` canviewownfulltrc`,`canviewallfulltrc` FROM wsnlinks_membergroups WHERE id>0 Load time so far: 0.73 seconds. Query 63: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder Number of rows is 13 Load time so far: 0.73 seconds. Query 64: 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 Load time so far: 0.73 seconds. Query 65: SELECT `id` FROM wsnlinks_links WHERE recipurl='http://truefresco.org/link_directory/upgrade.php' Number of rows is 0 Query 66: SHOW COLUMNS FROM wsnlinks_links Getting field list for table wsnlinks_links: id,title,url,description,rating,votes,recip,validated,recipu rl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid ,hitsin,voterips,voterids,keywords,lastedit,type,filename,fi letitle,notify,suspect,downloads,pendingedit,funds,suspended ,recipwith,alias,expire,ip,inalbum,typeorder,hitsinips,hitso utips,lastcomment,related,inhidden,viewers,threadviewers,hit sintemp,hitsouttemp,origtype,importance,parentids,timesdead, timesemailed,threadclosed,threadposters,country,states,city, travel,ecommerce,lastposterid,lastpostername,ownername,delet ed,deletionreason,movedto,deletedby,timevalidated,filefield, message,sticky,pollid,posticon,savedby,validatedemail,unpaid ,recipverified,effectivetime,sugcatid,pagerank,wysihtml,move did,unrevised,feedurl,feedcache,feedcachetime,tags,xmlsource ,ordercomments,lastpadupdate,padfile,lastmonthlycheck,invisi bleto,profileurl,lastprofileurl,timesrenewed,timedeleted Load time so far: 0.8 seconds. Query 67: SHOW COLUMNS FROM wsnlinks_categories Getting field list for table wsnlinks_categories: id,name,parent,validated,description,time,parentnames,parent ids,numlinks,hide,lastlinktime,custom,moderators,lastedit,he aderinfo,related,numsub,type,permissions,subscribers,subscri ber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ul searchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sp onsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlink sdelay,priority,levelsdeep,lastposterid,lastpostername,lastc ommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidate dlinks,unvalidatedcomments,actaslink,countposts,subcatshtml, linksperpage,wysihtml,numonline,sponsorship,lastprofileurl,d efaultnoaccess,lastthreadurl,lastposturl Load time so far: 0.8 seconds. Query 68: 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,al lowemail,signature,avatarname,stylesheet,allowuseremail,albu mid,failedattempts,totalbytes,images,funds,notifyoflinks,las tvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cooki eduration,banned,location,homepage,occupation,bio,aim,icq,ms n,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonlin e,acceptims,adminpermissions,referrer,groupreverttime,groupr evertto,moderationpm,secondarygroups,linksperpage,commentspe rpage,shouts,customtitle,shoutban,topicbans,forumbans,visibi lity,birthdate,lastsession,interests,posteditor,forumaccess, pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms ,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod ,showavatars,showsigs,warninglevel,topics,posts,chatcolor,tr aderrating,invitessent,validatedemail,calsub,macros,guestnot ify,keychecktime,notifykeywords,autosubscribepost,blogrss,po sitivepct,notifytrader Load time so far: 0.81 seconds. Query 69: SHOW COLUMNS FROM wsnlinks_membergroups Getting field list for table wsnlinks_membergroups: id,title,caneditown,caneditall,canvote,isadmin,canpost,canem ail,validatecats,validatecomments,validatelinks,validateedit s,cansubmitlinks,cansubmitcategories,cansubmitcomments,caned itownlinks,caneditowncategories,caneditowncomments,caneditow nprofile,caneditalllinks,caneditallcategories,caneditallcomm ents,caneditallprofiles,candownloadfiles,canupload,canviewip ,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canal ias,cancopy,candeleteown,candeleteall,candofulledit,candelet ecategories,candeletecomments,candeleteowncategories,candele teowncomments,candeletemembers,candeleteownmembers,canaliasc ategories,canviewpages,caneditvotes,numaliases,canviewvotes, canhideownlinks,canhideowncategories,canhideowncomments,canh idealllinks,canhideallcategories,canhideallcomments,canratec omments,bytespermem,canpm,canim,canharddelete,limitpms,limit pmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candel eteownpolls,caneditpolls,caneditownpolls,attachperpost,attac hperpm,canviewshouts,caneditshouts,caneditownshouts,candelet eshouts,candeleteownshouts,cansubmitshouts,canpollvote,custo mtitle,canviewinvisible,namestyle,canpmimportant,canviewmodl og,isleader,cansubmitquotes,validatequotes,candeletequotes,c andeleteownquotes,canreport,canusesearch,attachperlink,valid ateattachments,caneditownquotes,caneditallquotes,canviewchat ,caneditownevents,caneditallevents,candeleteownevents,candel eteevents,cansubmitevents,validateevents,bulkpms,issupermod, numinv,allowugspec,validateemails,validatesponsorlinks,cansu bmittags,candeletetags,cansubmitfeeds,validatefeeds,validate feeditems,numaliasestot,shoutsperday,validatetrader,renewday s,renewtimes,canviewownfulltrc,canviewallfulltrc Load time so far: 0.81 seconds. Query 70: 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.81 seconds. Query 71: SHOW COLUMNS FROM wsnlinks_sessions Getting field list for table wsnlinks_sessions: id,memberid,location,time,ip,browser,starttime,catid,threadi d,areaname,lastsearch,nopermission,inchat,name,isrobot,lastc hat,groupnamestyle,acceptims,visibility,profileurl Load time so far: 0.81 seconds. Query 72: 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.81 seconds. Query 73: SHOW COLUMNS FROM wsnlinks_markup Getting field list for table wsnlinks_markup: id,type,original,replacement,description,originalclose,repla cementclose,sortorder Load time so far: 0.81 seconds. Query 74: SHOW COLUMNS FROM wsnlinks_modlog Getting field list for table wsnlinks_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,dest ination,time,catid,memberid Load time so far: 0.81 seconds. Query 75: SHOW COLUMNS FROM wsnlinks_crons Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_crons: Load time so far: 0.82 seconds. Table 'truefresco_org.wsnlinks_crons' doesn't exist Query 76: SHOW COLUMNS FROM wsnlinks_tags Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_tags: Load time so far: 0.82 seconds. Table 'truefresco_org.wsnlinks_tags' doesn't exist Query 77: SHOW COLUMNS FROM wsnlinks_xmlfeeds Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_xmlfeeds: Load time so far: 0.82 seconds. Table 'truefresco_org.wsnlinks_xmlfeeds' doesn't exist Query 78: SHOW COLUMNS FROM wsnlinks_calendar Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_calendar: Load time so far: 0.82 seconds. Table 'truefresco_org.wsnlinks_calendar' doesn't exist Query 79: SHOW COLUMNS FROM wsnlinks_helpcategory Getting field list for table wsnlinks_helpcategory: id,name,numsubjects,priority Load time so far: 0.82 seconds. Query 80: SHOW COLUMNS FROM wsnlinks_helpitem Getting field list for table wsnlinks_helpitem: id,subject,helptext,priority,category Load time so far: 0.82 seconds. Query 81: SHOW COLUMNS FROM wsnlinks_shouts Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_shouts: Load time so far: 0.82 seconds. Table 'truefresco_org.wsnlinks_shouts' doesn't exist Query 82: SHOW COLUMNS FROM wsnlinks_quotes Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_quotes: Load time so far: 0.82 seconds. Table 'truefresco_org.wsnlinks_quotes' doesn't exist Query 83: SHOW COLUMNS FROM wsnlinks_chat Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_chat: Load time so far: 0.82 seconds. Table 'truefresco_org.wsnlinks_chat' doesn't exist Query 84: 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.82 seconds. Query 85: SHOW COLUMNS FROM wsnlinks_searches Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_searches: Load time so far: 0.82 seconds. Table 'truefresco_org.wsnlinks_searches' doesn't exist Query 86: SHOW COLUMNS FROM wsnlinks_comments Getting field list for table wsnlinks_comments: id,linkid,posterid,postername,message,time,linkname,validate d,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,las teditby,catid,editreason,preventedit,inhidden,deleted,deleti onreason,usernoteon,modnote,filefield,title,deletedby,parent ids,disablesmilies,disablesig,icon,disablewsn,disablehtml,or iginalmessage,flagged,wysihtml,unrevised,internalto,hasinter nal,invisibleto,hostname Load time so far: 0.85 seconds. Query 87: SHOW COLUMNS FROM wsnlinks_pm Getting field list for table wsnlinks_pm: id,toid,fromid,timeread,message,subject,time,icon,folderid,d eleted,attachment,flag,filefield,important,replyto,replied,s entdeleted,wysihtml,cc Load time so far: 0.86 seconds. Query 88: SHOW COLUMNS FROM wsnlinks_payments Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_payments: Load time so far: 0.86 seconds. Table 'truefresco_org.wsnlinks_payments' doesn't exist Query 89: SHOW COLUMNS FROM wsnlinks_attachments Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_attachments: Load time so far: 0.86 seconds. Table 'truefresco_org.wsnlinks_attachments' doesn't exist Query 90: SHOW COLUMNS FROM wsnlinks_trader Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_trader: Load time so far: 0.86 seconds. Table 'truefresco_org.wsnlinks_trader' doesn't exist Query 91: SHOW COLUMNS FROM wsnlinks_invites Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_invites: Load time so far: 0.86 seconds. Table 'truefresco_org.wsnlinks_invites' doesn't exist Query 92: SHOW COLUMNS FROM wsnlinks_reports Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_reports: Load time so far: 0.86 seconds. Table 'truefresco_org.wsnlinks_reports' doesn't exist Query 93: SHOW COLUMNS FROM wsnlinks_polls Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_polls: Load time so far: 0.86 seconds. Table 'truefresco_org.wsnlinks_polls' doesn't exist Query 94: SHOW COLUMNS FROM wsnlinks_pollvotes Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_pollvotes: Load time so far: 0.86 seconds. Table 'truefresco_org.wsnlinks_pollvotes' doesn't exist Query 95: SHOW COLUMNS FROM wsnlinks_zipcodes Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site1/fst/var/www/html/link_directory/database s/mysql.php on line 27 Getting field list for table wsnlinks_zipcodes: Load time so far: 0.86 seconds. Table 'truefresco_org.wsnlinks_zipcodes' doesn't exist Load time so far: 0.86 seconds. Table 'truefresco_org.wsnlinks_zipcodes' doesn't exist Query 96: UPDATE wsnlinks_settings SET content='id,title,url,description,rating,votes,recip,val idated,recipurl,catid,sumofvotes,email,time,hits,numcomments ,hide,ownerid,hitsin,voterips,voterids,keywords,lastedit,typ e,filename,filetitle,notify,suspect,downloads,pendingedit,fu nds,suspended,recipwith,alias,expire,ip,inalbum,typeorder,hi tsinips,hitsoutips,lastcomment,related,inhidden,viewers,thre adviewers,hitsintemp,hitsouttemp,origtype,importance,parenti ds,timesdead,timesemailed,threadclosed,threadposters,country ,states,city,travel,ecommerce,lastposterid,lastpostername,ow nername,deleted,deletionreason,movedto,deletedby,timevalidat ed,filefield,message,sticky,pollid,posticon,savedby,validate demail,unpaid,recipverified,effectivetime,sugcatid,pagerank, wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime,t ags,xmlsource,ordercomments,lastpadupdate,padfile,lastmonthl ycheck,invisibleto,profileurl,lastprofileurl,timesrenewed,ti medeleted' WHERE name='linkfields' Load time so far: 0.86 seconds. Query 97: UPDATE wsnlinks_settings SET content='id,name,parent,validated,description,time,paren tnames,parentids,numlinks,hide,lastlinktime,custom,moderator s,lastedit,headerinfo,related,numsub,type,permissions,subscr ibers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,u lsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcol s,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,re qcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpos tername,lastcommenttime,lastthreadid,lastthreadtitle,linkshe re,unvalidatedlinks,unvalidatedcomments,actaslink,countposts ,subcatshtml,linksperpage,wysihtml,numonline,sponsorship,las tprofileurl,defaultnoaccess,lastthreadurl,lastposturl' WHERE name='categoryfields' Load time so far: 0.87 seconds. Query 98: UPDATE wsnlinks_settings SET content='id,name,links,comments,time,usergroup,password, ip,totalhits,totalhitsin,email,validated,template,language,l astattempt,allowemail,signature,avatarname,stylesheet,allowu seremail,albumid,failedattempts,totalbytes,images,funds,noti fyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,ac ceptpms,cookieduration,banned,location,homepage,occupation,b io,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ig nored,isonline,acceptims,adminpermissions,referrer,groupreve rttime,grouprevertto,moderationpm,secondarygroups,linksperpa ge,commentsperpage,shouts,customtitle,shoutban,topicbans,for umbans,visibility,birthdate,lastsession,interests,posteditor ,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastm odnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe ,notifymethod,showavatars,showsigs,warninglevel,topics,posts ,chatcolor,traderrating,invitessent,validatedemail,calsub,ma cros,guestnotify,keychecktime,notifykeywords,autosubscribepo st,blogrss,positivepct,notifytrader' WHERE name='memberfields' Load time so far: 0.87 seconds. Query 99: UPDATE wsnlinks_settings SET content='id,title,caneditown,caneditall,canvote,isadmin, canpost,canemail,validatecats,validatecomments,validatelinks ,validateedits,cansubmitlinks,cansubmitcategories,cansubmitc omments,caneditownlinks,caneditowncategories,caneditowncomme nts,caneditownprofile,caneditalllinks,caneditallcategories,c aneditallcomments,caneditallprofiles,candownloadfiles,canupl oad,canviewip,limitlinks,canemailmembers,canusehtml,limitlin ksdaily,canalias,cancopy,candeleteown,candeleteall,candofull edit,candeletecategories,candeletecomments,candeleteowncateg ories,candeleteowncomments,candeletemembers,candeleteownmemb ers,canaliascategories,canviewpages,caneditvotes,numaliases, canviewvotes,canhideownlinks,canhideowncategories,canhideown comments,canhidealllinks,canhideallcategories,canhideallcomm ents,canratecomments,bytespermem,canpm,canim,canharddelete,l imitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candelet epolls,candeleteownpolls,caneditpolls,caneditownpolls,attach perpost,attachperpm,canviewshouts,caneditshouts,caneditownsh outs,candeleteshouts,candeleteownshouts,cansubmitshouts,canp ollvote,customtitle,canviewinvisible,namestyle,canpmimportan t,canviewmodlog,isleader,cansubmitquotes,validatequotes,cand eletequotes,candeleteownquotes,canreport,canusesearch,attach perlink,validateattachments,caneditownquotes,caneditallquote s,canviewchat,caneditownevents,caneditallevents,candeleteown events,candeleteevents,cansubmitevents,validateevents,bulkpm s,issupermod,numinv,allowugspec,validateemails,validatespons orlinks,cansubmittags,candeletetags,cansubmitfeeds,validatef eeds,validatefeeditems,numaliasestot,shoutsperday,validatetr ader,renewdays,renewtimes,canviewownfulltrc,canviewallfulltr c' WHERE name='usergroupfields' Load time so far: 0.87 seconds. Query 100: UPDATE wsnlinks_settings SET content='id,to,subject,message,headers,timesent,ip,repla cement,mime' WHERE name='emailfields' Load time so far: 0.87 seconds. Query 101: UPDATE wsnlinks_settings SET content='id,memberid,location,time,ip,browser,starttime, catid,threadid,areaname,lastsearch,nopermission,inchat,name, isrobot,lastchat,groupnamestyle,acceptims,visibility,profile url' WHERE name='sessionfields' Load time so far: 0.88 seconds. Query 102: UPDATE wsnlinks_settings SET content='id,votevalue,time,memberid,ip,custom,linkid,typ e' WHERE name='ratingfields' Load time so far: 0.89 seconds. Query 103: UPDATE wsnlinks_settings SET content='id,type,original,replacement,description,origin alclose,replacementclose,sortorder' WHERE name='markupfields' Load time so far: 0.9 seconds. Query 104: UPDATE wsnlinks_settings SET content='id,topicid,postid,type,nature,reason,moderatori d,source,destination,time,catid,memberid' WHERE name='modfields' Load time so far: 0.9 seconds. Query 105: UPDATE wsnlinks_settings SET content='' WHERE name='cronfields' Load time so far: 0.9 seconds. Query 106: UPDATE wsnlinks_settings SET content='' WHERE name='tagfields' Load time so far: 0.91 seconds. Query 107: UPDATE wsnlinks_settings SET content='' WHERE name='feedfields' Load time so far: 0.91 seconds. Query 108: UPDATE wsnlinks_settings SET content='' WHERE name='calfields' Load time so far: 0.91 seconds. Query 109: UPDATE wsnlinks_settings SET content='id,name,numsubjects,priority' WHERE name='helpcatfields' Load time so far: 0.93 seconds. Query 110: UPDATE wsnlinks_settings SET content='id,subject,helptext,priority,category' WHERE name='helpitemfields' Load time so far: 0.93 seconds. Query 111: UPDATE wsnlinks_settings SET content='' WHERE name='shoutfields' Load time so far: 0.94 seconds. Query 112: UPDATE wsnlinks_settings SET content='' WHERE name='quotefields' Load time so far: 0.95 seconds. Query 113: UPDATE wsnlinks_settings SET content='' WHERE name='chatfields' Load time so far: 0.97 seconds. Query 114: UPDATE wsnlinks_settings SET content='id,toid,fromid,message,time,isread,timeread,del eted' WHERE name='imfields' Load time so far: 0.97 seconds. Query 115: UPDATE wsnlinks_settings SET content='' WHERE name='searchtablefields' Load time so far: 0.97 seconds. Query 116: UPDATE wsnlinks_settings SET content='id,linkid,posterid,postername,message,time,link name,validated,ip,ownerid,lastedit,type,approved,votes,hide, typeorder,lasteditby,catid,editreason,preventedit,inhidden,d eleted,deletionreason,usernoteon,modnote,filefield,title,del etedby,parentids,disablesmilies,disablesig,icon,disablewsn,d isablehtml,originalmessage,flagged,wysihtml,unrevised,intern alto,hasinternal,invisibleto,hostname' WHERE name='commentfields' Load time so far: 0.97 seconds. Query 117: UPDATE wsnlinks_settings SET content='id,toid,fromid,timeread,message,subject,time,ic on,folderid,deleted,attachment,flag,filefield,important,repl yto,replied,sentdeleted,wysihtml,cc' WHERE name='pmfields' Load time so far: 1.01 seconds. Query 118: UPDATE wsnlinks_settings SET content='' WHERE name='paymentfields' Load time so far: 1.01 seconds. Query 119: UPDATE wsnlinks_settings SET content='' WHERE name='attachmentfields' Load time so far: 1.01 seconds. Query 120: UPDATE wsnlinks_settings SET content='' WHERE name='pollfields' Load time so far: 1.02 seconds. Query 121: UPDATE wsnlinks_settings SET content='' WHERE name='pollvotefields' Load time so far: 1.02 seconds. Query 122: UPDATE wsnlinks_settings SET content='' WHERE name='traderfields' Load time so far: 1.02 seconds. Query 123: UPDATE wsnlinks_settings SET content='' WHERE name='zipcodefields' Query 124: ALTER TABLE `wsnlinks_attachments` ADD `id` int default '0' NOT NULL auto_increment Query 125: ALTER TABLE `wsnlinks_attachments` ADD `type` varchar(255) NOT NULL Query 126: ALTER TABLE `wsnlinks_attachments` ADD `objectid` int default '0' NOT NULL Query 127: ALTER TABLE `wsnlinks_attachments` ADD `filename` varchar(255) NOT NULL Query 128: ALTER TABLE `wsnlinks_attachments` ADD `filetitle` varchar(255) NOT NULL Query 129: ALTER TABLE `wsnlinks_attachments` ADD `filesize` int default '0' NOT NULL Query 130: ALTER TABLE `wsnlinks_attachments` ADD `width` int default '0' NOT NULL Query 131: ALTER TABLE `wsnlinks_attachments` ADD `height` int default '0' NOT NULL Query 132: ALTER TABLE `wsnlinks_attachments` ADD `memberid` int default '0' NOT NULL Query 133: ALTER TABLE `wsnlinks_attachments` ADD `time` int default '0' NOT NULL Query 134: ALTER TABLE `wsnlinks_attachments` ADD `deleted` tinyint default '0' NOT NULL Query 135: ALTER TABLE `wsnlinks_attachments` ADD `field` varchar(255) NOT NULL Query 136: ALTER TABLE `wsnlinks_attachments` ADD `downloads` int default '0' NOT NULL Query 137: ALTER TABLE `wsnlinks_attachments` ADD `validated` tinyint default '0' NOT NULL Query 138: ALTER TABLE `wsnlinks_attachments` ADD `ownerip` varchar(255) NOT NULL Query 139: ALTER TABLE `wsnlinks_attachments` ADD `catid` int default '0' NOT NULL Query 140: ALTER TABLE `wsnlinks_attachments` ADD `importurl` varchar(255) NOT NULL Query 141: ALTER TABLE `wsnlinks_crons` ADD `id` int default '0' NOT NULL auto_increment Query 142: ALTER TABLE `wsnlinks_crons` ADD `frequency` int default '0' NOT NULL Query 143: ALTER TABLE `wsnlinks_crons` ADD `nextrun` int default '0' NOT NULL Query 144: ALTER TABLE `wsnlinks_crons` ADD `filename` varchar(255) NOT NULL Query 145: ALTER TABLE `wsnlinks_crons` ADD `native` tinyint default '0' NOT NULL Query 146: ALTER TABLE `wsnlinks_trader` ADD `id` int default '0' NOT NULL auto_increment Query 147: ALTER TABLE `wsnlinks_trader` ADD `ratingof` int default '0' NOT NULL Query 148: ALTER TABLE `wsnlinks_trader` ADD `ratingby` int default '0' NOT NULL Query 149: ALTER TABLE `wsnlinks_trader` ADD `value` int default '0' NOT NULL Query 150: ALTER TABLE `wsnlinks_trader` ADD `summary` varchar(255) NOT NULL Query 151: ALTER TABLE `wsnlinks_trader` ADD `report` text NOT NULL Query 152: ALTER TABLE `wsnlinks_trader` ADD `time` int default '0' NOT NULL Query 153: ALTER TABLE `wsnlinks_trader` ADD `type` varchar(255) NOT NULL Query 154: ALTER TABLE `wsnlinks_trader` ADD `linkid` int default '0' NOT NULL Query 155: ALTER TABLE `wsnlinks_trader` ADD `morecomments` text NOT NULL Query 156: ALTER TABLE `wsnlinks_trader` ADD `validated` tinyint default '0' NOT NULL Query 157: ALTER TABLE `wsnlinks_trader` ADD `response` text NOT NULL Query 158: ALTER TABLE `wsnlinks_searches` ADD `id` int default '0' NOT NULL auto_increment Query 159: ALTER TABLE `wsnlinks_searches` ADD `value` varchar(255) NOT NULL Query 160: ALTER TABLE `wsnlinks_searches` ADD `memberid` int default '0' NOT NULL Query 161: ALTER TABLE `wsnlinks_searches` ADD `catid` int default '0' NOT NULL Query 162: ALTER TABLE `wsnlinks_searches` ADD `time` int default '0' NOT NULL Query 163: ALTER TABLE `wsnlinks_calendar` ADD `id` int default '0' NOT NULL auto_increment Query 164: ALTER TABLE `wsnlinks_calendar` ADD `ownerid` int default '0' NOT NULL Query 165: ALTER TABLE `wsnlinks_calendar` ADD `title` varchar(255) NOT NULL Query 166: ALTER TABLE `wsnlinks_calendar` ADD `description` text NOT NULL Query 167: ALTER TABLE `wsnlinks_calendar` ADD `joined` text NOT NULL Query 168: ALTER TABLE `wsnlinks_calendar` ADD `starttime` int default '0' NOT NULL Query 169: ALTER TABLE `wsnlinks_calendar` ADD `endtime` int default '0' NOT NULL Query 170: ALTER TABLE `wsnlinks_calendar` ADD `date` varchar(255) NOT NULL Query 171: ALTER TABLE `wsnlinks_calendar` ADD `reminded` text NOT NULL Query 172: ALTER TABLE `wsnlinks_calendar` ADD `validated` tinyint default '0' NOT NULL Query 173: ALTER TABLE `wsnlinks_calendar` ADD `time` int default '0' NOT NULL Query 174: ALTER TABLE `wsnlinks_invites` ADD `id` int default '0' NOT NULL auto_increment Query 175: ALTER TABLE `wsnlinks_invites` ADD `inviter` int default '0' NOT NULL Query 176: ALTER TABLE `wsnlinks_invites` ADD `invitee` varchar(255) NOT NULL Query 177: ALTER TABLE `wsnlinks_invites` ADD `time` int default '0' NOT NULL Query 178: ALTER TABLE `wsnlinks_invites` ADD `usergroup` int default '0' NOT NULL Query 179: ALTER TABLE `wsnlinks_invites` ADD `taken` tinyint default '0' NOT NULL Query 180: ALTER TABLE `wsnlinks_invites` ADD `code` varchar(255) NOT NULL Query 181: ALTER TABLE `wsnlinks_tags` ADD `id` int default '0' NOT NULL auto_increment Query 182: ALTER TABLE `wsnlinks_tags` ADD `name` varchar(255) NOT NULL Query 183: ALTER TABLE `wsnlinks_tags` ADD `uses` int default '0' NOT NULL Query 184: ALTER TABLE `wsnlinks_tags` ADD `link` int default '0' NOT NULL Query 185: ALTER TABLE `wsnlinks_tags` ADD `ownerid` int default '0' NOT NULL Query 186: ALTER TABLE `wsnlinks_tags` ADD `ownerip` varchar(255) NOT NULL Query 187: ALTER TABLE `wsnlinks_reports` ADD `id` int default '0' NOT NULL auto_increment Query 188: ALTER TABLE `wsnlinks_reports` ADD `type` varchar(255) NOT NULL Query 189: ALTER TABLE `wsnlinks_reports` ADD `objectid` int default '0' NOT NULL Query 190: ALTER TABLE `wsnlinks_reports` ADD `reporter` int default '0' NOT NULL Query 191: ALTER TABLE `wsnlinks_reports` ADD `action` varchar(255) NOT NULL Query 192: ALTER TABLE `wsnlinks_reports` ADD `time` int default '0' NOT NULL Query 193: ALTER TABLE `wsnlinks_reports` ADD `moderator` int default '0' NOT NULL Query 194: ALTER TABLE `wsnlinks_reports` ADD `discussionthread` int default '0' NOT NULL Query 195: ALTER TABLE `wsnlinks_reports` ADD `reason` text NOT NULL Query 196: ALTER TABLE `wsnlinks_reports` ADD `forumid` int default '0' NOT NULL Query 197: ALTER TABLE `wsnlinks_reports` ADD `parentids` varchar(255) NOT NULL Query 198: ALTER TABLE `wsnlinks_reports` ADD `topicid` int default '0' NOT NULL Query 199: ALTER TABLE `wsnlinks_reports` ADD `offender` int default '0' NOT NULL Query 200: ALTER TABLE `wsnlinks_shouts` ADD `id` int default '0' NOT NULL auto_increment Query 201: ALTER TABLE `wsnlinks_shouts` ADD `ownerid` int default '0' NOT NULL Query 202: ALTER TABLE `wsnlinks_shouts` ADD `time` int default '0' NOT NULL Query 203: ALTER TABLE `wsnlinks_shouts` ADD `deleted` tinyint default '0' NOT NULL Query 204: ALTER TABLE `wsnlinks_shouts` ADD `message` text NOT NULL Query 205: ALTER TABLE `wsnlinks_shouts` ADD `name` varchar(255) NOT NULL Query 206: ALTER TABLE `wsnlinks_shouts` ADD `ip` varchar(255) NOT NULL Query 207: ALTER TABLE `wsnlinks_quotes` ADD `content` text NOT NULL Query 208: ALTER TABLE `wsnlinks_quotes` ADD `author` varchar(255) NOT NULL Query 209: ALTER TABLE `wsnlinks_quotes` ADD `id` int default '0' NOT NULL auto_increment Query 210: ALTER TABLE `wsnlinks_quotes` ADD `source` text NOT NULL Query 211: ALTER TABLE `wsnlinks_quotes` ADD `ownerid` int default '0' NOT NULL Query 212: ALTER TABLE `wsnlinks_quotes` ADD `ownername` varchar(255) NOT NULL Query 213: ALTER TABLE `wsnlinks_quotes` ADD `validated` tinyint default '0' NOT NULL Query 214: ALTER TABLE `wsnlinks_xmlfeeds` ADD `id` int default '0' NOT NULL auto_increment Query 215: ALTER TABLE `wsnlinks_xmlfeeds` ADD `url` varchar(255) NOT NULL Query 216: ALTER TABLE `wsnlinks_xmlfeeds` ADD `ownerid` int default '0' NOT NULL Query 217: ALTER TABLE `wsnlinks_xmlfeeds` ADD `lastfetched` int default '0' NOT NULL Query 218: ALTER TABLE `wsnlinks_xmlfeeds` ADD `validated` tinyint default '0' NOT NULL Query 219: ALTER TABLE `wsnlinks_xmlfeeds` ADD `catid` int default '0' NOT NULL Query 220: ALTER TABLE `wsnlinks_xmlfeeds` ADD `time` int default '0' NOT NULL Query 221: ALTER TABLE `wsnlinks_xmlfeeds` ADD `title` varchar(255) NOT NULL Query 222: ALTER TABLE `wsnlinks_xmlfeeds` ADD `description` text NOT NULL Query 223: ALTER TABLE `wsnlinks_xmlfeeds` ADD `homepage` varchar(255) NOT NULL Query 224: ALTER TABLE `wsnlinks_polls` ADD `id` int default '0' NOT NULL auto_increment Query 225: ALTER TABLE `wsnlinks_polls` ADD `topicid` int default '0' NOT NULL Query 226: ALTER TABLE `wsnlinks_polls` ADD `catid` int default '0' NOT NULL Query 227: ALTER TABLE `wsnlinks_polls` ADD `question` text NOT NULL Query 228: ALTER TABLE `wsnlinks_polls` ADD `options` text NOT NULL Query 229: ALTER TABLE `wsnlinks_polls` ADD `time` int default '0' NOT NULL Query 230: ALTER TABLE `wsnlinks_polls` ADD `endtime` int default '0' NOT NULL Query 231: ALTER TABLE `wsnlinks_polls` ADD `deleted` tinyint default '0' NOT NULL Query 232: ALTER TABLE `wsnlinks_polls` ADD `multi` int default '0' NOT NULL Query 233: ALTER TABLE `wsnlinks_polls` ADD `public` tinyint default '0' NOT NULL Query 234: ALTER TABLE `wsnlinks_polls` ADD `totals` text NOT NULL Query 235: ALTER TABLE `wsnlinks_pollvotes` ADD `id` int default '0' NOT NULL auto_increment Query 236: ALTER TABLE `wsnlinks_pollvotes` ADD `pollid` int default '0' NOT NULL Query 237: ALTER TABLE `wsnlinks_pollvotes` ADD `vote` int default '0' NOT NULL Query 238: ALTER TABLE `wsnlinks_pollvotes` ADD `memberid` int default '0' NOT NULL Query 239: ALTER TABLE `wsnlinks_pollvotes` ADD `ip` varchar(255) NOT NULL Query 240: ALTER TABLE `wsnlinks_pollvotes` ADD `deleted` tinyint default '0' NOT NULL Query 241: ALTER TABLE `wsnlinks_pollvotes` ADD `membername` varchar(255) NOT NULL Query 242: ALTER TABLE `wsnlinks_pollvotes` ADD `time` int default '0' NOT NULL Query 243: ALTER TABLE `wsnlinks_payments` ADD `id` int default '0' NOT NULL auto_increment Query 244: ALTER TABLE `wsnlinks_payments` ADD `linkid` int default '0' NOT NULL Query 245: ALTER TABLE `wsnlinks_payments` ADD `memberid` int default '0' NOT NULL Query 246: ALTER TABLE `wsnlinks_payments` ADD `price` float Query 247: ALTER TABLE `wsnlinks_payments` ADD `email` varchar(255) NOT NULL Query 248: ALTER TABLE `wsnlinks_payments` ADD `type` varchar(255) NOT NULL Query 249: ALTER TABLE `wsnlinks_payments` ADD `time` int default '0' NOT NULL Query 250: ALTER TABLE `wsnlinks_zipcodes` ADD `id` int default '0' NOT NULL auto_increment Query 251: ALTER TABLE `wsnlinks_zipcodes` ADD `zip` varchar(255) NOT NULL Query 252: ALTER TABLE `wsnlinks_zipcodes` ADD `lat` float Query 253: ALTER TABLE `wsnlinks_zipcodes` ADD `lon` float Query 254: ALTER TABLE `wsnlinks_zipcodes` ADD `city` varchar(255) NOT NULL Query 255: ALTER TABLE `wsnlinks_zipcodes` ADD `state` varchar(255) NOT NULL Query 256: ALTER TABLE `wsnlinks_zipcodes` ADD `country` varchar(255) NOT NULL Load time so far: 1.11 seconds. Table 'truefresco_org.wsnlinks_zipcodes' doesn't exist Query 257: UPDATE wsnlinks_members SET banned = '' WHERE banned = '0' Load time so far: 1.15 seconds. Query 258: ALTER TABLE CHANGE `lastthreadid` `lastthreadid` INT( 11 ) DEFAULT '0' Load time so far: 1.15 seconds. You have an error in your SQL syntax near 'CHANGE `lastthreadid` `lastthreadid` INT( 11 ) DEFAULT '0'' at line 1 Query 259: UPDATE wsnlinks_switches SET value='0' WHERE name='chat' Load time so far: 1.21 seconds. Query 260: SELECT `name` FROM wsnlinks_switches WHERE id>0 Number of rows is 93 Load time so far: 1.22 seconds. Query 261: UPDATE wsnlinks_settings SET content='' WHERE name='rewritecat' Load time so far: 1.23 seconds. Query 262: SELECT `name`,`content` FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC Number of rows is 490

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 49
Total Posts: 5539

Posted 04/14/08 - 12:23 PM:	#2
Looks like somehow -- though it should be logically impossible -- the config.php was updated without the database being updated. You'll need to remove all the post-3.1 tables specified at the end of config.php, save and re-run upgrade.php.

fresco
Experienced

Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 18
Total Posts: 90

Posted 04/16/08 - 02:05 AM:	#3
i figured out what was the problem - i have very old database version 3.23 i think. so what happened is that it demanded sql command to be TYPE=MyISAM, so I added all the missing tables manually - worked fine. actually I did not have to edit templates much - just used old ones - missing a few features but I did not needed those anyway. thanks again

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 49
Total Posts: 5539

Posted 04/16/08 - 01:26 PM:	#4
Random things will work wrong with the old templates that you probably won't notice for a while.

You don't have permission to post.

Please login or register.

Admin Control Panel