My News Wont Display

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   My News Wont Display
omitaybi
CZ Newbie
omitaybi has been a member for over 20 year's 20 Year Member
usa.gif massachusetts.gif
Occupation: Silly Girl
Age: 46
Gender: Female
Status: Offline
Joined: Jun 02, 2004
0.00 posts per day
Posts: 12
Points: 978
AIM Address   
icon_sad.gif


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 icon_smile.gif

not on mine however icon_sad.gif

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

it will work here icon_smile.gif
[ Register or login to view links on this board. ]

but not on my site icon_sad.gif

Can someone direct me to the files that seem to be the problem icon_sad.gif

-OR-

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

Thank you kindly



Back to top Reply with quote
#2   re: My News Wont Display
omitaybi
CZ Newbie
omitaybi has been a member for over 20 year's 20 Year Member
usa.gif massachusetts.gif
Occupation: Silly Girl
Age: 46
Gender: Female
Status: Offline
Joined: Jun 02, 2004
0.00 posts per day
Posts: 12
Points: 978
AIM Address   
icon_eek.gif

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.



Back to top Reply with quote
#3   
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,430
   
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.




_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#4   re: My News Wont Display
omitaybi
CZ Newbie
omitaybi has been a member for over 20 year's 20 Year Member
usa.gif massachusetts.gif
Occupation: Silly Girl
Age: 46
Gender: Female
Status: Offline
Joined: Jun 02, 2004
0.00 posts per day
Posts: 12
Points: 978
AIM Address   
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.



Back to top Reply with quote
#5   re: My News Wont Display
omitaybi
CZ Newbie
omitaybi has been a member for over 20 year's 20 Year Member
usa.gif massachusetts.gif
Occupation: Silly Girl
Age: 46
Gender: Female
Status: Offline
Joined: Jun 02, 2004
0.00 posts per day
Posts: 12
Points: 978
AIM Address   
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 ;


This is the NUKE 7.3 from the site I got it

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',
  alanguage varchar(30) NOT NULL default '',
  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,
  PRIMARY KEY  (sid),
  KEY sid (sid),
  KEY catid (catid),
  KEY counter (counter),
  KEY topic (topic)
) TYPE=MyISAM;


THIS IS MINE

CREATE TABLE `nuke_topics` (
  `topicid` int(3) NOT NULL auto_increment,
  `topicname` varchar(20) default NULL,
  `topicimage` varchar(20) default NULL,
  `topictext` varchar(40) default NULL,
  `counter` int(11) NOT NULL default '0',
  PRIMARY KEY  (`topicid`),
  KEY `topicid` (`topicid`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;


THISIS NUKE 7.3

CREATE TABLE nuke_topics (
  topicid int(3) NOT NULL auto_increment,
  topicname varchar(20) default NULL,
  topicimage varchar(20) default NULL,
  topictext varchar(40) default NULL,
  counter int(11) NOT NULL default '0',
  PRIMARY KEY  (topicid),
  KEY topicid (topicid)
) TYPE=MyISAM;



Back to top Reply with quote
#6   re: My News Wont Display
omitaybi
CZ Newbie
omitaybi has been a member for over 20 year's 20 Year Member
usa.gif massachusetts.gif
Occupation: Silly Girl
Age: 46
Gender: Female
Status: Offline
Joined: Jun 02, 2004
0.00 posts per day
Posts: 12
Points: 978
AIM Address   
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.



Back to top Reply with quote
#7   
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,430
   
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 path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#8   re: My News Wont Display
omitaybi
CZ Newbie
omitaybi has been a member for over 20 year's 20 Year Member
usa.gif massachusetts.gif
Occupation: Silly Girl
Age: 46
Gender: Female
Status: Offline
Joined: Jun 02, 2004
0.00 posts per day
Posts: 12
Points: 978
AIM Address   
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 icon_smile.gif >> [ Register or login to view links on this board.]



Back to top Reply with quote
#9   re: My News Wont Display
omitaybi
CZ Newbie
omitaybi has been a member for over 20 year's 20 Year Member
usa.gif massachusetts.gif
Occupation: Silly Girl
Age: 46
Gender: Female
Status: Offline
Joined: Jun 02, 2004
0.00 posts per day
Posts: 12
Points: 978
AIM Address   
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~



Back to top Reply with quote
#10   
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,430
   
Well atleast you know how to rebuild your stories tables. icon_razz.gif




_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
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 cannot attach files in this forum
You cannot download files in this forum