I just upgraded an old site from 2.2.13. Now I'm seeing this error message repeating over and over.
[2016-12-19 06:40:08] (ERROR @ /home/content/53/12362853/html/core/xpdo/om/xpdoobject.class.php : 240) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modRedirect.context_key' in 'where clause'
)
I upgraded in stages, 2.2.13, 2.3.0, 2.3.6, 2.4.2 and 2.5.2
I searched the forum, but didn't find anything on this message. Any ideas?
That's odd. I can't find 'modRedirect' anywhere in the 2.5.2 code.
Out of curiosity, see if your modx_context table has a name field.
Are you running any extras that might be creating a modRedirect object (eg., the modRedirect extra)?
Thanks Bob
As a matter of fact there is. Redirector has been installed.
Since it doesn't appear to be used, I uninstalled the extra and cleared the cache. Now I'm getting this error. It seems to appear when saving a resource.
[2016-12-19 20:15:41] (ERROR @ /home/content/53/12362853/html/core/xpdo/om/xpdoobject.class.php : 240) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'name' in 'order clause'
)
Might this be a remnant of the extra that didn't get removed from the DB?
I think it's more likely that your missing a database field due to skipping MODX 2.5.0.
As I said above, "see if your modx_context table has a name field."
If not, see this:
http://bobsguides.com/blog.html/2016/06/27/missing-db-fields-(unknown-column)/
