June 17th, 2005, 12:46 PM
|
#18 (permalink)
|
| 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.
|
| |