Message bodies gone after upgrade Hi, I have encountered a problem when upgrading from 5.1.22 to 5.2.7: the bodies of certain messages are not shown, even though they are in the DB. I have not been able to find any pattern for the missing ones, need help on this one. I include an example of a row in forums_messages where phorum fails to show the body, only author subject and nothing: The URL for that message is: [motorpsycho.fix.no] mysql> select * from forums_messages where subject like '%Empty Bottle' and author='Ivan'; +------------+----------+--------+-----------+--------+----------------------------------------+---------------------------------------------------------------------------------------------------------------------+-------+----------------------------+--------+-------------------------------------------+-------------+---------+--------------+----------------+------+------------+--------+-----------+--------+-------------------+----------------+---------------+-------+-----------------+ | message_id | forum_id | thread | parent_id | author | subject | body | email | ip | status | msgid | modifystamp | user_id | thread_count | moderator_post | sort | datestamp | meta | viewcount | closed | recent_message_id | recent_user_id | recent_author | moved | threadviewcount | +------------+----------+--------+-----------+--------+----------------------------------------+---------------------------------------------------------------------------------------------------------------------+-------+----------------------------+--------+-------------------------------------------+-------------+---------+--------------+----------------+------+------------+--------+-----------+--------+-------------------+----------------+---------------+-------+-----------------+ | 50658 | 4 | 50653 | 50653 | Ivan | Re: 2008-06-22: Chicago - Empty Bottle | wow! 15 years!! you were veeeery patient. that must be like christmas, birthday.....altogether. i´m happy for you! | | p57A1C46B.dip.t-dialin.net | 2 | 7977dd6f0f12f65e6246d7333a46e8b5.Setlists | 0 | 21 | 0 | 0 | 2 | 1214265760 | a:0:{} | 0 | 0 | 0 | 0 | | 0 | 0 | +------------+----------+--------+-----------+--------+----------------------------------------+---------------------------------------------------------------------------------------------------------------------+-------+----------------------------+--------+-------------------------------------------+-------------+---------+--------------+----------------+------+------------+--------+-----------+--------+-------------------+----------------+---------------+-------+-----------------+ 1 row in set (0.20 sec) https://www.phorum.org/support/read.php?61,131838,131838#msg-131838 Sat, 10 Oct 2026 15:31:20 -0500 Phorum 6.0.4 https://www.phorum.org/support/read.php?61,131838,131846#msg-131846 Re: Message bodies gone after upgrade https://www.phorum.org/support/read.php?61,131838,131846#msg-131846 "charset" => "utf8"
in include/db/config.php]]> vegardh Phorum Support Sat, 12 Jul 2008 11:52:00 -0500 https://www.phorum.org/support/read.php?61,131838,131845#msg-131845 Re: Message bodies gone after upgrade https://www.phorum.org/support/read.php?61,131838,131845#msg-131845
Quote
vegardh
It's the same database, same box etc. as before the upgrade.

What version of MySQL are you running? I found an upgrade to v5 worked best for me.

As far as charset, check your /include/db/config.php for the charset there, then be sure that your MySQL collation is the same, not only for the database as a whole, but also each table. Finally, make sure the $PHORUM["DATA"]['CHARSET'] in your include/lang/YOURLANG.php file is also set to the same charset.]]> Joe Curia Phorum Support Sat, 12 Jul 2008 11:34:19 -0500 https://www.phorum.org/support/read.php?61,131838,131844#msg-131844 Re: Message bodies gone after upgrade https://www.phorum.org/support/read.php?61,131838,131844#msg-131844 Thomas: could you be more specific, I don't know what to check. It's the same database, same box etc. as before the upgrade.]]> vegardh Phorum Support Sat, 12 Jul 2008 11:10:56 -0500 https://www.phorum.org/support/read.php?61,131838,131840#msg-131840 Re: Message bodies gone after upgrade https://www.phorum.org/support/read.php?61,131838,131840#msg-131840 Thomas Seifert Phorum Support Sat, 12 Jul 2008 05:49:47 -0500 https://www.phorum.org/support/read.php?61,131838,131839#msg-131839 Re: Message bodies gone after upgrade https://www.phorum.org/support/read.php?61,131838,131839#msg-131839 The same goes for modules.]]> Maurice Makaay Phorum Support Sat, 12 Jul 2008 05:48:13 -0500 https://www.phorum.org/support/read.php?61,131838,131838#msg-131838 Message bodies gone after upgrade https://www.phorum.org/support/read.php?61,131838,131838#msg-131838
I include an example of a row in forums_messages where phorum fails to show the body, only author subject and nothing:

The URL for that message is: [motorpsycho.fix.no]

mysql> select * from forums_messages where subject like '%Empty Bottle' and author='Ivan';
+------------+----------+--------+-----------+--------+----------------------------------------+---------------------------------------------------------------------------------------------------------------------+-------+----------------------------+--------+-------------------------------------------+-------------+---------+--------------+----------------+------+------------+--------+-----------+--------+-------------------+----------------+---------------+-------+-----------------+
| message_id | forum_id | thread | parent_id | author | subject | body | email | ip | status | msgid | modifystamp | user_id | thread_count | moderator_post | sort | datestamp | meta | viewcount | closed | recent_message_id | recent_user_id | recent_author | moved | threadviewcount |
+------------+----------+--------+-----------+--------+----------------------------------------+---------------------------------------------------------------------------------------------------------------------+-------+----------------------------+--------+-------------------------------------------+-------------+---------+--------------+----------------+------+------------+--------+-----------+--------+-------------------+----------------+---------------+-------+-----------------+
| 50658 | 4 | 50653 | 50653 | Ivan | Re: 2008-06-22: Chicago - Empty Bottle | wow! 15 years!! you were veeeery patient. that must be like christmas, birthday.....altogether.
i´m happy for you! | | p57A1C46B.dip.t-dialin.net | 2 | 7977dd6f0f12f65e6246d7333a46e8b5.Setlists | 0 | 21 | 0 | 0 | 2 | 1214265760 | a:0:{} | 0 | 0 | 0 | 0 | | 0 | 0 |
+------------+----------+--------+-----------+--------+----------------------------------------+---------------------------------------------------------------------------------------------------------------------+-------+----------------------------+--------+-------------------------------------------+-------------+---------+--------------+----------------+------+------------+--------+-----------+--------+-------------------+----------------+---------------+-------+-----------------+
1 row in set (0.20 sec)]]> vegardh Phorum Support Sat, 12 Jul 2008 05:42:02 -0500