Codezwiz >> Forums >> General PHP Nuke Help >> My News Wont Display

I don't know why this is happenning and I don't know where to look.
When I submit a story it will not list them out in other sections of the website.

Let me explain.
On the index.php everything displays fine as long as the "publish in home' button is activated. If I deactivate this ALL news disappears from the site.

Now as long as I have 'publish in home' activated on every article, then articles will display on the index.php.

BUT - in the categories block if I click a category name it wont list out
It passes this URL
[ Register or login to view links on this board. ]

But nothing happens?!

If I do this on this site like
[ Register or login to view links on this board. ]

something displays

not on mine however

The same thing happens when passiong the topic link [ Register or login to view links on this board. ]

it will work here

[ Register or login to view links on this board. ]

but not on my site

Can someone direct me to the files that seem to be the problem

-OR-

Is there another module to do the news functions altogether (categories topics etc)

Thank you kindly

Update: I installed NSN News Universal just to see if perhaps it was a problem with this module. Turns out this did nothing whatsoever to fix the problem.

Sounds like a database problem. Make a full back up of your nuke_stories and nuke_topics try reinstalling a fresh set then try posting news.

I am tried a few suggestions people gave and got nothing. I'm going to try this one now. I may have to get some hands on help maybe. I'll let you know how it goes in a few hours.

I am looking at this before I actually replace them I did notice something wierd

THIS IS MY TABLE

CREATE TABLE `nuke_stories` (
`sid` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`aid` varchar(30) NOT NULL default '',
`title` varchar(80) default NULL,
`time` datetime default NULL,
`hometext` text,
`bodytext` text NOT NULL,
`comments` int(11) default '0',
`counter` mediumint(8) unsigned default NULL,
`topic` int(3) NOT NULL default '1',
`informant` varchar(20) NOT NULL default '',
`notes` text NOT NULL,
`ihome` int(1) NOT NULL default '0',
`acomm` int(1) NOT NULL default '0',
`haspoll` int(1) NOT NULL default '0',
`pollID` int(10) NOT NULL default '0',
`score` int(10) NOT NULL default '0',
`ratings` int(10) NOT NULL default '0',
`associated` text NOT NULL,
`alanguage` varchar(30) NOT NULL default '',
PRIMARY KEY (`sid`),
KEY `sid` (`sid`),
KEY `catid` (`catid`),
KEY `counter` (`counter`),
KEY `topic` (`topic`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;

I backed up the database for

nuke_stories_cat
nuke_stories
nuke_topics

Then I went in the Admin and reinput the topics. That went fine.
Then I went into submit story and tried to put in the categories.
It said categories already existed although none existed in the DB.
Also all the stories were gone so I don't know where else they were stored. I tried to make a category that didn't exist before but that didn't work it ALSO said it already existed. So I added them manually the way they were prior.

So I input my FIRST NEW STORY and things seemed to work okay.
So I input my second story and ALL the news disappeared the way it had before. It seems it disappears one I use a different category other than the first one. I also noticed in the Administration menu Under LAST 20 ARTICLES my first article language is set to 'All' and article 2 is set to 'english'. So I go and Edit Article 2 to set it to Category 1 like Article 1. First thing I noticed is the language changed to 'All' Now both articles in LAST 20 ARTICLES is listed as language 'All'. I check the home again. NOW THE NEWS DISPLAYS FINE on the categories and index BUT NOT IF I CLICK A TOPIC ICON! It seems it all has to be the same to work. So I test this again and go into the Admin and change the 2 stories to make the topics Just the same. Now everything works fine! SO I go and change the topics (keeping both the same still)

Whaty I've thusfar concluded is that it doesn't have a problem displaying news exactly. It has a problem splitting it up over more than one topic (like using related topics or different topics per article) It also has a problem splitting them up over multiple categories within the same topic. To make News work on both index view, category view or topic view all of the articles MUST be the SAME category AND TOPIC with no related topics. If you split it over 2 categories the topics work but not the categories. If you split it over more than one topic the categories work but not the topics.

I have restored my original database now and it is the same with the errors. I hope this information helped you to think of maybe what the problem is.

I would also suggest reuploading your News module. Did you have any mods entered in the News Module? Is this a fresh install that you moved your forum over too recently?

The News Module was always the one that came with Nuke 7.3 from [ Register or login to view links on this board. ] I believe. So YES a fresh install. I only added the patches and the Protector to that module if it was required (I dont recall).

After all of this situation arose I had went and downloaded NSN News Universal may 2004 Edition and the issue did not resolve. If it were an issue with the News module wouldn't it had fixed? If it was an ussue with the SQL wouldn;t it had fixed? That's why maybe it could be Topics eh? Maybe Topics is having a problem? Maybe?

I have added no mods to the News Module Itself. It went like this:
7.2 -> (error) -> 7.3 (error) 7.3 From NuikeFiles (error) -> 7.3 Fixes (error) -> 7.3 Patches (error)-> Protector (error) -> NSN News Universal (error) -> SQL reinstall (error)

Seems like maybe I need new files altogether maybe its something that has nothing to do with it altogether.

What other Modules could this involve besides News and Topics? Perhaps I should try to install another Topics Module because maybe that is the offending Module. Other mods I installed never Modified the original files (except maybe adding values to lang modules) I only had the 7.3 and the patches from the website and then I manually installed Protecter. That's it. Nothing special. Could the THEME be at fault?

As for my FORUMS it was the FORUMS that came with the Nuke. Then I manually Upgraded them with the bbtoNuke manual upgrade to make them 2.0.8.a. That went fine with NO errors. When I imported the database I didn;t CONVERT it I merely inserted records 1 by 1 (yes thats heckic) My Dump is a perfect dump (the nuke_users and phpbb_users) it looks perfect no differences and everything runs kosher.

Oh and I put your link on my site

>> [ Register or login to view links on this board.]

Dear Telli

We found the problem to be some problem in the theme.php and we changed the theme (which was hard because we have a heavily modded site) but it all worked out. So if anyone ever has a similar error have them check the theme before going psychotic.

Thanks for all your help.

^..^Omi~

Well atleast you know how to rebuild your stories tables.