Firefox PHP

Message bodies gone after upgrade

Posted by vegardh 
Message bodies gone after upgrade
July 12, 2008 06:42AM
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)
Re: Message bodies gone after upgrade
July 12, 2008 06:48AM
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
Re: Message bodies gone after upgrade
July 12, 2008 06:49AM
and did you check charsets?


Thomas Seifert
Re: Message bodies gone after upgrade
July 12, 2008 12:10PM
Maurice: did not solve it.
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.
Re: Message bodies gone after upgrade
July 12, 2008 12:34PM
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
Thanks, Axumandias, looks like it's fixed. I needed to include
"charset" => "utf8"
in include/db/config.php
Sorry, only registered users may post in this forum.

Click here to login