Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro
Author Message
Neph
New Member
New Member


Joined: Dec 02, 2005
Posts: 6

PostPosted: Wed Jun 14, 2006 9:54 am Reply with quote

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.


Last edited by Neph on Thu Jun 15, 2006 6:23 pm; edited 1 time in total 
View user's profile Send private message
kguske
Site Admin


Joined: Jun 04, 2004
Posts: 6383

PostPosted: Wed Jun 14, 2006 10:19 am Reply with quote

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

_________________
I google, therefore I exist...
Only registered users can see links on this board! Get registered or login!
 
View user's profile Send private message
fkelly
Former Moderator in Good Standing


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

PostPosted: Wed Jun 14, 2006 10:21 am Reply with quote

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.
 
View user's profile Send private message Visit poster's website
Neph
PostPosted: Thu Jun 15, 2006 6:19 pm Reply with quote

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.
 
fkelly
PostPosted: Thu Jun 15, 2006 6:55 pm Reply with quote

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.
 
Neph
PostPosted: Thu Jun 15, 2006 9:12 pm Reply with quote

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


That did the trick...thanks again
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro

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 ©