mySQL error on upgrade: WSN Support Forums

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

Comments on mySQL error on upgrade

•fresco Forum Regular Usergroup: Customer Joined: Feb 19, 2003 Total Topics: 23 Total Comments: 106	•fresco #1 - Quote - Permalink Posted Apr 14, 2008 - 2:06 AM: 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,recipurl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,hitsin,voterips,voterids,keywords,lastedit,type,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,recipwith,alias,expire,ip,inalbum,typeorder,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,country,states,city,travel,ecommerce,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,pollid,posticon,savedby,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime,tags,xmlsource,ordercomments,lastpadupdate,padfile,lastmonthlycheck,invisibleto,profileurl,lastprofileurl,timesrenewed,timedeleted Load time so far: 0.38 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,moderators,lastedit,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,linksperpage,wysihtml,numonline,sponsorship,lastprofileurl,defaultnoaccess,lastthreadurl,lastposturl Load time so far: 0.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,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,images,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,traderrating,invitessent,validatedemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader Load time so far: 0.39 seconds. Query 6: SHOW COLUMNS FROM wsnlinks_membergroups Getting field list for table wsnlinks_membergroups: id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,numinv,allowugspec,validateemails,validatesponsorlinks,cansubmittags,candeletetags,cansubmitfeeds,validatefeeds,validatefeeditems,numaliasestot,shoutsperday,validatetrader,renewdays,renewtimes,canviewownfulltrc,canviewallfulltrc Load time so far: 0.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,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,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,replacementclose,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,destination,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/databases/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/databases/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/databases/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/databases/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/databases/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/databases/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/databases/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/databases/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,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised,internalto,hasinternal,invisibleto,hostname Load time so far: 0.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,deleted,attachment,flag,filefield,important,replyto,replied,sentdeleted,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/databases/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/databases/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/databases/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/databases/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/databases/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/databases/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/databases/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/databases/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,validated,recipurl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,hitsin,voterips,voterids,keywords,lastedit,type,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,recipwith,alias,expire,ip,inalbum,typeorder,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,country,states,city,travel,ecommerce,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,pollid,posticon,savedby,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime,tags,xmlsource,ordercomments,lastpadupdate,padfile,lastmonthlycheck,invisibleto,profileurl,lastprofileurl,timesrenewed,timedeleted' WHERE name='linkfields' Load time so far: 0.42 seconds. Query 34: UPDATE wsnlinks_settings SET content='id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,moderators,lastedit,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,linksperpage,wysihtml,numonline,sponsorship,lastprofileurl,defaultnoaccess,lastthreadurl,lastposturl' WHERE name='categoryfields' Load time so far: 0.43 seconds. Query 35: UPDATE wsnlinks_settings SET content='id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,images,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,traderrating,invitessent,validatedemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader' WHERE name='memberfields' Load time so far: 0.43 seconds. Query 36: UPDATE wsnlinks_settings SET content='id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,numinv,allowugspec,validateemails,validatesponsorlinks,cansubmittags,candeletetags,cansubmitfeeds,validatefeeds,validatefeeditems,numaliasestot,shoutsperday,validatetrader,renewdays,renewtimes,canviewownfulltrc,canviewallfulltrc' WHERE name='usergroupfields' Load time so far: 0.5 seconds. Query 37: UPDATE wsnlinks_settings SET content='id,to,subject,message,headers,timesent,ip,replacement,mime' WHERE name='emailfields' Load time so far: 0.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,profileurl' WHERE name='sessionfields' Load time so far: 0.51 seconds. Query 39: UPDATE wsnlinks_settings SET content='id,votevalue,time,memberid,ip,custom,linkid,type' WHERE name='ratingfields' Load time so far: 0.51 seconds. Query 40: UPDATE wsnlinks_settings SET content='id,type,original,replacement,description,originalclose,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,moderatorid,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,deleted' 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,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised,internalto,hasinternal,invisibleto,hostname' WHERE name='commentfields' Load time so far: 0.62 seconds. Query 54: UPDATE wsnlinks_settings SET content='id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,attachment,flag,filefield,important,replyto,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`,`originalclose`,`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`,`validatelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategories`,`cansubmitcomments`,`caneditownlinks`,`caneditowncategories`,`caneditowncomments`,`caneditownprofile`,`caneditalllinks`,`caneditallcategories`,`caneditallcomments`,`caneditallprofiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitlinks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`canalias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit`,`candeletecategories`,`candeletecomments`,`candeleteowncategories`,`candeleteowncomments`,`candeletemembers`,`candeleteownmembers`,`canaliascategories`,`canviewpages`,`caneditvotes`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideowncategories`,`canhideowncomments`,`canhidealllinks`,`canhideallcategories`,`canhideallcomments`,`canratecomments`,`bytespermem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpmsdaily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`candeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachperpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`caneditownshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmitshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`namestyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubmitquotes`,`validatequotes`,`candeletequotes`,`candeleteownquotes`,`canreport`,`canusesearch`,`attachperlink`,`validateattachments`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansubmitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot`,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes`,`canviewownfulltrc`,`canviewallfulltrc` FROM wsnlinks_membergroups WHERE id>0 Load time so far: 0.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,recipurl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,hitsin,voterips,voterids,keywords,lastedit,type,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,recipwith,alias,expire,ip,inalbum,typeorder,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,country,states,city,travel,ecommerce,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,pollid,posticon,savedby,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime,tags,xmlsource,ordercomments,lastpadupdate,padfile,lastmonthlycheck,invisibleto,profileurl,lastprofileurl,timesrenewed,timedeleted Load time so far: 0.8 seconds. Query 67: SHOW COLUMNS FROM wsnlinks_categories Getting field list for table wsnlinks_categories: id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,moderators,lastedit,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,linksperpage,wysihtml,numonline,sponsorship,lastprofileurl,defaultnoaccess,lastthreadurl,lastposturl Load time so far: 0.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,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,images,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,traderrating,invitessent,validatedemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader Load time so far: 0.81 seconds. Query 69: SHOW COLUMNS FROM wsnlinks_membergroups Getting field list for table wsnlinks_membergroups: id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,numinv,allowugspec,validateemails,validatesponsorlinks,cansubmittags,candeletetags,cansubmitfeeds,validatefeeds,validatefeeditems,numaliasestot,shoutsperday,validatetrader,renewdays,renewtimes,canviewownfulltrc,canviewallfulltrc Load time so far: 0.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,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,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,replacementclose,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,destination,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/databases/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/databases/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/databases/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/databases/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/databases/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/databases/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/databases/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/databases/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,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised,internalto,hasinternal,invisibleto,hostname Load time so far: 0.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,deleted,attachment,flag,filefield,important,replyto,replied,sentdeleted,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/databases/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/databases/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/databases/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/databases/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/databases/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/databases/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/databases/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/databases/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,validated,recipurl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,hitsin,voterips,voterids,keywords,lastedit,type,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,recipwith,alias,expire,ip,inalbum,typeorder,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,country,states,city,travel,ecommerce,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,pollid,posticon,savedby,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime,tags,xmlsource,ordercomments,lastpadupdate,padfile,lastmonthlycheck,invisibleto,profileurl,lastprofileurl,timesrenewed,timedeleted' WHERE name='linkfields' Load time so far: 0.86 seconds. Query 97: UPDATE wsnlinks_settings SET content='id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,moderators,lastedit,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,linksperpage,wysihtml,numonline,sponsorship,lastprofileurl,defaultnoaccess,lastthreadurl,lastposturl' WHERE name='categoryfields' Load time so far: 0.87 seconds. Query 98: 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,images,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,traderrating,invitessent,validatedemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader' WHERE name='memberfields' Load time so far: 0.87 seconds. Query 99: UPDATE wsnlinks_settings SET content='id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,numinv,allowugspec,validateemails,validatesponsorlinks,cansubmittags,candeletetags,cansubmitfeeds,validatefeeds,validatefeeditems,numaliasestot,shoutsperday,validatetrader,renewdays,renewtimes,canviewownfulltrc,canviewallfulltrc' WHERE name='usergroupfields' Load time so far: 0.87 seconds. Query 100: UPDATE wsnlinks_settings SET content='id,to,subject,message,headers,timesent,ip,replacement,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,profileurl' WHERE name='sessionfields' Load time so far: 0.88 seconds. Query 102: UPDATE wsnlinks_settings SET content='id,votevalue,time,memberid,ip,custom,linkid,type' WHERE name='ratingfields' Load time so far: 0.89 seconds. Query 103: UPDATE wsnlinks_settings SET content='id,type,original,replacement,description,originalclose,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,moderatorid,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,deleted' 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,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised,internalto,hasinternal,invisibleto,hostname' WHERE name='commentfields' Load time so far: 0.97 seconds. Query 117: UPDATE wsnlinks_settings SET content='id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,attachment,flag,filefield,important,replyto,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 developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7868	•Paul #2 - Quote - Permalink Posted Apr 14, 2008 - 2:23 PM: 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 Forum Regular Usergroup: Customer Joined: Feb 19, 2003 Total Topics: 23 Total Comments: 106	•fresco #3 - Quote - Permalink Posted Apr 16, 2008 - 4:05 AM: 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 developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7868	•Paul #4 - Quote - Permalink Posted Apr 16, 2008 - 3:26 PM: Random things will work wrong with the old templates that you probably won't notice for a while.

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