Webmastersite.net
Register Log In

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



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