Upgrade tip
Permalink
hi all
i have to upgrade my Concrete5 install.
i had read the procedure how to do it , and on my test site(on my local machine)works fine. I had upgraded from version 5.3.3 to 5.4 with no errors or problems.
Now i have to do the same thing on my online website, but the site is running on C5 5.1.1, so i dont know if i can directlly upgrade to version 5.4 or i have to first upgrade to 5.3.2-5.3.3 and than to 5.4?
Thnx
i have to upgrade my Concrete5 install.
i had read the procedure how to do it , and on my test site(on my local machine)works fine. I had upgraded from version 5.3.3 to 5.4 with no errors or problems.
Now i have to do the same thing on my online website, but the site is running on C5 5.1.1, so i dont know if i can directlly upgrade to version 5.4 or i have to first upgrade to 5.3.2-5.3.3 and than to 5.4?
Thnx
thnx
Error occurred while upgrading: mysql error: [1142: INDEX command denied to user 'renderc9_admin'@'localhost' for table 'BlockTypes'] in EXECUTE("DROP INDEX btHandle ON BlockTypes")
i get this type of error after pressing the button "Upgrade", any clue?
did i have to recreate the INDEX on this table?
i get this type of error after pressing the button "Upgrade", any clue?
did i have to recreate the INDEX on this table?
at what upgrade point did this error occur? from 5.1 to 5.3 or 5.3 to 5.4? I had an issue on localhost windows upgrading to 5.4 but I'd backed up the bits nad pieces I needed and did a fresh install so probably something I'd done but on the clean install it was perfect :)
from 5.1.1 to 5.3.2, only this error appears. I checked the database and found that BlockTypes table has duplicated rows,btHandle,btHandle2,btHandle3 i dont know if i have to delete them or not...
on localhost on windows(wampserv)everything went smooth and with no errors, upgrade from 5.3 to 5.4...
on localhost on windows(wampserv)everything went smooth and with no errors, upgrade from 5.3 to 5.4...
... do u have reuploaded all the data from the old version to the fresh install?
does this works?
does this works?
yeah, basically I always take a full backup before any upgrade just in case something goes awry, so basically restoring to a fresh install and running the upgrade again was pretty straight forward. In all honesty I still dont know for sure what happened with mine as I've never had an issue like it before.
i have done the back up of the entire concrete5 folder and of the database on the server locally, so i can restor anytime the old web site.
Just a thought on this point, you need to give your database user permissions to use the INDEX command, do you know if this permission is set?
i think not, i should check this. thnx
so, once we upgrade from 5.3.3.1 to 5.4.0 can we upgrade directly from 5.4.0 to 5.4.0.5 without the intermediate .2 and .3 in between? Or is it necessary to install and upgrade each increment?
Hey, yep thats right, I just upgraded a site straight from 5.4.0 to 5.4.0.5 without any issues. Just make you sure you have a full backup, including database backup before you go ahead just in case ;)
Yep, the INDEX permission was unchecked, that was the problem. Thnx again
I've upgraded three sites so far and 2 of them went perfectly. The third has been totally unsuccessful but realized that their is a pretty big jump from 5.2 to 5.4 to I think an intermediate step is a good idea. It shouldn't take to much extra time either.