Too many columns

Hello,

So I’ve managed to upgrade from V2.5.5 to the latest version, and here comes new issue I’m facing unfortunatley, see below for more details.

“SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id, w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled, m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio, md.*, wd.* FROM exp_channel_titles AS t LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (666,838,840,845,846,847,667,668,849,873) ORDER BY t.sticky desc, wd.field_id_357 asc, t.entry_id asc

Filename: modules/channel/mod.channel.php

Line Number: 290”

So the site Template and Multisite heavily rely on the Channel Module and as a result, we got a “Too many columns”, just using Channels that are listed here though https://docs.expressionengine.com/latest/channel/index.html

Can you suggest a better solution to this? normalization is the key but the site tables and thousands of data are there already and it’s not a reliable solution in our case.

Thanks