Forums

Error 500 on move page after C5 upgrade

Permalink
Hi,

I can't move page anymore (either from the sitemap or the page directly) after my upgrade from 5.6.1.2 to 5.6.2.1

I got the "waiting" gif turning forever and in my developer tools toolbar I got and ERROR 500 with a link:http://xxx/tools/required/dashboard/sitemap_update.php??foo=1&c...


An unexpected error occurred.
mysqlt error: [1054: Unknown column 'Array' in 'where clause'] in EXECUTE("select Pages.cID, Pages.pkgID, Pages.cPointerID, Pages.cPointerExternalLink, Pages.cIsActive, Pages.cIsSystemPage, Pages.cPointerExternalLinkNewWindow, Pages.cFilename, Collections.cDateAdded, Pages.cDisplayOrder, Collections.cDateModified, cInheritPermissionsFromCID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cCheckedOutUID, cIsTemplate, uID, cPath, cParentID, cChildren, cCacheFullPageContent, cCacheFullPageContentOverrideLifetime, cCacheFullPageContentLifetimeCustom from Pages inner join Collections on Pages.cID = Collections.cID left join PagePaths on (Pages.cID = PagePaths.cID and PagePaths.ppIsCanonical = 1) where Pages.cID = Array")


Any idea?
appliculture
 
JohntheFish replied on at Permalink Reply
JohntheFish
Some ideas:

It could be a browser cache issue, where the browser is still using an out of date version of a c5 script.

It could also be an incomplete upgrade, so check config/site.php for the applicable upgrade definition and also 'environment information' in the dashboard.

Another possibility is the c5 cache or pretty urls. So clear the cache and disable pretty urls (and enable again).
appliculture replied on at Permalink Reply
appliculture
Hi,

Thanks for your quick and precise answer. However still not working

- I tried several computer several browsers
- Clear browser cache and c5 cache
- site.php says<?php define('DIRNAME_APP_UPDATED', 'concrete5.6.2.1_updater');?> and everything works perfectly exept this
- Pretty URL are not been enabled yet
- In environnement everything seems ok.

Is there a way to go back to the previous version of c5 and try again the upgrade?
JohntheFish replied on at Permalink Reply
JohntheFish
You could try manually running the upgrade script again. There are instructions in the INSTALL file in the zip. Probably best to at least make a sql backup first.
appliculture replied on at Permalink Reply
appliculture
Unfortunatelly after relaunching the upgrade process the issue is still there.
I tried to uninstall all modules and it's still not working either..

If anyone has a solution I would be more than happy to solve it. Otherwise I'll have to remake a clean install and start everything again..

Thanks for your advices anyway.
appliculture replied on at Permalink Reply
appliculture
I just did a downgrade by removing define('DIRNAME_APP_UPDATED', 'concrete5.6.2.1_updater'); in the htaccess and everything is back to normal and working well..