Hi,
I have downloaded the phpBB full package from http://downloads.sourceforge.net/phpbb/phpBB-3.0.0.zip?download and am intrigued to find out how the forum stores private messages sent by users, as if you view the "privmsgs" table contained in the database, it doesn't contain the message entered?
Why is this, where is the message stored?
Upon looking through the "phpbb_privmsgs" table, I found a "message_text" field, but all it contains is: [BLOB - 21 B]
Where's the actual message kept? 😕
Probably in that blob field.
blob field contained in which table?
Dysan wrote:blob field contained in which table?
http://phpbuilder.com/board/showpost.php?p=10856758&postcount=2
Mind you, I don't know it's there, just sounds promising. If you really want to know, try the phpBB documentation, knowledgebase, and/or support forums.
What does "[BLOB - 21 B]" mean?
A BLOB is a Binary Large Object. I believe the "BLOB 21 B" is phpMyAdmin's way of saying there are 21 bytes worth of data in that particular field.