upgrade errors

jakaroo · September 21st, 2006, 10:31 PM

i just upgraded my vbulletin to version 3.5.5 and afterwards, my photopost was just blank, so I just purchased and uploaded the latest version of photopost and while upgrading... i get this error right off the bat...

Performing MySQL command: REPLACE INTO settings VALUES (94,'Use traditional Members Gallery configuration?','memformat','','yes',57,2); ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: REPLACE INTO settings VALUES (95,'Display headers during SlideShows?','slidehead','','yes',58,2); ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: REPLACE INTO settings VALUES (97,'Maximum multimedia upload size in kB','mmuploadsize','','2000',88,3); ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: REPLACE INTO settings VALUES (98,'Allow users to create Personal Albums?','allowpa','','yes',53,5); ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: REPLACE INTO settings VALUES (99,'Allow multimedia uploads?','allowmedia','','no',88,3); ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: REPLACE INTO settings VALUES (100,'Allow members to rate photos?','allowrate','','yes',54,5); ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: REPLACE INTO settings VALUES (101,'Display new comments/photos indicator on index?','displaynew','','no',58,2); ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: ALTER TABLE users ADD site VARCHAR(30) default NULL; ... Error: Table 'oldmetalme.users' doesn't exist
Performing MySQL command: ALTER TABLE users ADD views int(10) NOT NULL default '0'; ... Error: Table 'oldmetalme.users' doesn't exist
Performing MySQL command: ALTER TABLE useralbums ADD isprivate varchar(4) NOT NULL default 'no'; ... Error: Table 'oldmetalme.useralbums' doesn't exist
Performing MySQL command: ALTER TABLE useralbums ADD password VARCHAR(16) NOT NULL; ... Error: Table 'oldmetalme.useralbums' doesn't exist
Performing MySQL command: ALTER TABLE users ADD offset INT(2) UNSIGNED DEFAULT '0' NOT NULL; ... Error: Table 'oldmetalme.users' doesn't exist
Performing MySQL command: ALTER TABLE photos ADD watermarked varchar(5) NOT NULL default 'no'; ... Error: Table 'oldmetalme.photos' doesn't exist
Performing MySQL command: CREATE TABLE favorites (id smallint(4) NOT NULL auto_increment, userid int(8) NOT NULL default '0', photo int(11) NOT NULL default '0', PRIMARY KEY (id), KEY parent (photo)) TYPE=MyISAM; ... Error: Table 'favorites' already exists
Performing MySQL command: CREATE TABLE laston (cat smallint(4) NOT NULL default '0', userid mediumint(9) NOT NULL default '0', laston int(11) unsigned default NULL, PRIMARY KEY (cat,userid)) TYPE=MyISAM; ... Error: Table 'laston' already exists
Performing MySQL command: CREATE TABLE ipcache (id int(10) NOT NULL auto_increment,userid INT(25) NOT NULL, ipaddr VARCHAR(75) NOT NULL, date INT(11) UNSIGNED, type VARCHAR(4) NOT NULL, photo INT(10) NOT NULL, PRIMARY KEY (id)) TYPE=MyISAM; ... Error: Table 'ipcache' already exists
Performing MySQL command: REPLACE INTO sort VALUES (6, 'Random', 'ORDER BY RAND()'); ... Error: Table 'oldmetalme.sort' doesn't exist
Performing MySQL command: REPLACE INTO sort VALUES (5, 'Least Popular', 'ORDER BY rating, views'); ... Error: Table 'oldmetalme.sort' doesn't exist
Performing MySQL command: REPLACE INTO sort VALUES (4, 'Most Popular', 'ORDER BY rating DESC, views DESC'); ... Error: Table 'oldmetalme.sort' doesn't exist
Performing MySQL command: REPLACE INTO sort VALUES (7, 'Alphabetical', 'ORDER BY bigimage'); ... Error: Table 'oldmetalme.sort' doesn't exist
Performing MySQL command: DELETE FROM settings WHERE id=73; ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: DELETE FROM settings WHERE id=74; ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: DELETE FROM settings WHERE id=88; ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: DELETE FROM settings WHERE id=39; ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: DELETE FROM settings WHERE id=40; ... Error: Table 'oldmetalme.settings' doesn't exist
Performing MySQL command: DELETE FROM settings WHERE id=96; ... Error: Table 'oldmetalme.settings' doesn't exist
Fixing database: changing mediumint(9) to int(10) for photos.filesize...Starting to find image files and update file sizes in database...

Fatal error: Call to undefined function: ppmysql_query() in /home/webadmin/metalmeet.com/html/photopost/upgrade.php on line 488

all variables in the config files are the same as the previous... im kinda stuck here....any ideas??
thanks!
jack

Chuck S · September 22nd, 2006, 06:42 AM

You need to ensure you upload all the new files except the config files. Looks to me like you missing files and you overwrote your config which means you need to look at your config-inc.php and ensure it has the right stuff in it

jakaroo · September 22nd, 2006, 08:17 AM

I have reloaded everything that was in the zip file that I downloaded. I checked the config files and the settings are the same as the old ones. Im still getting the same errors. I believe my old version was the 3.06, although Im not sure as it quit working before the upgrade.
What files could I be missing? only folder I didnt upload was the data folder because I didnt want to overwrite existing pictures in duplicate folders.
Thanks again
Jack

Chuck S · September 22nd, 2006, 07:00 PM

well as noted your config file needs to have the proper variables so you can connect to the server and ppmysql function is defined in your pp-inc.php file so that file is corrupt or missing

jakaroo · September 23rd, 2006, 11:44 AM

thanks for the help, i went through again and did find a typo. the upgrade seemed to go well, but now when i get to my gallery....all the pictures (thumbnails too ) are gone. well, they are still on the server, but nothing is linking....
what could be the cause of this.... thanks again for your help...
http://www.metalmeet.com/photopost

Jack

Chuck S · September 23rd, 2006, 01:05 PM

You did not run all the required upgrades. You missed 485 and ONLY RUN THIS ONCE.

You might want to make sure every upgrade from your last version forward has been ran once

jakaroo · September 23rd, 2006, 02:31 PM

In the config file, it showed i was at version 4.7, and on the upgrade.php, it shows that I completed every upgrade after that... i get a ton of errors when doing version 4.85 with these being the last 5

Warning: fclose(): supplied argument is not a valid stream resource in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3255

Warning: fopen(/home/webadmin/metalmeet.com/html/photopost/data/3376/medium/index.htm): failed to open stream: Permission denied in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3260

Warning: fclose(): supplied argument is not a valid stream resource in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3261

Warning: fopen(/home/webadmin/metalmeet.com/html/photopost/data/3376/mini/index.htm): failed to open stream: Permission denied in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3266

Warning: fclose(): supplied argument is not a valid stream resource in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3267

they are all the same pretty much, just different address of the errors, could i have had a earlier version? should I have not selected to move data folders?

thanks again
jack

Chuck S · September 23rd, 2006, 02:41 PM

Loks to me like your data directory permissions are not right you need to set them to 777 at every level

jakaroo · September 23rd, 2006, 03:29 PM

thanks...would i need to run the 485 again after i check the settings?

Chuck S · September 23rd, 2006, 06:24 PM

Yes as it has never been run all the way through

jakaroo · September 23rd, 2006, 11:41 PM

Thanks Chuck,
i checked the settings and started over trying to reupgrade..but still the same errors. nothing looks different.... at 485 is where the errors start. still the forum works, but no pictures displayed.
I do appreciate your help
jack

Chuck S · September 24th, 2006, 06:49 AM

This is because you have not completed your upgrade and nothing will never show till you do.

The only errors you posted where permissions related. So you need to set the data directory and ALL its subcategories at every level to 777

--data
---3376
---thumbs
---medium
---mini

After you do this you need to continue through the 485 upgrade ALL THE WAY THROUGH ONCE. All 3 steps

jakaroo · September 24th, 2006, 09:57 PM

hey chuck,
i set permissions to 777 on all directories. during the first step of the upgrade i get:
Preparing to update 4.8.5 database...
Error performing MySQL command: ALTER TABLE pp_photos ADD numcom INT(8) DEFAULT '0' NOT NULL , ADD lastposter VARCHAR(255), ADD lastpid INT(8) DEFAULT '0' NOT NULL
Error: Duplicate column name 'numcom'

Error performing MySQL command: ALTER TABLE pp_categories ADD maximages INT(12) default '0' NOT NULL, ADD canzip VARCHAR(3) DEFAULT 'no' NOT NULL, ADD frames VARCHAR(32) NULL
Error: Duplicate column name 'maximages'

Error performing MySQL command: ALTER TABLE pp_categories ADD numextra INT(3) default '0' NOT NULL
Error: Duplicate column name 'numextra'

Error performing MySQL command: ALTER TABLE pp_categories ADD intro VARCHAR(3) default 'no' NOT NULL, ADD introtitle VARCHAR(128) DEFAULT NULL, ADD introcopy TEXT DEFAULT NULL, ADD moderators TEXT DEFAULT NULL
Error: Duplicate column name 'intro'

Error performing MySQL command: ALTER TABLE pp_categories ADD ratingtype INT(1) DEFAULT '0' NOT NULL, ADD takevotes INT(1) DEFAULT '0' NOT NULL
Error: Duplicate column name 'ratingtype'

Error performing MySQL command: CREATE TABLE pp_photoviews (photoid mediumint(9) NOT NULL default '0') TYPE=HEAP
Error: Table 'pp_photoviews' already exists

Error performing MySQL command: CREATE TABLE pp_extrafields (id INT(12) NOT NULL AUTO_INCREMENT, cat INT(12), fieldname VARCHAR(255), fieldtype VARCHAR(2), fieldoptions TEXT, PRIMARY KEY (id) )
Error: Table 'pp_extrafields' already exists

Error performing MySQL command: CREATE TABLE pp_photoextras (id INT(12) NOT NULL AUTO_INCREMENT, photo INT(12), extraid INT(12), selection TEXT, PRIMARY KEY (id) )
Error: Table 'pp_photoextras' already exists

Error performing MySQL command: ALTER TABLE pp_users ADD cellphone VARCHAR( 255 )
Error: Duplicate column name 'cellphone'

After the second step i get the below even after setting permissions ( this is the first part of the long list of failures....

Warning: fopen(/home/webadmin/metalmeet.com/html/photopost/data/500/thumbs/index.htm): failed to open stream: Permission denied in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3254

Warning: fclose(): supplied argument is not a valid stream resource in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3255

Warning: fopen(/home/webadmin/metalmeet.com/html/photopost/data/500/medium/index.htm): failed to open stream: Permission denied in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3260

Warning: fclose(): supplied argument is not a valid stream resource in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3261

Warning: fopen(/home/webadmin/metalmeet.com/html/photopost/data/500/mini/index.htm): failed to open stream: Permission denied in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3266

Warning: fclose(): supplied argument is not a valid stream resource in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3267

Warning: fopen(/home/webadmin/metalmeet.com/html/photopost/data/505/thumbs/index.htm): failed to open stream: Permission denied in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3254

Warning: fclose(): supplied argument is not a valid stream resource in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3255

thanks again for your help

Chuck S · September 25th, 2006, 09:14 AM

Are you understanding that I am saying you set EVERY LAST DIRECTORY IN DATA AT EVERY LEVEL DOWN TO 777?

Duplicate errors are of no concern. You need to run through the upgrade scripts all the way through once.

jakaroo · September 25th, 2006, 09:25 AM

yes chuck, i do understand what you are saying and I have gone through and made sure they were all set to 777. I will go back through them all again and see if I missed on by some chance.
thanks again
Jack

Chuck S · September 25th, 2006, 09:26 AM

When asking for support the following is needed usually or we are simply going to be going round and round here in circles

1. full description of the issue in as much detail as possible
2. link to your photopost install
3. test regular user login so we can see photos etc upload.

jakaroo · September 25th, 2006, 03:53 PM

Chuck,
I have checked the directories and subdirectories under the data folder and all are set to 777. my site is at www.metalmeet.com/photopost The only errors I continue to get are the ones posted above and no pictures are viewable in photopost....although they are in the data folder. I can provide you any account log on information in a pm or email if requested. I would also be intersted in just paying to get it to work if that would work better.
thanks for your help again
Jack

Chuck S · September 25th, 2006, 04:43 PM

http://www.metalmeet.com/photopost/s...1&limit=recent

Your photos dont show cause you ran the 485 upgrade twice

You need to restore a backup of that table and rerun the upgrades ONCE

jakaroo · September 26th, 2006, 03:05 PM

Ok, I have put in a old ( week old) back up of the database and my data directory. now, when i run the upgrade, do I just need to skip the step of move data folder at 485? Can the pictures just stay where they are?

Chuck S · September 26th, 2006, 03:09 PM

Once you restore a mysql backup you run the upgrade script straight through THE ONES YOU NEED TO RUN ONCE.