Thread Rating:
  • 3 Vote(s) - 2.33 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 3 Years, 11 Months, 4 Days, 11 Hours, 4 Minutes, 10 Seconds ago Common SQL Queries post Merge
#1
Solved: 3 Years, 11 Months, 4 Days, 11 Hours, 4 Minutes, 10 Seconds ago
I'll keep this updated as often as new Queries are needed.
Please remember to change "mybb_" in these queries to whatever your prefix actually is.

All PMs are "Unread"
Code:
UPDATE `mybb_privatemessages` SET `readtime` = '1' WHERE `readtime` = 0 AND `folder` != 2;
UPDATE `mybb_privatemessages` SET `status` = '1' WHERE `status` = 0 AND `folder` != 2;

Replies Count is Off and/or Threads with 1 post are showing 1 reply instead of 0
Code:
UPDATE `mybb_threads` t SET firstpost=(SELECT MIN(pid) FROM `mybb_posts` p WHERE t.tid=p.tid)

All Postcounts 0
Code:
UPDATE `mybb_forums` SET `usepostcounts` = '1';

PHP Error When Viewing Profiles
Code:
UPDATE `mybb_users` SET `birthday` = '' WHERE `birthday` LIKE '-%';

Members falsely show as visited post merge
Code:
UPDATE mybb_users SET lastvisit = UNIX_TIMESTAMP(NOW()) where lastvisit = '';
UPDATE mybb_users SET lastactive = UNIX_TIMESTAMP(NOW()) where lastactive = '';

Cannot Send Mass Mail to all users post merge
Code:
UPDATE `mybb_users` SET `allownotices` = '1';


Forum Jump:


Users browsing this thread: 1 Guest(s)