URGENT HELP, UPDATE TO CONCRET 5.6.1 FAILED

Permalink
Hi
I just backed up the site and the mysql data base and tried to update the site to the new C5.6.1 and now I'm getting this error.

Could you please help this website has more than 900 ecommerce products which countless hours have gone into listing.

If I want to restore the website can i just delete current www root folder and put back up online or does the update effect the original mysql data base as well?

If it does how do i restore the mysql database as well?

Screen shot of error im getting attached.

Cheers

mmdan
 
mmdan replied on at Permalink Reply 1 Attachment
mmdan
error attached.

Please help!
SheldonB replied on at Permalink Reply
SheldonB
I can't help with your error. But if you ftp to your config/site.php you can go back to the previous version you were on that was working.

then reload the backed-up database (if you need too) if there still is an issue

I ran into a few mysql errors when updating concrete5 that were caused by my shared hosting server and not concrete 5 .. but I had a diffrent error message
mmdan replied on at Permalink Reply
mmdan
Sorry so I don't reupload the entire root folder? if not which folder or files need to be overwritten with back up files?

Also when you say restore the database your talking about the mysql database through the backup dashboard?

I've been having timeouts and all sorts of issues since my host upgraded to mysql 5.5 form 5 so I tough if we upgrade the C5 and the ecommerce app it would improve.

ahhhh stressing now!

Thanks in advance!
SheldonB replied on at Permalink Best Answer Reply
SheldonB
your concrete 5 core files are in the updates folder
should look like
/public_html/updates

inside you should see
concrete#.#.#

in
/public_html/config/site.php

you should see a line that looks like this
<?php define('DIRNAME_APP_UPDATED', 'concrete5.6.1.0');?>


you change the concrete5.#.#.# -> to the last version you had found in the updates folder

(this is probably clearer)
http://www.rynomediaonline.com/resources/downgrading-your-concrete5...
SheldonB replied on at Permalink Reply
SheldonB
as a second thought I would call your hosting company to see if they see anything funny on there end since they just upgraded. if it is a true mysql error rolling back the versions might not help you because the database is screwed up .. you will have find someone who can help you rebuild that table by hand (worst case)

I had something funny on a few of my sites with msql was being updated server side and I had no clue and it issue lasted for about a day and then disapeared
mmdan replied on at Permalink Reply
mmdan
This website has over 900 products so the table is massive! over 10.5 mb in size!

I backed up the entire site files through ftp, cant i just reupload those files and overwrite current update?

Im trying to do what you've said now!

Cheers

Dan
mmdan replied on at Permalink Reply
mmdan
this is the old site.php file cant i put this back in config folder as is?
SheldonB replied on at Permalink Reply
SheldonB
replacing the site.php with the old one .. idk because there is a key the "Password_salt"? ..I'm not sure how that changes.. if there the same then sure
SheldonB replied on at Permalink Reply
SheldonB
That's a big database

you might want to look at this

http://www.concrete5.org/documentation/how-tos/developers/backup-a-...

also if you have statistics on those are also stored in the database and can build up very fast so keep that off and use an outside source like google (when I cleared my tables for statistics my database dropped a few MB)

.. if all else fails..
if you did back up correctly your database and files you could just rewrite over them, but if your not sure exactly how to do that you could also destroy your site for good (if for some reason your backups were bad - so be careful just rewriting everything) I've done it twice with no issues but I've read people having issues on the forms (I would look at the "how to move your site" before you go all out)