<?xml version="1.0" encoding="utf-8"?>
<?xml-stylesheet type="text/css" href="https://www.webmastersite.net/forums/templates/bootstrap/rss.css" ?>
<rss version="2.0"
 xmlns:content="http://purl.org/rss/1.0/modules/content/"
 xmlns:media="http://search.yahoo.com/mrss/"
 xmlns:atom="http://www.w3.org/2005/Atom"
 xmlns:georss="http://www.georss.org/georss"> 
<channel>
<title>WebmasterSite.net</title>
<link>https://www.webmastersite.net/forums</link>
<description></description>
<language>en-us</language>
<atom:link href="https://www.webmastersite.net/forums/rssfeed.php?thecondition=ownerid%3D656" rel="self" type="application/rss+xml" />

<item>
<title>Upgrade.php -nothing happens</title>
<description>I tried to manually update from 4.1.80 to 5.0.80. Everything uploaded except the templates files (except templates/admin).</description>
<link>https://www.webmastersite.net/forums/threads/upgradephp-nothing-happens-9081.html</link>
<pubDate>Fri, 10 Sep 2010 19:50:47 GMT</pubDate>
<guid>https://www.webmastersite.net/forums/thread/9081/</guid>
<content:encoded><![CDATA[I tried to manually update from 4.1.80 to 5.0.80.
Everything uploaded except the templates files (except templates/admin). And then <a href="http://yourinstallpath/upgrade.php" rel="nofollow" target="_blank">http://yourinstallpath/upgrade.php</a>. 
But nothing happens, it loads and loads and loads, but no changes are made and no text or change is appearing on the update site.

When visiting the admin-panel it says that I is up-to-date now, but the upgrade.php has not run yet finally.]]></content:encoded>
<comments>https://www.webmastersite.net/forums/threads/upgradephp-nothing-happens-9081.html</comments>   
</item>

<item>
<title>Category double in sub</title>
<description><![CDATA[After upgrading from 4.1.6.0 to 4.1.6.4 I have a strange fault in my directoy:

all categories work fine except for one.

This one is has its category name two times. First as normal category and below it appears as if there is a subcategory with the same name. If you click at the subcategory, you will be transfered to the main category. And in this category there is no subcategory to edit.

How can I remove this unwanted double?

All other categories (categories with no subcategories and categories with subcategories) are fine. ]]></description>
<link>https://www.webmastersite.net/forums/threads/category-double-in-sub-8350.html</link>
<pubDate>Sat, 30 Aug 2008 14:14:24 GMT</pubDate>
<guid>https://www.webmastersite.net/forums/thread/8350/</guid>
<content:encoded><![CDATA[After upgrading from 4.1.6.0 to 4.1.6.4 I have a strange fault in my directoy:

all categories work fine except for one.

This one is has its category name two times. First as normal category and below it appears as if there is a subcategory with the same name. If you click at the subcategory, you will be transfered to the main category. And in this category there is no subcategory to edit.

How can I remove this unwanted double?

All other categories (categories with no subcategories and categories with subcategories) are fine. ]]></content:encoded>
<comments>https://www.webmastersite.net/forums/threads/category-double-in-sub-8350.html</comments>   
</item>

<item>
<title>Upgrade Errors. HELP needed.</title>
<description><![CDATA[Hi,

I followed the upgrade instructions as I always do....

That&#039;s whta the upgrade.php said:

[code]Load time so far: 0.03 seconds.

Query 1: SELECT `name`,`content` FROM archive_settings WHERE id0 ORDER BY id ASC

Query 2: SHOW COLUMNS FROM archive_links

Getting field list for table archive_links: id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,notify,suspect,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,downloads,pollid,posticon,savedby,filesizekb,titlede,descriptionde,mirror,offsite,filetype,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime

Load time so far: 0.05 seconds.

Query 3: SHOW COLUMNS FROM archive_categories

Getting field list for table archive_categories: id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,alias,catcols,linkcols,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,catimage,descriptionde,namede,ulsearchmax,ulsearchquery,ulsearchadult,dmozpath,linksperpage,wysihtml,numonline

Load time so far: 0.05 seconds.

Query 4: SHOW COLUMNS FROM archive_members

Getting field list for table archive_members: id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,traderrating,invitessent,validatedemail,newemail,calsub,macros

Load time so far: 0.05 seconds.

Query 5: SHOW COLUMNS FROM archive_membergroups

Getting field list for table archive_membergroups: id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,numinv,allowugspec,validateemails,validatesponsorlinks

Load time so far: 0.05 seconds.

Query 6: SHOW COLUMNS FROM archive_sessions

Getting field list for table archive_sessions:

Load time so far: 0.05 seconds.

Can&#039;t open file: &#039;archive_sessions.MYI&#039;. (errno: 145)

Load time so far: 0.1 seconds.

Can&#039;t open file: &#039;archive_sessions.MYI&#039;. (errno: 145)

Query 7: SELECT `id` FROM archive_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1

Number of rows is 1

Load time so far: 0.1 seconds.

Query 8: UPDATE archive_settings SET content=&#039;116&#039; WHERE name=&#039;highestcatindex&#039;

Load time so far: 0.11 seconds.

Query 9: SELECT `name`,`value` FROM archive_switches WHERE id0

Number of rows is 72

Query 10: SHOW COLUMNS FROM archive_email

Getting field list for table archive_email: id,to,subject,message,headers,timesent,ip,replacement,mime

Load time so far: 0.11 seconds.

Query 11: SHOW COLUMNS FROM archive_ratings

Getting field list for table archive_ratings: id,votevalue,time,memberid,ip,custom,linkid,type

Load time so far: 0.11 seconds.

Query 12: SHOW COLUMNS FROM archive_markup

Getting field list for table archive_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder

Load time so far: 0.11 seconds.

Query 13: SHOW COLUMNS FROM archive_modlog

Getting field list for table archive_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid

Load time so far: 0.11 seconds.

Query 14: SHOW COLUMNS FROM archive_crons

Getting field list for table archive_crons: id,frequency,nextrun,filename,native

Load time so far: 0.11 seconds.

Query 15: SHOW COLUMNS FROM archive_helpcategory

Getting field list for table archive_helpcategory: id,name,numsubjects,priority

Load time so far: 0.11 seconds.

Query 16: SHOW COLUMNS FROM archive_helpitem

Getting field list for table archive_helpitem: id,subject,helptext,priority,category

Load time so far: 0.11 seconds.

Query 17: SHOW COLUMNS FROM archive_searches

Getting field list for table archive_searches: id,value,memberid,catid,time

Load time so far: 0.11 seconds.

Query 18: SHOW COLUMNS FROM archive_comments

Getting field list for table archive_comments: id,linkid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised

Load time so far: 0.11 seconds.

Load time so far: 0.11 seconds.

Query 19: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM archive_markup WHERE type=&#039;wsncode&#039; ORDER BY sortorder

Number of rows is 22

Query 20: SHOW COLUMNS FROM archive_attachments

Getting field list for table archive_attachments: id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid

Load time so far: 0.12 seconds.

Load time so far: 0.12 seconds.

Query 21: SELECT `id`,`title`,`caneditown`,`caneditall`,`canvote`,`isadmin`,`canpost`,`canemail`,`validatecats`,`validatecomments`,`validatelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategories`,`cansubmitcomments`,`caneditownlinks`,`caneditowncategories`,`caneditowncomments`,`caneditownprofile`,`caneditalllinks`,`caneditallcategories`,`caneditallcomments`,`caneditallprofiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitlinks`,`canemailmembers`,`canusehtml`,
`limitlinksdaily`,`canalias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit`,`candeletecategories`,`candeletecomments`,`candeleteowncategories`,`candeleteowncomments`,`candeletemembers`,`candeleteownmembers`,`canaliascategories`,`canviewpages`,`caneditvotes`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideowncategories`,`canhideowncomments`,`canhidealllinks`,`canhideallcategories`,`canhideallcomments`,`canratecomments`,`bytespermem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpmsdaily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`candeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachperpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`caneditownshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmitshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`namestyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubmitquotes`,`validatequotes`,`candeletequotes`,`candeleteownquotes`,`canreport`,`canusesearch`,`attachperlink`,`validateattachments`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks` FROM archive_membergroups WHERE id0

Load time so far: 0.12 seconds.

Query 22: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`macros` FROM archive_members WHERE id=1 AND validated=1

Load time so far: 0.14 seconds.

Query 23: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM archive_markup WHERE type=&#039;smilie&#039; ORDER BY sortorder

Number of rows is 14

Query 24: LOCK TABLES archive_email WRITE, archive_links WRITE, archive_categories WRITE, archive_members WRITE

Load time so far: 0.22 seconds.

Query 25: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM archive_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10

Number of rows is 0

Query 26: UNLOCK TABLES

Query 27: SHOW COLUMNS FROM archive_links

Getting field list for table archive_links: id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,notify,suspect,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,downloads,pollid,posticon,savedby,filesizekb,titlede,descriptionde,mirror,offsite,filetype,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime

Load time so far: 0.24 seconds.

Query 28: SHOW COLUMNS FROM archive_categories

Getting field list for table archive_categories: id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,alias,catcols,linkcols,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,catimage,descriptionde,namede,ulsearchmax,ulsearchquery,ulsearchadult,dmozpath,linksperpage,wysihtml,numonline

Load time so far: 0.24 seconds.

Query 29: SHOW COLUMNS FROM archive_comments

Getting field list for table archive_comments: id,linkid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised

Load time so far: 0.24 seconds.

Query 30: SHOW COLUMNS FROM archive_members

Getting field list for table archive_members: id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,traderrating,invitessent,validatedemail,newemail,calsub,macros

Load time so far: 0.24 seconds.

Query 31: SHOW COLUMNS FROM archive_helpcategory

Getting field list for table archive_helpcategory: id,name,numsubjects,priority

Load time so far: 0.24 seconds.

Query 32: SHOW COLUMNS FROM archive_helpitem

Getting field list for table archive_helpitem: id,subject,helptext,priority,category

Load time so far: 0.24 seconds.

Query 33: SHOW COLUMNS FROM archive_im

Getting field list for table archive_im: id,toid,fromid,message,time,isread,timeread,deleted

Load time so far: 0.24 seconds.

Query 34: SHOW COLUMNS FROM archive_pm

Getting field list for table archive_pm: id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,flag,filefield,important,replyto,replied,sentdeleted,wysihtml,cc

Load time so far: 0.24 seconds.

Query 35: SHOW COLUMNS FROM archive_calendar

Getting field list for table archive_calendar: id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time

Load time so far: 0.29 seconds.

Query 36: SHOW COLUMNS FROM archive_trader

Getting field list for table archive_trader: id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments

Load time so far: 0.31 seconds.

Query 37: SHOW COLUMNS FROM archive_invites

Getting field list for table archive_invites: id,inviter,invitee,time,usergroup,taken,code

Load time so far: 0.32 seconds.

Query 38: SHOW COLUMNS FROM archive_searches

Getting field list for table archive_searches: id,value,memberid,catid,time

Load time so far: 0.32 seconds.

Query 39: SHOW COLUMNS FROM archive_membergroups

Getting field list for table archive_membergroups: id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,numinv,allowugspec,validateemails,validatesponsorlinks

Load time so far: 0.32 seconds.

Query 40: SHOW COLUMNS FROM archive_email

Getting field list for table archive_email: id,to,subject,message,headers,timesent,ip,replacement,mime

Load time so far: 0.32 seconds.

Query 41: SHOW COLUMNS FROM archive_sessions

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /xxx/databases/mysql.php on line 19

Getting field list for table archive_sessions:

Load time so far: 0.32 seconds.

Can&#039;t open file: &#039;archive_sessions.MYI. (errno: 145)

Query 42: SHOW COLUMNS FROM archive_ratings

Getting field list for table archive_ratings: id,votevalue,time,memberid,ip,custom,linkid,type

Load time so far: 0.32 seconds.

Query 43: SHOW COLUMNS FROM archive_markup

Getting field list for table archive_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder

Load time so far: 0.33 seconds.

Query 44: SHOW COLUMNS FROM archive_modlog

Getting field list for table archive_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid

Load time so far: 0.33 seconds.

Query 45: SHOW COLUMNS FROM archive_attachments

Getting field list for table archive_attachments: id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid

Load time so far: 0.33 seconds.

Query 46: SHOW COLUMNS FROM archive_crons

Getting field list for table archive_crons: id,frequency,nextrun,filename,native

Load time so far: 0.33 seconds.

Query 47: ALTER TABLE `archive_sessions` ADD `id` int default &#039;0&#039; NOT NULL auto_increment

Query 48: ALTER TABLE `archive_sessions` ADD `memberid` int default &#039;0&#039; NOT NULL

Query 49: ALTER TABLE `archive_sessions` ADD `location` text NOT NULL

Query 50: ALTER TABLE `archive_sessions` ADD `time` int default &#039;0&#039; NOT NULL

Query 51: ALTER TABLE `archive_sessions` ADD `ip` text NOT NULL

Query 52: ALTER TABLE `archive_sessions` ADD `browser` text NOT NULL

Query 53: ALTER TABLE `archive_sessions` ADD `starttime` int default &#039;0&#039; NOT NULL

Query 54: ALTER TABLE `archive_sessions` ADD `catid` int default &#039;0&#039; NOT NULL

Query 55: ALTER TABLE `archive_sessions` ADD `threadid` int default &#039;0&#039; NOT NULL

Query 56: ALTER TABLE `archive_sessions` ADD `areaname` text NOT NULL

Query 57: ALTER TABLE `archive_sessions` ADD `lastsearch` int default &#039;0&#039; NOT NULL

Query 58: ALTER TABLE `archive_sessions` ADD `nopermission` int default &#039;0&#039; NOT NULL

Query 59: ALTER TABLE `archive_sessions` ADD `inchat` tinyint

Query 60: ALTER TABLE `archive_sessions` ADD `name` varchar(255) NOT NULL

Query 61: ALTER TABLE `archive_sessions` ADD `isrobot` int default &#039;0&#039; NOT NULL

Query 62: ALTER TABLE `archive_sessions` ADD `lastchat` int default &#039;0&#039; NOT NULL

Query 63: ALTER TABLE `archive_sessions` ADD `groupnamestyle` varchar(255) NOT NULL

Query 64: ALTER TABLE `archive_sessions` ADD `acceptims` varchar(255) NOT NULL

Query 65: ALTER TABLE `archive_sessions` ADD `visibility` varchar(255) NOT NULL

Load time so far: 0.34 seconds.

Can&#039;t open file: &#039;archive_sessions.MYI&#039;. (errno: 145)

Query 66: UPDATE archive_members SET banned = &#039;&#039; WHERE banned = &#039;0&#039;

Load time so far: 0.34 seconds.

Query 67: UPDATE archive_switches SET value=&#039;0&#039; WHERE name=&#039;chat&#039;

Load time so far: 0.36 seconds.

Query 68: SELECT `name` FROM archive_switches WHERE id0

Number of rows is 72

Load time so far: 0.36 seconds.

Query 69: UPDATE archive_membergroups SET numaliases=&#039;10&#039; WHERE numaliases=&#039;&#039;

Load time so far: 0.36 seconds.

Query 70: SELECT `name`,`content` FROM archive_settings WHERE id0 ORDER BY id ASC
WSN Upgrade

Administrative account verified... starting upgrade.

Adding online user fields: id memberid location time ip browser starttime catid threadid areaname lastsearch nopermission inchat name isrobot lastchat groupnamestyle acceptims visibility

Done adding fields.

No new switches need to be added.

Added these items to Deutsch:

Added these items to English:

Done appending languages.

Attempting to CHMOD new templates for you...


Upgrade complete. Have a look at what changed above, then check your settings in case there are new options you can make use of.[/code]



Now I have following problems:

first I can&#039;t access admin. There is no admin page. Only a 404 error although all necessary files are on the webspace.

Second, I get the following error code on the index site

[code]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /xxx/databases/mysql.php on line 19

Warning: Cannot modify header information - headers already sent by (output started at /xxx/databases/mysql.php:19) in /xxx/commonfuncs.php on line 727

Warning: Cannot modify header information - headers already sent by (output started at /xxx/databases/mysql.php:19) in /xxx/commonfuncs.php on line 731

Warning: Cannot modify header information - headers already sent by (output started at /xxx/databases/mysql.php:19) in /xxx/end.php on line 146

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /xxx/databases/mysql.php on line 22

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /xxx/databases/mysql.php on line 22

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /xxx/databases/mysql.php on line 22

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /xxx/databases/mysql.php on line 19

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /xxx/databases/mysql.php on line 19

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /xxx/databases/mysql.php on line 19[/code]



Anybody can help me? Please. I am in panic now. Database contains over 1000 links..... :-(]]></description>
<link>https://www.webmastersite.net/forums/threads/upgrade-errors-help-needed-7403.html</link>
<pubDate>Mon, 11 Jun 2007 21:19:40 GMT</pubDate>
<guid>https://www.webmastersite.net/forums/thread/7403/</guid>
<content:encoded><![CDATA[Hi,

I followed the upgrade instructions as I always do....

That's whta the upgrade.php said:

<pre class="code">Load time so far: 0.03 seconds.

Query 1: SELECT `name`,`content` FROM archive_settings WHERE id&#62;0 ORDER BY id ASC

Query 2: SHOW COLUMNS FROM archive_links

Getting field list for table archive_links: id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,notify,suspect,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,downloads,pollid,posticon,savedby,filesizekb,titlede,descriptionde,mirror,offsite,filetype,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime

Load time so far: 0.05 seconds.

Query 3: SHOW COLUMNS FROM archive_categories

Getting field list for table archive_categories: id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,alias,catcols,linkcols,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,catimage,descriptionde,namede,ulsearchmax,ulsearchquery,ulsearchadult,dmozpath,linksperpage,wysihtml,numonline

Load time so far: 0.05 seconds.

Query 4: SHOW COLUMNS FROM archive_members

Getting field list for table archive_members: id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,traderrating,invitessent,validatedemail,newemail,calsub,macros

Load time so far: 0.05 seconds.

Query 5: SHOW COLUMNS FROM archive_membergroups

Getting field list for table archive_membergroups: id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,numinv,allowugspec,validateemails,validatesponsorlinks

Load time so far: 0.05 seconds.

Query 6: SHOW COLUMNS FROM archive_sessions

Getting field list for table archive_sessions:

Load time so far: 0.05 seconds.

Can't open file: 'archive_sessions.MYI'. (errno: 145)

Load time so far: 0.1 seconds.

Can't open file: 'archive_sessions.MYI'. (errno: 145)

Query 7: SELECT `id` FROM archive_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1

Number of rows is 1

Load time so far: 0.1 seconds.

Query 8: UPDATE archive_settings SET content='116' WHERE name='highestcatindex'

Load time so far: 0.11 seconds.

Query 9: SELECT `name`,`value` FROM archive_switches WHERE id&#62;0

Number of rows is 72

Query 10: SHOW COLUMNS FROM archive_email

Getting field list for table archive_email: id,to,subject,message,headers,timesent,ip,replacement,mime

Load time so far: 0.11 seconds.

Query 11: SHOW COLUMNS FROM archive_ratings

Getting field list for table archive_ratings: id,votevalue,time,memberid,ip,custom,linkid,type

Load time so far: 0.11 seconds.

Query 12: SHOW COLUMNS FROM archive_markup

Getting field list for table archive_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder

Load time so far: 0.11 seconds.

Query 13: SHOW COLUMNS FROM archive_modlog

Getting field list for table archive_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid

Load time so far: 0.11 seconds.

Query 14: SHOW COLUMNS FROM archive_crons

Getting field list for table archive_crons: id,frequency,nextrun,filename,native

Load time so far: 0.11 seconds.

Query 15: SHOW COLUMNS FROM archive_helpcategory

Getting field list for table archive_helpcategory: id,name,numsubjects,priority

Load time so far: 0.11 seconds.

Query 16: SHOW COLUMNS FROM archive_helpitem

Getting field list for table archive_helpitem: id,subject,helptext,priority,category

Load time so far: 0.11 seconds.

Query 17: SHOW COLUMNS FROM archive_searches

Getting field list for table archive_searches: id,value,memberid,catid,time

Load time so far: 0.11 seconds.

Query 18: SHOW COLUMNS FROM archive_comments

Getting field list for table archive_comments: id,linkid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised

Load time so far: 0.11 seconds.

Load time so far: 0.11 seconds.

Query 19: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM archive_markup WHERE type='wsncode' ORDER BY sortorder

Number of rows is 22

Query 20: SHOW COLUMNS FROM archive_attachments

Getting field list for table archive_attachments: id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid

Load time so far: 0.12 seconds.

Load time so far: 0.12 seconds.

Query 21: SELECT `id`,`title`,`caneditown`,`caneditall`,`canvote`,`isadmin`,`canpost`,`canemail`,`validatecats`,`validatecomments`,`validatelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategories`,`cansubmitcomments`,`caneditownlinks`,`caneditowncategories`,`caneditowncomments`,`caneditownprofile`,`caneditalllinks`,`caneditallcategories`,`caneditallcomments`,`caneditallprofiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitlinks`,`canemailmembers`,`canusehtml`,
`limitlinksdaily`,`canalias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit`,`candeletecategories`,`candeletecomments`,`candeleteowncategories`,`candeleteowncomments`,`candeletemembers`,`candeleteownmembers`,`canaliascategories`,`canviewpages`,`caneditvotes`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideowncategories`,`canhideowncomments`,`canhidealllinks`,`canhideallcategories`,`canhideallcomments`,`canratecomments`,`bytespermem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpmsdaily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`candeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachperpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`caneditownshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmitshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`namestyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubmitquotes`,`validatequotes`,`candeletequotes`,`candeleteownquotes`,`canreport`,`canusesearch`,`attachperlink`,`validateattachments`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks` FROM archive_membergroups WHERE id&#62;0

Load time so far: 0.12 seconds.

Query 22: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`macros` FROM archive_members WHERE id=1 AND validated=1

Load time so far: 0.14 seconds.

Query 23: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM archive_markup WHERE type='smilie' ORDER BY sortorder

Number of rows is 14

Query 24: LOCK TABLES archive_email WRITE, archive_links WRITE, archive_categories WRITE, archive_members WRITE

Load time so far: 0.22 seconds.

Query 25: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM archive_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10

Number of rows is 0

Query 26: UNLOCK TABLES

Query 27: SHOW COLUMNS FROM archive_links

Getting field list for table archive_links: id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,notify,suspect,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,downloads,pollid,posticon,savedby,filesizekb,titlede,descriptionde,mirror,offsite,filetype,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime

Load time so far: 0.24 seconds.

Query 28: SHOW COLUMNS FROM archive_categories

Getting field list for table archive_categories: id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,alias,catcols,linkcols,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,catimage,descriptionde,namede,ulsearchmax,ulsearchquery,ulsearchadult,dmozpath,linksperpage,wysihtml,numonline

Load time so far: 0.24 seconds.

Query 29: SHOW COLUMNS FROM archive_comments

Getting field list for table archive_comments: id,linkid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged,wysihtml,unrevised

Load time so far: 0.24 seconds.

Query 30: SHOW COLUMNS FROM archive_members

Getting field list for table archive_members: id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,traderrating,invitessent,validatedemail,newemail,calsub,macros

Load time so far: 0.24 seconds.

Query 31: SHOW COLUMNS FROM archive_helpcategory

Getting field list for table archive_helpcategory: id,name,numsubjects,priority

Load time so far: 0.24 seconds.

Query 32: SHOW COLUMNS FROM archive_helpitem

Getting field list for table archive_helpitem: id,subject,helptext,priority,category

Load time so far: 0.24 seconds.

Query 33: SHOW COLUMNS FROM archive_im

Getting field list for table archive_im: id,toid,fromid,message,time,isread,timeread,deleted

Load time so far: 0.24 seconds.

Query 34: SHOW COLUMNS FROM archive_pm

Getting field list for table archive_pm: id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,flag,filefield,important,replyto,replied,sentdeleted,wysihtml,cc

Load time so far: 0.24 seconds.

Query 35: SHOW COLUMNS FROM archive_calendar

Getting field list for table archive_calendar: id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time

Load time so far: 0.29 seconds.

Query 36: SHOW COLUMNS FROM archive_trader

Getting field list for table archive_trader: id,ratingof,ratingby,value,summary,report,time,type,linkid,morecomments

Load time so far: 0.31 seconds.

Query 37: SHOW COLUMNS FROM archive_invites

Getting field list for table archive_invites: id,inviter,invitee,time,usergroup,taken,code

Load time so far: 0.32 seconds.

Query 38: SHOW COLUMNS FROM archive_searches

Getting field list for table archive_searches: id,value,memberid,catid,time

Load time so far: 0.32 seconds.

Query 39: SHOW COLUMNS FROM archive_membergroups

Getting field list for table archive_membergroups: id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,numinv,allowugspec,validateemails,validatesponsorlinks

Load time so far: 0.32 seconds.

Query 40: SHOW COLUMNS FROM archive_email

Getting field list for table archive_email: id,to,subject,message,headers,timesent,ip,replacement,mime

Load time so far: 0.32 seconds.

Query 41: SHOW COLUMNS FROM archive_sessions

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /xxx/databases/mysql.php on line 19

Getting field list for table archive_sessions:

Load time so far: 0.32 seconds.

Can't open file: 'archive_sessions.MYI&#
39;. (errno: 145)

Query 42: SHOW COLUMNS FROM archive_ratings

Getting field list for table archive_ratings: id,votevalue,time,memberid,ip,custom,linkid,type

Load time so far: 0.32 seconds.

Query 43: SHOW COLUMNS FROM archive_markup

Getting field list for table archive_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder

Load time so far: 0.33 seconds.

Query 44: SHOW COLUMNS FROM archive_modlog

Getting field list for table archive_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid

Load time so far: 0.33 seconds.

Query 45: SHOW COLUMNS FROM archive_attachments

Getting field list for table archive_attachments: id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid

Load time so far: 0.33 seconds.

Query 46: SHOW COLUMNS FROM archive_crons

Getting field list for table archive_crons: id,frequency,nextrun,filename,native

Load time so far: 0.33 seconds.

Query 47: ALTER TABLE `archive_sessions` ADD `id` int default '0' NOT NULL auto_increment

Query 48: ALTER TABLE `archive_sessions` ADD `memberid` int default '0' NOT NULL

Query 49: ALTER TABLE `archive_sessions` ADD `location` text NOT NULL

Query 50: ALTER TABLE `archive_sessions` ADD `time` int default '0' NOT NULL

Query 51: ALTER TABLE `archive_sessions` ADD `ip` text NOT NULL

Query 52: ALTER TABLE `archive_sessions` ADD `browser` text NOT NULL

Query 53: ALTER TABLE `archive_sessions` ADD `starttime` int default '0' NOT NULL

Query 54: ALTER TABLE `archive_sessions` ADD `catid` int default '0' NOT NULL

Query 55: ALTER TABLE `archive_sessions` ADD `threadid` int default '0' NOT NULL

Query 56: ALTER TABLE `archive_sessions` ADD `areaname` text NOT NULL

Query 57: ALTER TABLE `archive_sessions` ADD `lastsearch` int default '0' NOT NULL

Query 58: ALTER TABLE `archive_sessions` ADD `nopermission` int default '0' NOT NULL

Query 59: ALTER TABLE `archive_sessions` ADD `inchat` tinyint

Query 60: ALTER TABLE `archive_sessions` ADD `name` varchar(255) NOT NULL

Query 61: ALTER TABLE `archive_sessions` ADD `isrobot` int default '0' NOT NULL

Query 62: ALTER TABLE `archive_sessions` ADD `lastchat` int default '0' NOT NULL

Query 63: ALTER TABLE `archive_sessions` ADD `groupnamestyle` varchar(255) NOT NULL

Query 64: ALTER TABLE `archive_sessions` ADD `acceptims` varchar(255) NOT NULL

Query 65: ALTER TABLE `archive_sessions` ADD `visibility` varchar(255) NOT NULL

Load time so far: 0.34 seconds.

Can't open file: 'archive_sessions.MYI'. (errno: 145)

Query 66: UPDATE archive_members SET banned = '' WHERE banned = '0'

Load time so far: 0.34 seconds.

Query 67: UPDATE archive_switches SET value='0' WHERE name='chat'

Load time so far: 0.36 seconds.

Query 68: SELECT `name` FROM archive_switches WHERE id&#62;0

Number of rows is 72

Load time so far: 0.36 seconds.

Query 69: UPDATE archive_membergroups SET numaliases='10' WHERE numaliases=''

Load time so far: 0.36 seconds.

Query 70: SELECT `name`,`content` FROM archive_settings WHERE id&#62;0 ORDER BY id ASC
WSN Upgrade

Administrative account verified... starting upgrade.

Adding online user fields: id memberid location time ip browser starttime catid threadid areaname lastsearch nopermission inchat name isrobot lastchat groupnamestyle acceptims visibility

Done adding fields.

No new switches need to be added.

Added these items to Deutsch:

Added these items to English:

Done appending languages.

Attempting to CHMOD new templates for you...


Upgrade complete. Have a look at what changed above, then check your settings in case there are new options you can make use of.</pre>



Now I have following problems:

first I can't access admin. There is no admin page. Only a 404 error although all necessary files are on the webspace.

Second, I get the following error code on the index site

<pre class="code">Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /xxx/databases/mysql.php on line 19

Warning: Cannot modify header information - headers already sent by (output started at /xxx/databases/mysql.php:19) in /xxx/commonfuncs.php on line 727

Warning: Cannot modify header information - headers already sent by (output started at /xxx/databases/mysql.php:19) in /xxx/commonfuncs.php on line 731

Warning: Cannot modify header information - headers already sent by (output started at /xxx/databases/mysql.php:19) in /xxx/end.php on line 146

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /xxx/databases/mysql.php on line 22

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /xxx/databases/mysql.php on line 22

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /xxx/databases/mysql.php on line 22

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /xxx/databases/mysql.php on line 19

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /xxx/databases/mysql.php on line 19

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /xxx/databases/mysql.php on line 19</pre>



Anybody can help me? Please. I am in panic now. Database contains over 1000 links..... :-(]]></content:encoded>
<comments>https://www.webmastersite.net/forums/threads/upgrade-errors-help-needed-7403.html</comments>   
</item>

<item>
<title>Error when trying the top links</title>
<description>Load time so far: 0.13 seconds. Performing query: LOCK TABLES archive_email WRITE, archive_links WRITE, archive_categories WRITE, archive_members WRITE;</description>
<link>https://www.webmastersite.net/forums/threads/error-when-trying-the-top-links-6811.html</link>
<pubDate>Thu, 21 Sep 2006 21:29:39 GMT</pubDate>
<guid>https://www.webmastersite.net/forums/thread/6811/</guid>
<content:encoded><![CDATA[Load time so far: 0.13 seconds.
Performing query: LOCK TABLES archive_email WRITE, archive_links WRITE, archive_categories WRITE, archive_members WRITE;

Load time so far: 0.13 seconds.
Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM archive_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;

Number of rows is 0 for Resource id #47

Load time so far: 0.13 seconds.
Performing query: UNLOCK TABLES;

Load time so far: 0.14 seconds.
Performing query: SELECT id,frequency,filename,nextrun FROM archive_crons WHERE nextrun &#60; 1158873694 ORDER BY id ASC LIMIT 0,1;

Number of rows is 0 for Resource id #49

Load time so far: 0.14 seconds.
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,alias,catcols,linkcols,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,catimage,descriptionde,namede FROM archive_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 AND deleted=0 ORDER BY priority ASC,name ASC LIMIT 0,40;

Number of rows is 12 for Resource id #51

Load time so far: 0.14 seconds.
Performing query: SELECT id FROM archive_categories WHERE parent=0 AND validated=1 AND hide=0 AND deleted=0 ;

Number of rows is 12 for Resource id #52

Setting cookie with name returnto, value <a href="http://www.chevron26.com/archive/index.php?number%5B1%5D=5&thefield%5B1%5D=rating" rel="nofollow" target="_blank">www.chevron26.com/archive/i...D=5&thefield%5B1%5D=rating</a> and duration 1158874595

Load time so far: 0.53 seconds.
Performing query: 
SELECT COUNT(id) FROM archive_sessions WHERE memberid&#62;0 ;

Count is 1

Load time so far: 0.53 seconds.
Performing query: SELECT COUNT(id) FROM archive_sessions WHERE memberid=0 AND isrobot=0 ;

Count is 3

Load time so far: 0.53 seconds.
Performing query: SELECT COUNT(id) FROM archive_sessions WHERE memberid=0 AND isrobot=1 ;

Count is 0

Load time so far: 0.62 seconds.
Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,notify,suspect,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,downloads,pollid,posticon,savedby,filesizekb,titlede,descriptionde,mirror,offsite,filetype FROM archive_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND alias=0 AND inalbum=0 ORDER BY r DESC LIMIT 0,0;


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/htdocs/v124547/archive/classes/database.php on line 108

Number of rows is for Unknown column 'r' in 'order clause'

Load time so far: 0.62 seconds.
Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility FROM archive_sessions WHERE time &#62; 1158872795 AND (memberid&#62;0) ORDER BY a DESC LIMIT 0,a;

Unknown column 'r' in 'order clause'

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/htdocs/v124547/archive/classes/database.php on line 108

Number of rows is for You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'a' at line 1

Load time so far: 0.63 seconds.
Performing query: SELECT COUNT(id) FROM archive_categories WHERE validated=1 AND hide=0 AND parent=0 AND deleted=0 ;

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'a' at line 1
Count is 12


The script shows the top 5 links but when trying to get the top 5 links by top rated or visited, this error appears.]]></content:encoded>
<comments>https://www.webmastersite.net/forums/threads/error-when-trying-the-top-links-6811.html</comments>   
</item>

<item>
<title>Navigation problem</title>
<description><![CDATA[I have a mysterious problem with the navigation.


I have a multilanguage site in english and german.

When visiting a sub-sub-category it shows in enlish

Links  Categoryname  Subcategoryname  Subsubcategoryname

all correct.

When visiting the same sub-sub-Category in german (after switching the language) it shows:

Links  Categoryname  Categoryname  Categoryname

It does show the Categoryname instead of the Subcategoryname and Subsubcategoryname.
]]></description>
<link>https://www.webmastersite.net/forums/threads/navigation-problem-6755.html</link>
<pubDate>Wed, 30 Aug 2006 19:59:22 GMT</pubDate>
<guid>https://www.webmastersite.net/forums/thread/6755/</guid>
<content:encoded><![CDATA[I have a mysterious problem with the navigation.


I have a multilanguage site in english and german.

When visiting a sub-sub-category it shows in enlish

Links &#62; Categoryname &#62; Subcategoryname &#62; Subsubcategoryname

all correct.

When visiting the same sub-sub-Category in german (after switching the language) it shows:

Links &#62; Categoryname &#62; Categoryname &#62; Categoryname

It does show the Categoryname instead of the Subcategoryname and Subsubcategoryname.
]]></content:encoded>
<comments>https://www.webmastersite.net/forums/threads/navigation-problem-6755.html</comments>   
</item>

</channel>
</rss>