Tag: sql

Quick MyBB MySQL fix

Quick SQL fix to address the following issues for some MyBB users:

  • Hotlinked images and videos are not shown
  • Quoted images and videos are not shown
  • Classic layout is not enforced
  • “Friendly redirects” are not disabled
UPDATE `mybb_users` SET classicpostbit=1 WHERE classicpostbit=0;
UPDATE `mybb_users` SET showimages=1,showvideos=1 WHERE showimages=0;
UPDATE `mybb_users` SET showredirect=0 WHERE showredirect=1;

The first line is the most important because of the bug in MyBB UserCP.