forum and faq issue after upgrade

New Member Joined: Apr 03, 2009 Posts: 11

I just upgrades from 2.20 to 2.30.01 and noticed that the posts in the bulletin board are not showing up. The headings are there but no topics. The Headings for each section are registering the correct number of topics, so it seems to know about them. when looking at the database I see the following:

nuke_bbgategories has the correct information and it showing up properly.
nuke_bbforums has the correct information and it showing up properly.
nuke_bbgroups shows 3 personal users. one assoicated to anonymous and the other two look the same except for group ID being different. Not sure if this is correct or not.
nuke_bbposts contains the information but is not showing up on the bulletin board. this is the problem section.

Maybe I missed something in the upgrade? This is my first upgrade, so its very possible I did. anyone have a solution for this?

I also noticed that my faq's are gone. Looking in the database I don't see any. so it looks like they were deleted. I didn't look much here so it not a big deal. Just mentioning it incase others are experiencing the same issue.

Posted: Sun Apr 05, 2009 11:37 am

Have you tried with a different theme, like fisubice?

Posted: Sun Apr 05, 2009 12:26 pm

I had the site theme default set to fisubice when the problem occurs. I tried changing the site default as well as the one in the user profile. Doesn't seem to make an difference on any of the theme's I use.

Posted: Sun Apr 05, 2009 12:30 pm

Can you turn on error reporting and database logging.

Thanks

Posted: Sun Apr 05, 2009 1:07 pm

are you referring to the error reporting in the php.ini or somewhere else. I currently have it set to:
error_reporting = E_ALL
display_errors = On
display_startup_errors = Off
log_errors = On
log_errors_max_len = 1024
ignore_repeated_errors = Off
ignore_repeated_source = Off
report_memleaks = On
track_errors = Off

Is this the logging in mysql your also referring to/etc/my.cnf
log-error=/var/log/mysqld.log

I did "ls -la | grep<date time> to find out which log file was being added to in the apache logs. I then did "tail -f vhost_error.log" and saw this

[Sun Apr 05 14:50:25 2009] [error] [client 10.0.107.201] PHP Warning: ob_start() [<a href='ref.outcontrol'>ref.outcontrol</a>]: output handler 'ob_gzhandler' cannot be used twice in /var/www/html/modules/Forums/includes/page_header.php on line 58, referer: http://<omitted>/modules.php?name=Forums&file=viewforum&f=22

[Sun Apr 05 14:50:39 2009] [error] [client 10.0.107.201] PHP Warning: ob_start() [<a href='ref.outcontrol'>ref.outcontrol</a>]: output handler 'ob_gzhandler' cannot be used twice in /var/www/html/modules/Forums/includes/page_header.php on line 58, referer: http://<omitted>/modules.php?name=Forums&file=index

as for mysqld.log, i did not see any changes during the test of going to the topic and looking for the post.

Posted: Sun Apr 05, 2009 1:55 pm

This is error reporting and db logging in RN.

Look in the config.php and rnconfig.php files.

Posted: Sun Apr 05, 2009 3:51 pm

Here's what is set now
config.php
$display_errors = true;

rnconfig.php
$error_reporting = E_ALL^E_NOTICE
$loglevel = 1;

I set loglevel to 2 and there was tons of information in dblog but none of it was errors. here's the last couple lines i saw when going to the section with the missing posts

April 5, 2009, 5:47 pm SQL was: SELECT u.username, u.user_id, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_ip FROM nuke_users u, nuke_bbsessions s WHERE u.user_id = s.session_user_id AND s.session_time >= 1238967745 AND s.session_page = 22 ORDER BY u.username ASC, s.session_ip ASC
querycount = 141

April 5, 2009, 5:47 pm SQL was: SELECT c.cat_id, c.cat_title, c.cat_order FROM nuke_bbcategories c, nuke_bbforums f WHERE f.cat_id = c.cat_id GROUP BY c.cat_id, c.cat_title, c.cat_order ORDER BY c.cat_order
querycount = 142

April 5, 2009, 5:47 pm SQL was: SELECT * FROM nuke_bbforums ORDER BY cat_id, forum_order
querycount = 143

I set loglevel to 1 and retried to confirm I still saw no errors. I am able to add to new posts to the bulletin board with no problems. The show up correct on the webpage as well. I can see their showing up directly under the entries in the database that are not working.

The only error I see showing up on the bulletin board is below.

Warning: ob_start() [ref.outcontrol]: output handler 'ob_gzhandler' cannot be used twice in /var/www/html/modules/Forums/includes/page_header.php on line 58

Posted: Sun Apr 05, 2009 5:09 pm

After the upgrade, did you run the rndbupgrade.php ?

Posted: Sun Apr 05, 2009 6:23 pm

yes I ran rndb_upgrade.php as well as rndb_upgrade_nukesentinel.php. after seeing that I had a problem, I ran the index.html and setup.php scripts in the installation direction to see if it would find anything missing. The site matched in all the requirement checks it did. I wanted to be sure that I had nothing from 2.20 impacting me, so i removed all the RN 2.20 files and replaced them with only the 2.30.01 files. So the end result is an upgraded 2.20 to 2.30.01 database running only 2.30.01 package of RN.

Posted: Sun Apr 05, 2009 7:20 pm

Maybe re-upload the files again, sometimes does the trick.

Posted: Sun Apr 05, 2009 11:35 pm

I only had one test post in the bulletin board, so i decided to just delete it and just re-add it back in while using the new settings in 2.30.01. It added fine, so i'm good for now.

We can close this issue although there may be a bug hiding behind this. I have no issues posting new topics and posts. So its kind of strange that it would not pull out an entry added from a 2.20 website in the database in the same table.