Webmastersite.net
Register Log In

upgrade.php doesn't work

Title upgrade.php doesn't work
Message Text I have an issue on my real estate directory site with upgrade.php file and long time ago I asked about it and kinda ended up on my own since I've done too much modification of my database.. but I've been using upgrade.php from ver.3.16 for all this time successfully. Now I have a different site that I just installed 3.307 and was trying to upgrade it to 3.11 - the upgrade.php gives me blank page (just the same was as I have on my reale state directory site). I turned on debug function and still getting blank page. Well, I copied the 3.16 upgrade.php over the new one and it went through. But here are the messages I get and there are whole bunch of syntax error
Load time so far: 0.19 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 validated=1 AND deleted=0 AND hide=0 ;

Number of rows is 2 for Resource id #47

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

Load time so far: 0.2 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 #48

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

Load time so far: 0.22 seconds.
Performing query: ALTER TABLE agents ADD traderrating int default '0' NOT NULL;

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE wsnlinks_switches ADD id int default '0' NOT NULL auto_increment;

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE wsnlinks_switches ADD name text NOT NULL;

Duplicate column name 'id'

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE wsnlinks_switches ADD value int default '0' NOT NULL;

Duplicate column name 'name'

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD id int default '0' NOT NULL auto_increment;

Duplicate column name 'value'

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD topicid int default '0' NOT NULL;

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 'ADD id int default '0' NOT NULL auto_increment' at line 1

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD postid int default '0' NOT NULL;

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 'ADD topicid int default '0' NOT NULL' at line 1

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD type varchar(255) NOT NULL;

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 'ADD postid int default '0' NOT NULL' at line 1

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD nature varchar(255) NOT NULL;

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 'ADD type varchar(255) NOT NULL' at line 1

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD reason text NOT NULL;

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 'ADD nature varchar(255) NOT NULL' at line 1

Load time so far: 0.28 seconds.
Performing query: ALTER 
TABLE ADD moderatorid int default '0' NOT NULL;

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 'ADD reason text NOT NULL' at line 1

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD source int default '0' NOT NULL;

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 'ADD moderatorid int default '0' NOT NULL' at line 1

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD destination int default '0' NOT NULL;

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 'ADD source int default '0' NOT NULL' at line 1

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

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 'ADD destination int default '0' NOT NULL' at line 1

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD catid int default '0' NOT NULL;

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 'ADD time int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD memberid int default '0' NOT NULL;

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 'ADD catid int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD id int default '0' NOT NULL auto_increment;

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 'ADD memberid int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD type varchar(255) NOT NULL;

Duplicate column name 'id'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD objectid int default '0' NOT NULL;

Duplicate column name 'type'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD filename varchar(255) NOT NULL;

Duplicate column name 'objectid'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD filetitle varchar(255) NOT NULL;

Duplicate column name 'filename'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD filesize int default '0' NOT NULL;

Duplicate column name 'filetitle'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD width int default '0' NOT NULL;

Duplicate column name 'filesize'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD height int default '0' NOT NULL;

Duplicate column name 'width'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD memberid int default '0' NOT NULL;

Duplicate column name 'height'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD time int default '0' NOT NULL;

Duplicate column name 'memberid'

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

Duplicate column name 'time'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD field varchar(255) NOT NULL;

Duplicate column name 'deleted'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD downloads int default '0' NOT NULL;

Duplicate column name 'field'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD validated int default '0' NOT NULL;

Duplicate column name 'downloads'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD id int default '0' NOT NULL auto_increment;

Duplicate column name 'validated'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD name varchar(255) NOT NULL;

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 'ADD id int default '0' NOT NULL auto_increment' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD numsubjects int default '0' NOT NULL;

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 'ADD name varchar(255) NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD priority int default '0' NOT NULL;

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 'ADD numsubjects int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_helpitem ADD id int default '0' NOT NULL auto_increment;

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 'ADD priority int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_helpitem ADD subject varchar(255) NOT NULL;

Duplicate column name 'id'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_helpitem ADD helptext text NOT NULL;

Duplicate column name 'subject'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_helpitem ADD priority int default '0' NOT NULL;

Duplicate column name 'helptext'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_helpitem ADD category int default '0' NOT NULL;

Duplicate column name 'priority'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_crons ADD id int default '0' NOT NULL auto_increment;

Duplicate column name 'category'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_crons ADD frequency int default '0' NOT NULL;

Duplicate column name 'id'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_crons ADD nextrun int default '0' NOT NULL;

Duplicate column name 'frequency'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_crons ADD filename varchar(255) NOT NULL;

Duplicate column name 'nextrun'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_crons ADD native int default '0' NOT NULL;

Duplicate column name 'filename'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD id int default '0' NOT NULL auto_increment;

Duplicate column name 'native'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD toid int default '0' NOT NULL;

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 'ADD id int default '0' NOT NULL auto_increment' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD fromid int default '0' NOT NULL;

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 'ADD toid int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD message text NOT NULL;

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 'ADD fromid int default '0' NOT NULL' at line 1

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

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 'ADD message text NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD isread int default '0' NOT NULL;

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 'ADD time int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD timeread int default '0' NOT NULL;

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 'ADD isread int default '0' NOT NULL' at line 1

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

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 'ADD timeread int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_links CHANGE rating rating float default '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 'ADD deleted int default '0' NOT NULL' at line 1

Load time so far: 0.3 seconds.
Performing query: ALTER TABLE wsnlinks_links CHANGE lastedit lastedit int default '0';

nLoad time so far: 0.31 seconds.
Performing query: ALTER TABLE wsnlinks_links CHANGE `time` `time` int default '0';

Load time so far: 0.31 seconds.
Performing query: ALTER TABLE agents CHANGE failedattempts failedattempts int default '0';

Load time so far: 0.32 seconds.
Performing query: ALTER TABLE agents CHANGE `time` `time` int default '0';

Load time so far: 0.33 seconds.
Performing query: UPDATE agents SET time='0' WHERE time='{TIME}';

Load time so far: 0.33 seconds.
Performing query: ALTER TABLE wsnlinks_membergroups CHANGE canemailmembers canemailmembers int default '0';

Load time so far: 0.34 seconds.
Performing query: ALTER TABLE wsnlinks_membergroups CHANGE canusehtml canusehtml int default '0';

Load time so far: 0.35 seconds.
Performing query: ALTER TABLE wsnlinks_links CHANGE funds funds FLOAT DEFAULT '0' NOT NULL;

Load time so far: 0.35 seconds.
Performing query: ALTER TABLE wsnlinks_ratings CHANGE `id` `id` INT( 11 ) DEFAULT '0' NOT NULL AUTO_INCREMENT;

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

Number of rows is 57 for Resource id #67

Load time so far: 0.38 seconds.
Performing query: INSERT INTO wsnlinks_switches(id,name,value) VALUES('', 'trader', '1');

Load time so far: 0.38 seconds.
Performing query: UPDATE agents SET notifyoflinks='no' WHERE notifyoflinks = '';

Load time so far: 0.39 seconds.
Performing query: UPDATE wsnlinks_links SET lastedit='0' WHERE lastedit='time';

Load time so far: 0.39 seconds.
Performing query: DELETE FROM wsnlinks_settings WHERE name='sitemap';

Load time so far: 0.39 seconds.
Performing query: UPDATE wsnlinks_categories SET permissions='' WHERE permissions NOT LIKE '%[GROUP]%';

Load time so far: 0.39 seconds.
Performing query: UPDATE wsnlinks_links SET hitsinips='' WHERE hitsinips NOT LIKE '%[,]%';

Load time so far: 0.39 seconds.
Performing query: UPDATE wsnlinks_links SET hitsoutips='' WHERE hitsoutips NOT LIKE '%[,]%';

Load time so far: 0.39 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 parentids != '' ;

Number of rows is 0 for Resource id #68

Load time so far: 0.39 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 moderators != '' ;

Number of rows is 3 for Resource id #69

Load time so far: 0.41 seconds.
Performing query: SELECT agent_id FROM agents WHERE username = 'max.chirkov' ;

Load time so far: 0.41 seconds.
Performing query: UPDATE wsnlinks_categories SET moderators=', 8, ' WHERE id=5;

Load time so far: 0.41 seconds.
Performing query: UPDATE wsnlinks_settings SET content='' WHERE name='excludedtoadmin';

Load time so far: 0.41 seconds.
Performing query: UPDATE wsnlinks_categories SET type='regular' WHERE type='';

Load time so far: 0.41 seconds.
Performing query: UPDATE wsnlinks_comments SET type='regular' WHERE type='';

Load time so far: 0.41 seconds.
Performing query: UPDATE agents SET allowuseremail='yes' WHERE allowuseremail='';

Load time so far: 0.42 seconds.
Performing query: UPDATE agents SET allowemail='yes' WHERE allowemail='';

Load time so far: 0.43 seconds.
Performing query: SELECT hits,hitsin FROM wsnlinks_links WHERE hide=0 AND validated=1 ;

Number of rows is 8 for Resource id #71

Load time so far: 0.43 seconds.
Performing query: SELECT id FROM wsnlinks_comments WHERE validated=1 AND hide=0 ;

Number of rows is 0 for Resource id #72

Load time so far: 0.43 seconds.
Performing query: SELECT agent_id FROM agents WHERE validated=1 ;

Number of rows is 121 for Resource id #73

Load time so far: 0.43 seconds.
Performing query: SELECT lastedit FROM wsnlinks_links WHERE validated=1 AND hide=0 ORDER BY lastedit DESC LIMIT 0,1;

Load time so far: 0.43 seconds.
Performing query: UPDATE wsnlinks_settings SET content='8' WHERE name='totallinks';

Load time so far: 0.43 seconds.
Performing query: UPDATE wsnlinks_settings SET content='0' WHERE name='totalcomments';

Load time so far: 0.43 seconds.
Performing query: UPDATE wsnlinks_settings SET content='0' WHERE name='totalhitsin';

Load time so far: 0.44 seconds.
Performing query: UPDATE wsnlinks_settings SET content='0' WHERE name='totalhits';

Load time so far: 0.44 seconds.
Performing query: UPDATE wsnlinks_settings SET content='121' WHERE name='totalmembers';

Load time so far: 0.44 seconds.
Performing query: UPDATE wsnlinks_settings SET content='1142612375' WHERE name='lastupdate';

Load time so far: 0.44 seconds.
Performing query: SELECT stylesheet FROM agents WHERE level=3 ;

Load time so far: 0.44 seconds.
Performing query: SELECT numsub FROM wsnlinks_categories WHERE id>0 ORDER BY numsub DESC LIMIT 0,1;

Load time so far: 0.44 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 id>0 ;

Number of rows is 3 for Resource id #77

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

Number of rows is 0 for Resource id #78

Load time so far: 0.45 seconds.
Performing query: UPDATE wsnlinks_categories SET numsub='0' WHERE id=3;

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

Number of rows is 0 for Resource id #79

Load time so far: 0.46 seconds.
Performing query: UPDATE wsnlinks_categories SET numsub='0' WHERE id=4;

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

Number of rows is 0 for Resource id #80

Load time so far: 0.46 seconds.
Performing query: UPDATE wsnlinks_categories SET numsub='0' WHERE id=5;

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

Load time so far: 0.57 seconds.
Performing query: SELECT id,name,parentids,parentnames FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY priority ASC,name ASC ;

Number of rows is 2 for Resource id #86

Load time so far: 0.57 seconds.
Performing query: SELECT id,name,parentids,parentnames FROM wsnlinks_categories WHERE parent=3 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY priority ASC,name ASC ;

Number of rows is 0 for Resource id #87

Load time so far: 0.57 seconds.
Performing query: SELECT id,name,parentids,parentnames FROM wsnlinks_categories WHERE parent=4 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY priority ASC,name ASC ;

Number of rows is 0 for Resource id #88

Load time so far: 0.57 seconds.
Performing query: UPDATE wsnlinks_settings SET content='3,4' WHERE name='sitemaporder';

Load time so far: 0.57 seconds.
Performing query: UPDATE wsnlinks_settings SET content='<option value="3"> Vol 29 #13 - April</option><option value="4"> Vol 30 #01 - May</option>' WHERE name='categoryselector';
So, I'm confused now... does it has to do with my host that upgrade.php gives me blank page or with my custom fields added to the database? Or it's something wrong with the actual file?
Rating
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5
0/5 based on 0 votes.
Ownership gemini
Views 666 views. Averaging 0 views per day.
Similar Topics
Submission Date Mar 22, 2006 - 7:59 AM