I followed the upgrade instructions as I always do....
That's whta the upgrade.php said:
Load time so far: 0.03 seconds.
Query 1: SELECT `name`,`content` FROM archive_settings WHERE id>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>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>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
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'. (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>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>0 ORDER BY id ASC WSN 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.
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
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
Anybody can help me? Please. I am in panic now. Database contains over 1000 links..... :-(
Comments on Upgrade Errors. HELP needed.
Member
Usergroup: Customer
Joined: Jul 02, 2003
Total Topics: 7
Total Comments: 17
Hi,
I followed the upgrade instructions as I always do....
That's whta the upgrade.php said:
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
Anybody can help me? Please. I am in panic now. Database contains over 1000 links..... :-(
Member
Usergroup: Customer
Joined: Jul 02, 2003
Total Topics: 7
Total Comments: 17
Now I deleted the old sessions via phpmyadmin, installed an old backup for the sessions and run upgrade.php again.
Not I have no more errors on the index page.
But I still get the 404 error if I try to reach /admin/?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Can't open file: 'archive_sessions.MYI'. (errno: 145)
This means your mysql database has errors. Try repairing the database.
But I still get the 404 error if I try to reach /admin/?
Do you have files in /admin/? If so, test deleting your .htaccess if you have one.
Member
Usergroup: Customer
Joined: Jul 02, 2003
Total Topics: 7
Total Comments: 17
Deleting the htaccess was the solution.
Thank you :-)