You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When putting ERF into a section and using it to associate another section that has an Association Field in it. Then any attempt to access that section either through ERF or backend page causes this error.
Symphony Fatal Database Error: Unknown column 'd.entries' in 'where clause'
An error occurred while attempting to execute the following query
SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`, UNIX_TIMESTAMP(e.`modification_date`) AS `modification_date` FROM `ar6_entries` AS `e` INNER JOIN `ar6_entries_data_41` AS `d` ON `e`.id = `d`.`entry_id` WHERE 1 AND `e`.`section_id` = '10' AND (`d`.`entries` = '235' OR `d`.`entries` LIKE '235,%' OR `d`.`entries` LIKE '%,235' OR `d`.`entries` LIKE '%,235,%') ORDER BY ( SELECT `ed`.value FROM ar6_entries_data_12 AS `ed` WHERE entry_id = e.id ) ASC
Further I found that upon removing ERF the section is accessible but can no longer appear in the list of things to associate in the Association Field. Whatever links those tables together must be altered somehow I would guess.
Backup DB before trying the section stays broken.
The text was updated successfully, but these errors were encountered:
When putting ERF into a section and using it to associate another section that has an Association Field in it. Then any attempt to access that section either through ERF or backend page causes this error.
Symphony Fatal Database Error: Unknown column 'd.entries' in 'where clause'
An error occurred while attempting to execute the following query
Further I found that upon removing ERF the section is accessible but can no longer appear in the list of things to associate in the Association Field. Whatever links those tables together must be altered somehow I would guess.
Backup DB before trying the section stays broken.
The text was updated successfully, but these errors were encountered: