New stories.

New Member Joined: Dec 02, 2005 Posts: 6

Hey all,
Not certain when this starte, but I am unable to post/create Articles for my site. I add my content, choose post story then click OK! which takes me to the nesxt page listing all my article, except the one I just created(or atleast though I did). Anyone else experiencing this? Any suggestions on a fix?

Thanks.

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

It sounds like the database table structure may have changed. What fields are in the nuke_stories table?

Posted: Wed Jun 14, 2006 10:21 am

This sounds like a SQL error when you go to post. I had a similar issue with messages a week ago on a test site and I found that a line in the nsngroups Sql during the install process hadn't been executed so the table was out of synch with what the program expected (there was a missing field).

You don't say which version you are running or whether you have any coding expertise but you could either compare the table structure using PHPmyadmin to what the program expects or you could post the table structure here along with the information on what version you are running.

Posted: Thu Jun 15, 2006 6:19 pm

The version I am using is rwsRavenNuke76_v2.02.02_FULL. The only mudule I've added to Raven's release has been Gallery 2.1, which was after the problem had started.

The field in nuke_stories table are

Code:




-- 


-- Host: localhost


-- Generation Time: Jun 15, 2006 at 07:20 PM


-- Server version: 4.0.25


-- PHP Version: 4.3.11


-- 


-- Database: `room719_nuke3`


-- 





-- --------------------------------------------------------





-- 


-- 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=30 ;





-- 


-- Dumping data for table `nuke_stories`


--

the rest of the exported sql contains the stories prior to the inability to post new content.

Posted: Thu Jun 15, 2006 6:55 pm

I don't find the field rating_ip anywhere in Raven Nuke. I'm not sure where that came from in your table structure and I'm always prepared to be enlightened, but I think that if you back things up and delete that field or column you might find things would work a lot better.

Posted: Thu Jun 15, 2006 9:12 pm

I'll give it a try, thank for the help.

That did the trick...thanks again