-
☆ A M B ☆
- 300 Posts
have a Revo 2.2.4-pl version of modx that is not showing all templates in the list. Giving me this error:
Unknown column 'modTemplate.name' in 'where clause'
[2014-02-07 00:33:31] (ERROR @ /connectors/element/index.php) Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modTemplate.name' in 'where clause'
)
any ideas on what to do?
seems a script is trying to use modTemplate.name in its where-clause, but there isn't a field 'name' in this table.
The name is modTemplate.templatename
If you have an editor with multi-file search, you can search for 'modTemplate.name'. The first place to look would be the core/components directory. Change it to 'modTemplate.templatename' as Bruno suggests.
I'm also seeing this error, but when I search for modTemplate.name (grep -r modTemplate.name * in root over SSH), the only results that come back are the log entries themselves.
@redtoad Were you able to resolve your issue through this means or another so far?
Try a search for these two:
getObject('modTemplate', array('name'
getObject('modTemplate',array('name'
-
☆ A M B ☆
- 300 Posts
we had to do upgrades on the modx install itself and the lplugins and I'm not sure that that fixed it, I think my programmer ended up actually finding the query in question and changing the query to
modTemplate.templatename
instead of
modTemplate.name
I have just has the same thing happen to one of my sites - any ideas where to change this line of code? I've run grep -r modTemplate.name * and same as temple tantrum it's only in the error.log.
It is on 2.2.4 - will upgrade to latest after this issue is resolved.
It's most likely an add-on, rather than MODX itself, so an upgrade is unlikely to help. See my message above for other search options.
Thanks Bob, am searching for your strings now - I haven't installed any plugins/add-ons recently so not sure what they could be. Searching...
