site crashed by updating -site is up again, cannot edit anymore

Permalink
Hi,

I tried to update one of my sites (ttt-theaterproducties.nl) to 5.7.4.2, but this didn't work out. I got a message that one of the paths wasn't correct. That message appeared on all pages and I thought I lost my complete site (no I didn't make a backup. That is stupid I known).

My hoster helped me a bit by (I thought) renaming update.php and my site is up again. Well, kind of. I cannot edit any page, I cannot create a backup, so I'm pretty stuck right now.

If I copy the installation files of the latest version onto it, would that help? What is the best approach? I can get into the dashboard, but that's about all...

Can anybody get me into the right direction?

Kind regards,
David

 
VPenkov replied on at Permalink Reply
VPenkov
I'd try making a backup first of my current files and database, then replace everything with the latest version, then running the update script.

I doubt a solution can be provided without looking at the actual errors that you're getting, but drop me a PM if you need someone to spend some time fixing this.
WillemAnchor replied on at Permalink Reply
WillemAnchor
I just had similar problems.
I gathered a few links and possible solutions:http://www.anchor-ict.com/blog/upgrade-573-5753-problems...
VPenkov replied on at Permalink Reply
VPenkov
Putting the sessions into the database is unlikely to solve his problem.
They were stored in files before this version so he would have had problems with the previous versions as well.

Plus, he can get into his dashboard which means that his sessions are working.
No other part of Concrete 5.7 operates outside its base directory so the open_basedir restriction is unlikely to trigger an error for anything else.
podarcis replied on at Permalink Reply
Hi all,

Thanks for everyones responses.

I forgot to write down the first error-message (with the path-error), as I thought I had lost my site already and I thought I had to start all over again.

When I visit the site and want to edit it, I don't get any error-messages. It is just that when I want to add something, or change a block on a page it just doesn't change to 'edit-mode'. When I select a new block (like "image") the block hovers on my page, but none of the areas where I normally could drop them lights up.

In the dashboard do get an error:

in /dashboard/sitemap:

! Load Error! (Parsererror)

in /dashboard/files

It doesn't show any files

Maybe an indication what is wrong; On all pages it shows "##" on top. Does that indicate something? They didn't show up before...
VPenkov replied on at Permalink Reply
VPenkov
Have you tried what I suggested?
podarcis replied on at Permalink Reply
Not yet... currently @work.
When I copy the latest installation files over my current files, is there still an update-button somewhere? Or should I execute something likehttp://mysite/index.php/update?...
VPenkov replied on at Permalink Reply
VPenkov
/index.php/tools/required/upgrade
podarcis replied on at Permalink Reply
Well, tried that (finally).

I made a copy of the database and all the files of the site as backup. Copied Concrete 5.7.5.3 onto the current files and then went to

http://mysite/index.php/tools/required/upgrade....
It looks like it is redirected tohttp://mysite//ccm/system/upgrade... and I end up with a blank screen with:

### access denied.


(I don't think I have a subdir called ccm?)

When I go to the main site:http://mysite I get the following error:

Er heeft zich een onverwachte fout voorgedaan:
An exception occurred while executing 'SELECT t0.issID AS issID1, t0.customClass AS customClass2, t0.backgroundColor AS backgroundColor3, t0.backgroundImageFileID AS backgroundImageFileID4, t0.backgroundRepeat AS backgroundRepeat5, t0.borderColor AS borderColor6, t0.borderStyle AS borderStyle7, t0.borderWidth AS borderWidth8, t0.borderRadius AS borderRadius9, t0.baseFontSize AS baseFontSize10, t0.alignment AS alignment11, t0.textColor AS textColor12, t0.linkColor AS linkColor13, t0.marginTop AS marginTop14, t0.marginBottom AS marginBottom15, t0.marginLeft AS marginLeft16, t0.marginRight AS marginRight17, t0.paddingTop AS paddingTop18, t0.paddingBottom AS paddingBottom19, t0.paddingLeft AS paddingLeft20, t0.paddingRight AS paddingRight21, t0.rotate AS rotate22, t0.boxShadowHorizontal AS boxShadowHorizontal23, t0.boxShadowVertical AS boxShadowVertical24, t0.boxShadowBlur AS boxShadowBlur25, t0.boxShadowSpread AS boxShadowSpread26, t0.boxShadowColor AS boxShadowColor27, t0.hideOnExtraSmallDevice AS hideOnExtraSmallDevice28, t0.hideOnSmallDevice AS hideOnSmallDevice29, t0.hideOnMediumDevice AS hideOnMediumDevice30, t0.hideOnLargeDevice AS hideOnLargeDevice31 FROM StyleCustomizerInlineStyleSets t0 WHERE t0.issID = ?' with params ["12"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.hideOnExtraSmallDevice' in 'field list'


Looks like there is a problem with the database... any suggestions in how to proceed?
VPenkov replied on at Permalink Reply
VPenkov
Make sure you're logged in as an administrator first ( site.com/index.php/login ).

Then it will work fine.
The SQL error is normal at this stage. It means that your files are upgraded but your database isn't (which is what the /ccm/system/upgrade does)
podarcis replied on at Permalink Reply
I was logged in before I copied all new files.

Now I can't login anymore;

Er heeft zich een onverwachte fout voorgedaan:
Doctrine\Common\Proxy\AbstractProxyFactory::getProxyDefinition(): Failed opening required '/var/www/vhosts/ttt-theaterproducties.nl/httpdocs/application/config/doctrine/proxies/__CG__ConcreteCoreFileStorageLocationStorageLocation.php' (include_path='/var/www/vhosts/ttt-theaterproducties.nl/httpdocs/concrete/vendor:.:')
VPenkov replied on at Permalink Reply
VPenkov
What version of PHP does your server run?

You can check by creating a file called phpinfo.php in your website's main directory, then put this in there:
<?php phpinfo(); ?>


And open yoursite.com/phpinfo.php
podarcis replied on at Permalink Reply
The PHP-version is 5.4.45
VPenkov replied on at Permalink Reply
VPenkov
How about your OS? Do you host it on a Windows machine?
Also, what was the Concrete5 version you were running until now?
podarcis replied on at Permalink Reply
No, it's on a linux machine.

I wish I knew the version I was using before... it was one of the first (with some, but don't know how many, updates) of the 5.7 versions...

I'll copy everything back, see if i can retrace the version
VPenkov replied on at Permalink Reply
VPenkov
Would it be okay if I requested to PM me some FTP login details and your Skype name? I think I can resolve your issue by editing some files but it will take too long if we chat here. I'll do my best to document my actions afterwards and write them up as a solution here.

This looks like an old 5.7.0.2 bug.
VPenkov replied on at Permalink Reply
VPenkov
Oh! Now that I mentioned this, you should upgrade to 5.7.3 first before 5.7.5.3. Get it here:https://github.com/concrete5/concrete5/archive/5.7.3.zip...

This should be the solution.
VPenkov replied on at Permalink Reply
VPenkov
Looks like a bug. Continued here:https://www.concrete5.org/index.php?cID=791057...