2019-01-30, 02:41 PM
Please i am using the latest mybb but after installing Myalert plugin (plugin link https://community.mybb.com/thread-171301.html )i get this error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1054 - Unknown column 't.can_be_user_disabled' in 'where clause'Query:SELECT COUNT(*) AS count FROM mybbas_alerts a INNER JOIN mybbas_alert_types t ON (a.alert_type_id = t.id) WHERE (a.alert_type_id IN (1,2,3,4,5,6,7,8) OR a.forced = 1 OR t.can_be_user_disabled = 0) AND t.enabled = 1 AND a.uid = 1 AND a.unread = 1;
Please contact the MyBB Group for technical support.
[attachment=41493]
Please i am not too familiar with sql any way i can fix this.
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1054 - Unknown column 't.can_be_user_disabled' in 'where clause'Query:SELECT COUNT(*) AS count FROM mybbas_alerts a INNER JOIN mybbas_alert_types t ON (a.alert_type_id = t.id) WHERE (a.alert_type_id IN (1,2,3,4,5,6,7,8) OR a.forced = 1 OR t.can_be_user_disabled = 0) AND t.enabled = 1 AND a.uid = 1 AND a.unread = 1;
Please contact the MyBB Group for technical support.
[attachment=41493]
Please i am not too familiar with sql any way i can fix this.