Fatal error

[Meghwar]

VB 3.7
PP 6.2

I use to have old 6.02 PP I FTP all files. I see no pictures no thumbs i see no images at all....
I did back up DB all files on the ftp is ok all images still their, Cats, and sub cats all visible but no images.

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/content/m/e/g/*****/html/PhotoPost/pp-inc.php on line 4402

[Chuck S]

Have you ran your upgrades 6.0-6.1 and 6.1-6.2 as per the upgrade instructions?

[Meghwar]

Originally Posted by Chuck S

Have you ran your upgrades 6.0-6.1 and 6.1-6.2 as per the upgrade instructions?

Yes CHUCK I did it ran in to errors while doing that?

Regards

[Meghwar]

Here what am getting:

Preparing to update database...
Error performing MySQL command: INSERT INTO pp_settings VALUES (236,'Enable Email a Friend feature?','findfriend','','yes',7,4)
Error: Duplicate entry '236' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (238,'Use images for user menu options on showphoto?','imgmenu','','yes',35,5)
Error: Duplicate entry '238' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (239,'Enable zoom javascript?','zoom','Enable the TJP zoom javascript feature on showphoto?','no',36,5)
Error: Duplicate entry '239' for key 1

Error performing MySQL command: ALTER TABLE pp_messages ADD fromuserid INT( 12 ) DEFAULT '0' NOT NULL AFTER userid
Error: Duplicate column name 'fromuserid'


Upgrade complete! You should continue to next step

Here the final step:

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]

You would definately need to post a link to your site OPEN so we can see it.

[Meghwar]

Originally Posted by Chuck S

You would definately need to post a link to your site OPEN so we can see it.

:::::!!!!!!!!!!!!!!!

how it works alone

[Chuck S]

not sure what your statement means. I asked for you to post a link to your site and open it. I saw a site which I thought was yours by browsing our license database but it was closed so lets make sure we are talking about the same site and we need to see it open to see what issues we see.

[Niyuka]

I received the same errors as well when upgrading. you get this error when you visit upgrade.php and perform it, u would see these errors

[skidpics]

does it work after the upgrade? Those errors look like it is an error stating that the fields already exist, which mean that if the upgrade ran smooth once for sure, those fields will already be there. Will the upgrade let you continue to the next step until it is final? Then does the site work?

[Chuck S]

Those are not errors they are warnings telling you that upgrade has already been performed.