Message bodies gone after upgrade
Posted by vegardh
Message bodies gone after upgrade July 12, 2008 06:42AM |
Registered: 16 years ago Posts: 6 |
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)
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)
July 12, 2008 06:48AM |
Admin Registered: 17 years ago Posts: 8,532 |
Did you try with the default emerald template to rule out a templating problem?
The same goes for modules.
Maurice Makaay
Phorum Development Team
my blog
linkedin profile
secret sauce
The same goes for modules.
Maurice Makaay
Phorum Development Team



Re: Message bodies gone after upgrade July 12, 2008 06:49AM |
Admin Registered: 19 years ago Posts: 9,240 |
Re: Message bodies gone after upgrade July 12, 2008 12:10PM |
Registered: 16 years ago Posts: 6 |
July 12, 2008 12:34PM |
Registered: 15 years ago Posts: 1,301 |
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 (aka Azumandias)
Modules: l0Admin Mass Email00000000l000000Automatic Time Zones000ll.l00000Enhanced Custom Profiles0.00Google Calendar0000l.l000000Post Previews
000000000Admin Security Suite000000000000Check Modules for Upgrades0000External Authentication000000Group Auto-Email00000.00000Private Message Alerts
000000000Attachment Download Counter0000Custom Attachment Icons000ll.ll00Favorite Forums000000.00000Highlighted Search Terms0000Self-Delete Posts Option
000000000Attachment Watermarks0l00000000Custom Language Database00l.l.0Forum Lockdown00000.00000Ignore Forums0000000000000Threaded Tree View
000000000Automatic Message Pruning00.llll.00Easy Color Scheme Manager0l.l00Forum Subscriptions0000lll000Moderated User Group
Templates:lGeneric Integration000000000 0000Simple Rounded000000 00000000Tabbed Emerald
Re: Message bodies gone after upgrade July 12, 2008 12:52PM |
Registered: 16 years ago Posts: 6 |
Sorry, only registered users may post in this forum.