Upgrade Issues

arcab4 · April 2nd, 2012, 11:56 AM

Hi,

was running 3.1. and just purchased my renewal and upgraded. went through the upgrade process and when i was done, my images are all gone and also links are all gone.

logged into the admin (there was no visible link on the reviewpost but i had photopost installed os i was able to find the admin link). logged in and it says my current version is 5.21. but the left nav there are no links. the boxes are there but contain nothing.

thanks!

Chuck S · April 2nd, 2012, 02:50 PM

You did not run the upgrade 3.1 script from what I am seeing. Also your data directory is not 777 at every level so you need to fix that and then run the required upgrades.

arcab4 · April 2nd, 2012, 07:52 PM

got the text to show up. had to upgrade the language in the upgrade.php file.

in the admin it says current version is 5.21 but in the announcement box it's telling me 4.12 is available.

you said i didnt' run the 3.1 upgrade script. upon clicking it, i got a bunch of mysql errors and this message at the bottom:

Move DATA directory files (you only do this only once successfully) --> or quit here.
Moving data files can take some time depending on your installation; 10,000 files could take 5 minutes or more. Please be patient.

i did not continue on. still also can't get images to show up.

Chuck S · April 2nd, 2012, 09:29 PM

yes you did not run your upgrade which is what I am saying your stopping for some reason.

You are running all except the 3.1 upgrade for some reason. You are stopping for some reason after step 1 there are 3 steps.

Now you do not want to run the steps to move the files and rename them until you set your data directory permissions recursively to 777 like I said. I also show you have not done this yet either.

arcab4 · April 3rd, 2012, 12:32 AM

thanks!

so this is what i am going to do..

1. all the folders in DATA and subfolders (there is alot) change them all to 777
2. run the 3.1 upgrade again.

just for the record..this is the error i got when i ran the 3.1 upgrade.

Preparing to update 3.11 database...

Performing MySQL command: REPLACE INTO rp_settings VALUES (84,'ReviewPost Version','pversion','','3.2',53,0); ... Error: Column count doesn't match value count at row 1
Performing MySQL command: REPLACE INTO rp_settings VALUES (37,'cright','cright','','Powered by: ReviewPost --replaceme--
Copyright 2006 All Enthusiast, Inc.',300,'0') ... Error: Column count doesn't match value count at row 1
Performing MySQL command: INSERT INTO rp_settings VALUES (242,'Do you want to enable the Announcement box?','news', '', 'no', 12, 3) ... Error: Column count doesn't match value count at row 1
Performing MySQL command: INSERT INTO rp_settings VALUES (243,'Title for the Announcement box?','newstitle', '', 'News', 13, 3) ... Error: Column count doesn't match value count at row 1
Performing MySQL command: INSERT INTO rp_settings VALUES (244,'Contents of the Announcement box?','newscopy', 'This block can contain HTML code (200 character limit)', '', 14, 3) ... Error: Column count doesn't match value count at row 1
Performing MySQL command: INSERT INTO rp_settings VALUES (245,'Use category cache?','catcache','On some larger sites, using the category cache can actually reduce performance.','no',36,1) ... Error: Column count doesn't match value count at row 1
Performing MySQL command: INSERT INTO rp_settings VALUES (246,'Display Featured Ads on this page?','features','On larger sites this option can slow down the showcat page. Turn off to speed up this page.','yes',8,5) ... Error: Column count doesn't match value count at row 1
Performing MySQL command: INSERT INTO rp_settings VALUES (247,'Display Admin quick move/delete options under ad?','quickopts','On larger sites this option can slow down the showproduct page. Turn off to speed up this page.','yes',8,5) ... Error: Column count doesn't match value count at row 1
Performing MySQL command: INSERT INTO rp_settings VALUES (248,'Load limit for server?','loadlimit','If running *nix and you want to disable your forums when load goes over a certain limit; place the high limit here.','0',35,1) ... Error: Column count doesn't match value count at row 1
Performing MySQL command: ALTER TABLE rp_categories ADD intro VARCHAR(3) default 'no' NOT NULL, ADD introtitle VARCHAR(128) DEFAULT NULL, ADD introcopy TEXT DEFAULT NULL, ADD theme VARCHAR(32) NOT NULL, ADD sortorder INT(2) DEFAULT '1' NOT NULL, ADD frames VARCHAR(32) NULL ... Error: Duplicate column name 'intro'
Performing MySQL command: REPLACE INTO rp_settings VALUES (206,'Show Last Product column on Index?','showlast','','yes',17,3) ... Error: Column count doesn't match value count at row 1
Performing MySQL command: REPLACE INTO rp_settings VALUES (79,'Show Most Popular products on Index page?','dispopular','','no',5,3) ... Error: Column count doesn't match value count at row 1
Performing MySQL command: REPLACE INTO rp_settings VALUES (224, 'setting224', 'ppboards', 'open', 20,

Chuck S · April 3rd, 2012, 07:42 AM

You will get duplicate errors on step 1 sure since you ran that.

You want to do what you posted yes but you need to run through that upgrade. You have not ran step 2 or step 3 yet. You need to click the step 2 link to move files etc.

arcab4 · April 3rd, 2012, 12:20 PM

thanks chuck. did as told. it seems to work. my images show up and etc.

in the admin it says my current version is 5.21 - but in the announcement box it keeps on telling me that ReviewPost 4.12 Now Available!. so just disregard or did i still not completely 100% of the upgrade. my admin is still in the blue color template. just wondering as my photopost admin is now black template. unless that is changeable somewhere.

Chuck S · April 3rd, 2012, 04:57 PM

The news announcement I will pass along as that was updated I thought

Anyway the reviewpost admin has always used its own style.

The only vb style we show is on the front end.