Upgrade Errors. HELP needed.: WSN Support Forums

Upgrade Errors. HELP needed.
Upgrade 4.0.28--->4.0.31

Comments on Upgrade Errors. HELP needed.

•isto Member Usergroup: Customer Joined: Jul 02, 2003 Total Topics: 7 Total Comments: 17	•isto #1 - Quote - Permalink Posted Jun 11, 2007 - 2:19 PM: Hi, 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 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'. (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 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. 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..... :-(
•isto Member Usergroup: Customer Joined: Jul 02, 2003 Total Topics: 7 Total Comments: 17	•isto #2 - Quote - Permalink Posted Jun 11, 2007 - 2:28 PM: 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/?
•Paul developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7868	•Paul #3 - Quote - Permalink Posted Jun 11, 2007 - 10:02 PM: 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.
•isto Member Usergroup: Customer Joined: Jul 02, 2003 Total Topics: 7 Total Comments: 17	•isto #4 - Quote - Permalink Posted Jun 18, 2007 - 3:15 PM: Deleting the htaccess was the solution. Thank you :-)

This thread is closed, so you cannot post a reply.