Upgrade 2 > 5 Column 'channel_id' in where clause is ambiguous
Development and Programming
I have managed to upgrade from 2 > 5 successfully, however when trying to edit an entry I get this error:
SQLSTATE[23000]: 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
When trying to create a new entry I get this error: Error: Unable to load requested publish tab file: tab.user.php
To fix I simply removed the channel_id field from the exp_members table, it didn’t have any useful info in it (every row was set to ‘0’) and it doesn’t seem to be needed!
I’m not even sure why/how this column was added to the members table, members aren’t really related to channels.