Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved what happens if posthash in posts table is empty?
#1
Not Solved
what happens if posthash in posts table is empty?
is there any drawback or functionality issue there ?
Reply
#2
Not Solved
See: http://community.mybb.com/thread-33838-post-227016.html#pid227016

I haven't looked into it much, but it seems you'll have issues with uploading attachments if the posthash doesn't exist.
Reply
#3
Not Solved
you might also have issues with quick reply
Reply
#4
Not Solved
I'm having this issue, I was using advanced quick reply plugin (which signature stopped working) and disabled it but I doubt that has anything to do with attachments.
Anyway the posthash was blank for 7 attachments and in some cases these 7 attachments will move themselves all to a different post id and thread id....
I fixed the pid and tid in phpMyAdmin but how do I generate posthash for these 7 attachments so this doesn't happen again (the attachments moving posts).
My original post with this problem:
http://community.mybb.com/thread-131741.html

frostschutz provided me a fix for the posthash issue on this post:
http://community.mybb.com/thread-77971-post-954198.html#pid954198
(12-28-2012, 10:04 PM)frostschutz Wrote:  This should reset ALL posthashes to a random md5 hash for each post and attachment. In phpMyAdmin, execute all three lines in one go.

Code:
SET @salt=CONCAT(RAND(),RAND(),RAND(),RAND());
UPDATE mybb_posts SET posthash=MD5(CONCAT(@salt, '-', pid, '-', uid, '-', @salt));
UPDATE mybb_attachments SET posthash=MD5(CONCAT(@salt, '-', pid, '-', uid, '-', @salt));

It shouldn't cause any problems as long as no one is creating/editing a post with attachments at the time you run this.

It works. Thank you Frostschuz!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)