title: SQL Error: 1267 - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_persian_ci,IMPLICIT) for operation '='
body: <p>MyBB SQL Error</p>
  
  <p>MyBB has experienced an internal SQL error and cannot continue.</p>
  
  <p>SQL Error:</p>
  
  <pre><code>1267 - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_persian_ci,IMPLICIT) for operation '='
  </code></pre>
  
  <p>Query:</p>
  
  <pre><code>SELECT t.*
      ,t.subject AS threadsubject
      ,u.username
      ,u.usergroup
      ,u.displaygroup
      ,i.*
      ,i.NAME AS iconname
      ,t.dateline AS threaddate
      ,t.lastpost AS threadlastpost
  FROM mybb_threads t
  LEFT JOIN mybb_icons i ON (i.iid = t.icon)
  LEFT JOIN mybb_users u ON (t.lastposter = u.username)
  WHERE t.visible = '1'
      AND t.uid = '54445'
  GROUP BY t.tid
  ORDER BY threadlastpost DESC LIMIT 5
  </code></pre>
  
  <p>Please contact the MyBB Group for technical support.</p>
  
  <p><a href="https://i.stack.imgur.com/Q5DNR.png" rel="nofollow noreferrer">image1</a></p>
  
  <p><a href="https://i.stack.imgur.com/AQAhB.png" rel="nofollow noreferrer">image 2 </a></p>