6.2 b2

grahamsmythe · November 21st, 2008, 04:41 PM

We're currently running the second beta version of 6.2 with the fantastic flash uploader.

I see there's now a stable version of 6.2 running.

How do we upgrade to this gold version, and do we have to run the upgrade script or do we just need to upload the new files?

Chuck S · November 21st, 2008, 09:18 PM

You would need to upload the files and run the upgrade script from 6.1 to 6.2

grahamsmythe · November 22nd, 2008, 03:42 PM

I tried that and got the following error.

Quote:

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 · November 23rd, 2008, 10:14 AM

Yes thats fine. You would run it again just to get changes that where not present after the beta 2. Duplicate issues are not a problem.