PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Photopost Pro How Do I...? (http://www.photopost.com/forum/photopost-pro-how-do-i/)
-   -   confused (http://www.photopost.com/forum/photopost-pro-how-do-i/135361-confused.html)

jpawluk February 10th, 2008 03:04 PM
confused
 
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 February 10th, 2008 03:39 PM
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 February 10th, 2008 04:01 PM
Thanks Chuck
 
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 February 10th, 2008 04:51 PM
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 February 10th, 2008 05:13 PM
Duplicate errors are no big deal you should be fine that just means you ran the script more than once.

jpawluk February 10th, 2008 05:26 PM
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 February 10th, 2008 05:51 PM
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 February 10th, 2008 06:30 PM
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 February 10th, 2008 06:32 PM
Quote:
Originally Posted by Chuck S (Post 1216869)
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....:confused:

Chuck S February 10th, 2008 08:25 PM
No problem let us know if we can assist you further.

jpawluk February 12th, 2008 06:40 PM
Quote:
Originally Posted by jpawluk (Post 1216873)
OK, I'll try again....:confused:
Hi Chuck,

Where do I find the above mentioned upgrade scripts?

JP

jpawluk February 12th, 2008 06:52 PM
Quote:
Originally Posted by jpawluk (Post 1217058)
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 February 12th, 2008 06:59 PM
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 February 12th, 2008 07:04 PM
Quote:
Originally Posted by Chuck S (Post 1217061)
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 February 12th, 2008 07:11 PM
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 February 13th, 2008 05:22 PM
Thanks
 
Thanks to Chuck for getting me straightend out and back in service with Photopost.

You are the best!! B=0 :D

John

Chuck S February 13th, 2008 08:35 PM
No problem glad to assist.


All times are GMT -5. The time now is 02:30 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97