Webmastersite.net
Register Log In

Major problems upgrading from 3.3.7
Upgrade.php gives no errors, but pages blank

Comments on Major problems upgrading from 3.3.7

Errk!
Member

Usergroup: Customer
Joined: Nov 26, 2005
Location: MI, USA

Total Topics: 11
Total Comments: 35
Errk!
Posted Sep 18, 2006 - 6:32 PM:

I am upgrading from 3.3.7 to 3.4.3.

I uploaded all of the files except the templates and integration directories, and did upload the default/admin template directory.

I then ran upgrade.php. Here's what I get:

Administrative account verified... starting upgrade.

Done adding fields.

No new switches need to be added.

Done appending languages.

Attempting to CHMOD new templates for you...

Updating stylesheets...


If you have any attachments, they haven't been converted to the new format yet. Click to begin conversion.


...and that's it. Any attempt to go to the login screen, main index, or admin directory results in a blank page...actually I just found I can reach the admin panel if I go directly to admin/index.php. If I try to go to just /admin it tries to go to www.totalsportslinks.com/ho...otalspo/public_html/admin/... - I'm not sure if this reveals anything or not.

Once in the admin panel nothing seems to be wrong; I don't get any errors or anything, at least that I've seen so far.

The site can be seen at www.totalsportslinks.com.
Errk!
Member

Usergroup: Customer
Joined: Nov 26, 2005
Location: MI, USA

Total Topics: 11
Total Comments: 35
Errk!
Posted Sep 18, 2006 - 6:33 PM:

Load time so far: 0.08 seconds.
Performing query: SELECT name,content FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC ;

Load time so far: 0.1 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1;

Number of rows is 1 for Resource id #20

Load time so far: 0.11 seconds.
Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;

Number of rows is 58 for Resource id #37

Load time so far: 0.12 seconds.
Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder ;

Number of rows is 22 for Resource id #40

Load time so far: 0.12 seconds.
Performing query: SELECT original,replacement,description,id,sortorder FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder ;

Number of rows is 14 for Resource id #41

Load time so far: 0.12 seconds.
Performing query: 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 FROM wsnlinks_membergroups WHERE id>0 ;

Load time so far: 0.12 seconds.
Performing query: 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 FROM wsnlinks_members WHERE id=1 AND validated=1 ;

Load time so far: 0.14 seconds.
Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;

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

Number of rows is 0 for Resource id #49

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

Load time so far: 0.14 seconds.
Performing query: SELECT id,frequency,filename,nextrun FROM wsnlinks_crons WHERE nextrun < 1158628565 ORDER BY id ASC LIMIT 0,1;

Number of rows is 0 for Resource id #51

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,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 AND deleted=0 ORDER BY name ASC,subcatshtml ASC LIMIT 0,500;

Number of rows is 8 for Resource id #53

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

Number of rows is 8 for Resource id #54

Setting cookie with name returnto, value Errk!
Member

Usergroup: Customer
Joined: Nov 26, 2005
Location: MI, USA

Total Topics: 11
Total Comments: 35
Errk!
Posted Sep 18, 2006 - 6:51 PM:

I turned debug mode on for admin only - this is what I get when viewing the main index:





Load time so far: 0.14 seconds.
Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;

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

Number of rows is 0 for Resource id #47

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

Load time so far: 0.14 seconds.
Performing query: SELECT id,frequency,filename,nextrun FROM wsnlinks_crons WHERE nextrun < 1158630575 ORDER BY id ASC LIMIT 0,1;

Number of rows is 0 for Resource id #49

Load time so far: 0.15 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,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 AND deleted=0 ORDER BY name ASC,subcatshtml ASC LIMIT 0,500;

Number of rows is 8 for Resource id #51

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

Number of rows is 8 for Resource id #52

Setting cookie with name returnto, value http://www.totalsportslinks.com//index.php and duration 1158631475

Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Sep 18, 2006 - 11:33 PM:

actually I just found I can reach the admin panel if I go directly to admin/index.php. If I try to go to just /admin it tries to go to http://www.totalsportslinks.com/home/totalspo/pub......

That means you have a problem with your .htaccess file, an incorrect rewrite_base value.

See scripts.webmastersite.net/w...nks/wsnmanual/articles/211 , htaccess and file permissions seem the likely suspects.
Errk!
Member

Usergroup: Customer
Joined: Nov 26, 2005
Location: MI, USA

Total Topics: 11
Total Comments: 35
Errk!
Posted Sep 19, 2006 - 12:13 AM:

Does Apache need to be restarted? I've turned mod_rewrite off and deleted htaccess and still get the same thing.
Errk!
Member

Usergroup: Customer
Joined: Nov 26, 2005
Location: MI, USA

Total Topics: 11
Total Comments: 35
Errk!
Posted Sep 19, 2006 - 12:38 AM:

With mod_rewrite turned on and htaccess uploaded I've got the admin vs admin/index.php error cleared up, but the rest of the site is still givng blank pages. Debug mode doesn't give any errors.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Sep 19, 2006 - 4:23 PM:

Should I presume you've tried re-running the upgrade?

That the page has a message about a cookie without debug mode on is very odd.

Is it possible that your host has disabled output buffering? Upload and then view the attached servertest.php , does it say that output buffering fails? I'm pretty sure 3.3.7 used output buffering as well though so the upgrade would have to be incidental.

Attached Files:
Errk!
Member

Usergroup: Customer
Joined: Nov 26, 2005
Location: MI, USA

Total Topics: 11
Total Comments: 35
Errk!
Posted Sep 19, 2006 - 7:36 PM:


If you see no errors above this, everything worked. Your mysql info is correct and you can just retype it on the setup screen to install the script.

If you see an error, the most likely cause would be that you haven't assigned the username to the database in your hosting control panel. The database connection info you supplied worked, but if you see an error that means it wasn't able to access the particular database you specified.


There were no errors listed.

I did try re-running the upgrade and got exactly the same results.

Everything was working fine before the upgrade; I don't believe my host changed anything.

Somethign else to note: when I run the upgrade I'm still getting the exact same message on my screen as I posted in the first post of this thread; where it says "If you have any attachments, they haven't been converted to the new format yet. Click to begin conversion." I do not have any attachments, but I clicked the link anyway and get this:



Load time so far: 0.15 seconds.
Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;

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

Number of rows is 0 for Resource id #47

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

Load time so far: 0.15 seconds.
Performing query: SELECT COUNT(id) FROM wsnlinks_attachments WHERE 1=1 ;
Count is 0

Load time so far: 0.15 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 FROM wsnlinks_links WHERE filename != '' ORDER BY id ASC LIMIT 0,100;

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/totalspo/public_html/classes/database.php on line 108

Number of rows is for Unknown column 'filename' in 'where clause'


I don't know if that tells you anything, but I thought I'd include it.



Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Sep 20, 2006 - 4:10 PM:

It says you have no filename field in your links table, which would mean you somehow have a database from prior to 3.3.0, which doesn't make any sense... and it would add that field along with all the others when running the upgrade.

If you want to use the upgrade service I should be able to tell something with FTP and phpmyadmin access.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



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