The upgrade from v2 to v5 working without error as did upgrading several plugins, however when in the control panel I and I select 'Edit' > and a channel I get the following error:
SQLSTATE: Integrity constraint violation: 1052 Column ‘channel_id’ in where clause is ambiguous:
SELECT DISTINCT t.author_id, m.screen_name FROM (exp_channel_titles t) LEFT JOIN exp_members m ON m.member_id = t.author_id WHERE channel_id = 83 ORDER BY screen_name asc
Any help identifying the cause of this error and providing a fix would be very much appreciated
Please note: I understand what the error means and how to fix it, what I need to know is what is going wrong and how to fix it in relation to the framework that it's used in Expression Engine.