Webmastersite.net
Register Log In

index.php blank
index.php blank after upgrade from 3.14 to 3.27

Comments on index.php blank

mactoph
Beginner

Usergroup: Customer
Joined: Nov 02, 2004

Total Topics: 2
Total Comments: 9
mactoph
Posted Oct 20, 2005 - 2:42 PM:

I just upgraded and now when I go to my directory, the page is completely blank- nothing at all there. The Admin panel seems to be working fine, but not the directory itself. The directory is at:
http://www.faithability.org/directory/

Here is the Query:

Load time so far: 0.09 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 FROM wsnlinks_categories WHERE validated=1 AND deleted=0 AND hide=0 ;

Number of rows is 26 for Resource id #29

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

Load time so far: 0.11 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 #30

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

Load time so far: 0.12 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 FROM wsnlinks_categories WHERE parent=1 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY name ASC,name ASC LIMIT 0,300;

Number of rows is 9 for Resource id #32

Load time so far: 0.3 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_links WHERE catid=1 AND hide=0 AND deleted=0 AND validated=1 ;

Count is

Load time so far: 0.31 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_links WHERE catid=1 AND validated=1 AND hide=0 AND deleted=0 AND type='regular' ;

Unknown column 'deleted' in 'where clause'
Count is

Load time so far: 0.32 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_links WHERE catid=1 AND validated=1 AND hide=0 AND deleted=0 AND type='recip' ;

Unknown column 'deleted' in 'where clause'
Count is

Load time so far: 0.32 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_links WHERE catid=1 AND hide=0 AND deleted=0 AND validated=1 ;

Unknown column 'deleted' in 'where clause'
Count is

Load time so far: 0.32 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_links WHERE catid=1 AND hide=0 AND deleted=0 AND validated=1 ;

Unknown column 'deleted' in 'where clause'
Count is

Setting cookie with name returnto, value http://www.faithability.org/directory/index.php and duration 1129845168

Load time so far: 0.49 seconds.
Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat FROM wsnlinks_sessions WHERE time > 1129843369 AND (catid=1 AND memberid>0) ORDER BY time DESC LIMIT 0,100;

Unknown column 'deleted' in 'where clause'

Number of rows is 0 for Resource id #33

Load time so far: 1 seconds.
Performing query: SELECT memberid,starttime,time FROM wsnlinks_sessions WHERE time < 1129843369 AND memberid > 0 ;

Number of rows is 0 for Resource id #38

Load time so far: 1.01 seconds.
Performing query: DELETE FROM wsnlinks_sessions WHERE time < 1129843369;

Load time so far: 1.01 seconds.
Performing query: SELECT starttime FROM wsnlinks_sessions WHERE memberid=2 ;

Number of rows is 1 for Resource id #39

Load time so far: 1.01 seconds.
Performing query: UPDATE wsnlinks_sessions SET time='1129844269', location='http://www.faithability.org/directory/index.php', catid='1', threadid='', areaname='Faithability Religion, Spirituality and Disability Resources', nopermission=0, inchat=0 WHERE memberid=2;

closing database connection

mactoph
Beginner

Usergroup: Customer
Joined: Nov 02, 2004

Total Topics: 2
Total Comments: 9
mactoph
Posted Oct 20, 2005 - 5:52 PM:

I received this email from Paul:
"Well, one thing I can see from your debug output is that fields haven't been added. http://www.faithability.org/directory/upgrade.php also lists all sorts of fields needing addition, indicating you haven't actually run the upgrade."

However, I have actually run the upgrade script three times now, but apparently it isn't working.

Before I start the upgrade there is a page telling me that the following queries need to be run:
ALTER TABLE wsnlinks_links ADD lastposterid int default '0' NOT NULL;
ALTER TABLE wsnlinks_links ADD lastpostername varchar(255) NOT NULL;
ALTER TABLE wsnlinks_links ADD ownername varchar(255) NOT NULL;
ALTER TABLE wsnlinks_links ADD deleted int default '0' NOT NULL;
ALTER TABLE wsnlinks_links ADD deletionreason varchar(255) NOT NULL;
ALTER TABLE wsnlinks_links ADD movedto int default '0' NOT NULL;
ALTER TABLE wsnlinks_links ADD deletedby int default '0' NOT NULL;
ALTER TABLE wsnlinks_links ADD timevalidated int default '0' NOT NULL;
ALTER TABLE wsnlinks_links ADD filefield varchar(255) NOT NULL;

I tried going to phpmyadmin to run the first one and received this response:
SQL-query:
ALTER TABLE wsnlinks_links ADD lastposterid int default '0' NOT NULL

MySQL said: Documentation
#1060 - Duplicate column name 'title'

When I run the upgrade this is the page that comes back:

Administrative account verified... starting upgrade.

Load time so far: 1.27 seconds.
Performing query: ALTER TABLE wsnlinks_links ADD lastposterid int default '0' NOT NULL;

Load time so far: 1.27 seconds.
Performing query: ALTER TABLE wsnlinks_links ADD lastpostername varchar(255) NOT NULL;

Duplicate column name 'title'

Load time so far: 1.28 seconds.
Performing query: ALTER TABLE wsnlinks_links ADD ownername varchar(255) NOT NULL;

Duplicate column name 'title'

Load time so far: 1.28 seconds.
Performing query: ALTER TABLE wsnlinks_links ADD deleted int default '0' NOT NULL;

Duplicate column name 'title'

Load time so far: 1.28 seconds.
Performing query: ALTER TABLE wsnlinks_links ADD deletionreason varchar(255) NOT NULL;

Duplicate column name 'title'

Load time so far: 1.28 seconds.
Performing query: ALTER TABLE wsnlinks_links ADD movedto int default '0' NOT NULL;

Duplicate column name 'title'

Load time so far: 1.28 seconds.
Performing query: ALTER TABLE wsnlinks_links ADD deletedby int default '0' NOT NULL;

Duplicate column name 'title'

Load time so far: 1.28 seconds.
Performing query: ALTER TABLE wsnlinks_links ADD timevalidated int default '0' NOT NULL;

Duplicate column name 'title'

Load time so far: 1.28 seconds.
Performing query: ALTER TABLE wsnlinks_links ADD filefield varchar(255) NOT NULL;

Duplicate column name 'title'

Load time so far: 1.28 seconds.
Performing query: ALTER TABLE phpbb_users ADD location varchar(255) NOT NULL;

Duplicate column name 'title'

Load time so far: 1.28 seconds.
Performing query: ALTER TABLE phpbb_users ADD homepage varchar(255) NOT NULL;

Duplicate column name 'location'

Load time so far: 1.28 seconds.
Performing query: ALTER TABLE phpbb_users ADD occupation varchar(255) NOT NULL;

Duplicate column name 'homepage'

Load time so far: 1.28 seconds.
Performing query: ALTER TABLE phpbb_users ADD bio text NOT NULL;

Duplicate column name 'occupation'

Load time so far: 1.28 seconds.
Performing query: ALTER TABLE phpbb_users ADD aim varchar(255) NOT NULL;

Duplicate column name 'bio'

Load time so far: 1.28 seconds.
Performing query: ALTER TABLE phpbb_users ADD icq varchar(255) NOT NULL;

Duplicate column name 'aim'

Load time so far: 1.28 seconds.
Performing query: ALTER TABLE phpbb_users ADD msn varchar(255) NOT NULL;

Duplicate column name 'icq'

Load time so far: 1.28 seconds.
Performing query: ALTER TABLE phpbb_users ADD yahoo varchar(255) NOT NULL;

Duplicate column name 'msn'

Load time so far: 1.29 seconds.
Performing query: ALTER TABLE phpbb_users ADD inactive int default '0' NOT NULL;

Duplicate column name 'yahoo'

Load time so far: 1.29 seconds.
Performing query: ALTER TABLE phpbb_users ADD timeonline int default '0' NOT NULL;

Duplicate column name 'inactive'

Load time so far: 1.29 seconds.
Performing query: ALTER TABLE phpbb_users ADD totalpms int default '0' NOT NULL;

Duplicate column name 'timeonline'

Load time so far: 1.29 seconds.
Performing query: ALTER TABLE phpbb_users ADD buddies text NOT NULL;

Duplicate column name 'totalpms'

Load time so far: 1.29 seconds.
Performing query: ALTER TABLE phpbb_users ADD ignored text NOT NULL;

Duplicate column name 'buddies'

Load time so far: 1.29 seconds.
Performing query: ALTER TABLE phpbb_users ADD isonline int default '0' NOT NULL;

Duplicate column name 'ignored'

Load time so far: 1.29 seconds.
Performing query: ALTER TABLE phpbb_users ADD acceptims varchar(255) NOT NULL;

Duplicate column name 'isonline'

Load time so far: 1.29 seconds.
Performing query: ALTER TABLE phpbb_users ADD adminpermissions text NOT NULL;

Duplicate column name 'acceptims'

Load time so far: 1.29 seconds.
Performing query: ALTER TABLE phpbb_users ADD referrer int default '0' NOT NULL;

Duplicate column name 'adminpermissions'

Load time so far: 1.29 seconds.
Performing query: ALTER TABLE phpbb_users ADD groupreverttime int default '0' NOT NULL;

Duplicate column name 'referrer'

Load time so far: 1.29 seconds.
Performing query: ALTER TABLE phpbb_users ADD grouprevertto int default '0' NOT NULL;

Duplicate column name 'groupreverttime'

Load time so far: 1.29 seconds.
Performing query: ALTER TABLE phpbb_users ADD moderationpm varchar(255) NOT NULL;

Duplicate column name 'grouprevertto'

Load time so far: 1.3 seconds.
Performing query: ALTER TABLE phpbb_users ADD secondarygroups text NOT NULL;

Duplicate column name 'moderationpm'

Load time so far: 1.31 seconds.
Performing query: ALTER TABLE phpbb_users ADD linksperpage int default '0' NOT NULL;

Duplicate column name 'secondarygroups'

Load time so far: 1.31 seconds.
Performing query: ALTER TABLE phpbb_users ADD commentsperpage int default '0' NOT NULL;

Duplicate column name 'linksperpage'

Load time so far: 1.31 seconds.
Performing query: ALTER TABLE phpbb_users ADD shouts int default '0' NOT NULL;

Duplicate column name 'commentsperpage'

Load time so far: 1.31 seconds.
Performing query: ALTER TABLE phpbb_users ADD customtitle varchar(255) NOT NULL;

Duplicate column name 'shouts'

Load time so far: 1.31 seconds.
Performing query: ALTER TABLE phpbb_users ADD shoutban int default '0' NOT NULL;

Duplicate column name 'customtitle'

Load time so far: 1.31 seconds.
Performing query: ALTER TABLE phpbb_users ADD topicbans text NOT NULL;

Duplicate column name 'shoutban'

Load time so far: 1.31 seconds.
Performing query: ALTER TABLE phpbb_users ADD forumbans text NOT NULL;

Duplicate column name 'topicbans'

Load time so far: 1.31 seconds.
Performing query: ALTER TABLE phpbb_users ADD visibility text NOT NULL;

Duplicate column name 'forumbans'

Load time so far: 1.32 seconds.
Performing query: ALTER TABLE phpbb_users ADD birthdate date;

Duplicate column name 'visibility'

Load time so far: 1.32 seconds.
Performing query: ALTER TABLE phpbb_users ADD lastsession int default '0' NOT NULL;

Duplicate column name 'birthdate'

Load time so far: 1.32 seconds.
Performing query: ALTER TABLE phpbb_users ADD interests text NOT NULL;

Duplicate column name 'lastsession'

Load time so far: 1.32 seconds.
Performing query: ALTER TABLE phpbb_users ADD posteditor varchar(255) NOT NULL;

Duplicate column name 'interests'

Load time so far: 1.32 seconds.
Performing query: ALTER TABLE phpbb_users ADD forumaccess text NOT NULL;

Duplicate column name 'posteditor'

Load time so far: 1.32 seconds.
Performing query: ALTER TABLE phpbb_users ADD pmpopup int default '0' NOT NULL;

Duplicate column name 'forumaccess'

Load time so far: 1.32 seconds.
Performing query: ALTER TABLE phpbb_users ADD pmnotify varchar(255) NOT NULL;

Duplicate column name 'pmpopup'

Load time so far: 1.32 seconds.
Performing query: ALTER TABLE phpbb_users ADD modnotes int default '0' NOT NULL;

Duplicate column name 'pmnotify'

Load time so far: 1.32 seconds.
Performing query: ALTER TABLE phpbb_users ADD guestnotes int default '0' NOT NULL;

Duplicate column name 'modnotes'

Load time so far: 1.32 seconds.
Performing query: ALTER TABLE phpbb_users ADD salt varchar(255) NOT NULL;

Duplicate column name 'guestnotes'

Load time so far: 1.32 seconds.
Performing query: ALTER TABLE phpbb_users ADD lastmodnote int default '0' NOT NULL;

Duplicate column name 'salt'

Load time so far: 1.32 seconds.
Performing query: ALTER TABLE phpbb_users ADD newpms int default '0' NOT NULL;

Duplicate column name 'lastmodnote'

Load time so far: 1.32 seconds.
Performing query: ALTER TABLE phpbb_users ADD imflag int default '0' NOT NULL;

Duplicate column name 'newpms'

Load time so far: 1.32 seconds.
Performing query: ALTER TABLE phpbb_users ADD orderalbums varchar(255) NOT NULL;

Duplicate column name 'imflag'

Load time so far: 1.32 seconds.
Performing query: ALTER TABLE phpbb_users ADD lastguestnote int default '0' NOT NULL;

Duplicate column name 'orderalbums'

Load time so far: 1.33 seconds.
Performing query: ALTER TABLE phpbb_users ADD autosubscribe varchar(255) NOT NULL;

Duplicate column name 'lastguestnote'

Load time so far: 1.33 seconds.
Performing query: ALTER TABLE phpbb_users ADD notifymethod varchar(255) NOT NULL;

Duplicate column name 'autosubscribe'

Load time so far: 1.33 seconds.
Performing query: ALTER TABLE phpbb_users ADD showavatars varchar(255) NOT NULL;

Duplicate column name 'notifymethod'

Load time so far: 1.33 seconds.
Performing query: ALTER TABLE phpbb_users ADD showsigs varchar(255) NOT NULL;

Duplicate column name 'showavatars'

Load time so far: 1.33 seconds.
Performing query: ALTER TABLE phpbb_users ADD warninglevel int default '0' NOT NULL;

Duplicate column name 'showsigs'

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

Number of rows is 52 for Resource id #51

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


Adding fields: lastposterid lastpostername ownername deleted deletionreason movedto deletedby timevalidated filefield
Adding member fields: 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
Done adding fields.

No new settings need to be added.

No new switches need to be added.

Appending new language from englishonly.lng to your current languages:

Added these items to default:


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.


Anyone have any idea what is happening? Why it won't upgrade?


Thanks



Paul
developer

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

Total Topics: 61
Total Comments: 7868
Paul
Posted Oct 21, 2005 - 1:08 PM:

When you look at your links table, what fields are in it?
mactoph
Beginner

Usergroup: Customer
Joined: Nov 02, 2004

Total Topics: 2
Total Comments: 9
mactoph
Posted Oct 21, 2005 - 3:27 PM:

These are the fields in my links table:
id,,title,,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,
hid,ownerid,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,pendingedit,
fund,suspended,alias,expire,ip,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,
lastcomment,related,inhidden,viewer,threadviewer,hitsintem,hitsouttemp,origtype,importance,parentids,
timesdead,timesemailed,threadclose,threadposter
mactoph
Beginner

Usergroup: Customer
Joined: Nov 02, 2004

Total Topics: 2
Total Comments: 9
mactoph
Posted Oct 21, 2005 - 9:36 PM:

I've been trying to figure out what is causing the #1060 - Duplicate column name 'title' error that I'm getting and am not sure what is happening-
I don't know if it is helpful, but I found this link:
groups.google.com/group/mai...ad/thread/665f88ebc26ad4ec

I've also started this thread on another forum:
www.sitepoint.com/forums/sh...s/showthread.php?p=2241569

If it is any help, my version of MySQL is 4.1.9


Anyone with any other ideas?
mactoph
Beginner

Usergroup: Customer
Joined: Nov 02, 2004

Total Topics: 2
Total Comments: 9
mactoph
Posted Oct 22, 2005 - 9:38 AM:

Here:
www.sitepoint.com/forums/sh...s/showthread.php?p=2242281
Paul
developer

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

Total Topics: 61
Total Comments: 7868
Paul
Posted Oct 23, 2005 - 2:36 PM:

I don't see any query there that's trying to add 'title' but it could be some sort of stuck, leftover error.

Anyhow it looks like your link fields have been added properly based on what you list. I don't see why something would not work then, unless it was a matter of a changed config.php path not having been updated as a I sometimes forget when overwriting prestart.php on one of my forums.

Your site looks okay now except that you need to regenerate counters.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



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