confused

[jpawluk]

I have Ver. 5.21 on my site. I want to upgrade to the newest version... Do I just copy the entire contents of the new version and overight all the files and directories, then run the install script?

It's running on it's own DB along with vBulliten 3.5 4 and vbPortal Version 3.5.0

Thanks,

JP

[Chuck S]

You would download the new code and overwrite everything except do not upload the 2 config files and install.php. Then simply run upgrade.php and select the 5.2-6.0 upgrade scripts running through each one and delete upgrade.php from the server that is all there is to it,

[jpawluk]

So... I will upload all the files and directories in the photopost602.zip file into my photopost directory except:

config-int.php.NEW
config-inc.php.NEW
install.php

Then run the new upgrade.php script in my Photopost Dir. on my remote sever?

I'm am not very good at all this and hope I don't mess it up!!

Thanks Chuck!!

:O)

JP

[jpawluk]

Here's what I got after running the upgrade.php file :O(

Damn!


Preparing to update database...
Error performing MySQL command: CREATE TABLE messages ( msgid int( 12 ) NOT NULL AUTO_INCREMENT , userid int( 12 ) NOT NULL default '0', datestamp int( 15 ) NOT NULL default '0', message mediumtext, status smallint( 1 ) NOT NULL default '0', type enum( 'c', 'f', 'i', 'm', 'r' ) default NULL , photo int( 12 ) NOT NULL default '0', PRIMARY KEY ( msgid ) ) TYPE=MYISAM
Error: Table 'messages' already exists

Error performing MySQL command: CREATE TABLE captcha ( id int( 12 ) NOT NULL auto_increment , code varchar( 12 ) default NULL , PRIMARY KEY ( id ) ) TYPE=MyISAM
Error: Table 'captcha' already exists

Error performing MySQL command: CREATE TABLE buddies ( id int( 12 ) NOT NULL auto_increment , userid int( 12 ) NOT NULL default '0', buddy int( 12 ) NOT NULL default '0', PRIMARY KEY ( id ) , KEY userid ( userid ) ) TYPE=MyISAM
Error: Table 'buddies' already exists

Error performing MySQL command: CREATE TABLE board ( msgid int(12) NOT NULL auto_increment, replyto int(12) NOT NULL default '0', userid int(12) NOT NULL default '0', category int(4) NOT NULL default '0', date int(15) NOT NULL default '0', subject varchar(250) default NULL, message mediumtext, replies int(6) NOT NULL default '0', views int(7) NOT NULL default '0', lastmsg int(12) NOT NULL default '0', lastdate int(15) NOT NULL default '0', lastuser int(12) NOT NULL default '0', lastusername varchar(32) default NULL, ipaddr varchar(15) default NULL, updated int(16) NOT NULL default '0', updateuser int(12) NOT NULL default '0', PRIMARY KEY (msgid), KEY date (date) ) TYPE=MyISAM
Error: Table 'board' already exists

Error performing MySQL command: CREATE TABLE invites ( id int( 12 ) NOT NULL AUTO_INCREMENT , code varchar( 32 ) default NULL , email varchar( 32 ) default NULL , name varchar( 64 ) default NULL , message mediumtext, datestamp int( 16 ) NOT NULL default '0', referer int( 10 ) NOT NULL default '0', status smallint( 1 ) NOT NULL default '0', uid int( 12 ) NOT NULL default '0', PRIMARY KEY ( id ) , UNIQUE KEY code ( code ) ) TYPE=MYISAM
Error: Table 'invites' already exists

Error performing MySQL command: ALTER TABLE users ADD realname varchar(80) default NULL, ADD title varchar(30) default NULL, ADD signature varchar(250) default NULL, ADD avatar varchar(120) default NULL, ADD mature tinyint(1) NOT NULL default '1', ADD invites int(6) NOT NULL default '0', ADD accepts int(6) NOT NULL default '0', ADD laston int(15) NOT NULL default '0'
Error: Duplicate column name 'realname'

Error performing MySQL command: ALTER TABLE photos ADD votes tinyint(1) NOT NULL default '0'
Error: Duplicate column name 'votes'

Error performing MySQL command: ALTER TABLE comments ADD votes tinyint(1) NOT NULL default '0'
Error: Duplicate column name 'votes'

Error performing MySQL command: ALTER TABLE iponline ADD uid INT(12) NOT NULL default '0', ADD referer VARCHAR(255) default NULL, ADD agent VARCHAR(100) default NULL
Error: Duplicate column name 'uid'

Error performing MySQL command: ALTER TABLE photos ADD tags INT(15) NOT NULL default '0', ADD ismature smallint(1) NOT NULL default '0', ADD exifinfo BINARY(1) NOT NULL DEFAULT '0'
Error: Duplicate column name 'tags'

Error performing MySQL command: INSERT INTO settings VALUES (226,'Use lightbox integration?','lightbox','','no',32,5)
Error: Duplicate entry '226' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (227,'Width to trigger lightbox integration (if enabled)?','lbwidth','','900',33,5)
Error: Duplicate entry '227' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (228,'Height to trigger lightbox integration (if enabled)?','lbheight','','600',34,5)
Error: Duplicate entry '228' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (229,'Use mature content filter?','mature','Prevents photos marked from mature being shown without user electing to view them.','no',18,2)
Error: Duplicate entry '229' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (230,'Use uniform thumbnail feature?','uniform','','no',26,6)
Error: Duplicate entry '230' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (231,'Uniform thumbnail height?','uniheight','Can only be used when using IM for imaging.','78',27,6)
Error: Duplicate entry '231' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (232,'Uniform thumbnail width','uniwidth','Can only be used when using IM for imaging.','120',28,6)
Error: Duplicate entry '232' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (233,'Use Messaging System for PhotoPost alerts/notices?','usemsg','','yes',38,1)
Error: Duplicate entry '233' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (234,'Use CAPTCHA images when verifying registration?','usecaptcha','Requires GD2 support!','no',4,8)
Error: Duplicate entry '234' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (235,'Enable PhotoPost Message Board?','usebb','Used only for internal PhotoPost systems.','no',5,13)
Error: Duplicate entry '235' for key 1

updating photo tags...done.
scanning for exifs... done.
updating users table...done.
updating votes... Home · Search · Register




GHS Photo Gallery Message

[Chuck S]

Duplicate errors are no big deal you should be fine that just means you ran the script more than once.

[jpawluk]

This is what get when I try to access my Photopost Gallery...

Bummer...


We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT id,ugnoupload,ugnoview,password,cattype,ismember,catname,parent,children,thumbs,canzip,moderators,header,footer,headtags,subalbum FROM categories

Result: Unknown column 'subalbum' in 'field list'

Database handle: Resource id #37

[Chuck S]

Okay you have not ran all the required upgrades. You said you had 5.21 so you need to run the 5.2 5.3 5.5 and 5.62 upgrade scripts

it appears at the least you forgot 5.2

[jpawluk]

I'm getting no where... this really is frustrating... I have always had to pay you guys to make the upgrades work... I guess I'll have to pay again to get this software to work. I appreciate all your hard work Chuck, but this software is not for people like myself that are not computer savvy.

At this point, none of my users can upload, view or otherwise manipulate any of the thousands of photos on my site.

I'm sure there's something simple that will fix this but I have no idea how...

I've spent a lot of money over the last decade on this software and I feel like I've been ripped... I guess I'll have to spend more money to get upgraded

Sorry, I don't want to rip on you but your the only one that seems to care...

JP

[jpawluk]

Originally Posted by Chuck S

Okay you have not ran all the required upgrades. You said you had 5.21 so you need to run the 5.2 5.3 5.5 and 5.62 upgrade scripts

it appears at the least you forgot 5.2

OK, I'll try again....

[Chuck S]

No problem let us know if we can assist you further.

[jpawluk]

Originally Posted by jpawluk

OK, I'll try again....

Hi Chuck,

Where do I find the above mentioned upgrade scripts?

JP

[jpawluk]

Originally Posted by jpawluk

Hi Chuck,

Where do I find the above mentioned upgrade scripts?

JP

Ok, I ran them from the upgrade script... DUH!!!

Now it says there's a version 6.0 available. Do I need to just DL it and run the upgrade script again??

I get this error trying to go from 5.62 to 6.0

Preparing to update database...
Error performing MySQL command: CREATE TABLE messages ( msgid int( 12 ) NOT NULL AUTO_INCREMENT , userid int( 12 ) NOT NULL default '0', datestamp int( 15 ) NOT NULL default '0', message mediumtext, status smallint( 1 ) NOT NULL default '0', type enum( 'c', 'f', 'i', 'm', 'r' ) default NULL , photo int( 12 ) NOT NULL default '0', PRIMARY KEY ( msgid ) ) TYPE=MYISAM
Error: Table 'messages' already exists

Error performing MySQL command: CREATE TABLE captcha ( id int( 12 ) NOT NULL auto_increment , code varchar( 12 ) default NULL , PRIMARY KEY ( id ) ) TYPE=MyISAM
Error: Table 'captcha' already exists

Error performing MySQL command: CREATE TABLE buddies ( id int( 12 ) NOT NULL auto_increment , userid int( 12 ) NOT NULL default '0', buddy int( 12 ) NOT NULL default '0', PRIMARY KEY ( id ) , KEY userid ( userid ) ) TYPE=MyISAM
Error: Table 'buddies' already exists

Error performing MySQL command: CREATE TABLE board ( msgid int(12) NOT NULL auto_increment, replyto int(12) NOT NULL default '0', userid int(12) NOT NULL default '0', category int(4) NOT NULL default '0', date int(15) NOT NULL default '0', subject varchar(250) default NULL, message mediumtext, replies int(6) NOT NULL default '0', views int(7) NOT NULL default '0', lastmsg int(12) NOT NULL default '0', lastdate int(15) NOT NULL default '0', lastuser int(12) NOT NULL default '0', lastusername varchar(32) default NULL, ipaddr varchar(15) default NULL, updated int(16) NOT NULL default '0', updateuser int(12) NOT NULL default '0', PRIMARY KEY (msgid), KEY date (date) ) TYPE=MyISAM
Error: Table 'board' already exists

Error performing MySQL command: CREATE TABLE invites ( id int( 12 ) NOT NULL AUTO_INCREMENT , code varchar( 32 ) default NULL , email varchar( 32 ) default NULL , name varchar( 64 ) default NULL , message mediumtext, datestamp int( 16 ) NOT NULL default '0', referer int( 10 ) NOT NULL default '0', status smallint( 1 ) NOT NULL default '0', uid int( 12 ) NOT NULL default '0', PRIMARY KEY ( id ) , UNIQUE KEY code ( code ) ) TYPE=MYISAM
Error: Table 'invites' already exists

Error performing MySQL command: ALTER TABLE users ADD realname varchar(80) default NULL, ADD title varchar(30) default NULL, ADD signature varchar(250) default NULL, ADD avatar varchar(120) default NULL, ADD mature tinyint(1) NOT NULL default '1', ADD invites int(6) NOT NULL default '0', ADD accepts int(6) NOT NULL default '0', ADD laston int(15) NOT NULL default '0'
Error: Duplicate column name 'realname'

Error performing MySQL command: ALTER TABLE photos ADD votes tinyint(1) NOT NULL default '0'
Error: Duplicate column name 'votes'

Error performing MySQL command: ALTER TABLE comments ADD votes tinyint(1) NOT NULL default '0'
Error: Duplicate column name 'votes'

Error performing MySQL command: ALTER TABLE iponline ADD uid INT(12) NOT NULL default '0', ADD referer VARCHAR(255) default NULL, ADD agent VARCHAR(100) default NULL
Error: Duplicate column name 'uid'

Error performing MySQL command: ALTER TABLE photos ADD tags INT(15) NOT NULL default '0', ADD ismature smallint(1) NOT NULL default '0', ADD exifinfo BINARY(1) NOT NULL DEFAULT '0'
Error: Duplicate column name 'tags'

Error performing MySQL command: INSERT INTO settings VALUES (226,'Use lightbox integration?','lightbox','','no',32,5)
Error: Duplicate entry '226' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (227,'Width to trigger lightbox integration (if enabled)?','lbwidth','','900',33,5)
Error: Duplicate entry '227' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (228,'Height to trigger lightbox integration (if enabled)?','lbheight','','600',34,5)
Error: Duplicate entry '228' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (229,'Use mature content filter?','mature','Prevents photos marked from mature being shown without user electing to view them.','no',18,2)
Error: Duplicate entry '229' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (230,'Use uniform thumbnail feature?','uniform','','no',26,6)
Error: Duplicate entry '230' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (231,'Uniform thumbnail height?','uniheight','Can only be used when using IM for imaging.','78',27,6)
Error: Duplicate entry '231' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (232,'Uniform thumbnail width','uniwidth','Can only be used when using IM for imaging.','120',28,6)
Error: Duplicate entry '232' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (233,'Use Messaging System for PhotoPost alerts/notices?','usemsg','','yes',38,1)
Error: Duplicate entry '233' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (234,'Use CAPTCHA images when verifying registration?','usecaptcha','Requires GD2 support!','no',4,8)
Error: Duplicate entry '234' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (235,'Enable PhotoPost Message Board?','usebb','Used only for internal PhotoPost systems.','no',5,13)
Error: Duplicate entry '235' for key 1

updating photo tags...done.
scanning for exifs... done.
updating users table...done.
updating votes...done.

Upgrade complete! To prevent users from modifying your PhotoPost database settings, please be sure to delete the upgrade.php file from your PhotoPost directory before continuing.




Thanks,

JP

[Chuck S]

Is your gallery working I am not sure what your asking here really. If you downloaded and upgraded your files to 6.02 then you have the latest. I already responded that if you get the errors your noting that just means you ran the upgrade before.

[jpawluk]

Originally Posted by Chuck S

Is your gallery working I am not sure what your asking here really. If you downloaded and upgraded your files to 6.02 then you have the latest. I already responded that if you get the errors your noting that just means you ran the upgrade before.

Thanks Chuck,

The Gallery is working OK except when you try to upload images you get an http 406 error message. Sorry for the confusion...

JP

[Chuck S]

I would suggest you check your directory permissions on data and uploads are 777

You can send me via pm a url admin login and ftp login to the server.

[jpawluk]

Thanks to Chuck for getting me straightend out and back in service with Photopost.

You are the best!!

John

[Chuck S]

No problem glad to assist.