Express Object View Entries Error

This occurs when I try to view entries for 1 of 6 Express objects on the site I’m developing (other work just fine):
Doctrine \ DBAL \ Exception \ InvalidFieldNameException
An exception occurred while executing ‘SELECT e.exEntryID, ak_name FROM ExpressEntityEntries e LEFT JOIN ListingExpressSearchIndexAttributes ea ON e.exEntryID = ea.exEntryID WHERE e.exEntryEntityID = ? ORDER BY ak_name asc, e.exEntryID asc LIMIT 10’ with params [“72f4b733-fd30-11ee-94b6-56b37e5f60c5”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘ak_name’ in ‘field list’

Anyone had this experience and/or have any thoughts?

  • Concrete CMS version: 9.2.8
  • Database version: 20240122172319
  • PHP version: 8.1.27

Have you deleted any Express objects or attributes or associations? Just wondering if something might have gotten orphaned or something.

Also wondering about Search Index - if running search indexing tasks might help.

sorry for the late response, but I have been slammed. I will give ‘indexing’ a shot. As for the deletion of objects/attributes/associations, probably all of the above while I’ve been developing the data schema for this site. Since this behavior is restricted to a single object, I’m tempted to just recreate it. I’ll follow up, after I have a chance to work with it some more-- thanks!

1 Like