Can't get News to show up anywhere

dahman · Beginner Joined: Jan 07, 2006 Posts: 8

I have been trying to figure out why my News and Topics do not show up anywhere after I submit them. After publishing either a news article or adding something to my Topics, it's as if it never goes anywhere, other than nowhere. Any ideas? I would appreciate it very much, thanks.

AdBot

dari · Posted: Mon Jan 16, 2006 8:28 am Post subject: Re: Can

it's most likely a DB issue. can't be more specific than that since i don't know the specifics of your database. make sure all the column names, etc are included and spelled properly, etc.
_________________

dahman · Beginner Joined: Jan 07, 2006 Posts: 8

Ok, and what particular tables should I be checking? _autonews or _topics?
Here are both of my DB's

--
-- Table structure for table `nuke_autonews`
--

CREATE TABLE `nuke_autonews` (
`anid` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`aid` varchar(25) NOT NULL default '',
`title` varchar(80) NOT NULL default '',
`time` varchar(19) NOT NULL default '',
`hometext` text NOT NULL,
`bodytext` text NOT NULL,
`topic` int(3) NOT NULL default '1',
`informant` varchar(25) 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',
`associated` text NOT NULL,
PRIMARY KEY (`anid`),
KEY `anid` (`anid`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

--
-- Dumping data for table `nuke_autonews`
--

--
-- Table structure for table `nuke_topics`
--

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

--
-- Dumping data for table `nuke_topics`
--

INSERT INTO `nuke_topics` VALUES (1, 'phpnuke', 'phpnuke.gif', 'PHP-Nuke', 0);

dahman · Beginner Joined: Jan 07, 2006 Posts: 8

Also _stories:

--
-- Table structure for table `nuke_stories`
--

CREATE TABLE `nuke_stories` (
`sid` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`aid` varchar(25) 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(25) 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',
`rating_ip` varchar(15) default '0',
`associated` text NOT NULL,
PRIMARY KEY (`sid`),
KEY `sid` (`sid`),
KEY `catid` (`catid`),
KEY `counter` (`counter`),
KEY `topic` (`topic`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `nuke_stories`
--

dari · Posted: Mon Jan 23, 2006 9:56 am Post subject: Re: Can

is this a plain vanilla phpnuke?
_________________

dahman · Beginner Joined: Jan 07, 2006 Posts: 8

No it is not, I don't think

dari · Posted: Wed Jan 25, 2006 9:04 am Post subject: Re: Can

if you downloaded it from anywhere but phpnuke.org, you'll have to ask the maintainer of that site.
_________________