is this a problem?

hornstar6969 · April 13th, 2009, 10:10 PM

I just upgraded from 6.11 to 6.21 and on the last step it said:

Quote:

PhotoPost Upgrade
Preparing to update database...

Error performing MySQL command: CREATE TABLE vb3_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 'vb3_payments' already exists

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2 questions:

1. Is this going to cause any problems?

2. Is there any function or query that I can use to mass rebuild all the thumbnails?

Chuck S · April 13th, 2009, 11:22 PM

1. No you just ran the upgrade more than once.

2. Not sure what you mean. If you changed the thumbnail size and want to rebuild them sure you can do so in admin => scan database. If you did an upgrade and are missing all your thumbs thats a different issue you need to deal with.