News Articles Still Appearing In News Block After Archiving

Worker Joined: May 26, 2006 Posts: 153

Has anyone else come across this. I am running RN20.20.01

I have got 17 stories in the news block at present. I have marked at least half for moving to archive and not to be published in the home page.

For some reason they are still appearing in the news block. I have done this before with RN2.20.00 without any problems.

the site is at www.zenjudo.co.uk

Posted: Fri May 30, 2008 6:56 pm

Any chance you can check your stories table with phpmyadmin for us. To not be published in home the catid has to be something other than 0 (articles) and ihome has to be not = 1. Let us know what those fields are set to in the articles that are showing up in home when they shouldn't be. Either: it's user error, or the update isn't taking place correctly or the news display program is showing them where it shouldn't.

You could even try to change one of your articles to archive and not in home and watch phpmyadmin on the stories table before and after and report the results back. That would help immensely in diagnosing the problem.

Posted: Wed Jun 04, 2008 3:55 pm

fkelly wrote:

Any chance you can check your stories table with phpmyadmin for us. To not be published in home the catid has to be something other than 0 (articles) and ihome has to be not = 1. Let us know what those fields are set to in the articles that are showing up in home when they shouldn't be. Either: it's user error, or the update isn't taking place correctly or the news display program is showing them where it shouldn't.

You could even try to change one of your articles to archive and not in home and watch phpmyadmin on the stories table before and after and report the results back. That would help immensely in diagnosing the problem.

I have had a quick look in the tables and at present I'm worried about touching anything. I have just edited a content page and saved it and now it won't show up in the site, its still there in the Admin module and I can still open it for editing. Having checked more content pages and other links many of them now don't open anymore.

As far as I can remember I haven't changed or updated anything recently. My other site which is on the same server and in same directory looks Ok at present, but I haven't touched that in any way.

The sites are www.zenjudo.co.uk (problems) and www.brzjc.co.uk (seems ok)

John

Posted: Wed Jun 04, 2008 5:38 pm

A straightforward upgrade from RN 2.20.00 to 2.20.01 would not have done this to you. The changes were mostly minor and not anything that would have caused this.

It either sounds like you had an incomplete FTP process for the 2.20.01 files or the update of your tables did not work properly and thus you have some tables "out of synch" with the PHP programs. After you back your site up I'd suggest deleting everything from the html directory down and re-ftping the 2.20.01 files to make sure you have a complete set. You might also run MYSQLdiff on the 2.20.00 tables versus 2.20.01. There should be very minor differences that are detailed in the INSTALLATION directory for 2.20.01.

registered · Posted: Thu Jun 05, 2008 5:01 am

Might also want to turn on dblogging (see rnconfig.php - setting of 1 should be sufficient) and then check the rnlogs/dblog after a few access attempts of the content and see if there are any SQL errors in there. It might point to a specific issue. However, I do suspect, as fkelly, that there really is a missing file update somewhere.

Posted: Thu Jun 05, 2008 4:22 pm

Thanks fro the help fkelly / montego, I didn't get much from the logs, but did find the nuke_mail_config table had disappeared again. I've fixed that and eventually found that the black pages have been caused by a corrupted .htaccess file it turns out that all the rewrite rules had been stripped out of the file.

I have replaced that file with a working one and have checked the nuke_stories table and as you suggested the catid and ihome fields hadn't updated correctly. I have now got them sorted and when I have time I will do some testing from admin again to check all is working as it should.

Can you tell me if the following tables are still required in RN20.20.01

nuke_bbquotes
nuke_optimize_gain
nuke_quotes

Posted: Thu Jun 05, 2008 9:41 pm

I can find no reference to nuke_bbquotes but the others are required.

Posted: Fri Jun 06, 2008 5:16 am

Sorry, something was bugging me so I had to check the code. I guess we have more clean-up to do in our setup SQL. I could find no reference to _quotes in the code.

Also, nuke_optimize_gain is created the first time you perform an "Optimize DB". But, as Guardian has stated, its needed (don't want to drop it and lose your historical stats).

Posted: Fri Jun 06, 2008 8:39 am

I'm going to correct myself now as Montego has confirmed something.
I have just checked the code base too and although the table nuke_quotes is created it is not used anywhere. I suspect it might be a carry over from the old 'quotes' block which is no longer part of *nuke and certainly not in RN so if you do not have a 'quotes' block left over from an earlier nuke install, you can remove that table (nuke_quotes).