Updating my gallery

Ted M · April 15th, 2009, 07:24 PM

Hello all,

I just got the announcement that PhotoPost Pro has been updated to 6.22.

I have NO idea how to update my gallery... in fact, I paid for Installation and Chuck was kind enough to do that for me.

Are there EASY to understand instructions on what I need to do?

Heck,I have no idea how to even find my version!

Thanks much!

Chuck S · April 16th, 2009, 08:25 AM

Ted

Your version is listed in the admin statistics.

Upgrade instructions are included in the documentations folder.

Basically you upload all files except the config files install file and run upgrade.php and select the upgrades you need to run if any depending on your version.

Ted M · April 16th, 2009, 08:46 AM

Quote:

Originally Posted by Chuck S

Ted

Your version is listed in the admin statistics.

Upgrade instructions are included in the documentations folder.

Basically you upload all files except the config files install file and run upgrade.php and select the upgrades you need to run if any depending on your version.

Chuck, thanks so much for getting back to me!

I think that makes sense to me...so you must have done a good job explaining it! LOL! Not much makes sense to me!

How do I "run upgrade.php"? Do I just enter in my browser:

http://www.mysite.com/gallery/upgrade.php ?

Or is there a different way?

Chuck S · April 16th, 2009, 08:50 AM

Yes thats what you do and select which upgrades you need for example if you have 6.1 you run the 6.1 to 6.2 upgrade.

Ted M · April 16th, 2009, 09:04 AM

Chuck, I downloaded/extracted 6.22.

I see a config-inc.php and a config-int.php

Do those get uploaded to my site? Or are those the "config" files which I don't upload?

Chuck S · April 16th, 2009, 10:12 AM

You do NOT upload config files

Ted M · April 16th, 2009, 10:39 AM

Okay... I uploaded the necessary files...and ran upgrade.php but I see no option to upgrade from 6.21 to 6.22.

I do see an option to upgrade from 6.1 to 6.2, but then it says I do this ONLY if I have 6.1...which I do not.. I have 6.21

What should I do please?

Ted M · April 16th, 2009, 10:47 AM

And now I have an error.

I went to vBulletin and chose QuickLinks > Mark Forums Read and get this error:

"Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/content/t/m/a/<myname>/html/gallery/inc_features.php on line 67
Table '<myname>.pp_photos' doesn't exist"

I'm guessing it is something I did with this upgrade, because it was working fine before...and it does mention "gallery" in the error path.

Ack! Please help!

Edit: In fact I can't access my forums at all now!

Ted M · April 16th, 2009, 10:50 AM

Also, when I did try to upgrade, I got this page:

Preparing to update database...
Error performing MySQL command: INSERT INTO pp_settings VALUES (240,'Enable Flash uploader?','flashupload','Selects flash uploader if user is registered and flash is installed. As a 3rd party plug-in, this option is not supported by PhotoPost support.','no',29,6)
Error: Duplicate entry '240' for key 1

Error performing MySQL command: ALTER TABLE pp_users ADD paypal VARCHAR(75) NOT NULL DEFAULT ''
Error: Duplicate column name 'paypal'

Error performing MySQL command: INSERT INTO pp_admingroups VALUES (15, 'Payment Options');
Error: Duplicate entry '15' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (241, 'Which Payment Processor do you want to use?', 'processor', 'currently paypal and authorize.net are supported', 'paypal', 3, 15)
Error: Duplicate entry '241' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (242, 'Authorize.Net Login ID', 'authorizeid', 'Your Login ID for Authorize.Net.', '', 4, 15)
Error: Duplicate entry '242' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (243, 'Authorize.Net Transaction Key', 'authorizekey', 'The transaction key as specified within the Security section of the Authorize.Net merchant account system.', '', 5, 15)
Error: Duplicate entry '243' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (244, 'MoneyBookers Email', 'mbemail', 'Please enter your MoneyBookers email, all references to the subscription service will use this email.', '', 6, 15)
Error: Duplicate entry '244' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (245, 'Moneybookers Secret Word', 'mbsecret', 'Secret Word in lowercase as typed into your Moneybookers Profile.', '', 7, 15)
Error: Duplicate entry '245' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (246, 'WorldPay Installation ID', 'wp_instid', 'The Install ID that is generated by the WorldPay CMS for the subscription callback.
You must set your callback url to point to your payment.php script', '', 8, 15)
Error: Duplicate entry '246' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (247, 'WorldPay Callback Password', 'wp_password', 'The password entered during the creation of the subscription callback within the WorldPay CMS.', '', 9, 15)
Error: Duplicate entry '247' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (248, 'Default Currency', 'currency', '', 'USD', 19, 1)
Error: Duplicate entry '248' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (249,'Your PayPal email address for your account?', 'paypalemail', 'Required to receive payments!', '', 12, 15)
Error: Duplicate entry '249' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (250,'PayPal currency code?', 'paypalcur', 'USD for US Dollar', 'USD', 13, 15)
Error: Duplicate entry '250' for key 1

Error performing MySQL command: CREATE TABLE pp_payments (id int(12) NOT NULL auto_increment, amount float(12,2) NOT NULL default '0', pmt_key VARCHAR(32) NOT NULL default '', user_id INT(5) NOT NULL default '0', sub_id INT(5) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM
Error: Table 'pp_payments' already exists

Error performing MySQL command: INSERT INTO pp_currency VALUES (1,'US Dollars','USD','$', '0')
Error: Duplicate entry '1' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (2,'Britain Pounds','GBP','£', '0')
Error: Duplicate entry '2' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (3,'Canadian Dollars','CAD','$', '0')
Error: Duplicate entry '3' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (4,'Australian Dollars','AUD','$', '0')
Error: Duplicate entry '4' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (5,'Brazil, Reais','BRL','R$', '0')
Error: Duplicate entry '5' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (7,'Costa Rica, Colón','CRC','₡', '2')
Error: Duplicate entry '7' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (8,'Denmark Kroner','DKK','kr', '2')
Error: Duplicate entry '8' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (9,'Euro','EUR','€', '0')
Error: Duplicate entry '9' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (10,'Lira','ITL','₤', '1')
Error: Duplicate entry '10' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (11,'Franc','FRF','₣', '1')
Error: Duplicate entry '11' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (12,'Korea (South), Won','KRW','￦', '3')
Error: Duplicate entry '12' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (13,'Japan, Yen','JPY','¥', '3')
Error: Duplicate entry '13' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (14,'South Africa, Rand','ZAR','R', '0')
Error: Duplicate entry '14' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (15,'Indian, Rupees','INR','₨', '2')
Error: Duplicate entry '15' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (16,'Thailand, Baht','THB','฿', '0')
Error: Duplicate entry '16' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (17,'Laos, Kips','LAK','₭', '3')
Error: Duplicate entry '17' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (18,'China, Yuan','CNY','元', '3')
Error: Duplicate entry '18' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (19,'Hong Kong, Dollars','HKD','HK$', '0')
Error: Duplicate entry '19' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (20,'Iran Rials','IRR','﷼', '2')
Error: Duplicate entry '20' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (21,'Israel, New Shekels','ILS','₪', '2')
Error: Duplicate entry '21' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (22,'Mongolia, Tugriks','MNT','₮', '2')
Error: Duplicate entry '22' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (23,'Netherlands Antilles, Guilders/Florins','ANG','ƒ', '2')
Error: Duplicate entry '23' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (24,'Nigeria, Nairas','NGN','₦', '2')
Error: Duplicate entry '24' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (25,'Russia, Rubles','RUB','руб', '2')
Error: Duplicate entry '25' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (26,'Taiwan, New Dollars','TWD','NT$', '0')
Error: Duplicate entry '26' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (27,'Vietnam, Dong','VND','₫', '2')
Error: Duplicate entry '27' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (28,'Pesos','COP','₱', '0')
Error: Duplicate entry '28' for key 1

Error performing MySQL command: INSERT INTO pp_currency VALUES (29,'Signapore Dollars','SGD','SGD$', '0')
Error: Duplicate entry '29' for key 1

Upgrade complete! You need to remove the upgrade.php script for security reasons before continuing.

Chuck S · April 16th, 2009, 12:01 PM

PhotoPost Enhanced vB3 Index Integration

Please read the bold text in this thread. You need to uncomment the mysql_select_db lines and link lines and fill out with the proper mysql info

Ted M · April 16th, 2009, 12:07 PM

I will have to do this each time I upgrade?

Chuck S · April 16th, 2009, 12:09 PM

well yes and no. Only if you replace the inc_features.php file

Ted M · April 16th, 2009, 12:50 PM

Quote:

Originally Posted by Chuck S

well yes and no. Only if you replace the inc_features.php file

Should I NOT replace the inc_features.php file next time I follow the upgrade directions (as I don't replace the config and install files)?

I'm starting to think that I shouldn't upgrade that often if I'm going to have to deal with this problem each time I upgrade.

Ted M · April 16th, 2009, 01:01 PM

Hi Chuck,

Okay, I printed out that link of integrating and I did scan over the bold information.

I have no idea how to do any of that.

Is there a way to go back to before I started to try to upgrade? So then I don't have to deal with any of this?

Chuck S · April 16th, 2009, 01:25 PM

Nope but if you send us ftp and admin info we may be able to assist.

Ted M · April 16th, 2009, 01:35 PM

Thank you very much for your generous offer, Chuck... I may take you up on that!

Ted M · April 16th, 2009, 02:53 PM

I'm curious about something...

Since my forums and gallery are integrated, were there different steps I should have done to upgrade?

I saw nothing about it in the "upgrade.txt".

Chuck S · April 16th, 2009, 05:15 PM

No the steps are no different if its integrated with a forum or not.

Ted M · April 16th, 2009, 05:50 PM

Hi Chuck and thanks for answering.

I paid a friend to fix the problem. I guess I just get frustrated that it wouldn't be easier to upgrade... but I'm aware I'm no programmer.

I apologize if I took out my frustration on you and the forums.

Chuck S · April 16th, 2009, 08:30 PM

Have a good night no problems thats why we are here