PDA

View Full Version : Fatar errors photopost 6.2


Niyuka
January 29th, 2009, 02:21 AM
Hi,

I am receiving the same errors just like the others when i tried to upgrade to 6.2


http://www.photopost.com/forum/photopost-pro-installation-upgrades/139042-upgrade-loop.html

http://www.photopost.com/forum/photopost-pro-installation-upgrades/139076-fatal-error.html


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.

May be that is why my gallery is not functioning right for me or/and i have some missing features? which is why i am having issues like this one ?

http://www.photopost.com/forum/general-discussion/139071-bug-something-went-wrong.html

Chuck S
January 29th, 2009, 11:16 AM
I upgraded your gallery without issue. Duplicate issues mean your running queries that already exist in the program.