View Single Post
Old June 17th, 2005, 12:46 PM   #18 (permalink)
ncg
Member
Verified Customer
 
Join Date: Dec 2004
Posts: 207
this is what i did:

1) put the catagories from the old db into the new db -- ok
2) put the products from the old db into the new db -- ok
3) put the reviews form the old db into the new db -- ok
4) run upgrade.php -- error

error:
Quote:
Performing MySQL command: INSERT INTO rp_settings VALUES (165,'Your SMF Cookie Name', 'smfcookie', 'Only needed for users of SMF forums', '', 5, 12) ... Error: Duplicate entry '165' for key 1
Performing MySQL command: INSERT INTO rp_settings VALUES (198,'Use 24 hour time format?','timeformat', 'You can elect to have time displayed as HH:MMam or using the 24 hour clock', 'no', 32, 1) ... Error: Duplicate entry '198' for key 1
Performing MySQL command: INSERT INTO rp_settings VALUES (205,'Show Last Reviews column on Index?','showrevs','','yes',16,3) ... Error: Duplicate entry '205' for key 1
Performing MySQL command: INSERT INTO rp_settings VALUES (206,'Show Last Product column on Index','showlast','','yes',17,3) ... Error: Duplicate entry '206' for key 1
Performing MySQL command: REPLACE INTO rp_admingroups VALUES (12,'Forum Settings') ... Successful!
Performing MySQL command: ALTER TABLE rp_products ADD numreviews INT(12) DEFAULT '0' NOT NULL AFTER lastpost ... Error: Duplicate column name 'numreviews'
Performing MySQL command: REPLACE INTO rp_settings VALUES (84,'ReviewPost Version','pversion','','2.91',53,0) ... Successful!

Warning: unlink(/hsphere/local/home/xxx/reviews//showgallery.php): No such file or directory in varhspherelocalxxxreviewsupgrade.php on line 566

Warning: unlink(/hsphere/local/home/xxx/reviews//login-inc.php): No such file or directory in varhspherelocalhomexxxreviewsupgrade.php on line 567

Warning: unlink(/hsphere/local/home/xxx/reviews//email-inc.php): No such file or directory in varhspherelocalhomexxxreviewsupgrade.php on line 568

Warning: unlink(/hsphere/local/home/xxx/reviews//adm-backup.php): No such file or directory in varhspherelocalxxxreviewsupgrade.php on line 569


Finished upgrade! You may now remove this script.
then my other issue is that hte review count dont show up, but when you click on a product to see a review they are all there that were there before.
ncg is offline   Reply With Quote