Message bodies gone after upgrade
Posted by vegardh
Message bodies gone after upgrade July 12, 2008 06:42AM |
Registered: 18 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)
Re: Message bodies gone after upgrade July 12, 2008 06:48AM |
Admin Registered: 19 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
my blog linkedin profile secret sauce
Re: Message bodies gone after upgrade July 12, 2008 06:49AM |
Admin Registered: 21 years ago Posts: 9,240 |
Re: Message bodies gone after upgrade July 12, 2008 12:10PM |
Registered: 18 years ago Posts: 6 |
Re: Message bodies gone after upgrade July 12, 2008 12:34PM |
Registered: 17 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: 18 years ago Posts: 6 |
Sorry, only registered users may post in this forum.