Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues
Author Message
j4rdin
Worker
Worker


Joined: May 26, 2006
Posts: 153
Location: West Sussex - UK

PostPosted: Fri May 30, 2008 3:33 pm Reply with quote

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 Only registered users can see links on this board! Get registered or login!
 
View user's profile Send private message Visit poster's website
fkelly
Former Moderator in Good Standing


Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY

PostPosted: Fri May 30, 2008 6:56 pm Reply with quote

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.
 
View user's profile Send private message Visit poster's website
j4rdin
PostPosted: Wed Jun 04, 2008 3:55 pm Reply with quote

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 Only registered users can see links on this board! Get registered or login! (problems) and Only registered users can see links on this board! Get registered or login! (seems ok)

John
 
fkelly
PostPosted: Wed Jun 04, 2008 5:38 pm Reply with quote

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.
 
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9449
Location: Arizona

PostPosted: Thu Jun 05, 2008 5:01 am Reply with quote

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.

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
j4rdin
PostPosted: Thu Jun 05, 2008 4:22 pm Reply with quote

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
 
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6792
Location: Ha Noi, Viet Nam

PostPosted: Thu Jun 05, 2008 9:41 pm Reply with quote

I can find no reference to nuke_bbquotes but the others are required.
 
View user's profile Send private message Send e-mail
montego
PostPosted: Fri Jun 06, 2008 5:16 am Reply with quote

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).
 
Guardian2003
PostPosted: Fri Jun 06, 2008 8:39 am Reply with quote

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).
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©